public JsonResult InsertInvoicePurchase(string UserBizCode, string TotalPrice)
{
var DbUser = _context.Tbl_User.SingleOrDefault(u => u.BIZCode == UserBizCode);
PersianDateTime now = PersianDateTime.Now;
var ShamsiDate = now.ToString();
DateTime MiladiDate = DateTime.Now;
var Invoice = new Tbl_Invoices {
UserID = DbUser.Id, SellerID = Convert.ToInt32(Session["UserId"]), DateTime = ShamsiDate, InvoiceStatesID = 1, Description = "خرید از فروشگاه سیرجان"
};
var Purchase = new Tbl_SirjanPurchase {
UserId = DbUser.Id, PurchaseId = 1, Price = TotalPrice, DateTime = ShamsiDate, MiladiDate = MiladiDate, Description = "خرید از فروشگاه سیرجان"
};
_context.Tbl_Invoices.Add(Invoice);
_context.SaveChanges();
_context.Tbl_SirjanPurchase.Add(Purchase);
_context.SaveChanges();
int LastInvoiceId = _context.Database.SqlQuery <int>(@"select top 1 Id from Tbl_Invoices order by Id desc").FirstOrDefault <int>();
return(Json(LastInvoiceId.ToString(), JsonRequestBehavior.AllowGet));
}
public JsonResult InsertUserBalance(string UserId, string BalancePrice, string Temp)
{
PersianDateTime now = PersianDateTime.Now;
var DateTime = now.ToString();
var Purchase = new Tbl_SirjanPurchase {
};
if (Temp == "Increase")
{
Purchase = new Tbl_SirjanPurchase {
UserId = Convert.ToInt32(UserId), PurchaseId = 3, Price = BalancePrice, DateTime = DateTime, Description = "افزایش سهام کاربر"
};
}
else if (Temp == "Decrease")
{
Purchase = new Tbl_SirjanPurchase {
UserId = Convert.ToInt32(UserId), PurchaseId = 4, Price = BalancePrice, DateTime = DateTime, Description = "کاهش سهام کاربر"
};
}
_context.Tbl_SirjanPurchase.Add(Purchase);
_context.SaveChanges();
return(Json("Successful", JsonRequestBehavior.AllowGet));
}