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;
}
}
}
