private void InsertCustomer()
{
string columnName = "CustNo,CustName,SortName,CustSearchKey,AltCustName,fbilltono,CustCd,EntryDt,EntryID";
string fbilltoNo = "";
if (ddlCode.SelectedValue == "BTST")
{
fbilltoNo = txtCustNo.Text.Replace("'", "''");
}
else if (ddlCode.SelectedValue == "ST")
{
fbilltoNo = BillCustomerNo;
}
string updateString = "'" + txtCustNo.Text.Replace("'", "''") + "'," +
"'" + txtCustName.Text.Replace("'", "''") + "'," +
"'" + txtSortName.Text.Replace("'", "''") + "'," +
"'" + txtSearchKey.Text.Replace("'", "''") + "'," +
"'" + txtAltCustName.Text.Replace("'", "''") + "'," +
"'" + fbilltoNo + "'," +
"'" + ddlCode.SelectedValue + "'," +
"'" + DateTime.Now.ToShortDateString() + "'," +
"'" + Session["UserName"].ToString().Replace("'", "''") + "'";
newCustID = customerDetails.InsertCustomerDetails(columnName, updateString);
}
