protected void ibtnUpdate_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
if (ddlCode.SelectedValue == "P")
{
customerDetails.UpdateCustomerDetails("CustomerContact", "ContactCd='A'", "fCustAddrID=" + hidAddressID.Value.Trim());
}
if (Mode == "Add")
{
//[fCustAddrID],CustNo,ContactType,ContactCd,[Name],[JobTitle],[Phone],[PhoneExt],[FaxNo],[MobilePhone],
//[EmailAddr],[Department],[EntryID],[EntryDt],[ChangeID],[ChangeDt]
string columnValue = AddressID + "," +
"'" + CustomerNumber + "'," +
"'" + ddlType.SelectedValue + "'," +
"'" + ddlCode.SelectedValue + "'," +
"'" + txtName.Text.Trim().Replace("'", "''") + "'," +
"'" + txtJobTitle.Text.Trim().Replace("'", "''") + "'," +
"'" + phContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"'" + txtExt.Text.Trim().Replace("'", "''") + "'," +
"'" + fxContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"'" + txtMphone.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"'" + txtEmail.Text.Trim().Replace("'", "''") + "'," +
"'" + txtDepartment.Text.Trim().Replace("'", "''") + "'," +
"'" + ((Session["UserName"] != null) ? Session["UserName"].ToString() : "") + "'," +
"'" + DateTime.Now.ToShortDateString() + "'";
hidContactID.Value = customerDetails.InsertContactDetails(columnValue);
}
else
if (hidMode.Value == "Edit")
{
string updateValue = "ContactType='" + ddlType.SelectedValue + "'," +
"ContactCd='" + ddlCode.SelectedValue + "'," +
"Name='" + txtName.Text.Trim().Replace("'", "''") + "'," +
"JobTitle='" + txtJobTitle.Text.Trim().Replace("'", "''") + "'," +
"Phone='" + phContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"PhoneExt='" + txtExt.Text.Trim().Replace("'", "''") + "'," +
"FaxNo='" + fxContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"MobilePhone='" + txtMphone.GetPhoneNumber.Trim().Replace("'", "''") + "'," +
"EmailAddr='" + txtEmail.Text.Trim().Replace("'", "''") + "'," +
"Department='" + txtDepartment.Text.Trim().Replace("'", "''") + "'," +
"ChangeID='" + ((Session["UserName"] != null) ? Session["UserName"].ToString() : "") + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'";
customerDetails.UpdateCustomerDetails("CustomerContact", updateValue, "pCustContactsID=" + hidContactID.Value.Trim());
}
if (ddlCode.SelectedValue == "P")
{
customerDetails.UpdateCustomerDetails("CustomerAddress", "fCustContactsID=" + hidContactID.Value.Trim(), "pCustomerAddressID=" + hidAddressID.Value.Trim());
}
tblContactEntry.Visible = false;
btnAdd.Visible = true;
BindContactDetails();
divDisplay.Style.Add(HtmlTextWriterStyle.Display, "");
}
}
