public ActionResult RequisitionDetails(TBL_BALANCE_TRANSFER_LOGS objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { //long userId = long.Parse(objval.FromUser); // var membertype = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == userId).FirstOrDefault(); // var vartempReviewDate = Convert.ToDateTime(Request["requisitiondate"].ToString()); var translist = db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == objval.SLN).FirstOrDefault(); if (translist != null) { translist.REQUEST_DATE = objval.REQUEST_DATE; translist.REQUEST_TIME = System.DateTime.Now; translist.BANK_ACCOUNT = objval.BANK_ACCOUNT; translist.AMOUNT = objval.AMOUNT; translist.PAYMENT_METHOD = objval.PAYMENT_METHOD; translist.TRANSFER_METHOD = "Cash"; translist.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; db.Entry(translist).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //return RedirectToAction("Index"); } else { //long fromuser = long.Parse(objval.FromUser); long fromuser = objval.FROM_MEMBER; string timeval = DateTime.Now.ToString("hhmmss"); string dateval = DateTime.Now.ToString("yyyyMMdd"); objval.TransactionID = fromuser + "" + 0 + DateTime.Now.ToString("yyyyMMdd-HHMMss"); objval.TO_MEMBER = 0; objval.FROM_MEMBER = fromuser; objval.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); objval.REQUEST_TIME = System.DateTime.Now; objval.BANK_ACCOUNT = objval.BANK_ACCOUNT; objval.STATUS = "Pending"; objval.TRANSFER_METHOD = "Cash"; db.TBL_BALANCE_TRANSFER_LOGS.Add(objval); db.SaveChanges(); //return RedirectToAction("Index"); } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); throw ex; } } }
public JsonResult getTransdata(string TransId = "") { try { var db = new DBContext(); long transid = long.Parse(TransId); //var listdetails = db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == transid).FirstOrDefault(); var listdetails = (from x in db.TBL_BALANCE_TRANSFER_LOGS join y in db.TBL_MASTER_MEMBER on x.FROM_MEMBER equals y.MEM_ID where x.SLN == transid select new { Touser = "******", FromUser = y.UName, REQUEST_DATE = x.REQUEST_DATE, AMOUNT = x.AMOUNT, BANK_ACCOUNT = x.BANK_ACCOUNT, TRANSACTION_DETAILS = x.TRANSACTION_DETAILS, SLN = x.SLN }).AsEnumerable().Select(z => new TBL_BALANCE_TRANSFER_LOGS { ToUser = z.Touser, FromUser = z.FromUser, AMOUNT = z.AMOUNT, REQUEST_DATE = Convert.ToDateTime(z.REQUEST_DATE.ToString("yyyy-MM-dd")), BANK_ACCOUNT = z.BANK_ACCOUNT, TRANSACTION_DETAILS = z.TRANSACTION_DETAILS, SLN = z.SLN }).FirstOrDefault(); return(Json(new { Result = "true", data = listdetails })); } catch (Exception ex) { var listdetails = new TBL_BALANCE_TRANSFER_LOGS(); return(Json(new { Result = "false", data = listdetails })); } }
public JsonResult PrintMerchantcouponInvoice(string TransId = "") { initpage();//// try { var db = new DBContext(); long transid = long.Parse(TransId); var Tramslist = (from Cpn in db.TBL_COUPON_TRANSFER_LOGS join mem in db.TBL_MASTER_MEMBER on Cpn.FROM_MEMBER equals mem.MEM_ID where Cpn.STATUS == "Success" && Cpn.MEM_ROLE == 5 && Cpn.SLN == transid select new { Sln = Cpn.SLN, From_Mem = Cpn.FROM_MEMBER, RefNo = Cpn.REFERENCE_NO, ReqDate = Cpn.REQUEST_DATE, //MemBer_Name = db.TBL_MASTER_MEMBER.Where(a => a.MEM_ID == Cpn.FROM_MEMBER).Select(c => c.MEMBER_NAME).FirstOrDefault(), MemBer_Name = mem.MEMBER_NAME, CouponType = Cpn.COUPON_TYPE, CouponName = db.TBL_COUPON_MASTER.Where(a => a.sln == Cpn.COUPON_TYPE).Select(c => c.couponType).FirstOrDefault(), Qty = Cpn.QTY, Status = Cpn.STATUS, //CouponPrice = db.TBL_COUPON_COMMISSION_SLAB.Where(a => a.coupon_id == Cpn.COUPON_TYPE && a.Super_Role_Id == 3).Select(c => c.Super_Comm_Value).FirstOrDefault(), CouponPrice = Cpn.SELL_VALUE_RATE, GstNo = mem.COMPANY_GST_NO, CompanyName = mem.COMPANY, Address = mem.ADDRESS, Mobile = mem.MEMBER_MOBILE, Total = (Cpn.QTY * Cpn.SELL_VALUE_RATE), GST_Amount = Cpn.GST_VALUE, TDS_Amount = Cpn.TDS_VALUE, NetValue = Cpn.NET_SELL_VALUE, ImageVal = db.TBL_MASTER_MEMBER.Where(a => a.UNDER_WHITE_LEVEL == 0 && a.MEMBER_ROLE == 1).Select(c => c.LOGO).FirstOrDefault(), }).AsEnumerable().Select(z => new TBL_COUPON_TRANSFER_LOGS { SLN = z.Sln, FROM_MEMBER = z.From_Mem, REFERENCE_NO = z.RefNo, REQUEST_DATE = z.ReqDate, Member_Name = z.MemBer_Name, COUPON_Name = z.CouponName, COUPON_TYPE = z.CouponType, QTY = z.Qty, STATUS = z.Status, CouponPrice = Convert.ToDecimal(z.CouponPrice), GSTNo = z.GstNo, CompanyName = z.CompanyName, Address = z.Address, Mem_Mobile = z.Mobile, TotalAmount = z.Total, GST_VALUE = z.GST_Amount, TDS_VALUE = z.TDS_Amount, NET_SELL_VALUE = z.NetValue, Logo = z.ImageVal }).FirstOrDefault(); return(Json(Tramslist, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var listdetails = new TBL_BALANCE_TRANSFER_LOGS(); Logger.Error("Controller:- MemberRequisition(Admin), method:- getTransdata (POST) Line No:- 433", ex); return(Json(new { Result = "false", data = listdetails })); } }
public async Task <ActionResult> SubmitRequestRequition(TBL_BALANCE_TRANSFER_LOGS objval) { initpage();//// var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { //long userId = long.Parse(objval.FromUser); // var membertype = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == userId).FirstOrDefault(); var whiteleveluser = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); var translist = await db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == objval.SLN).FirstOrDefaultAsync(); if (translist != null) { translist.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); translist.REQUEST_TIME = System.DateTime.Now; translist.BANK_ACCOUNT = objval.BANK_ACCOUNT; translist.AMOUNT = objval.AMOUNT; translist.PAYMENT_METHOD = objval.PAYMENT_METHOD; translist.TRANSFER_METHOD = "Cash"; translist.FromUser = "******"; translist.BANK_CHARGES = objval.BANK_CHARGES; translist.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; translist.INSERTED_BY = MemberCurrentUser.MEM_ID; db.Entry(translist).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); //return RedirectToAction("Index"); } else { var checkrefNo = db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.REFERENCE_NO == objval.REFERENCE_NO).FirstOrDefault(); if (checkrefNo != null) { checkrefNo.REQUEST_DATE = objval.REQUEST_DATE; checkrefNo.REQUEST_TIME = System.DateTime.Now; checkrefNo.BANK_ACCOUNT = objval.BANK_ACCOUNT; checkrefNo.AMOUNT = objval.AMOUNT; checkrefNo.PAYMENT_METHOD = objval.PAYMENT_METHOD; checkrefNo.TRANSFER_METHOD = "Cash"; checkrefNo.FromUser = "******"; checkrefNo.BANK_CHARGES = objval.BANK_CHARGES; checkrefNo.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; checkrefNo.INSERTED_BY = MemberCurrentUser.MEM_ID; db.Entry(checkrefNo).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } else { //long fromuser = long.Parse(objval.FromUser); long fromuser = long.Parse(whiteleveluser.INTRODUCER.ToString()); objval.TransactionID = fromuser + "" + MemberCurrentUser.MEM_ID + DateTime.Now.ToString("yyyyMMdd") + "" + DateTime.Now.ToString("HHMMss"); objval.TO_MEMBER = fromuser; objval.FROM_MEMBER = MemberCurrentUser.MEM_ID; objval.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); objval.REQUEST_TIME = System.DateTime.Now; objval.BANK_ACCOUNT = objval.BANK_ACCOUNT; objval.REFERENCE_NO = objval.REFERENCE_NO; objval.STATUS = "Pending"; objval.TRANSFER_METHOD = "Cash"; objval.FromUser = "******"; objval.BANK_CHARGES = objval.BANK_CHARGES; objval.INSERTED_BY = MemberCurrentUser.MEM_ID; db.TBL_BALANCE_TRANSFER_LOGS.Add(objval); await db.SaveChangesAsync(); //return RedirectToAction("Index"); } } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- SuperRequestRequisition(Super), method:- RequestRequistion (POST) Line No:- 351", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; } } //return View(); }
public async Task <ActionResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) { try { var db = new DBContext(); var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == obj_bal.FROM_MEMBER).FirstOrDefault(); if (checkAvailableMember != null) { var obj = obj_bal; //var mem_id = Request.Form["memberDomainId"].ToString(); long memberid = long.Parse(obj_bal.FROM_MEMBER.ToString()); decimal closingamt = 0; decimal Openingamt = 0; decimal transamt = 0; decimal AddAmount = 0; var amtval = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); if (amtval != null) { Openingamt = amtval.OPENING; closingamt = amtval.CLOSING; transamt = amtval.AMOUNT; if (obj_bal.PAYMENT_METHOD == "CR") { AddAmount = decimal.Parse(obj_bal.AMOUNT.ToString()) + closingamt; } else { AddAmount = closingamt - decimal.Parse(obj_bal.AMOUNT.ToString()); } } else { closingamt = obj_bal.AMOUNT; AddAmount = obj_bal.AMOUNT; } TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = memberid, MEMBER_TYPE = "RETAILER", TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = obj_bal.PAYMENT_METHOD, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = AddAmount, OPENING = closingamt, REC_NO = 0, COMM_AMT = 0 }; db.TBL_ACCOUNTS.Add(objaccnt); db.SaveChanges(); var memberlist = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memberid).FirstOrDefaultAsync(); memberlist.BALANCE = AddAmount; db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); #region For WhiteLevel decimal WLOpening = 0; decimal WLClosing = 0; decimal WLAmtvalue = 0; var tbl_accnt = await db.TBL_ACCOUNTS.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefaultAsync(); if (tbl_accnt != null) { WLOpening = tbl_accnt.OPENING; WLClosing = tbl_accnt.CLOSING; if (obj_bal.PAYMENT_METHOD == "CR") { WLAmtvalue = WLClosing - decimal.Parse(obj_bal.AMOUNT.ToString()); } else { WLAmtvalue = WLClosing + decimal.Parse(obj_bal.AMOUNT.ToString()); } TBL_ACCOUNTS objWL = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = MemberCurrentUser.MEM_ID, MEMBER_TYPE = "DISTRIBUTOR", TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = obj_bal.PAYMENT_METHOD, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = WLAmtvalue, OPENING = WLClosing, REC_NO = 0, COMM_AMT = 0 }; db.TBL_ACCOUNTS.Add(objWL); db.SaveChanges(); var WLBalance = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); WLBalance.BALANCE = WLAmtvalue; db.Entry(WLBalance).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } #endregion return(View("DisplayAccount")); } else { ViewBag.msg = "Please provide valid merchant user name"; return(View("Index")); } } catch (Exception ex) { throw; } }
//public async Task<ActionResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) public async Task <JsonResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) { initpage();//// var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { //var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == obj_bal.FROM_MEMBER).FirstOrDefault(); var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefault(); //if (checkAvailableMember != null) if (checkAvailableMember != null) { var obj = obj_bal; //var mem_id = Request.Form["memberDomainId"].ToString(); long memberid = long.Parse(obj_bal.FROM_MEMBER.ToString()); decimal closingamt = 0; decimal Openingamt = 0; decimal transamt = 0; decimal AddAmount = 0; string MEWR_TYHPETRN = string.Empty; var amtval = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.ACC_NO).FirstOrDefault(); if (amtval != null) { Openingamt = amtval.OPENING; closingamt = amtval.CLOSING; transamt = amtval.AMOUNT; if (obj_bal.PAYMENT_METHOD == "CR") { AddAmount = decimal.Parse(obj_bal.AMOUNT.ToString()) + closingamt; } else { AddAmount = closingamt - decimal.Parse(obj_bal.AMOUNT.ToString()); } } else { Openingamt = 0; closingamt = decimal.Parse(obj_bal.AMOUNT.ToString()); AddAmount = decimal.Parse(obj_bal.AMOUNT.ToString()); } TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = memberid, MEMBER_TYPE = "RETAILER", //TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_TYPE = obj_bal.TRANSACTION_DETAILS, TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = obj_bal.PAYMENT_METHOD, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = AddAmount, OPENING = closingamt, REC_NO = 0, COMM_AMT = 0, GST = 0, TDS = 0, SERVICE_ID = 0, }; db.TBL_ACCOUNTS.Add(objaccnt); //await db.SaveChangesAsync(); var memberlist = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memberid).FirstOrDefaultAsync(); memberlist.BALANCE = AddAmount; db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; //await db.SaveChangesAsync(); #region For WhiteLevel decimal WLOpening = 0; decimal WLClosing = 0; decimal WLAmtvalue = 0; var tbl_accnt = await db.TBL_ACCOUNTS.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).OrderByDescending(z => z.ACC_NO).FirstOrDefaultAsync(); if (tbl_accnt != null) { string trasftyoe = string.Empty; WLOpening = tbl_accnt.OPENING; WLClosing = tbl_accnt.CLOSING; if (obj_bal.PAYMENT_METHOD == "CR") { trasftyoe = "DR"; WLAmtvalue = WLClosing - decimal.Parse(obj_bal.AMOUNT.ToString()); } else { trasftyoe = "CR"; WLAmtvalue = WLClosing + decimal.Parse(obj_bal.AMOUNT.ToString()); } TBL_ACCOUNTS objWL = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = MemberCurrentUser.MEM_ID, MEMBER_TYPE = "DISTRIBUTOR", //TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_TYPE = obj_bal.TRANSACTION_DETAILS, TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = trasftyoe, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = WLAmtvalue, OPENING = WLClosing, REC_NO = 0, COMM_AMT = 0, GST = 0, TDS = 0, SERVICE_ID = 0, }; db.TBL_ACCOUNTS.Add(objWL); //await db.SaveChangesAsync(); var WLBalance = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); WLBalance.BALANCE = WLAmtvalue; db.Entry(WLBalance).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } ContextTransaction.Commit(); #endregion //return View("DisplayAccount"); return(Json("Manual Balance Transfer done successfully.", JsonRequestBehavior.AllowGet)); } else { //ViewBag.msg = "Please provide valid merchant user name"; //return View("Index"); return(Json("Please contact to your administrator.", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { ContextTransaction.Rollback(); throw ex; } } }
public async Task <ActionResult> RequisitionDetails(TBL_BALANCE_TRANSFER_LOGS objval) { initpage(); var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { //long userId = long.Parse(objval.FromUser); // var membertype = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == userId).FirstOrDefault(); var whiteleveluser = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == CurrentMerchant.MEM_ID).FirstOrDefaultAsync(); var translist = await db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == objval.SLN).FirstOrDefaultAsync(); if (translist != null) { translist.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); translist.REQUEST_TIME = System.DateTime.Now; translist.BANK_ACCOUNT = objval.BANK_ACCOUNT; translist.AMOUNT = objval.AMOUNT; translist.PAYMENT_METHOD = objval.PAYMENT_METHOD; translist.TRANSFER_METHOD = "Cash"; translist.FromUser = "******"; translist.BANK_CHARGES = objval.BANK_CHARGES; translist.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; translist.INSERTED_BY = CurrentMerchant.MEM_ID; translist.REF_NO = objval.RequisitionSendTO; db.Entry(translist).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); //return RedirectToAction("Index"); } else { //long fromuser = long.Parse(objval.FromUser); long fromuser = 0; if (objval.RequisitionSendTO == "Distributor") { fromuser = long.Parse(whiteleveluser.INTRODUCER.ToString()); } else { fromuser = long.Parse(whiteleveluser.UNDER_WHITE_LEVEL.ToString()); } objval.TransactionID = fromuser + "" + CurrentMerchant.MEM_ID + DateTime.Now.ToString("yyyyMMdd") + "" + DateTime.Now.ToString("HHMMss"); objval.TO_MEMBER = fromuser; objval.FROM_MEMBER = CurrentMerchant.MEM_ID; objval.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); objval.REQUEST_TIME = System.DateTime.Now; objval.BANK_ACCOUNT = objval.BANK_ACCOUNT; objval.STATUS = "Pending"; objval.FromUser = "******"; objval.TRANSFER_METHOD = "Cash"; objval.BANK_CHARGES = objval.BANK_CHARGES; objval.INSERTED_BY = CurrentMerchant.MEM_ID; objval.REF_NO = objval.RequisitionSendTO; db.TBL_BALANCE_TRANSFER_LOGS.Add(objval); await db.SaveChangesAsync(); //return RedirectToAction("Index"); } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- DistributorRequestRequisition(Distributor), method:- RequisitionDetails (POST) Line No:- 341", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; } } }
public async Task <ActionResult> SubmitRequestRequisition(TBL_BALANCE_TRANSFER_LOGS objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var transinfo = await db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == objval.SLN).FirstOrDefaultAsync(); if (transinfo == null) { var checkrefNo = db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.REFERENCE_NO == objval.REFERENCE_NO).FirstOrDefault(); if (checkrefNo != null) { checkrefNo.REQUEST_DATE = objval.REQUEST_DATE; checkrefNo.REQUEST_TIME = System.DateTime.Now; checkrefNo.BANK_ACCOUNT = objval.BANK_ACCOUNT; checkrefNo.AMOUNT = objval.AMOUNT; checkrefNo.PAYMENT_METHOD = objval.PAYMENT_METHOD; checkrefNo.TRANSFER_METHOD = "Cash"; checkrefNo.FromUser = "******"; checkrefNo.BANK_CHARGES = objval.BANK_CHARGES; checkrefNo.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; checkrefNo.INSERTED_BY = MemberCurrentUser.MEM_ID; db.Entry(checkrefNo).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } else { long fromuser = objval.FROM_MEMBER; //objval.TransactionID = MemberCurrentUser.MEM_ID + "" + fromuser + DateTime.Now.ToString("yyyyMMdd-HHMMss"); objval.TransactionID = MemberCurrentUser.MEM_ID + "" + fromuser + DateTime.Now.ToString("yyyyMMdd") + "" + DateTime.Now.ToString("HHMMss"); objval.TO_MEMBER = 0; objval.FROM_MEMBER = MemberCurrentUser.MEM_ID; objval.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); objval.REQUEST_TIME = System.DateTime.Now; objval.BANK_ACCOUNT = objval.BANK_ACCOUNT; objval.STATUS = "Pending"; objval.TRANSFER_METHOD = "Cash"; objval.BANK_CHARGES = objval.BANK_CHARGES; objval.FromUser = "******"; objval.INSERTED_BY = MemberCurrentUser.MEM_ID; db.TBL_BALANCE_TRANSFER_LOGS.Add(objval); await db.SaveChangesAsync(); //ContextTransaction.Commit(); //return View(); } } else { long fromuser = objval.FROM_MEMBER; //objval.TransactionID = MemberCurrentUser.MEM_ID + "" + fromuser + DateTime.Now.ToString("yyyyMMdd-HHMMss"); //objval.TransactionID = MemberCurrentUser.MEM_ID + "" + fromuser + DateTime.Now.ToString("yyyyMMdd") + "" + DateTime.Now.ToString("HHMMss"); //objval.TO_MEMBER = 0; //objval.FROM_MEMBER = MemberCurrentUser.MEM_ID; transinfo.REQUEST_DATE = Convert.ToDateTime(objval.REQUEST_DATE); transinfo.REQUEST_TIME = System.DateTime.Now; transinfo.BANK_ACCOUNT = objval.BANK_ACCOUNT; transinfo.STATUS = "Pending"; transinfo.TRANSFER_METHOD = "Cash"; transinfo.TRANSACTION_DETAILS = objval.TRANSACTION_DETAILS; transinfo.BANK_CHARGES = objval.BANK_CHARGES; transinfo.INSERTED_BY = MemberCurrentUser.MEM_ID; transinfo.FromUser = "******"; //db.TBL_BALANCE_TRANSFER_LOGS.Add(objval); db.Entry(transinfo).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); //return View(); } ContextTransaction.Commit(); return(RedirectToAction("RequisitionDispay")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- RequestRequisition(Admin), method:- SubmitRequestRequisition (POST) Line No:- 192", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); } } return(View()); }
public async Task <ActionResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) { try { var db = new DBContext(); var memid = db.TBL_WHITE_LEVEL_HOSTING_DETAILS.Where(x => x.DOMAIN == obj_bal.FromUser).FirstOrDefault(); //var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memid.MEM_ID).FirstOrDefault(); if (memid != null) { var obj = obj_bal; var mem_id = Request.Form["memberDomainId"].ToString(); long memberid = long.Parse(mem_id); decimal closingamt = 0; decimal Openingamt = 0; decimal transamt = 0; decimal AddAmount = 0; var amtval = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); if (amtval != null) { Openingamt = amtval.OPENING; closingamt = amtval.CLOSING; transamt = amtval.AMOUNT; if (obj_bal.PAYMENT_METHOD == "CR") { AddAmount = decimal.Parse(obj_bal.AMOUNT.ToString()) + closingamt; } else { AddAmount = closingamt - decimal.Parse(obj_bal.AMOUNT.ToString()); } } TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = memberid, MEMBER_TYPE = "WHITE LEVEL", TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = obj_bal.PAYMENT_METHOD, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = AddAmount, OPENING = closingamt, REC_NO = 0, COMM_AMT = 0, GST = 0, TDS = 0 }; db.TBL_ACCOUNTS.Add(objaccnt); db.SaveChanges(); var memberlist = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memberid).FirstOrDefaultAsync(); memberlist.BALANCE = AddAmount; db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); return(View("DisplayAccount")); } else { ViewBag.msg = "Please provide valid white level user name"; return(View("Index")); } } catch (Exception ex) { throw; } }
//public async Task<ActionResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) public async Task <JsonResult> Index(TBL_BALANCE_TRANSFER_LOGS obj_bal) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == obj_bal.FROM_MEMBER).FirstOrDefault(); if (checkAvailableMember != null) { var obj = obj_bal; //var mem_id = Request.Form["memberDomainId"].ToString(); long memberid = long.Parse(obj_bal.FROM_MEMBER.ToString()); decimal closingamt = 0; decimal Openingamt = 0; decimal transamt = 0; decimal AddAmount = 0; decimal SubAmt = 0; //var amtval = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); var amtval = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memberid).FirstOrDefault(); if (amtval != null) { //var MemAcnt = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); var MemAcnt = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == memberid).OrderByDescending(z => z.ACC_NO).FirstOrDefault(); if (MemAcnt != null) { Openingamt = MemAcnt.OPENING; closingamt = MemAcnt.CLOSING; transamt = MemAcnt.AMOUNT; } else { Openingamt = 0; closingamt = obj_bal.AMOUNT; AddAmount = obj_bal.AMOUNT; } //Openingamt = amtval.OPENING; //closingamt = amtval.CLOSING; //transamt = amtval.AMOUNT; //if (obj_bal.PAYMENT_METHOD == "CR") //{ // AddAmount = decimal.Parse(obj_bal.AMOUNT.ToString()) + closingamt; //} //else //{ // AddAmount = closingamt - decimal.Parse(obj_bal.AMOUNT.ToString()); //} if (obj_bal.PAYMENT_METHOD == "CR") { decimal.TryParse(obj_bal.AMOUNT.ToString(), out SubAmt); AddAmount = SubAmt + closingamt; } else { decimal.TryParse(obj_bal.AMOUNT.ToString(), out SubAmt); AddAmount = Convert.ToDecimal(closingamt - SubAmt); } } TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = memberid, MEMBER_TYPE = "DISTRIBUTOR", //TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_TYPE = obj_bal.TRANSACTION_DETAILS, TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = obj_bal.PAYMENT_METHOD, AMOUNT = obj_bal.AMOUNT, NARRATION = obj_bal.TRANSACTION_DETAILS, CLOSING = AddAmount, OPENING = closingamt, REC_NO = 0, COMM_AMT = 0, GST = 0, TDS = 0, SERVICE_ID = 0, }; db.TBL_ACCOUNTS.Add(objaccnt); //await db.SaveChangesAsync(); var memberlist = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == memberid).FirstOrDefaultAsync(); memberlist.BALANCE = AddAmount; db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); ContextTransaction.Commit(); //#region For WhiteLevel //decimal WLOpening = 0; //decimal WLClosing = 0; //decimal WLAmtvalue = 0; //var wlingo = (from x in db.TBL_MASTER_MEMBER // join y in db.TBL_MASTER_MEMBER_ROLE on x.MEMBER_ROLE equals y.ROLE_ID // where x.MEM_ID == MemberCurrentUser.MEM_ID // select new // { // MemberType = y.ROLE_NAME // }).FirstOrDefault(); //var tbl_accnt = await db.TBL_ACCOUNTS.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefaultAsync(); //if (tbl_accnt != null) //{ // WLOpening = tbl_accnt.OPENING; // WLClosing = tbl_accnt.CLOSING; // if (obj_bal.PAYMENT_METHOD == "CR") // { // WLAmtvalue = WLClosing - decimal.Parse(obj_bal.AMOUNT.ToString()); // } // else // { // WLAmtvalue = WLClosing + decimal.Parse(obj_bal.AMOUNT.ToString()); // } // TBL_ACCOUNTS objWL = new TBL_ACCOUNTS() // { // API_ID = 0, // MEM_ID = MemberCurrentUser.MEM_ID, // MEMBER_TYPE = wlingo.MemberType, // TRANSACTION_TYPE = "Cash Deposit in bank", // TRANSACTION_DATE = DateTime.Now, // TRANSACTION_TIME = DateTime.Now, // DR_CR = obj_bal.PAYMENT_METHOD, // AMOUNT = obj_bal.AMOUNT, // NARRATION = obj_bal.TRANSACTION_DETAILS, // CLOSING = WLAmtvalue, // OPENING = WLClosing, // REC_NO = 0, // COMM_AMT = 0, // GST=0, // TDS=0, // SERVICE_ID = 0, // }; // db.TBL_ACCOUNTS.Add(objWL); // db.SaveChanges(); // var WLBalance = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); // WLBalance.BALANCE = WLAmtvalue; // db.Entry(WLBalance).State = System.Data.Entity.EntityState.Modified; // await db.SaveChangesAsync(); //} //#endregion return(Json("Manual Balance Transfer done successfully.", JsonRequestBehavior.AllowGet)); //return View("DisplayAccount"); } else { return(Json("Please contact to your administrator.", JsonRequestBehavior.AllowGet)); //ViewBag.msg = "Please provide valid super distributor user name"; //return View("Index"); } } catch (Exception ex) { ContextTransaction.Rollback(); throw; } } }