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