protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
{
if (ViewState["Mode"].ToString() == "Add")
{
DataTable dtCheckCustNo = partner.CheckTradingCustNo(txtCustNo.Text.ToString().Replace("'", "''"));
if (dtCheckCustNo.Rows.Count > 0)
{
partner.DisplayMessage(MessageType.Failure, "Customer Number already exists", lblMessage);
}
else
{
string tradingID;
columnValue = "'" + txtCustNo.Text.Replace("'", "''") + "'," +
"'" + ddlTradingType.SelectedItem.Value.ToString().Replace("'", "''") + "'," +
"'" + ddlTradingCode.SelectedItem.Value.ToString().Replace("'", "''") + "'," +
"'" + txtEmail.Text.Replace("'", "''") + "'," +
"'" + txtAssignedVendNo.Text.Replace("'", "''").Trim() + "'," +
"'" + Session["fCustomerMasterID"].ToString() + "'," +
"'" + Session["UserName"].ToString() + "'," +
"'" + DateTime.Now.ToShortDateString() + "'";
tradingID = partner.InsertTradingInformation(columnValue);
partner.DisplayMessage(MessageType.Success, "Data is Successfully added", lblMessage);
//ClearControl();
}
}
else
{
string updateValue;
if (txtCustNo.Text.ToString().Replace("'", "''") != Session["CustNo"].ToString().Replace("''", "''"))
{
DataTable dtCheckCustNo = partner.CheckTradingCustNo(txtCustNo.Text.ToString().Replace("'", "''"));
if (dtCheckCustNo.Rows.Count > 0)
{
// lbl.Text = "Customer Number already exists";
partner.DisplayMessage(MessageType.Failure, "Customer Number already exists ", lblMessage);
}
else
{
updateValue = "LocationCustomerNo='" + txtCustNo.Text.Replace("'", "").Trim() + "'," +
"EDIType='" + ddlTradingType.SelectedItem.Value.ToString() + "'," +
"TradingPartnerCd='" + ddlTradingCode.SelectedItem.Value.ToString() + "'," +
"AssignedVendorNo='" + txtAssignedVendNo.Text.ToString() + "'," +
"CustomerEDIEmailAddress='" + txtEmail.Text.Replace("'", "") + "'," +
"fCustomerMasterID='" + Session["fCustomerMasterID"].ToString() + "'," +
"ChangeID='" + Session["UserName"].ToString() + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'";
partner.UpdateTradingInformation(updateValue, Session["TradingID"].ToString());
partner.DisplayMessage(MessageType.Success, "Data is Successfully updated ", lblMessage);
// ClearControl();
ViewState["Mode"] = "Add";
}
}
else
{
updateValue = "LocationCustomerNo='" + txtCustNo.Text.Replace("'", "").Trim() + "'," +
"EDIType='" + ddlTradingType.SelectedItem.Value.ToString() + "'," +
"TradingPartnerCd='" + ddlTradingCode.SelectedItem.Value.ToString() + "'," +
"AssignedVendorNo='" + txtAssignedVendNo.Text.ToString() + "'," +
"CustomerEDIEmailAddress='" + txtEmail.Text.Replace("'", "") + "'," +
"ChangeID='" + Session["UserName"].ToString() + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'";
partner.UpdateTradingInformation(updateValue, Session["TradingID"].ToString());
partner.DisplayMessage(MessageType.Success, "Data is Successfully updated", lblMessage);
// ClearControl();
ViewState["Mode"] = "Add";
}
}
ViewState["CustomerNo"] = txtCustNo.Text;
string value = "";
BindLocationDetails(value);
SelectedNode = ViewState["CustomerNo"].ToString();
ClearControl();
upnlMessage.Update();
upnlData.Update();
upnlMenu.Update();
}
