protected static DeltoneCRM.ViewQuoteCom.ContactUpdate getExisitingCustomerContactDetails(String CustID)
{
var obj = new DeltoneCRM.ViewQuoteCom.ContactUpdate();
String strCompanyName = "";
String CustomerName = "";
String CustomerShipAddressLine1 = "";
String CustomerShipCity = "";
String CustomerShipPostcode = "";
String CustomerShipState = "";
String CustomerContactNumber = "";
String CustomerEmail = "";
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT CT.*, CP.CompanyName FROM dbo.Quote_Contacts CT, dbo.Quote_Companies CP WHERE CT.CompanyID = CP.CompanyID AND CP.CompanyID = " + CustID;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
strCompanyName = sdr["CompanyName"].ToString();
CustomerName = sdr["FirstName"].ToString();
var lastName = sdr["LastName"].ToString();
CustomerShipAddressLine1 = sdr["STREET_AddressLine1"].ToString();
CustomerShipCity = sdr["STREET_City"].ToString();
CustomerShipPostcode = sdr["STREET_PostalCode"].ToString();
CustomerShipState = sdr["STREET_Region"].ToString();
CustomerContactNumber = sdr["DEFAULT_AreaCode"].ToString() + ' ' + sdr["DEFAULT_Number"].ToString();
CustomerEmail = sdr["Email"].ToString();
obj.CompanyName = strCompanyName;
obj.ComId = Convert.ToInt32(CustID);
obj.Address1 = CustomerShipAddressLine1;
obj.City = CustomerShipCity;
obj.Email = CustomerEmail;
obj.FirstName = CustomerName;
obj.LastName = lastName;
obj.AreaCode = sdr["DEFAULT_AreaCode"].ToString();
obj.DefaultNumber = sdr["DEFAULT_Number"].ToString();
obj.Phone = sdr["MOBILE_Number"].ToString();
obj.PostCode = CustomerShipPostcode;
obj.State = CustomerShipState;
}
}
}
}
return(obj);
}
private static void UpdateCom_Contacts(DeltoneCRM.ViewQuoteCom.ContactUpdate obj)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
var strSqlContactStmt = @"UPDATE Quote_Contacts SET FirstName=@FirstName, LastName=@LastName , AlteredBy=@AlteredBy ,
STREET_AddressLine1=@STREET_AddressLine1, STREET_City=@STREET_City,DEFAULT_Number=@DEFAULT_Number,DEFAULT_AreaCode=@DEFAULT_AreaCode ,MOBILE_Number=@Mobile_Number , Email=@Email ,
STREET_PostalCode=@STREET_PostalCode, STREET_Region=@STREET_Region,AlteredDateTime=CURRENT_TIMESTAMP
WHERE CompanyID=@ContactID";
cmd.Connection = conn;
conn.Open();
cmd.CommandText = strSqlContactStmt;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = obj.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = obj.LastName;
cmd.Parameters.Add("@AlteredBy", SqlDbType.NVarChar).Value = HttpContext.Current.Session["LoggedUser"].ToString();
cmd.Parameters.Add("@STREET_AddressLine1", SqlDbType.NVarChar).Value = obj.Address1;
cmd.Parameters.Add("@STREET_City", SqlDbType.NVarChar).Value = obj.City;
cmd.Parameters.Add("@STREET_PostalCode", SqlDbType.NVarChar).Value = obj.PostCode;
cmd.Parameters.Add("@STREET_Region", SqlDbType.NVarChar).Value = obj.State;
cmd.Parameters.Add("@Mobile_Number", SqlDbType.NVarChar).Value = obj.Phone;
cmd.Parameters.Add("@DEFAULT_AreaCode", SqlDbType.NVarChar).Value = obj.AreaCode;
cmd.Parameters.Add("@DEFAULT_Number", SqlDbType.NVarChar).Value = obj.DefaultNumber;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = obj.Email;
cmd.Parameters.Add("@ContactID", SqlDbType.Int).Value = obj.ComId;
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
public static void UpdateContact(DeltoneCRM.ViewQuoteCom.ContactUpdate obj)
{
UpdateCom_Contacts(obj);
}
