public static Dictionary <int, string> GetAllProductPromotionInfo(List <int> productIds) { Dictionary <int, string> result = new Dictionary <int, string>(); DataTable dt = new BundlingDao().GetAllProductPromotionInfo(productIds); if (dt != null) { foreach (DataRow row in dt.Rows) { int productId = 0; if (row["ProductId"] != DBNull.Value) { productId = (int)row["ProductId"]; if (!result.ContainsKey(productId)) { result.Add(productId, (string)row["PromotionName"].ToString()); } } } } return(result); }
public static bool UpdateBundlingProduct(BundlingInfo bundlingInfo) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { BundlingDao bundlingDao = new BundlingDao(); if (!bundlingDao.UpdateBundlingProduct(bundlingInfo, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!bundlingDao.DeleteBundlingByID(bundlingInfo.BundlingID, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!bundlingDao.AddBundlingProductItems(bundlingInfo.BundlingID, bundlingInfo.BundlingItemInfos, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } } catch (Exception var_4_91) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static DataTable GetProductPromotionList(Member member, int productid) { //Member member = HiContext.Current.User as Member; DataTable result; if (member != null) { result = new BundlingDao().GetProductPromotionList(productid, member); } else { result = null; } return(result); }
public static PromotionInfo GetProductPromotionInfo(Member member, int productid) { //Member member = HiContext.Current.User as Member; PromotionInfo result; if (member != null) { result = new BundlingDao().GetProductPromotionInfo(productid, member); } else { result = null; } return(result); }