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);
}
}
}
}
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 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 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);
}
}
}
