public void Delete(GameDiscount entity)
{
if (_db.Entry(entity).State == EntityState.Detached)
{
_db.Attach(entity);
}
_db.GameDiscounts.Remove(entity);
}
public void Update(GameDiscount entity)
{
if (_db.Entry(entity).State == EntityState.Detached)
{
_db.GameDiscounts.Attach(entity);
}
_db.Entry(entity).State = EntityState.Modified;
}
public List <GameDiscount> GetAllGameDiscount()
{
List <GameDiscount> GameDiscountList = new List <GameDiscount>();
var dataTable = productData.GetAllGameDiscount();
foreach (DataRow dr in dataTable.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());
GameDiscountList.Add(discount);
}
return(GameDiscountList);
}
public async Task InsertAsync(GameDiscount entity)
{
await _db.GameDiscounts.AddAsync(entity);
}
public void Insert(GameDiscount entity)
{
_db.GameDiscounts.Add(entity);
}
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);
}
