//for Add Consumer
public TransactionStatus AddConsumer(ConsumerBo consumerBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerDomain(consumerBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
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), //3
new SqlParameter("@Cons_mailid", consumer.Cons_mailid), //4
new SqlParameter("@Cons_Pswd", consumer.Cons_Pswd), //5
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), //10
new SqlParameter("@Cons_Pincode", consumer.Cons_Pincode), //11
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_Affiliates_Id", consumer.Cons_Affiliates_Id), //15
new SqlParameter("@Cons_Loyalty_Id", consumer.Cons_Loyalty_Id), //16
new SqlParameter("@Cons_Earned_Loyalpoints", consumer.Cons_Earned_Loyalpoints), //17
new SqlParameter("@Cons_Redeemed_Loyalpoints1", consumer.Cons_Redeemed_Loyalpoints1), //18
new SqlParameter("@Cons_Ipaddress", consumer.Cons_Ipaddress), //19
new SqlParameter("@Cons_regist_On", consumer.Cons_regist_On), //20
new SqlParameter("@Cons_Active_flag", consumer.Cons_Active_flag), //21
new SqlParameter("@opReturnValue", SqlDbType.Int) //22
};
Params[22].Direction = ParameterDirection.Output;
//string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddConsumer", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[22].Value.ToString();
return(transactionStatus);
}
//for reset pwd
public TransactionStatus UpdateConsumerPswd(ConsumerBo consumerBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerDomain(consumerBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@Cons_Pswd", consumer.Cons_Pswd), //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_UpdateConsumerPswd", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[0].Value.ToString();
return(transactionStatus);
}
//for Add Consumer
public TransactionStatus AddConsumer(ConsumerBo consumerBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerDomain(consumerBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cons_First_Name", SqlDbType.NVarChar), //0
new SqlParameter("@Cons_Last_Name", SqlDbType.NVarChar), //1
new SqlParameter("@Cons_Gender", SqlDbType.NVarChar), //2
new SqlParameter("@Cons_Dob", SqlDbType.NVarChar), //3
new SqlParameter("@Cons_mailid", SqlDbType.NVarChar), //4
new SqlParameter("@Cons_Pswd", SqlDbType.NVarChar), //5
new SqlParameter("@Cons_Mobile", SqlDbType.NVarChar), //6
new SqlParameter("@Cons_Addr1", SqlDbType.NVarChar), //7
new SqlParameter("@Cons_Addr2", SqlDbType.NVarChar), //8
new SqlParameter("@Cons_City", SqlDbType.NVarChar), //9
new SqlParameter("@Cons_Area", SqlDbType.NVarChar), //10
new SqlParameter("@Cons_Pincode", SqlDbType.Int), //11
new SqlParameter("@Cons_Company", SqlDbType.NVarChar), //12
new SqlParameter("@Cons_Company_Id", SqlDbType.NVarChar), //13
new SqlParameter("@Cons_Reference", SqlDbType.NVarChar), //14
new SqlParameter("@Cons_Affiliates_Id", SqlDbType.Int), //15
new SqlParameter("@Cons_Loyalty_Id", SqlDbType.Int), //16
new SqlParameter("@Cons_Earned_Loyalpoints", SqlDbType.Int), //17
new SqlParameter("@Cons_Ipaddress", SqlDbType.NVarChar), //19
new SqlParameter("@Cons_regist_On", DateTime.Now), //20
new SqlParameter("@Cons_Active_flag", 1), //21
new SqlParameter("@opReturnValue", SqlDbType.Int) //22
};
if (!String.IsNullOrEmpty(consumer.Cons_First_Name))
{
Params[0].Value = consumer.Cons_First_Name;
}
else
{
Params[0].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Last_Name))
{
Params[1].Value = consumer.Cons_Last_Name;
}
else
{
Params[1].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Gender))
{
Params[2].Value = consumer.Cons_Gender;
}
else
{
Params[2].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Dob))
{
Params[3].Value = consumer.Cons_Dob;
}
else
{
Params[3].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_mailid))
{
Params[4].Value = consumer.Cons_mailid;
}
else
{
Params[4].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Pswd))
{
Params[5].Value = consumer.Cons_Pswd;
}
else
{
Params[5].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Mobile))
{
Params[6].Value = consumer.Cons_Mobile;
}
else
{
Params[6].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Addr1))
{
Params[7].Value = consumer.Cons_Addr1;
}
else
{
Params[7].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Addr2))
{
Params[8].Value = consumer.Cons_Addr2;
}
else
{
Params[8].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_City))
{
Params[9].Value = consumer.Cons_City;
}
else
{
Params[9].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Area))
{
Params[10].Value = consumer.Cons_Area;
}
else
{
Params[10].Value = DBNull.Value;
}
if (consumer.Cons_Pincode != 0)
{
Params[11].Value = consumer.Cons_Pincode;
}
else
{
Params[11].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Company))
{
Params[12].Value = consumer.Cons_Company;
}
else
{
Params[12].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Company_Id))
{
Params[13].Value = consumer.Cons_Company_Id;
}
else
{
Params[13].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Reference))
{
Params[14].Value = consumer.Cons_Reference;
}
else
{
Params[14].Value = DBNull.Value;
}
if (consumer.Cons_Affiliates_Id != 0)
{
Params[15].Value = consumer.Cons_Affiliates_Id;
}
else
{
Params[15].Value = DBNull.Value;
}
if (consumer.Cons_Loyalty_Id != 0)
{
Params[16].Value = consumer.Cons_Loyalty_Id;
}
else
{
Params[16].Value = DBNull.Value;
}
if (consumer.Cons_Earned_Loyalpoints != 0)
{
Params[17].Value = consumer.Cons_Earned_Loyalpoints;
}
else
{
Params[17].Value = DBNull.Value;
}
if (consumer.Cons_Redeemed_Loyalpoints1 != 0)
{
Params[18].Value = consumer.Cons_Redeemed_Loyalpoints1;
}
else
{
Params[18].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Ipaddress))
{
Params[19].Value = consumer.Cons_Ipaddress;
}
else
{
Params[19].Value = DBNull.Value;
}
Params[22].Direction = ParameterDirection.Output;
//string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddConsumer", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[22].Value.ToString();
return(transactionStatus);
}
private Consumer BuiltConsumerDomain(ConsumerBo consumer)
{
return((Consumer) new Consumer().InjectFrom(consumer));
}
