public MasterDiscounts GetAllDiscounts() { DataTable transactiondiscount = new DataTable();; DataTable gamedisc = new DataTable(); List <GameDiscount> gamediscount = new List <GameDiscount>(); MasterDiscounts m = new MasterDiscounts(); DataTable dataTable = productData.GetAllDiscounts(); try { transactiondiscount = dataTable.AsEnumerable() .Where(r => r.Field <string>("discount_type") == "T") .CopyToDataTable(); } catch { } try { gamedisc = dataTable.AsEnumerable() .Where(r => r.Field <string>("discount_type") != "T") .CopyToDataTable(); } catch (Exception e1) { } MasterDiscounts masterdiscount = new MasterDiscounts(); foreach (DataRow dr in transactiondiscount.Rows) { TransactionDiscount discount = new TransactionDiscount(); discount.DiscountID = dr.IsNull("discount_id") ? 0 : int.Parse(dr["discount_id"].ToString()); discount.DiscountName = dr.IsNull("discount_name") ? "" : (dr["discount_name"].ToString()); discount.DiscountPercentage = dr.IsNull("discount_percentage") ? 0 : decimal.Parse(dr["discount_percentage"].ToString()); discount.DiscountType = dr.IsNull("discount_type") ? "" : (dr["discount_type"].ToString()); discount.RemarkMendatory = dr.IsNull("RemarksMandatory") ? false : bool.Parse(dr["RemarksMandatory"].ToString()); discount.ActiveFlag = dr.IsNull("active_flag") ? false : bool.Parse(dr["active_flag"].ToString()); discount.AutomaticApply = dr.IsNull("automatic_apply") ? false : bool.Parse(dr["automatic_apply"].ToString()); discount.CouponMendatory = dr.IsNull("CouponMandatory") ? false : bool.Parse(dr["CouponMandatory"].ToString()); discount.DiscountAmount = dr.IsNull("DiscountAmount") ? 0 : float.Parse(dr["DiscountAmount"].ToString()); discount.MinimumSaleAmount = dr.IsNull("minimum_sale_amount") ? 0 : int.Parse(dr["minimum_sale_amount"].ToString()); discount.MinimumUsedCredits = dr.IsNull("minimum_credits") ? 0 : int.Parse(dr["minimum_credits"].ToString()); discount.DisplayInPOS = dr.IsNull("display_in_POS") ? false : bool.Parse(dr["display_in_POS"].ToString()); discount.ManagerApproval = dr.IsNull("manager_approval_required") ? false : bool.Parse(dr["manager_approval_required"].ToString()); discount.LastUpdatedDate = Convert.ToDateTime(dr.IsNull("last_updated_date") ? "01/01/2019" : (dr["last_updated_date"].ToString())); discount.LastUpdatedUser = dr.IsNull("last_updated_user") ? "" : (dr["last_updated_user"].ToString()); discount.DisplayOrder = dr.IsNull("sort_order") ? 0 : int.Parse(dr["sort_order"].ToString()); masterdiscount.transactiondiscount.Add(discount); } foreach (DataRow dr in gamedisc.Rows) { GameDiscount discount = new GameDiscount(); discount.DiscountID = dr.IsNull("discount_id") ? 0 : int.Parse(dr["discount_id"].ToString()); discount.DiscountName = dr.IsNull("discount_name") ? "" : (dr["discount_name"].ToString()); discount.DiscountPercentage = dr.IsNull("discount_percentage") ? 0 : int.Parse(dr["discount_percentage"].ToString()); discount.ActiveFlag = dr.IsNull("active_flag") ? false : bool.Parse(dr["active_flag"].ToString()); discount.MinimumUsedCredits = dr.IsNull("minimum_credits") ? 0 : int.Parse(dr["minimum_credits"].ToString()); discount.LastUpdatedDate = Convert.ToDateTime(dr.IsNull("last_updated_date") ? "01/01/2019" : (dr["last_updated_date"].ToString())); discount.LastUpdatedUser = dr.IsNull("last_updated_user") ? "" : (dr["last_updated_user"].ToString()); //discount.DisplayOrder = dr.IsNull("sort_order") ? 0 : int.Parse(dr["sort_order"].ToString()); masterdiscount.gaamediscount.Add(discount); } return(masterdiscount); }
// // GET: /Discount/ public ActionResult Index() { MasterDiscounts datatable = b.GetAllDiscounts(); return(View("Discount", datatable)); }