// 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)); }