Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #3
0
        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);
        }
Example #4
0
        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);
        }