protected void btnSave_Click(object sender, EventArgs e)
{
try
{
using (SalesDBEntities1 objEntity = new SalesDBEntities1())
{
customerMST objProNew = new customerMST();
objProNew.cellNumber = txtCell.Text;
objProNew.companyName = txtCompany.Text;
objProNew.CreatedBy = Convert.ToDecimal(Session["userID"]);
objProNew.CreatedDate = DateTime.Now;
objProNew.customerStatusID = Convert.ToInt64(ddlStatus.SelectedValue);
objProNew.customerTypeID = Convert.ToInt64(ddlType.SelectedValue);
objProNew.firstName = txtFName.Text;
objProNew.homeNumber = txtHome.Text;
objProNew.isActive = true;
objProNew.isDeleted = false;
objProNew.lastName = txtLName.Text;
objProNew.middelName = txtMName.Text;
objEntity.customerMSTs.Add(objProNew);
objEntity.SaveChanges();
Response.Redirect("~/customers.aspx", false);
}
}
catch (Exception ex)
{
appOperations.LogException(ex, "");
liVal.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
using (SalesDBEntities1 objEntity = new SalesDBEntities1())
{
decimal custID = Convert.ToDecimal(Session["custID"]);
customerMST objProNew = objEntity.customerMSTs.FirstOrDefault(cust => cust.customerID == custID);
if (objProNew != null)
{
objProNew.cellNumber = txtCell.Text;
objProNew.companyName = txtCompany.Text;
objProNew.LastmodifiedBy = Convert.ToDecimal(Session["userID"]);
objProNew.LastmodifiedDate = DateTime.Now;
objProNew.customerStatusID = Convert.ToInt64(ddlStatus.SelectedValue);
objProNew.customerTypeID = Convert.ToInt64(ddlType.SelectedValue);
objProNew.firstName = txtFName.Text;
objProNew.homeNumber = txtHome.Text;
objProNew.isActive = true;
objProNew.isDeleted = false;
objProNew.lastName = txtLName.Text;
objProNew.middelName = txtMName.Text;
objProNew.addressLine1 = txtAddress1.Text;
objProNew.addressLine2 = txtAddress2.Text;
objProNew.city = txtCity.Text;
if (txtDOB.Text != "")
{
objProNew.DOB = Convert.ToDateTime(txtDOB.Text);
}
objProNew.email = txtEmail.Text;
objProNew.website = txtWebSite.Text;
objProNew.workPhone = txtWorkPhone.Text;
objEntity.SaveChanges();
liVal.Text = "Saved Successfull.";
}
else
{
liVal.Text = "Customer Not Found.";
}
}
}
catch (Exception ex)
{
appOperations.LogException(ex, "");
liVal.Text = ex.Message;
}
}
private void getCust()
{
try
{
using (SalesDBEntities1 objEntity = new SalesDBEntities1())
{
decimal custID = Convert.ToDecimal(Session["custID"]);
customerMST objProNew = objEntity.customerMSTs.FirstOrDefault(cust => cust.customerID == custID);
if (objProNew != null)
{
txtCell.Text = objProNew.cellNumber;
txtCompany.Text = objProNew.companyName;
if (ddlStatus.Items.FindByValue(Convert.ToInt64(objProNew.customerStatusID).ToString()) != null)
{
ddlStatus.Items.FindByValue(Convert.ToInt64(objProNew.customerStatusID).ToString()).Selected = true;
}
if (ddlType.Items.FindByValue(Convert.ToInt64(objProNew.customerTypeID).ToString()) != null)
{
ddlType.Items.FindByValue(Convert.ToInt64(objProNew.customerTypeID).ToString()).Selected = true;
}
txtFName.Text = objProNew.firstName;
txtHome.Text = objProNew.homeNumber;
txtLName.Text = objProNew.lastName;
txtMName.Text = objProNew.middelName;
txtAddress1.Text = objProNew.addressLine1;
txtAddress2.Text = objProNew.addressLine2;
txtCity.Text = objProNew.city;
txtDOB.Text = Convert.ToString(objProNew.DOB);
txtEmail.Text = objProNew.email;
txtWebSite.Text = objProNew.website;
txtWorkPhone.Text = objProNew.workPhone;
}
else
{
liVal.Text = "Customer Not Found.";
}
}
}
catch (Exception ex)
{
appOperations.LogException(ex, "");
liVal.Text = ex.Message;
}
}