public ActionResult SaveDiscount(TransactionDiscount data)
{
int s = b.SaveDiscount(data);
// return View();
return(Json(1, JsonRequestBehavior.AllowGet));
}
public Transaction InsertTransactionFromTemp(IConnectionHandler connectionHandler, Temp temp, Transaction newtransaction, byte paytype)
{
var bo = new TransactionBO();
var orderId = bo.Max(connectionHandler, x => x.InvoiceId) + 1;
var transaction = new Transaction
{
Amount = temp.Amount,
PayTypeId = paytype,
InvoiceId = orderId,
Status = null,
Description = temp.Description,
PayerId = temp.PayerId,
PayerTitle = temp.PayerTitle,
CallBackUrl = temp.CallBackUrl,
CurrencyType = temp.CurrencyType,
AdditionalData = temp.AdditionalData,
TrackYourOrderNum = temp.TrackYourOrderNum
};
if (newtransaction != null)
{
transaction.DocNo = newtransaction.DocNo;
transaction.PayDate = newtransaction.PayDate;
transaction.DocScan = newtransaction.DocScan;
transaction.AccountId = newtransaction.AccountId;
transaction.OnlineBankId = newtransaction.OnlineBankId;
}
if (!ValidateTransaction(transaction))
{
return(null);
}
if (!this.Insert(connectionHandler, transaction))
{
throw new Exception(Resources.Payment.ErrorInSaveTransaction);
}
var transactionDiscountBo = new TransactionDiscountBO();
var discountAttaches = new TempDiscountBO().Where(connectionHandler, discount => discount.TempId == temp.Id);
foreach (var discountAttach in discountAttaches)
{
if (discountAttaches.Count > 1)
{
System.Threading.Thread.Sleep(1000);
}
var transactionDiscount = new TransactionDiscount
{
TransactionId = transaction.Id,
DiscountTypeId = discountAttach.DiscountTypeId,
AttachId = discountAttach.AttachId
};
if (!transactionDiscountBo.Insert(connectionHandler, transactionDiscount))
{
throw new Exception(Resources.Payment.ErrorInSaveTransactionDiscount);
}
}
return(transaction);
}
public TransactionDiscount GetDiscountById(int id)
{
try
{
var dataTable = productData.GetDiscountById(id);
TransactionDiscount discount = null;
//To Do : get only top 1 discount
//dataTable.Rows[0][0]
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
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());
break;
}
}
if (discount == null)
{
discount = new TransactionDiscount();
}
return(discount);
}
catch (Exception e)
{
// LogError
throw e;
}
}
public int SaveDiscount(TransactionDiscount discount)
{
int status = productData.SaveDiscount(discount.ActiveFlag, discount.AutomaticApply, discount.CouponMendatory, discount.DiscountAmount, discount.DiscountID, discount.DiscountName, discount.DiscountPercentage, discount.DiscountType, discount.DisplayInPOS, discount.DisplayOrder, discount.LastUpdatedDate, discount.LastUpdatedUser, discount.ManagerApproval, discount.MinimumSaleAmount, discount.MinimumUsedCredits, discount.RemarkMendatory, discount.Type);
return(status);
}
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);
}
