public JsonResult VerifyBeneficiaryAccount(string id) { try { const string agentId = "395Y36706"; var db = new DBContext(); var Mem_IDval = long.Parse(CurrentMerchant.MEM_ID.ToString()); var remitterid = Session["MerchantDMRId"].ToString(); long benid = long.Parse(id); var benefiVal = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.ID == benid).FirstOrDefault(); var getremitterinfo = (from benef in db.TBL_REMITTER_BENEFICIARY_INFO join rem in db.TBL_DMR_REMITTER_INFORMATION on benef.RemitterID equals rem.RemitterID select new { mobileno = rem.MobileNo }).FirstOrDefault(); var PaymentValidation = MoneyTransferAPI.BeneficiaryAccountVerification(getremitterinfo.mobileno, benefiVal.Account.ToString(), benefiVal.IFSC.ToString(), agentId); //var PaymentValidation = MoneyTransferAPI.BeneficiaryDelete(benefiVal.RemitterID, benefiVal.BeneficiaryID); string errorcode = string.IsNullOrEmpty(PaymentValidation.statuscode.Value) ? PaymentValidation.statuscode.Value : PaymentValidation.statuscode.Value;//res.res_code; //if (PaymentValidation != "Unknown Error") //{ //if (PaymentValidation.statuscode == "TXN") if (errorcode == "TXN") { var ipat_id = benefiVal.RemitterID; var Benificiary_id = benefiVal.BeneficiaryID; var RemitterId = ipat_id; var msg = PaymentValidation.status.Value; var msgcode = PaymentValidation.statuscode.Value; var Verification_Status = PaymentValidation.data.verification_status.Value; var bankrefno = PaymentValidation.data.bankrefno.Value; var ipay_id = PaymentValidation.data.ipay_id.Value; var updatebenefstatus = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.ID == benid).FirstOrDefault(); if (updatebenefstatus != null) { updatebenefstatus.Verification_Status = Verification_Status; updatebenefstatus.BankRefNo = bankrefno; updatebenefstatus.Ipay_Id = ipay_id; db.Entry(updatebenefstatus).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } decimal Trans_Amt = 1; #region Retailer Commission var membtype = (from mm in db.TBL_MASTER_MEMBER join rm in db.TBL_MASTER_MEMBER_ROLE on mm.MEMBER_ROLE equals rm.ROLE_ID where mm.MEM_ID == CurrentMerchant.MEM_ID select new { RoleId = mm.MEMBER_ROLE, roleName = rm.ROLE_NAME, Amount = mm.BALANCE }).FirstOrDefault(); var tbl_account = db.TBL_ACCOUNTS.Where(z => z.MEM_ID == CurrentMerchant.MEM_ID).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); if (tbl_account != null) { decimal ClosingAmt = tbl_account.CLOSING; decimal SubAmt = ClosingAmt - Trans_Amt; TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = CurrentMerchant.MEM_ID, MEMBER_TYPE = membtype.roleName, TRANSACTION_TYPE = "Verification", TRANSACTION_DATE = System.DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = "DR", AMOUNT = Trans_Amt, NARRATION = "Account Verification", OPENING = ClosingAmt, CLOSING = SubAmt, REC_NO = 0, COMM_AMT = 0 }; db.TBL_ACCOUNTS.Add(objaccnt); db.SaveChanges(); } #endregion //return Json(new { remitterid = remitterid, beneficiaryid = benefiVal.BeneficiaryID, status = msg, msgcode = msgcode, idval = id }); return(Json(new { Result = "true" })); } else { return(Json(new { Result = "fail" })); //return Json(new { remitterid = "", beneficiaryid = "", status = PaymentValidation.status.Value, msgcode = PaymentValidation.statuscode.Value }); ///return Json(PaymentValidation.status); } } catch (Exception ex) { return(Json(ex.InnerException.InnerException.ToString())); throw ex; } }
public JsonResult CalculateGSTAmount(string MonthID = "", string ServiceName = "", string Year = "") { initpage(); if (MonthID != null) { var db = new DBContext(); int Monthval = 0; int.TryParse(MonthID, out Monthval); long serviceid = 0; long.TryParse(ServiceName, out serviceid); var serviceId = db.TBL_SERVICE_PROVIDERS.Where(x => x.ID == serviceid).Select(c => c.SERVICE_NAME).FirstOrDefault(); //var GSTValu12e = (from x in db.TBL_ACCOUNTS // where x.MEM_ID == CurrentMerchant.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == "Mobile Recharge" && x.SERVICE_ID == serviceid && x.MEMBER_TYPE == "RETAILER" && x.NARRATION == "Commission" // select new // { // MEM_ID = x.MEM_ID, // TRANSACTION_TYPE = x.TRANSACTION_TYPE, // TRANSACTION_DATE = x.TRANSACTION_DATE, // AMOUNT = x.AMOUNT, // GST = x.GST, // GSTPERCENTAGE = x.GST_PERCENTAGE, // TDS = x.TDS, // TDSPERCENTAGE = x.TDS_PERCENTAGE, // }).AsEnumerable().Select(z => new TBL_ACCOUNTS // { // MEM_ID = z.MEM_ID, // TRANSACTION_TYPE = z.TRANSACTION_TYPE, // timevalue = z.TRANSACTION_DATE.ToString(), // //TRANSACTION_DATE = z.TRANSACTION_DATE, // AMOUNT = z.AMOUNT, // GST = z.GST, // GST_PERCENTAGE = z.GSTPERCENTAGE, // TDS = z.TDS, // TDS_PERCENTAGE = z.TDSPERCENTAGE // }).ToList().Distinct(); var GSTValue = (from x in db.TBL_ACCOUNTS where x.MEM_ID == CurrentMerchant.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == "Mobile Recharge" && x.SERVICE_ID == serviceid && x.MEMBER_TYPE == "RETAILER" && x.NARRATION == "Commission" select new { Operator = db.TBL_SERVICE_PROVIDERS.Where(d => d.ID == x.SERVICE_ID).Select(c => c.SERVICE_NAME).FirstOrDefault(), COMMISSIONAMT = x.COMM_AMT }).Sum(c => (decimal?)c.COMMISSIONAMT) ?? 0; var getListGSTComm = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == CurrentMerchant.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == "Mobile Recharge" && x.SERVICE_ID == serviceid && x.MEMBER_TYPE == "RETAILER" && x.NARRATION == "Commission").FirstOrDefault(); TBL_ACCOUNTS objval = new TBL_ACCOUNTS() { MEMBER_TYPE = serviceId, COMM_AMT = GSTValue, timevalue = DateTime.Now.ToString("dd-MM-yyyy"), GST_PERCENTAGE = 18 }; return(Json(objval, JsonRequestBehavior.AllowGet)); } else { return(Json("There is no GST Available in this month", JsonRequestBehavior.AllowGet)); } }
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 <JsonResult> POSTApplyIssueDebitCreditNote(TBL_DEBIT_CREDIT_SETTIING objDRCR) { initpage();//// var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { string COrelationID = Settings.GetUniqueKey(MemberCurrentUser.MEM_ID.ToString()); long MemberType = 0; long.TryParse(objDRCR.MEM_TYPE.ToString(), out MemberType); long Dist_Id = 0; long Mer_Id = 0; long DR_CR_ISSUED = 0; string MEM_ROLE = string.Empty; decimal TDS_Val = 0; decimal.TryParse(objDRCR.TDS_AMOUNT.ToString(), out TDS_Val); decimal DeductTDS = 0; decimal Remain_AMt = 0; decimal Trans_Amt = 0; decimal SGST = 0; decimal CGST = 0; decimal IGST = 0; decimal SGST_VAL = 0; decimal CGST_VAL = 0; decimal IGST_VAL = 0; decimal TotalGST = 0; if (MemberType == 4) { MEM_ROLE = "DISTRIBUTOR"; long.TryParse(objDRCR.DIST_ID.ToString(), out DR_CR_ISSUED); Dist_Id = DR_CR_ISSUED; } else { MEM_ROLE = "MERCHANT"; long.TryParse(objDRCR.MER_ID.ToString(), out DR_CR_ISSUED); long.TryParse(objDRCR.DIST_ID.ToString(), out Dist_Id); } if (objDRCR.MER_ID == null) { Mer_Id = 0; } else { long.TryParse(objDRCR.MER_ID.ToString(), out Mer_Id); } var checkAvailableMember = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == DR_CR_ISSUED).FirstOrDefault(); if (checkAvailableMember != null) { var obj = objDRCR; //var mem_id = Request.Form["memberDomainId"].ToString(); long memberid = DR_CR_ISSUED; 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(); if (MemAcnt != null) { Openingamt = MemAcnt.OPENING; closingamt = MemAcnt.CLOSING; transamt = MemAcnt.AMOUNT; } else { Openingamt = 0; closingamt = 0; transamt = 0; } decimal.TryParse(objDRCR.TRANS_AMOUNT.ToString(), out Trans_Amt); if (objDRCR.TDS_APPLICABLE_VALUE == "1") { DeductTDS = (Trans_Amt * TDS_Val) / 100; Remain_AMt = Trans_Amt - DeductTDS; } else { DeductTDS = 0; Remain_AMt = Trans_Amt - DeductTDS; } if (objDRCR.TDS_APPLICABLE_VALUE == "1") { var GetGST = db.TBL_STATES.Where(x => x.STATEID == checkAvailableMember.STATE_ID).FirstOrDefault(); if (GetGST != null) { decimal.TryParse(GetGST.SGST.ToString(), out SGST); decimal.TryParse(GetGST.CGST.ToString(), out CGST); decimal.TryParse(GetGST.IGST.ToString(), out IGST); SGST_VAL = (Remain_AMt * SGST) / 100; CGST_VAL = (Remain_AMt * CGST) / 100; IGST_VAL = (Remain_AMt * IGST) / 100; TotalGST = SGST_VAL + CGST_VAL + IGST_VAL; } } else { SGST = 0; CGST = 0; IGST = 0; SGST_VAL = 0; CGST_VAL = 0; IGST_VAL = 0; TotalGST = SGST_VAL + CGST_VAL + IGST_VAL; } if (objDRCR.TRANS_TYPE == "CR") { //decimal.TryParse(objDRCR.TRANS_AMOUNT.ToString(), out SubAmt); decimal.TryParse(Remain_AMt.ToString(), out SubAmt); AddAmount = SubAmt + closingamt; } else { //decimal.TryParse(objDRCR.TRANS_AMOUNT.ToString(), out SubAmt); decimal.TryParse(Remain_AMt.ToString(), out SubAmt); AddAmount = Convert.ToDecimal(closingamt - SubAmt); } } TBL_ACCOUNTS objaccnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = memberid, MEMBER_TYPE = MEM_ROLE, TRANSACTION_TYPE = "Cash Deposit in bank", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = objDRCR.TRANS_TYPE, AMOUNT = objDRCR.TRANS_AMOUNT, NARRATION = objDRCR.TRANS_DETAILS, CLOSING = AddAmount, OPENING = closingamt, REC_NO = 0, COMM_AMT = 0, GST = (float)TotalGST, TDS = (float)DeductTDS, SERVICE_ID = 0, CORELATIONID = COrelationID, }; 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(); bool IsGstApply = false; if (objDRCR.GST_APPLICABLE_VALUE == "1") { IsGstApply = true; } else { IsGstApply = false; } bool IsTdsApply = false; if (objDRCR.TDS_APPLICABLE_VALUE == "1") { IsTdsApply = true; } else { IsTdsApply = false; } TBL_DEBIT_CREDIT_SETTIING ObjDRCRval = new TBL_DEBIT_CREDIT_SETTIING() { CORELLATION_ID = COrelationID, MER_ID = Mer_Id, DIST_ID = Dist_Id, WLP_ID = MemberCurrentUser.MEM_ID, MEM_TYPE = objDRCR.MEM_TYPE, TRANS_AGAINST = DR_CR_ISSUED, TRANS_ISSUED_BY = MemberCurrentUser.MEM_ID, TRANS_DONE_BY = MemberCurrentUser.MEM_ID, TRANS_TYPE = objDRCR.TRANS_TYPE, TRANS_AMOUNT = objDRCR.TRANS_AMOUNT, TRANS_REF_NO = objDRCR.TRANS_REF_NO, TRANS_DETAILS = objDRCR.TRANS_DETAILS, TRANS_REMARKS = objDRCR.TRANS_REMARKS, GST_APPLICABLE = IsGstApply, TDS_APPLICABLE = IsTdsApply, TDS_PER = objDRCR.TDS_PER, TDS_AMOUNT = DeductTDS, TRANS_DATE = DateTime.Now, STATUS = true }; db.TBL_DEBIT_CREDIT_SETTIING.Add(ObjDRCRval); await db.SaveChangesAsync(); ContextTransaction.Commit(); //#region For WhiteLevel //decimal WLOpening = 0; //decimal WLClosing = 0; //decimal WLAmtvalue = 0; //string WLP_TranType = string.Empty; //decimal WLPBal = 0; //if (objDRCR.TRANS_TYPE == "CR") //{ // WLP_TranType = "DR"; // WLAmtvalue = objDRCR.TRANS_AMOUNT; //} //else //{ // WLP_TranType = "CR"; // WLAmtvalue = objDRCR.TRANS_AMOUNT; //} //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 (objDRCR.TRANS_TYPE == "CR") // { // WLP_TranType = "DR"; // WLAmtvalue = WLClosing - decimal.Parse(objDRCR.TRANS_AMOUNT.ToString()); // } // else // { // WLP_TranType = "CR"; // WLAmtvalue = WLClosing + decimal.Parse(objDRCR.TRANS_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 = WLP_TranType, // AMOUNT = objDRCR.TRANS_AMOUNT, // NARRATION = objDRCR.TRANS_DETAILS, // CLOSING = WLAmtvalue, // OPENING = 0, // REC_NO = 0, // COMM_AMT = 0, // GST = 0, // TDS = 0, // SERVICE_ID = 0, // }; // db.TBL_ACCOUNTS.Add(objWL); // db.SaveChanges(); // decimal AddWLPBal =0; // var WLBalance = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); // decimal.TryParse(WLBalance.BALANCE.ToString(), out WLPBal); // if (objDRCR.TRANS_TYPE == "CR") // { // AddWLPBal = WLPBal - WLAmtvalue; // } // else // { // AddWLPBal = WLPBal + WLAmtvalue; // } // WLBalance.BALANCE = AddWLPBal; // db.Entry(WLBalance).State = System.Data.Entity.EntityState.Modified; // await db.SaveChangesAsync(); //} //else //{ // 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 = "", // AMOUNT = objDRCR.TRANS_AMOUNT, // NARRATION = objDRCR.TRANS_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(); // decimal AddWLPBal = 0; // var WLBalance = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); // decimal.TryParse(WLBalance.BALANCE.ToString(), out WLPBal); // if (objDRCR.TRANS_TYPE == "CR") // { // AddWLPBal = WLPBal - WLAmtvalue; // } // else // { // AddWLPBal = WLPBal + WLAmtvalue; // } // WLBalance.BALANCE = AddWLPBal; // db.Entry(WLBalance).State = System.Data.Entity.EntityState.Modified; // await db.SaveChangesAsync(); //} //ContextTransaction.Commit(); //#endregion return(Json("Debit Credit Note Issued successfully.", JsonRequestBehavior.AllowGet)); } else { ContextTransaction.Rollback(); string Msg = string.Empty; Msg = "Please provide valid super distributor user name"; return(Json(Msg, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { string Msg = string.Empty; Msg = "Try After Some Time"; return(Json(Msg, JsonRequestBehavior.AllowGet)); throw; } } return(Json("")); }
//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 <JsonResult> PostCREDITBALANCE(MemberCreditBalanceModel objCredit) { var DBcon = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = DBcon.Database.BeginTransaction()) { try { var MerberName = DBcon.TBL_MASTER_MEMBER.FirstOrDefault(x => x.MEM_ID == objCredit.FROM_MEM_ID); var TDSVal = DBcon.TBL_TAX_MASTERS.FirstOrDefault(x => x.SLN == 2).TAX_VALUE; string COrelationID = Settings.GetUniqueKey(MemberCurrentUser.MEM_ID.ToString()); var member_Role = DBcon.TBL_MASTER_MEMBER_ROLE.FirstOrDefault(x => x.ROLE_ID == objCredit.MEMBER_ROLE).ROLE_NAME; decimal TdsVal = 0; decimal GstVal = 0; decimal TotalGST = 0; decimal TDS_Amount = 0; decimal GST_Amount = 0; decimal TotalCreditAmt = 0; decimal CreditAmtWhithTDS = 0; decimal AddMainBalance = 0; decimal UpdateMainBalance = 0; decimal.TryParse(TDSVal.ToString(), out TdsVal); if (objCredit.CREDIT_TYPE == "DR") { var GetGSTVAlue = DBcon.TBL_STATES.FirstOrDefault(x => x.STATEID == MerberName.STATE_ID); TotalGST = GetGSTVAlue.SGST + GetGSTVAlue.IGST + GetGSTVAlue.CGST; decimal.TryParse(TotalGST.ToString(), out GstVal); if (objCredit.GSTAPPLY == "Yes") { GST_Amount = ((objCredit.CREDIT_AMOUNT) * TotalGST) / 100; TotalCreditAmt = objCredit.CREDIT_AMOUNT + GST_Amount; } else { GST_Amount = 0; TotalCreditAmt = objCredit.CREDIT_AMOUNT + GST_Amount; } } else { GST_Amount = 0; TotalCreditAmt = objCredit.CREDIT_AMOUNT + GST_Amount; } if (objCredit.TDSAPPLY == "Yes") { TDS_Amount = ((objCredit.CREDIT_AMOUNT) * TdsVal) / 100; CreditAmtWhithTDS = objCredit.CREDIT_AMOUNT - TDS_Amount; TotalCreditAmt = objCredit.CREDIT_AMOUNT + GST_Amount - TDS_Amount; } else { TDS_Amount = 0; CreditAmtWhithTDS = objCredit.CREDIT_AMOUNT - TDS_Amount; TotalCreditAmt = objCredit.CREDIT_AMOUNT + GST_Amount - TDS_Amount; } AddMainBalance = Convert.ToDecimal(MerberName.BALANCE); if (objCredit.CREDIT_TYPE == "DR") { UpdateMainBalance = AddMainBalance - TotalCreditAmt; } else { UpdateMainBalance = AddMainBalance + TotalCreditAmt; } TBL_CREDIT_BALANCE_DISTRIBUTION objcr = new TBL_CREDIT_BALANCE_DISTRIBUTION() { TO_MEM_ID = MemberCurrentUser.MEM_ID, FROM_MEM_ID = objCredit.FROM_MEM_ID, MEMBER_ROLE = objCredit.MEMBER_ROLE, CREDIT_DATE = DateTime.Now, CREDIT_TYPE = objCredit.CREDIT_TYPE, //CREDIT_AMOUNT = objCredit.CREDIT_AMOUNT, CREDIT_AMOUNT = TotalCreditAmt, GST_VAL = TotalGST, GST_AMOUNT = GST_Amount, TDS_VAL = TdsVal, TDS_AMOUNT = TDS_Amount, CREDIT_NOTE_DESCRIPTION = objCredit.CREDIT_NOTE_DESCRIPTION, CREDIT_STATUS = true }; DBcon.TBL_CREDIT_BALANCE_DISTRIBUTION.Add(objcr); DBcon.SaveChanges(); MerberName.BALANCE = UpdateMainBalance; DBcon.Entry(MerberName).State = System.Data.Entity.EntityState.Modified; DBcon.SaveChanges(); decimal Frm_OpeningAmt = 0; decimal Frm_ClosingAmt = 0; decimal Frm_AddOpeningAmt = 0; decimal Frm_AddClosingAmt = 0; //var FromMemberamtobj = DBcon.TBL_ACCOUNTS.Where(x => x.MEM_ID == objCredit.FROM_MEM_ID).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); var FromMemberamtobj = DBcon.TBL_ACCOUNTS.Where(x => x.MEM_ID == objCredit.FROM_MEM_ID).OrderByDescending(z => z.ACC_NO).FirstOrDefault(); if (FromMemberamtobj != null) { decimal.TryParse(FromMemberamtobj.CLOSING.ToString(), out Frm_ClosingAmt); if (objCredit.CREDIT_TYPE == "DR") { Frm_AddClosingAmt = Frm_ClosingAmt - TotalCreditAmt; } else { Frm_AddClosingAmt = Frm_ClosingAmt + TotalCreditAmt; } } else { Frm_AddClosingAmt = TotalCreditAmt; } TBL_ACCOUNTS objacnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = objCredit.FROM_MEM_ID, MEMBER_TYPE = member_Role, TRANSACTION_TYPE = "CREDIT NOTES", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = objCredit.CREDIT_TYPE, AMOUNT = (decimal)TotalCreditAmt, NARRATION = objCredit.CREDIT_NOTE_DESCRIPTION, OPENING = Frm_ClosingAmt, CLOSING = Frm_AddClosingAmt, REC_NO = 0, COMM_AMT = 0, GST = (double)GST_Amount, TDS = (double)TDS_Amount, IPAddress = "", SERVICE_ID = 0, CORELATIONID = COrelationID }; DBcon.TBL_ACCOUNTS.Add(objacnt); DBcon.SaveChanges(); ContextTransaction.Commit(); //var member_Role = DBcon.TBL_MASTER_MEMBER_ROLE.FirstOrDefault(x => x.ROLE_ID == objCredit.MEMBER_ROLE).ROLE_NAME; return(Json("Credit balance given to " + MerberName.UName + ". ")); } catch (Exception ex) { ContextTransaction.Rollback(); return(Json("Try again after some time")); throw; } } }
public async Task <JsonResult> PostCREDITLIMITBALANCE(TBL_CREDIT_LIMIT_BALANCE_DISTRIBUTION objCredit) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { decimal creditlimitBalance = 0; decimal MainBal = 0; decimal creditLimitMainBal = 0; decimal AddMainBalance = 0; decimal AddMainCreditLimitBalance = 0; decimal closingAmt = 0; decimal AddCloingAMt = 0; decimal.TryParse(objCredit.CREDIT_AMOUNT.ToString(), out creditlimitBalance); string COrelationID = Settings.GetUniqueKey(MemberCurrentUser.MEM_ID.ToString()); decimal CR_Opening = 0; decimal CR_Closinging = 0; decimal ADD_CR_Closinging = 0; var CreditLimit_Val = db.TBL_CREDIT_LIMIT_BALANCE_DISTRIBUTION.Where(x => x.FROM_MEM_ID == objCredit.FROM_MEM_ID).OrderByDescending(c => c.SLN).FirstOrDefault(); if (CreditLimit_Val != null) { CR_Opening = (decimal)CreditLimit_Val.CREDIT_OPENING; CR_Closinging = (decimal)CreditLimit_Val.CREDITCLOSING; ADD_CR_Closinging = CR_Closinging + creditlimitBalance; } else { CR_Closinging = 0; ADD_CR_Closinging = creditlimitBalance; } TBL_CREDIT_LIMIT_BALANCE_DISTRIBUTION objLimit = new TBL_CREDIT_LIMIT_BALANCE_DISTRIBUTION() { TO_MEM_ID = MemberCurrentUser.MEM_ID, FROM_MEM_ID = objCredit.FROM_MEM_ID, CREDIT_DATE = DateTime.Now, //CREDIT_AMOUNT = objCredit.CREDIT_AMOUNT, CREDIT_AMOUNT = creditlimitBalance, GST_VAL = 0, GST_AMOUNT = 0, TDS_VAL = 0, TDS_AMOUNT = 0, CREDIT_NOTE_DESCRIPTION = objCredit.CREDIT_NOTE_DESCRIPTION, CREDIT_STATUS = true, CREDIT_OPENING = CR_Closinging, CREDITCLOSING = ADD_CR_Closinging, CREDIT_TRN_TYPE = "CR", CORELATIONID = COrelationID }; db.TBL_CREDIT_LIMIT_BALANCE_DISTRIBUTION.Add(objLimit); db.SaveChanges(); var memberinfo = db.TBL_MASTER_MEMBER.FirstOrDefault(x => x.MEM_ID == objCredit.FROM_MEM_ID); decimal.TryParse(memberinfo.BALANCE.ToString(), out MainBal); decimal.TryParse(memberinfo.CREDIT_LIMIT.ToString(), out creditLimitMainBal); AddMainBalance = MainBal + creditlimitBalance; AddMainCreditLimitBalance = creditLimitMainBal + creditlimitBalance; memberinfo.BALANCE = AddMainBalance; memberinfo.CREDIT_LIMIT = AddMainCreditLimitBalance; db.Entry(memberinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Accounts //var FromMemberamtobj = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == objCredit.FROM_MEM_ID).OrderByDescending(z => z.TRANSACTION_TIME).FirstOrDefault(); var FromMemberamtobj = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == objCredit.FROM_MEM_ID).OrderByDescending(z => z.ACC_NO).FirstOrDefault(); if (FromMemberamtobj != null) { decimal.TryParse(FromMemberamtobj.CLOSING.ToString(), out closingAmt); AddCloingAMt = closingAmt + creditlimitBalance; } else { AddCloingAMt = creditlimitBalance; //decimal.TryParse(FromMemberamtobj.CLOSING.ToString(), out closingAmt); } TBL_ACCOUNTS objacnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = objCredit.FROM_MEM_ID, MEMBER_TYPE = "DISTRIBUTOR", TRANSACTION_TYPE = "CREDIT LIMIT", TRANSACTION_DATE = DateTime.Now, TRANSACTION_TIME = DateTime.Now, DR_CR = "CR", AMOUNT = creditlimitBalance, NARRATION = objCredit.CREDIT_NOTE_DESCRIPTION, OPENING = closingAmt, CLOSING = AddCloingAMt, REC_NO = 0, COMM_AMT = 0, GST = 0, TDS = 0, IPAddress = "", SERVICE_ID = 0, CORELATIONID = COrelationID }; db.TBL_ACCOUNTS.Add(objacnt); db.SaveChanges(); ContextTransaction.Commit(); return(Json("Credit Limit is given to distributor")); } catch (Exception ex) { ContextTransaction.Rollback(); return(Json("Please try again after some time")); throw ex; } } }
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 JsonResult ChangeTransactionStatus(string trandate = "", string TransationStatus = "", string slnval = "") { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { long sln = long.Parse(slnval); decimal addamount = 0; decimal memb_bal = 0; decimal trans_bal = 0; decimal availableamt = 0; decimal addavilamt = 0; decimal closingamt = 0; decimal addclosingamt = 0; var transinfo = db.TBL_BALANCE_TRANSFER_LOGS.Where(x => x.SLN == sln).FirstOrDefault(); var memberlist = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == transinfo.FROM_MEMBER).FirstOrDefault(); var membtype = (from mm in db.TBL_MASTER_MEMBER join rm in db.TBL_MASTER_MEMBER_ROLE on mm.MEMBER_ROLE equals rm.ROLE_ID where mm.MEM_ID == transinfo.FROM_MEMBER select new { RoleId = mm.MEMBER_ROLE, roleName = rm.ROLE_NAME }).FirstOrDefault(); //transinfo.REQUEST_DATE = Convert.ToDateTime(trandate); transinfo.STATUS = "Approve"; transinfo.APPROVAL_DATE = DateTime.Now; transinfo.APPROVAL_TIME = DateTime.Now; transinfo.APPROVED_BY = "Power Admin"; db.Entry(transinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); memb_bal = decimal.Parse(memberlist.BALANCE.ToString()); trans_bal = decimal.Parse(transinfo.AMOUNT.ToString()); addamount = memb_bal + trans_bal; memberlist.BALANCE = addamount; //db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; //db.SaveChanges(); var amtobj = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == transinfo.FROM_MEMBER).FirstOrDefault(); if (amtobj != null) { availableamt = amtobj.AMOUNT; addavilamt = availableamt + trans_bal; amtobj.AMOUNT = addavilamt; closingamt = amtobj.CLOSING; addclosingamt = closingamt + trans_bal; amtobj.CLOSING = addclosingamt; amtobj.OPENING = trans_bal; db.Entry(amtobj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { TBL_ACCOUNTS objacnt = new TBL_ACCOUNTS() { API_ID = 0, MEM_ID = transinfo.FROM_MEMBER, MEMBER_TYPE = membtype.roleName, TRANSACTION_TYPE = transinfo.PAYMENT_METHOD, TRANSACTION_DATE = Convert.ToDateTime(transinfo.REQUEST_DATE), TRANSACTION_TIME = DateTime.Now, DR_CR = "CR", AMOUNT = transinfo.AMOUNT, NARRATION = transinfo.TRANSACTION_DETAILS, OPENING = 0, CLOSING = addamount, REC_NO = 0 }; db.TBL_ACCOUNTS.Add(objacnt); db.SaveChanges(); } db.Entry(memberlist).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ContextTransaction.Commit(); return(Json(new { Result = "true" })); } catch (Exception ex) { ContextTransaction.Rollback(); return(Json(new { Result = "false " })); } } }
//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; } } }