// For Loyalty
public TransactionStatus AddPromotion(PromotionBo promotiontyBo)
{
var transactionStatus = new TransactionStatus();
var promotion = BuiltPromotionDomain(promotiontyBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Promo_Code", promotion.Promo_Code), //0
new SqlParameter("@Promo_descr", promotion.Promo_descr), //1
new SqlParameter("@Promo_Type", promotion.Promo_Type), //2
new SqlParameter("@Prop_Value", promotion.Prop_Value), //3
new SqlParameter("@Promo_Start", promotion.Promo_Start), //4
new SqlParameter("@Promo_End", promotion.Promo_End), //5
new SqlParameter("@Promo_Active_flag", "true"), //6
new SqlParameter("@opReturnValue", SqlDbType.Int) //7
};
Params[7].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddPromotion", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
private Promotion BuiltPromotionDomain(PromotionBo promotionBo)
{
return((Promotion) new Promotion().InjectFrom(promotionBo));
}
