public TransactionStatus UpdateSystemProfile(SystemProfileBo systemprofileBo)
{
var transactionStatus = new TransactionStatus();
var systemprofile = BuiltSystemProfileDomain(systemprofileBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@id", systemprofile.Id), //0
new SqlParameter("@company_Title", systemprofile.Company_Title), //1
new SqlParameter("@owned_By", systemprofile.Owned_By), //2
new SqlParameter("@cin_Number", systemprofile.CIN_Number), //3
new SqlParameter("@adr1", systemprofile.Adr1), //4
new SqlParameter("@adr2", systemprofile.Adr2), //5
new SqlParameter("@location", systemprofile.Location), //6
new SqlParameter("@city", systemprofile.City), //7
new SqlParameter("@tin_id", systemprofile.Tin_id), //8
new SqlParameter("@phone", systemprofile.Phone), //9
new SqlParameter("@mobile", systemprofile.Mobile), //10
new SqlParameter("@email", systemprofile.Email), //11
new SqlParameter("@sms_Url", systemprofile.Sms_Url), //12
new SqlParameter("@user_Id", systemprofile.User_Id), //13
new SqlParameter("@EmailMaster", systemprofile.SetupEmail), //14
new SqlParameter("@Pwd", systemprofile.Password), //15
new SqlParameter("@smtp", systemprofile.SMTP), //16
new SqlParameter("@opReturnValue", SqlDbType.Int) //17
};
Params[17].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateSystemProfile", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
public String AddSystemProfile(SystemProfileBo systemprofileBo)
{
var transactionStatus = new TransactionStatus();
var systemprofile = BuiltSystemProfileDomain(systemprofileBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@company_Title", systemprofile.Company_Title), //0
new SqlParameter("@owned_By", systemprofile.Owned_By), //1
new SqlParameter("@cin_Number", systemprofile.CIN_Number), //2
new SqlParameter("@adr1", systemprofile.Adr1), //3
new SqlParameter("@adr2", systemprofile.Adr2), //4
new SqlParameter("@location", systemprofile.Location), //5
new SqlParameter("@city", systemprofile.City), //6
new SqlParameter("@tin_id", systemprofile.Tin_id), //7
new SqlParameter("@phone", systemprofile.Phone), //8
new SqlParameter("@mobile", systemprofile.Mobile), //9
new SqlParameter("@email", systemprofile.Email), //10
new SqlParameter("@sms_Url", systemprofile.Sms_Url), //11
new SqlParameter("@user_Id", systemprofile.User_Id), //112
new SqlParameter("@UserProfile_Id", systemprofile.UserProfile_Id), //13
new SqlParameter("@opReturnValue", SqlDbType.Int) //14
};
Params[14].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddSystemProfile", Params);
return(ds.Tables[0].Rows[0][0].ToString());
}
private SystemProfile BuiltSystemProfileDomain(SystemProfileBo systemprofileBo)
{
return((SystemProfile) new SystemProfile().InjectFrom(systemprofileBo));
}
