// For Loyalty
public TransactionStatus AddLoyalty(LoyaltyBo loyaltyBo)
{
var transactionStatus = new TransactionStatus();
var loyalty = BuiltLoyaltyDomain(loyaltyBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Loyal_Desc", loyalty.Loyal_Desc), //0
new SqlParameter("@Loyal_Max_Allowed", loyalty.Loyal_Max_Allowed), //1
new SqlParameter("@Loyal_Min_redmpt", loyalty.Loyal_Min_redmpt), //2
new SqlParameter("@Loyal_Max_redmpt", loyalty.Loyal_Max_redmpt), //3
new SqlParameter("@Loyal_Start_On", loyalty.Loyal_Start_On), //4
new SqlParameter("@Loyal_End_On", loyalty.Loyal_End_On), //5
new SqlParameter("@Loyal_Set_Up", loyalty.Loyal_Set_Up), //6
new SqlParameter("@Loyal_Checked_By", loyalty.Loyal_Checked_By), //7
new SqlParameter("@Loyal_Approved_By", loyalty.Loyal_Approved_By), //8
new SqlParameter("@Loyal_Active_flag", "true"), //9
new SqlParameter("@opReturnValue", SqlDbType.Int) //10
};
Params[10].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddLoyalty", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
private Loyalty BuiltLoyaltyDomain(LoyaltyBo loyaltyBo)
{
return((Loyalty) new Loyalty().InjectFrom(loyaltyBo));
}
