protected void grdCanteenMaster_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("ADD")) { TextBox txtNewCanteenTypeName = (TextBox)grdCanteenMaster.FooterRow.FindControl("txtNewCanteenTypeName"); CheckBox txtNewRemarks = (CheckBox)grdCanteenMaster.FooterRow.FindControl("txtNewRemarks"); if (IsValid) { //errNumber = -1; try { objBusinessClass = new BusinessLayer.BusinessClass(); objML_CokeType = new ML_CokeType(); objML_CokeType.CokeType = ML_Common.clean(txtNewCanteenTypeName.Text); objML_CokeType.Remarks = ML_Common.clean(txtNewRemarks.Text); objML_CokeType.IsActive = ML_Common.clean(ML_Common.bit2int(false).ToString()); objML_CokeType.IsArchive = ML_Common.clean(ML_Common.bit2int(false).ToString()); objML_CokeType.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeType.CreatedBy = Session["UserName"].ToString(); objML_CokeType.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeType.ModifiedBy = ML_Common.clean(string.Empty); int obhReturn = objBusinessClass.AddCokeType(objML_CokeType); if (obhReturn == 1) { lblMsg.Visible = true; lblMsg.Text = "Record Saved Successfully"; FillGrid(); } else if (obhReturn == 2) { lblMsg.Text = "Record Already Exists!"; lblMsg.Visible = true; } } catch (SqlException sqlExc) { // LogManager.LogManager.WriteErrorLog(sqlExc); SqlException sqlEt = sqlExc; return; } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); } } } }