private void WriteUserActivity(string strActivity, string strLogStatus = "") { if (Session["UserName"] != null && Session["UserNameId"] != null && Session["UserTypeId"] != null && Session["UserType"] != null && Session["IPAddress"] != null && Session["hostName"] != null) { ML_UserLog objML_UserLog = new ML_UserLog(); objBusinessClass = new BusinessLayer.BusinessClass(); try { objML_UserLog.UserLog = ML_Common.string2string(Session["UserName"]); objML_UserLog.UserName = ML_Common.string2string(Session["UserName"]); objML_UserLog.UserNameId = ML_Common.string2Long(Session["UserNameId"]); objML_UserLog.Email = string.Empty; objML_UserLog.UserTypeId = ML_Common.string2Long(Session["UserTypeId"]); objML_UserLog.UserType = ML_Common.string2string(Session["UserType"]); objML_UserLog.LogStatus = strLogStatus; objML_UserLog.IPAddress = ML_Common.string2string(Session["IPAddress"]); objML_UserLog.MachineHostName = ML_Common.string2string(Session["hostName"]); objML_UserLog.UserActivity = strActivity; objML_UserLog.Remarks = string.Empty; objBusinessClass.AddUserLog(objML_UserLog); } catch { } } else { Response.Redirect("Login.aspx", false); } }
private void FillObjectToForm(long lngId, bool IsEditFlag = true) { objBusinessClass = new BusinessLayer.BusinessClass(); try { if (ViewState["ReportType"] != null && ViewState["grdSanitizationReportId"] != null) { string ReportType = ML_Common.string2string(ViewState["ReportType"].ToString()); lngId = ML_Common.string2Long(ViewState["grdSanitizationReportId"].ToString()); // string ReportType = ML_Common.GetDropDownValue(ddlReportTypeSearch, true); ML_SanitizationReport objML_SanitizationReport = objBusinessClass.GetSCSanitizationResultByReportTypeandId(lngId, ReportType); if (objML_SanitizationReport != null) { //ViewState["SanitizationResultId"] = objML_SanitizationReport.SanitizationResultId; //ViewState["SanitizationStartDate"] = objML_SanitizationReport.SanitizationStartDate; //ViewState["SanitizationEndDate"] = objML_SanitizationReport.SanitizationEndDate; //FillGridForData(); ShowReport(objML_SanitizationReport.Id, objML_SanitizationReport.ReportType); } //UpdatePanelGridResult.Update(); } } catch (Exception ex) { Exception exc = ex; } }
private void FillGrid() { try { DataTable DtList = null; if (ViewState["grdUserName"] == null) { if (ddlUserTypeSearch.SelectedIndex > 0) { objML_UserName.UserTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlUserTypeSearch, true)); objML_UserName.UserType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlUserTypeSearch, false)); DtList = BindGridViewBySearch(objML_UserName); ViewState["grdUserName"] = DtList; } } else { DtList = (DataTable)ViewState["grdUserName"]; } if (DtList != null) { if (DtList.Rows.Count > 0) { grdUserName.DataSource = DtList; grdUserName.DataBind(); } else { DtList.Rows.Add(DtList.NewRow()); grdUserName.DataSource = DtList; grdUserName.DataBind(); int TotalColumns = grdUserName.Rows[0].Cells.Count; grdUserName.Rows[0].Cells.Clear(); grdUserName.Rows[0].Cells.Add(new TableCell()); grdUserName.Rows[0].Cells[0].ColumnSpan = TotalColumns; grdUserName.Rows[0].Cells[0].Text = "No Record Found"; } UpdatePanelGrid.Update(); } } catch (Exception ex) { Exception exx = ex; } }
protected void grdSanitizationReport_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { try { lblMsg.Text = string.Empty; int lngId = ML_Common.string2int32(grdSanitizationReport.DataKeys[e.NewSelectedIndex].Values[0].ToString()); string ReportType = ML_Common.string2string(grdSanitizationReport.DataKeys[e.NewSelectedIndex].Values[2].ToString()); ViewState["grdSanitizationReportId"] = lngId; ViewState["ReportType"] = ReportType; if (lngId > 0) { FillObjectToForm(lngId, false); // ModalPopupExtenderView.Show(); } else { lblMsg.Text = "Record is not exists?"; } } catch (Exception ex) { Exception exc = ex; } }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (btnAdd.Enabled) { DataRow dr; if (ViewState["dtCokeDynamic"] == null) { dtCokeDynamic = new DataTable(); dtCokeDynamic = BindCokeDynamicDataTable(); } else { dtCokeDynamic = (DataTable)ViewState["dtCokeDynamic"]; } dr = dtCokeDynamic.NewRow(); dr["CokeTypeId"] = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeType, true)); dr["CokeType"] = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeType, false)); dr["CokeSupplierId"] = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeSupplier, true)); dr["CokeSupplier"] = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeSupplier, false)); //dr["NameofParty"] = dr["CokeSupplier"]; dr["AnalysisTypeId"] = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlAnalysisType, true)); dr["AnalysisType"] = ML_Common.string2string(ML_Common.GetDropDownValue(ddlAnalysisType, false)); //dr["NameofAnalysis"] = dr["AnalysisType"]; //dr["SampleNo"] = dtFlowMetrDataTable.Rows.Count + 1;// ML_Common.string2int32(ML_Common.clean(txtSampleNo.Text)); //dr["SamplingDate"] = ML_Common.ToDateTimeSafeNull(txtSamplingDate.Text); //dr["StoreSINo"] = ML_Common.string2int32(ML_Common.clean(txtStoreSINo.Text)); //dr["SampleDetail"] = ML_Common.clean(txtSampleDetail.Text); dr["FieldSize"] = ML_Common.clean(txtFieldSize.Text); dr["FieldUnit"] = ML_Common.clean(txtFieldUnit.Text); dr["FieldSpec"] = ML_Common.clean(txtFieldSpec.Text); dr["MinValue"] = ML_Common.clean(txtMinValue.Text); dr["MaxValue"] = ML_Common.clean(txtMaxValue.Text); dtCokeDynamic.Rows.Add(dr); //DtList = (DataTable)ViewState["grdStartupBathTapping"]; if (dtCokeDynamic.Rows.Count > 0) { ViewState["dtCokeDynamic"] = dtCokeDynamic; grdCokeDynamic.DataSource = dtCokeDynamic; grdCokeDynamic.DataBind(); } else { dtCokeDynamic.Rows.Add(dtCokeDynamic.NewRow()); grdCokeDynamic.DataSource = dtCokeDynamic; grdCokeDynamic.DataBind(); int TotalColumns = grdCokeDynamic.Rows[0].Cells.Count; grdCokeDynamic.Rows[0].Cells.Clear(); grdCokeDynamic.Rows[0].Cells.Add(new TableCell()); grdCokeDynamic.Rows[0].Cells[0].ColumnSpan = TotalColumns; grdCokeDynamic.Rows[0].Cells[0].Text = "No Record Found"; } txtFieldSize.Text = string.Empty; txtFieldUnit.Text = string.Empty; txtFieldSpec.Text = string.Empty; txtMinValue.Text = string.Empty; txtMaxValue.Text = string.Empty; UpdatePanelGrid.Update(); btnSubmit.Visible = true; btnSubmit.BackColor = System.Drawing.ColorTranslator.FromHtml("#5bc0de"); btnSubmit.ForeColor = System.Drawing.Color.White; btnNewAdd.Visible = true; // btnNewAdd.BackColor = System.Drawing.Color.Green; btnNewAdd.BackColor = System.Drawing.ColorTranslator.FromHtml("#5bc0de"); btnSubmit.ForeColor = System.Drawing.Color.White; UpdatePanelSave.Update(); } } catch (Exception ex) { string str = ex.Message.ToString(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (IsValid) { //errNumber = -1; try { if (btnSubmit.Enabled) { int obhReturn = -1; objBusinessClass = new BusinessLayer.BusinessClass(); objML_CokeDynamic = new ML_CokeDynamic(); //objML_CokeDynamic.Id = ML_Common.string2Long(ML_Common.clean(txtId.Text)); //objML_CokeDynamic.CokeDynamicId = ML_Common.string2Long(ML_Common.clean(txtCokeDynamicId.Text)); //objML_CokeDynamic.CokeDynamic = ML_Common.clean(txtCokeDynamic.Text); objML_CokeDynamic.CokeTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeType, true)); objML_CokeDynamic.CokeType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeType, false)); objML_CokeDynamic.CokeSupplierId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeSupplier, true)); objML_CokeDynamic.CokeSupplier = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeSupplier, false)); objML_CokeDynamic.AnalysisTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlAnalysisType, true)); objML_CokeDynamic.AnalysisType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlAnalysisType, false)); objML_CokeDynamic.FieldSize = ML_Common.clean(txtFieldSize.Text); objML_CokeDynamic.FieldUnit = ML_Common.clean(txtFieldUnit.Text); objML_CokeDynamic.FieldSpec = ML_Common.clean(txtFieldSpec.Text); objML_CokeDynamic.MinValue = ML_Common.clean(txtMinValue.Text); objML_CokeDynamic.MaxValue = ML_Common.clean(txtMaxValue.Text); for (int i = 0; i <= grdCokeDynamic.Rows.Count - 1; i++) { objML_CokeDynamic.FieldSize = string.Empty; objML_CokeDynamic.FieldUnit = string.Empty; objML_CokeDynamic.FieldSpec = string.Empty; objML_CokeDynamic.MinValue = string.Empty; objML_CokeDynamic.MaxValue = string.Empty; GridViewRow gRow = grdCokeDynamic.Rows[i]; Label lblCokeTypeID = (Label)gRow.FindControl("lblCokeTypeID"); if (lblCokeTypeID != null) { objML_CokeDynamic.CokeTypeId = ML_Common.string2int32(lblCokeTypeID.Text); } Label lblCokeType = (Label)gRow.FindControl("lblCokeType"); if (lblCokeType != null) { objML_CokeDynamic.CokeType = ML_Common.clean(lblCokeType.Text); } Label lblCokeSupplierID = (Label)gRow.FindControl("lblCokeSupplierID"); if (lblCokeSupplierID != null) { objML_CokeDynamic.CokeSupplierId = ML_Common.string2int32(lblCokeSupplierID.Text); } Label lblCokeSupplier = (Label)gRow.FindControl("lblCokeSupplier"); if (lblCokeSupplier != null) { objML_CokeDynamic.CokeSupplier = ML_Common.clean(lblCokeSupplier.Text); } Label lblAnalysisTypeID = (Label)gRow.FindControl("lblAnalysisTypeID"); if (lblAnalysisTypeID != null) { objML_CokeDynamic.AnalysisTypeId = ML_Common.string2int32(lblAnalysisTypeID.Text); } Label lblAnalysisType = (Label)gRow.FindControl("lblAnalysisType"); if (lblAnalysisTypeID != null) { objML_CokeDynamic.AnalysisType = ML_Common.clean(lblAnalysisType.Text); } Label lblFieldSize = (Label)gRow.FindControl("lblFieldSize"); if (lblFieldSize != null) { objML_CokeDynamic.FieldSize = lblFieldSize.Text; } Label lblFieldUnit = (Label)gRow.FindControl("lblFieldUnit"); if (lblFieldUnit != null) { objML_CokeDynamic.FieldUnit = lblFieldUnit.Text; } Label lblFieldSpec = (Label)gRow.FindControl("lblFieldSpec"); if (lblFieldSpec != null) { objML_CokeDynamic.FieldSpec = lblFieldSpec.Text; } Label lblMinValue = (Label)gRow.FindControl("lblMinValue"); if (lblMinValue != null) { objML_CokeDynamic.MinValue = lblMinValue.Text; } Label lblMaxValue = (Label)gRow.FindControl("lblMaxValue"); if (lblMaxValue != null) { objML_CokeDynamic.MaxValue = lblMaxValue.Text; } obhReturn = objBusinessClass.AddCokeDynamic(objML_CokeDynamic); } if (obhReturn == 1) { lblMsg.Text = "Record Update Successfully"; lblMsgEdit.Text = "Record Update Successfully"; btnSubmit.Visible = false; UpdatePanelSave.Update(); } else { lblMsg.Text = "Ooops!OtherIssue..."; lblMsgEdit.Text = "Ooops!OtherIssue..."; } txtFieldSize.Text = string.Empty; txtFieldUnit.Text = string.Empty; txtFieldSpec.Text = string.Empty; txtMinValue.Text = string.Empty; txtMaxValue.Text = string.Empty; lblMsg.Text = string.Empty; lblMsgEdit.Text = string.Empty; UpdatePanelSave.Update(); btnSubmit.Enabled = true; ViewState["dtCokeDynamic"] = null; dtCokeDynamic = new DataTable(); dtCokeDynamic = BindCokeDynamicDataTable(); grdCokeDynamic.DataSource = dtCokeDynamic; grdCokeDynamic.DataBind(); UpdatePanelGrid.Update(); btnAdd.Enabled = true; //btnSubmit.Visible = false; } } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); } } }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { //errNumber = -1; try { objBusinessClass = new BusinessLayer.BusinessClass(); objML_UserName = new ML_UserName(); objML_UserName.UserName = ML_Common.clean(txtUserName.Text); objML_UserName.FirstName = ML_Common.clean(txtFirstName.Text); objML_UserName.LastName = ML_Common.clean(txtLastName.Text); objML_UserName.Email = ML_Common.clean(txtEmail.Text); objML_UserName.Telephone = ML_Common.clean(txtTelephone.Text); objML_UserName.Mobile = ML_Common.clean(txtMobile.Text); objML_UserName.Password = ML_Common.clean(txtPassword.Text); objML_UserName.UserTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlUserType, true)); objML_UserName.UserType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlUserType, false)); objML_UserName.ReTryAttempt = 3; // ML_Common.string2int32(ML_Common.clean(txtReTryAttempt.Text)); objML_UserName.IsLocked = false; // ML_Common.string2Boolean(ML_Common.clean(txtIsLocked.Text)); objML_UserName.LockedDateTime = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_UserName.IsActive = ML_Common.clean(ML_Common.bit2int(true).ToString()); objML_UserName.IsArchive = ML_Common.clean(ML_Common.bit2int(false).ToString()); objML_UserName.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_UserName.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); if (Session["UserName"] != null && Session["UserNameId"] != null) { objML_UserName.CreatedBy = ML_Common.clean(Session["UserName"]); objML_UserName.ModifiedBy = ML_Common.clean(Session["UserName"]); objML_UserName.CreatedByUserNameId = ML_Common.string2int32(ML_Common.clean(Session["UserNameId"])); } int obhReturn = objBusinessClass.AddUserName(objML_UserName); if (obhReturn == 1) { lblMsg.Visible = true; lblMsg.Text = "Record Saved Successfully"; FormFieldsClear(); } else if (obhReturn == 2) { lblMsg.Text = "Record Already Exists!"; lblMsg.Visible = true; } } catch (SqlException sqlExc) { SqlException sqlExt = sqlExc; return; } catch (Exception ex) { Exception exx = ex; } } }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { //errNumber = -1; try { objBusinessClass = new BusinessLayer.BusinessClass(); objML_CokeDynamicResult = new ML_CokeDynamicResult(); ML_CokeDynamic objML_CokeDynamic = null;// new ML_KeysPointChk(); objBusinessClass = new BusinessClass(); int CokeDynamicId = -1; int obhReturn = 0; DateTime dtDateandTime = System.DateTime.Now; if (ddlCokeType.SelectedIndex > 0) { foreach (GridViewRow row in grdCokeDynamicResult.Rows) { objML_CokeDynamic = new ML_CokeDynamic(); string txtCokeDynamicResult = string.Empty; TextBox mytxtCokeDynamicResult = (TextBox)row.FindControl("txtCokeDynamicResult"); if (mytxtCokeDynamicResult != null) { txtCokeDynamicResult = mytxtCokeDynamicResult.Text; } Label lblCokeDynamicId = (Label)row.FindControl("lblCokeDynamicId"); if (lblCokeDynamicId != null) { CokeDynamicId = ML_Common.string2int(lblCokeDynamicId.Text); objML_CokeDynamic = objBusinessClass.GetCokeDynamicByCokeDynamicId(CokeDynamicId); objML_CokeDynamicResult = new ML_CokeDynamicResult(); objML_CokeDynamicResult.CokeDynamicResult = objML_CokeDynamic.CokeDynamic; objML_CokeDynamicResult.CokeTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeType, true)); objML_CokeDynamicResult.CokeType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeType, false)); objML_CokeDynamicResult.CokeSupplierId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeSupplierName, true)); objML_CokeDynamicResult.CokeSupplier = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeSupplierName, false)); objML_CokeDynamicResult.AnalysisTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlAnalysisType, true)); objML_CokeDynamicResult.AnalysisType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlAnalysisType, false)); objML_CokeDynamicResult.CokeDynamicId = objML_CokeDynamicResult.CokeDynamicId; objML_CokeDynamicResult.CokeDynamic = objML_CokeDynamic.CokeDynamic; objML_CokeDynamicResult.FieldSize = objML_CokeDynamic.FieldSize; objML_CokeDynamicResult.FieldUnit = objML_CokeDynamic.FieldUnit; objML_CokeDynamicResult.FieldSpec = objML_CokeDynamic.FieldSpec; objML_CokeDynamicResult.MinValue = objML_CokeDynamic.MinValue; objML_CokeDynamicResult.MaxValue = objML_CokeDynamic.MaxValue; //objML_CokeDynamicResult.CokeDynamicId = ML_Common.string2string(txtCokeDynamicResult); objML_CokeDynamicResult.CokeTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeType, true)); objML_CokeDynamicResult.CokeType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeType, false)); objML_CokeDynamicResult.CokeSupplierId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeSupplierName, true)); objML_CokeDynamicResult.CokeSupplier = ML_Common.string2string(ML_Common.GetDropDownValue(ddlCokeSupplierName, false)); objML_CokeDynamicResult.AnalysisTypeId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlAnalysisType, true)); objML_CokeDynamicResult.AnalysisType = ML_Common.string2string(ML_Common.GetDropDownValue(ddlAnalysisType, false)); objML_CokeDynamicResult.FieldSize = ML_Common.clean(objML_CokeDynamicResult.FieldSize); objML_CokeDynamicResult.FieldUnit = ML_Common.clean(objML_CokeDynamicResult.FieldUnit); objML_CokeDynamicResult.FieldSpec = ML_Common.clean(objML_CokeDynamicResult.FieldSpec); objML_CokeDynamicResult.MinValue = ML_Common.clean(objML_CokeDynamicResult.MinValue); objML_CokeDynamicResult.MaxValue = ML_Common.clean(objML_CokeDynamicResult.MaxValue); obhReturn = objBusinessClass.AddCokeDynamicResult(objML_CokeDynamicResult); } } if (obhReturn == 1) { lblMsg.Visible = true; lblMsg.Text = "Record Saved Successfully"; } FormFieldsClear(); } } catch (SqlException sqlExc) { SqlException sqlExt = sqlExc; return; } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); } } //if (IsValid ) //{ // //errNumber = -1; // try // { // objBusinessClass = new BusinessLayer.BusinessClass(); // objML_CokeDynamicResult = new ML_CokeDynamicResult(); // string strAdminLoginName = string.Empty; // if (Session["UserName"] != null) // { // strAdminLoginName = Session["UserName"].ToString(); // } // objML_CokeDynamicResult.Id = ML_Common.string2Long(ML_Common.clean(txtId.Text)); // objML_CokeDynamicResult.CokeDynamicResultId = ML_Common.string2Long(ML_Common.clean(txtCokeDynamicResultId.Text)); // objML_CokeDynamicResult.CokeDynamicResult = ML_Common.clean(txtCokeDynamicResult.Text); // objML_CokeDynamicResult.CokeDynamicId = ML_Common.string2int32(ML_Common.clean(txtCokeDynamicId.Text)); // objML_CokeDynamicResult.CokeDynamic = ML_Common.clean(txtCokeDynamic.Text); // objML_CokeDynamicResult.CPCokeId = ML_Common.string2int32(ML_Common.clean(txtCPCokeId.Text)); // objML_CokeDynamicResult.CPCokeName = ML_Common.clean(txtCPCokeName.Text); // objML_CokeDynamicResult.CokeTypeId = ML_Common.string2int32(ML_Common.clean(txtCokeTypeId.Text)); // objML_CokeDynamicResult.CokeType = ML_Common.clean(txtCokeType.Text); // objML_CokeDynamicResult.CokeSupplierId = ML_Common.string2int32(ML_Common.clean(txtCokeSupplierId.Text)); // objML_CokeDynamicResult.CokeSupplier = ML_Common.clean(txtCokeSupplier.Text); // objML_CokeDynamicResult.AnalysisTypeId = ML_Common.string2int32(ML_Common.clean(txtAnalysisTypeId.Text)); // objML_CokeDynamicResult.AnalysisType = ML_Common.clean(txtAnalysisType.Text); // objML_CokeDynamicResult.FieldSize = ML_Common.clean(txtFieldSize.Text); // objML_CokeDynamicResult.FieldUnit = ML_Common.clean(txtFieldUnit.Text); // objML_CokeDynamicResult.FieldSpec = ML_Common.clean(txtFieldSpec.Text); // objML_CokeDynamicResult.MinValue = ML_Common.clean(txtMinValue.Text); // objML_CokeDynamicResult.MaxValue = ML_Common.clean(txtMaxValue.Text); // // objML_CokeDynamicResult.IsActive = ML_Common.clean(ML_Common.bit2int(chkIsActive.Checked).ToString()); // // objML_CokeDynamicResult.IsArchive = ML_Common.clean(ML_Common.bit2int(chkIsArchive.Checked).ToString()); // // objML_CokeDynamicResult.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); // // objML_CokeDynamicResult.CreatedBy = ML_Common.clean(string.Empty); // // objML_CokeDynamicResult.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); // // objML_CokeDynamicResult.ModifiedBy = ML_Common.clean(string.Empty); // int obhReturn = objBusinessClass.AddCokeDynamicResult(objML_CokeDynamicResult); // if (obhReturn == 1) // { // lblMsg.Visible = true; // lblMsg.Text = "Record Saved Successfully"; // } // else if (obhReturn == 2) // { // lblMsg.Text = "Record Already Exists!"; // lblMsg.Visible = true; // } // } // catch (SqlException sqlExc) // { // // LogManager.LogManager.WriteErrorLog(sqlExc); // foreach (SqlError error in sqlExc.Errors) // { // errNumber = error.Number; // } // if (errNumber == 50000) // { // } // return; // } // catch (Exception ex) // { // Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); // } //} }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { //errNumber = -1; try { objBusinessClass = new BusinessLayer.BusinessClass(); objML_CokeSupplier = new ML_CokeSupplier(); objML_CokeSupplier.CokeSupplier = ML_Common.string2string(txtCokeSupplier.Text); objML_CokeSupplier.Address1 = ML_Common.clean(txtAddress1.Text); objML_CokeSupplier.Address2 = ML_Common.clean(txtAddress2.Text); objML_CokeSupplier.Address3 = ML_Common.clean(txtAddress3.Text); objML_CokeSupplier.CityName = string.Empty; // ML_Common.clean(txtCityName.Text); objML_CokeSupplier.StateName = string.Empty; // ML_Common.clean(txtStateName.Text); objML_CokeSupplier.PinCode = string.Empty; // ML_Common.clean(txtPinCode.Text); objML_CokeSupplier.Title = string.Empty; //ML_Common.clean(txtTitle.Text); objML_CokeSupplier.CountryName = string.Empty; //ML_Common.clean(txtCountryName.Text); objML_CokeSupplier.ContactPerson = ML_Common.clean(txtContactPerson.Text); objML_CokeSupplier.MobNo = ML_Common.clean(txtMobNo.Text); objML_CokeSupplier.WebSite = string.Empty;// ML_Common.clean(txtWebSite.Text); objML_CokeSupplier.Email = ML_Common.clean(txtEmail.Text); objML_CokeSupplier.Remarks = ML_Common.clean(txtRemarks.Text); objML_CokeSupplier.IsActive = ML_Common.clean(ML_Common.bit2int(true).ToString()); objML_CokeSupplier.IsArchive = ML_Common.clean(ML_Common.bit2int(false).ToString()); objML_CokeSupplier.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeSupplier.CreatedBy = ML_Common.clean(string.Empty); objML_CokeSupplier.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeSupplier.ModifiedBy = ML_Common.clean(string.Empty); objML_CokeSupplier.CreatedByUserNameId = 1;// ML_Common.string2int(ML_Common.clean(txtCreatedByUserNameId.Text)); int obhReturn = objBusinessClass.AddCokeSupplier(objML_CokeSupplier); if (obhReturn == 1) { lblMsg.Text = "Record Saved Successfully"; FormFieldsClear(); } else { lblMsg.Text = "Record Already Exists!"; FormFieldsClear(); } } catch (SqlException sqlExc) { lblMsg.Text = "Record Already Exists!"; SqlException sqlExt = sqlExc; return; } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); } } }
protected void btnUpdate_Click(object sender, EventArgs e) { lblMsg.Text = string.Empty; lblMsgEdit.Text = string.Empty; if (IsValid) { //errNumber = -1; BusinessClass objBusinessClass = new BusinessLayer.BusinessClass(); int lngId = Convert.ToInt32(ViewState["grdCokeSupplierId"]); ML_CokeSupplier objML_CokeSupplier = objBusinessClass.GetCokeSupplierById(lngId); try { if (objML_CokeSupplier != null) { // objML_CokeSupplier.Id = ML_Common.string2int32(ML_Common.clean(txtIdEdit.Text)); // objML_CokeSupplier.CokeSupplierId = ML_Common.string2int32(ML_Common.GetDropDownValue(ddlCokeSupplierEdit, true)); objML_CokeSupplier.CokeSupplier = ML_Common.string2string(txtCokeSupplierEdit.Text); objML_CokeSupplier.Address1 = ML_Common.clean(txtAddress1Edit.Text); objML_CokeSupplier.Address2 = ML_Common.clean(txtAddress2Edit.Text); objML_CokeSupplier.Address3 = ML_Common.clean(txtAddress3Edit.Text); objML_CokeSupplier.CityName = string.Empty; //ML_Common.clean(txtCityNameEdit.Text); objML_CokeSupplier.StateName = string.Empty; // ML_Common.clean(txtStateNameEdit.Text); objML_CokeSupplier.PinCode = string.Empty; //ML_Common.clean(txtPinCodeEdit.Text); objML_CokeSupplier.Title = string.Empty; // ML_Common.clean(txtTitleEdit.Text); objML_CokeSupplier.CountryName = string.Empty; // ML_Common.clean(txtCountryNameEdit.Text); objML_CokeSupplier.ContactPerson = ML_Common.clean(txtContactPersonEdit.Text); objML_CokeSupplier.MobNo = ML_Common.clean(txtMobNoEdit.Text); objML_CokeSupplier.WebSite = string.Empty;// ML_Common.clean(txtWebSiteEdit.Text); objML_CokeSupplier.Email = ML_Common.clean(txtEmailEdit.Text); objML_CokeSupplier.Remarks = ML_Common.clean(txtRemarksEdit.Text); objML_CokeSupplier.IsActive = ML_Common.clean(ML_Common.bit2int(true).ToString()); objML_CokeSupplier.IsArchive = ML_Common.clean(ML_Common.bit2int(false).ToString()); objML_CokeSupplier.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeSupplier.CreatedBy = ML_Common.clean(string.Empty); objML_CokeSupplier.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); objML_CokeSupplier.ModifiedBy = ML_Common.clean(string.Empty); objML_CokeSupplier.CreatedByUserNameId = 1;// ML_Common.string2int(ML_Common.clean(txtCreatedByUserNameIdEdit.Text)); // int obhReturn = objBusinessClass.UpdateUniqueCokeSupplier(objML_CokeSupplier); int obhReturn = objBusinessClass.UpdateCokeSupplier(objML_CokeSupplier); if (obhReturn == 1) { lblMsg.Visible = true; lblMsg.Text = "Record Update Successfully"; lblMsgEdit.Text = "Record Update Successfully"; ModalPopupExtenderEdit.Hide(); lblMsgEdit.Text = string.Empty; } else if (obhReturn == 2) { lblMsg.Text = "Record Already Exists!"; lblMsgEdit.Text = "Record Already Exists!"; lblMsg.Visible = true; ModalPopupExtenderEdit.Hide(); } else { lblMsg.Text = "Ooops!OtherIssue..."; lblMsgEdit.Text = "Ooops!OtherIssue..."; lblMsg.Visible = true; } FillGrid(); } } catch (SqlException sqlExc) { SqlException sqlExt = sqlExc; return; } catch (Exception ex) { Exception exc = ex;// LogManager.LogManager.WriteErrorLog(ex); } } }