public DataSet AddConsumerMandet(ConsumerMandetBo consumerBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerMandetDomain(consumerBo);
string compName = string.Empty;
if (consumer.emailCheck)
{
var index = consumer.Cons_mailid.IndexOf('.');
var domain = consumer.Cons_mailid.Split('@')[1];
compName = domain.Split('.')[0];
consumer.Cons_Company = compName;
}
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_mailid", SqlDbType.NVarChar), //2
new SqlParameter("@Cons_Pswd", SqlDbType.NVarChar), //3
new SqlParameter("@Cons_Mobile", SqlDbType.NVarChar), //4
new SqlParameter("@Cons_regist_On", DateTime.Now), //5
new SqlParameter("@Cons_Active_flag", 1), //6
new SqlParameter("@opReturnValue", SqlDbType.Int), //7
new SqlParameter("@cons_company", SqlDbType.NVarChar)
};
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_Last_Name))
{
Params[1].Value = consumer.Cons_Last_Name;
}
else
{
Params[1].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_mailid))
{
Params[2].Value = consumer.Cons_mailid;
}
else
{
Params[2].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Pswd))
{
Params[3].Value = consumer.Cons_Pswd;
}
else
{
Params[3].Value = DBNull.Value;
}
if (!String.IsNullOrEmpty(consumer.Cons_Mobile))
{
Params[4].Value = consumer.Cons_Mobile;
}
else
{
Params[4].Value = DBNull.Value;
}
Params[7].Direction = ParameterDirection.Output;
if (!String.IsNullOrEmpty(consumer.Cons_Company))
{
Params[8].Value = consumer.Cons_Company;
}
else
{
Params[8].Value = DBNull.Value;
}
//string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddConsumerMandet", Params);
return(ds);
}
private ConsumerMandet BuiltConsumerMandetDomain(ConsumerMandetBo consumer)
{
return((ConsumerMandet) new ConsumerMandet().InjectFrom(consumer));
}
