public TransactionStatus UpdateConsumerProfile(ConsumerFormBo consumerBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerFormDomain(consumerBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@Cons_First_Name", consumer.Cons_First_Name), //0
new SqlParameter("@Cons_Last_Name", consumer.Cons_Last_Name), //1
new SqlParameter("@Cons_Gender", consumer.Cons_Gender), //2
new SqlParameter("@Cons_Dob", consumer.Cons_Dob.ToString("dd/MM/yyyy")), //3
new SqlParameter("@Cons_mailid", consumer.Cons_mailid), //4
new SqlParameter("@Cons_Mobile", consumer.Cons_Mobile), //6
new SqlParameter("@Cons_Addr1", consumer.Cons_Addr1), //7
new SqlParameter("@Cons_Addr2", consumer.Cons_Addr2), //8
new SqlParameter("@Cons_City", consumer.Cons_City), //9
new SqlParameter("@Cons_Area", consumer.Cons_Area), //12
new SqlParameter("@Cons_Pincode", consumer.Cons_Pincode), //12
new SqlParameter("@Cons_Company", consumer.Cons_Company), //12
new SqlParameter("@Cons_Company_Id", consumer.Cons_Company_Id), //13
new SqlParameter("@Cons_Reference", consumer.Cons_Reference), //14
new SqlParameter("@Cons_Ipaddress", consumer.Cons_Ipaddress), //19
new SqlParameter("@Cons_Id", consumer.Cons_Id) //23
};
Params[0].Direction = ParameterDirection.Output;
//string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateConsumer", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[0].Value.ToString();
return(transactionStatus);
}
private ConsumerForm BuiltConsumerFormDomain(ConsumerFormBo consumer)
{
return((ConsumerForm) new ConsumerForm().InjectFrom(consumer));
}
