protected void grdCokeDynamicResult_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
lblMsg.Visible = false;
int lngId = ML_Common.string2int32(grdCokeDynamicResult.DataKeys[e.NewEditIndex].Values[0].ToString());
if (lngId > 0)
{
ViewState["grdCokeDynamicResultViewId"] = lngId;
grdCokeDynamicResult.EditIndex = -1;
e.Cancel = true;
// PanelMainDisplay(false);
FormFieldsClear();
//PanelEditFormDisplay(true);
//FillObjectToForm(lngId, true);
//UpdatePanelEdit.Update();
//ModalPopupExtenderEdit.Show();
}
else
{
lblMsg.Text = "Record is not exists?";
lblMsg.Visible = true;
}
}
catch (Exception ex)
{
Exception exc = ex;// LogManager.LogManager.WriteErrorLog(ex);
}
}
protected void grdCokeSupplier_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
lblMsg.Visible = false;
int lngId = ML_Common.string2int32(grdCokeSupplier.DataKeys[e.NewSelectedIndex].Values[0].ToString());
ViewState["grdCokeSupplierId"] = lngId;
if (lngId > 0)
{
FormFieldsClear();
FillObjectToForm(lngId, false);
UpdatePanelView.Update();
ModalPopupExtenderView.Show();
}
else
{
lblMsg.Text = "Record is not exists?";
lblMsg.Visible = true;
}
}
catch (Exception ex)
{
Exception exc = ex;// LogManager.LogManager.WriteErrorLog(ex);
}
}
protected void grdSanitizationReport_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
int lngId = ML_Common.string2int32(grdSanitizationReport.DataKeys[e.NewEditIndex].Values[0].ToString());
if (lngId > 0)
{
ViewState["grdSanitizationReportId"] = lngId;
grdSanitizationReport.EditIndex = -1;
e.Cancel = true;
//FormFieldsClear();
// FillObjectToForm(lngId, true);
// UpdatePanelMsg.Update();
// ModalPopupExtenderMsg.Show();
}
else
{
lblMsg.Text = "Record is not exists?";
}
}
catch (Exception ex)
{
Exception exc = ex;
}
}
protected void grdUserName_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
lblMsg.Visible = false;
int lngId = ML_Common.string2int32(grdUserName.DataKeys[e.NewSelectedIndex].Values[0].ToString());
ViewState["UserNameViewId"] = lngId;
if (lngId > 0)
{
// e.Cancel = true;
FormFieldsClear();
FillObjectToForm(lngId, false);
UpdatePanelView.Update();
ModalPopupExtenderView.Show();
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Record is not exists?";
}
}
catch (Exception ex)
{
Exception exx = ex;
}
}
protected void grdCokeDynamic_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
// Guid guid = ML_Common.String2Guid(grdCokeComposite.DataKeys[e.NewSelectedIndex].Values[0].ToString());
//int lngId = ML_Common.string2int(grdCokeComposite.DataKeys[e.NewSelectedIndex].Values[0].ToString());
int lngId = ML_Common.string2int32(grdCokeDynamic.DataKeys[e.NewSelectedIndex].Values[0].ToString());
ViewState["grdCokeDynamicId"] = lngId;
if (lngId > 0)
{
FormFieldsClear();
//FillObjectToForm(lngId, false);
// UpdatePanelView.Update();
//ModalPopupExtenderView.Show();
}
else
{
lblMsg.Text = "Record is not exists?";
}
UpdatePanelCokeDynamicDisplay.Update();
}
catch (Exception ex)
{
Exception exc = ex;// LogManager.LogManager.WriteErrorLog(ex);
}
}
public int Update(ML_CanteenMaster objML_CanteenMaster)
{
int results = 0;
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CanteenMaster:Update(ML_CanteenMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Update Properties
new SqlParameter("@CanteenCode", objML_CanteenMaster.CanteenCode),
new SqlParameter("@CanteenName", objML_CanteenMaster.CanteenName),
new SqlParameter("@CanteenAddress", objML_CanteenMaster.CanteenAddress),
new SqlParameter("@CanteenActive", objML_CanteenMaster.CanteenActive),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_UpdateCanteenMaster.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CanteenMaster:Update(ML_CanteenMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
int errNumber = int.MinValue;
//LogManager.LogManager.WriteErrorLog(sqlExc);
foreach (SqlError error in sqlExc.Errors)
{
errNumber = error.Number;
}
if (errNumber == 50000)
{
results = 999;
throw;
}
}
catch (Exception ex)
{
results = 0;
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(results);
}
protected void grdUserName_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
lblMsg.Text = string.Empty;
lblMsgEdit.Text = string.Empty;
lblMsg.Visible = false;
lblMsgEdit.Visible = false;
int lngId = ML_Common.string2int32(grdUserName.DataKeys[e.NewEditIndex].Values[0].ToString());
if (lngId > 0)
{
ViewState["grdUserNameEditId"] = lngId;
grdUserName.EditIndex = -1;
e.Cancel = true;
FormFieldsClear();
FillObjectToForm(lngId, true);
UpdatePanelEdit.Update();
ModalPopupExtenderEdit.Show();
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Record is not exists?";
}
}
catch (Exception ex)
{
Exception exc = ex;
}
}
public int Update(ML_CokeType objML_CokeType)
{
int results = 0;
try
{
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Update Properties
new SqlParameter("@Id", objML_CokeType.Id),
new SqlParameter("@CokeTypeId", objML_CokeType.CokeTypeId),
new SqlParameter("@CokeType", objML_CokeType.CokeType),
new SqlParameter("@Remarks", objML_CokeType.Remarks),
new SqlParameter("@IsActive", objML_CokeType.IsActive),
new SqlParameter("@IsArchive", objML_CokeType.IsArchive),
//new SqlParameter("@CreatedDate", objML_CokeType.CreatedDate),
//new SqlParameter("@CreatedBy", objML_CokeType.CreatedBy),
//new SqlParameter("@ModifiedDate", objML_CokeType.ModifiedDate),
new SqlParameter("@ModifiedBy", objML_CokeType.ModifiedBy),
new SqlParameter("@CreatedByUserNameId", objML_CokeType.CreatedByUserNameId),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_UpdateCokeType.ToString(), this.Parameters);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc;
throw;
}
catch (Exception ex)
{
results = 0;
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(
}
return(results);
}
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;
}
}
public ML_CokeType GetCokeTypeByCokeTypeId(int CokeTypeId)
{
DataTable dt = new DataTable();
try
{
objML_CokeType = new ML_CokeType();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@CokeTypeId", CokeTypeId)
#endregion
};
this.Parameters = parameters;
SqlDataReader sdr = SqlHelper.ExecuteReader(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCokeTypeByCokeTypeId.ToString(), this.Parameters);
if (sdr.HasRows)
{
dt.Load(sdr);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
objML_CokeType.Id = ML_Common.string2int32(ML_Common.clean(dr["Id"].ToString()));
objML_CokeType.CokeTypeId = ML_Common.string2int32(ML_Common.clean(dr["CokeTypeId"].ToString()));
objML_CokeType.CokeType = ML_Common.clean(dr["CokeType"].ToString());
objML_CokeType.Remarks = ML_Common.clean(dr["Remarks"].ToString());
objML_CokeType.IsActive = ML_Common.clean(dr["IsActive"].ToString());
objML_CokeType.IsArchive = ML_Common.clean(dr["IsArchive"].ToString());
objML_CokeType.CreatedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["CreatedDate"].ToString()));
objML_CokeType.CreatedBy = ML_Common.clean(dr["CreatedBy"].ToString());
objML_CokeType.ModifiedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["ModifiedDate"].ToString()));
objML_CokeType.ModifiedBy = ML_Common.clean(dr["ModifiedBy"].ToString());
objML_CokeType.CreatedByUserNameId = ML_Common.string2int(ML_Common.clean(dr["CreatedByUserNameId"].ToString()));
}
}
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(
}
return(objML_CokeType);
}
public int Add(ML_UserType objML_UserType)
{
int results = 0;
try
{
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Add Properties
//new SqlParameter("@Id", objML_UserType.Id),
//new SqlParameter("@UserTypeId", objML_UserType.UserTypeId),
new SqlParameter("@UserType", objML_UserType.UserType),
new SqlParameter("@IsActive", objML_UserType.IsActive),
new SqlParameter("@IsArchive", objML_UserType.IsArchive),
//new SqlParameter("@CreatedDate", objML_UserType.CreatedDate),
new SqlParameter("@CreatedBy", objML_UserType.CreatedBy),
new SqlParameter("@CreatedByUserNameId", objML_UserType.CreatedByUserNameId),
//new SqlParameter("@ModifiedDate", objML_UserType.ModifiedDate),
//new SqlParameter("@ModifiedBy", objML_UserType.ModifiedBy),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_SaveUserType.ToString(), this.Parameters);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc; throw;
}
catch (Exception ex)
{
results = 0;
Exception exx = ex;
throw;
}
finally
{
//
}
return(results);
}
public ML_CanteenMaster GetCanteenMasterByCanteenActive(long CanteenActive)
{
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CanteenMaster:GetCanteenMasterById(long Id)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
objML_CanteenMaster = new ML_CanteenMaster();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@CanteenActive", CanteenActive)
#endregion
};
this.Parameters = parameters;
DataSet ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCanteenMasterByCanteenActive.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CanteenMaster:GetCanteenMasterById(long Id)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
objML_CanteenMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(dr["CanteenCode"].ToString()));
objML_CanteenMaster.CanteenName = ML_Common.clean(dr["CanteenName"].ToString());
objML_CanteenMaster.CanteenAddress = ML_Common.clean(dr["CanteenAddress"].ToString());
objML_CanteenMaster.CanteenActive = ML_Common.string2int32(ML_Common.clean(dr["CanteenActive"].ToString()));
}
}
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(objML_CanteenMaster);
}
protected void grdUserName_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int lngId = ML_Common.string2int32(grdUserName.DataKeys[e.RowIndex].Values[0].ToString());
DeleteGridRowItem(lngId);
FormFieldsClear();
lblMsg.Visible = true;
lblMsg.Text = string.Empty;
ViewState["grdUserNameEdit"] = null;
FillGrid();
}
catch (Exception ex)
{
Exception exx = ex;
}
}
public int DeleteCokeSupplierByCokeSupplierId(int CokeSupplierId)
{
int results = 0;
try
{
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Delete Properties
new SqlParameter("@CokeSupplierId", CokeSupplierId),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_DeleteCokeSupplierByCokeSupplierId.ToString(), this.Parameters);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc;
throw;
}
catch (Exception ex)
{
results = 0;
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(
}
return(results);
}
public int DeleteUserTypeByUserType(string UserType)
{
int results = 0;
try
{
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Delete Properties
new SqlParameter("@UserType", UserType),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_DeleteUserTypeByUserType.ToString(), this.Parameters);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc;
throw;
}
catch (Exception ex)
{
results = 0;
Exception exx = ex;
throw;
}
finally
{
//
}
return(results);
}
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 btnUpdate_Click(object sender, EventArgs e)
{
lblMsg.Text = string.Empty;
lblMsgEdit.Text = string.Empty;
if (IsValid)
{
//errNumber = -1;
try
{
BusinessClass objBusinessClass = new BusinessLayer.BusinessClass();
int lngId = Convert.ToInt32(ViewState["UserNameViewId"]);
ML_UserName objML_UserName = objBusinessClass.GetUserNameById(lngId);
objML_UserName.UserName = ML_Common.clean(txtUserNameEdit.Text);
objML_UserName.FirstName = ML_Common.clean(txtFirstNameEdit.Text);
objML_UserName.LastName = ML_Common.clean(txtLastNameEdit.Text);
objML_UserName.Email = ML_Common.clean(txtEmailEdit.Text);
objML_UserName.Telephone = ML_Common.clean(txtTelephoneEdit.Text);
objML_UserName.Mobile = ML_Common.clean(txtMobileEdit.Text);
objML_UserName.Remarks = ML_Common.clean(txtRemarksEdit.Text);
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.CreatedBy = ML_Common.clean(string.Empty);
objML_UserName.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString());
objML_UserName.ModifiedBy = ML_Common.clean(string.Empty);
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.UpdateUserName(objML_UserName);
if (obhReturn == 1)
{
lblMsg.Text = "Record Update Successfully";
lblMsgEdit.Text = "Record Update Successfully";
FormFieldsClear();
}
else if (obhReturn == 2)
{
lblMsg.Text = "Record Already Exists!";
lblMsgEdit.Text = "Record Already Exists!";
}
else
{
lblMsg.Text = "There are some issue while Updating!";
lblMsgEdit.Text = "There are some issue while Updating!";
}
UpdatePanelEdit.Update();
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc;
return;
}
catch (Exception ex)
{
Exception exx = 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_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);
// }
//}
}
public int Add(ML_CokeSupplier objML_CokeSupplier)
{
int results = 0;
try
{
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Add Properties
//new SqlParameter("@Id", objML_CokeSupplier.Id),
//new SqlParameter("@CokeSupplierId", objML_CokeSupplier.CokeSupplierId),
new SqlParameter("@CokeSupplier", objML_CokeSupplier.CokeSupplier),
new SqlParameter("@Address1", objML_CokeSupplier.Address1),
new SqlParameter("@Address2", objML_CokeSupplier.Address2),
new SqlParameter("@Address3", objML_CokeSupplier.Address3),
new SqlParameter("@CityName", objML_CokeSupplier.CityName),
new SqlParameter("@StateName", objML_CokeSupplier.StateName),
new SqlParameter("@PinCode", objML_CokeSupplier.PinCode),
new SqlParameter("@Title", objML_CokeSupplier.Title),
new SqlParameter("@CountryName", objML_CokeSupplier.CountryName),
new SqlParameter("@ContactPerson", objML_CokeSupplier.ContactPerson),
new SqlParameter("@MobNo", objML_CokeSupplier.MobNo),
new SqlParameter("@WebSite", objML_CokeSupplier.WebSite),
new SqlParameter("@Email", objML_CokeSupplier.Email),
new SqlParameter("@Remarks", objML_CokeSupplier.Remarks),
new SqlParameter("@IsActive", objML_CokeSupplier.IsActive),
new SqlParameter("@IsArchive", objML_CokeSupplier.IsArchive),
//new SqlParameter("@CreatedDate", objML_CokeSupplier.CreatedDate),
new SqlParameter("@CreatedBy", objML_CokeSupplier.CreatedBy),
//new SqlParameter("@ModifiedDate", objML_CokeSupplier.ModifiedDate),
//new SqlParameter("@ModifiedBy", objML_CokeSupplier.ModifiedBy),
new SqlParameter("@CreatedByUserNameId", objML_CokeSupplier.CreatedByUserNameId),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_SaveCokeSupplier.ToString(), this.Parameters);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
SqlException sqlExt = sqlExc;
throw;
}
catch (Exception ex)
{
results = 0;
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(
}
return(results);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsValid)
{
errNumber = -1;
try
{
objBusinessClass = new BusinessLayer.BusinessClass();
objML_CategoryGroupMaster = new ML_CategoryGroupMaster();
string strAdminLoginName = string.Empty;
if (Session["AdminLoginName"] != null)
{
strAdminLoginName = Session["AdminLoginName"].ToString();
}
// objML_CategoryGroupMaster.CategoryGroupCode = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupCode.Text));
objML_CategoryGroupMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(txtCanteenCode.Text));
objML_CategoryGroupMaster.CategoryGroupName = ML_Common.clean(txtCategoryGroupName.Text);
// objML_CategoryGroupMaster.CategoryGroupActive = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupActive.Text));
// objML_CategoryGroupMaster.IsActive = ML_Common.clean(ML_Common.bit2int(chkIsActive.Checked).ToString());
// objML_CategoryGroupMaster.IsArchive = ML_Common.clean(ML_Common.bit2int(chkIsArchive.Checked).ToString());
// objML_CategoryGroupMaster.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString());
// objML_CategoryGroupMaster.CreatedBy = ML_Common.clean(string.Empty);
// objML_CategoryGroupMaster.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString());
// objML_CategoryGroupMaster.ModifiedBy = ML_Common.clean(string.Empty);
int obhReturn = objBusinessClass.AddCategoryGroupMaster(objML_CategoryGroupMaster);
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);
}
}
}
public ML_CokeSupplier GetCokeSupplierByCokeSupplierId(int CokeSupplierId)
{
DataTable dt = new DataTable();
try
{
objML_CokeSupplier = new ML_CokeSupplier();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@CokeSupplierId", CokeSupplierId)
#endregion
};
this.Parameters = parameters;
SqlDataReader sdr = SqlHelper.ExecuteReader(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCokeSupplierByCokeSupplierId.ToString(), this.Parameters);
if (sdr.HasRows)
{
dt.Load(sdr);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
objML_CokeSupplier.Id = ML_Common.string2int32(ML_Common.clean(dr["Id"].ToString()));
objML_CokeSupplier.CokeSupplierId = ML_Common.string2int32(ML_Common.clean(dr["CokeSupplierId"].ToString()));
objML_CokeSupplier.CokeSupplier = ML_Common.clean(dr["CokeSupplier"].ToString());
objML_CokeSupplier.Address1 = ML_Common.clean(dr["Address1"].ToString());
objML_CokeSupplier.Address2 = ML_Common.clean(dr["Address2"].ToString());
objML_CokeSupplier.Address3 = ML_Common.clean(dr["Address3"].ToString());
objML_CokeSupplier.CityName = ML_Common.clean(dr["CityName"].ToString());
objML_CokeSupplier.StateName = ML_Common.clean(dr["StateName"].ToString());
objML_CokeSupplier.PinCode = ML_Common.clean(dr["PinCode"].ToString());
objML_CokeSupplier.Title = ML_Common.clean(dr["Title"].ToString());
objML_CokeSupplier.CountryName = ML_Common.clean(dr["CountryName"].ToString());
objML_CokeSupplier.ContactPerson = ML_Common.clean(dr["ContactPerson"].ToString());
objML_CokeSupplier.MobNo = ML_Common.clean(dr["MobNo"].ToString());
objML_CokeSupplier.WebSite = ML_Common.clean(dr["WebSite"].ToString());
objML_CokeSupplier.Email = ML_Common.clean(dr["Email"].ToString());
objML_CokeSupplier.Remarks = ML_Common.clean(dr["Remarks"].ToString());
objML_CokeSupplier.IsActive = ML_Common.clean(dr["IsActive"].ToString());
objML_CokeSupplier.IsArchive = ML_Common.clean(dr["IsArchive"].ToString());
objML_CokeSupplier.CreatedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["CreatedDate"].ToString()));
objML_CokeSupplier.CreatedBy = ML_Common.clean(dr["CreatedBy"].ToString());
objML_CokeSupplier.ModifiedDate = ML_Common.ToDateTimeSafe(ML_Common.clean(dr["ModifiedDate"].ToString()));
objML_CokeSupplier.ModifiedBy = ML_Common.clean(dr["ModifiedBy"].ToString());
objML_CokeSupplier.CreatedByUserNameId = ML_Common.string2int(ML_Common.clean(dr["CreatedByUserNameId"].ToString()));
}
}
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(
}
return(objML_CokeSupplier);
}
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;
}
}
}
