Insert Update Using LINQ

21 Sep 2012    by: Sameer Das

sewakdbDataContext swdb = new sewakdbDataContext();
tbl_AnnualReport tbannual = new tbl_AnnualReport();

try {

	#region Insert/Update data
	if (hfid.Value != string.Empty)	{

		tbannual = (from d in swdb.tbl_AnnualReports where d.AR_ID == Convert.ToInt32(hfid.Value) select d).FirstOrDefault();

		btnSubmit.Text = "Submit";

		msg = "Updated Successfully";

	} else {

		swdb.tbl_AnnualReports.InsertOnSubmit(tbannual);

		msg = "Inserted Successfully";

	}

	#endregion
	#region Entity
	tbannual.AR_DATE =Convert.ToDateTime (txtARDate.Text.Trim());
	tbannual.AR_HEADLINE = txtHeadline.Text.Trim();
	tbannual.entry_date = DateTime.Now;
	tbannual.ARCHIVE_STATUS = false;
	tbannual.DELSTATUS = false;
	if (FileUpload1.HasFile)
		tbannual.AR_COVER_IMAGE = uploadPhoto(ref FileUpload1);

	if(FileUpload2.HasFile)
		tbannual.AR_FILE = uploadDocument(ref FileUpload2);

	#endregion
	lblerr.Text = msg;
	lblerr.ForeColor = System.Drawing.Color.Green;
	swdb.SubmitChanges();
	//Reset

	reset();

	//Fill gridview
	_LoadGrid();

} catch (Exception ex) {

	lblerr.Text = ex.ToString();
	lblerr.ForeColor = System.Drawing.Color.Red;

}

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz