public PartialViewResult IndexGrid()
{
var db = new DBContext();
var remitterid = Session["MerchantDMRId"].ToString();
var remtterMob = db.TBL_DMR_REMITTER_INFORMATION.FirstOrDefault(x => x.RemitterID == remitterid);
var PaymentValidation = MoneyTransferAPI.RemitterDetails(remtterMob.MobileNo);
if (PaymentValidation.statuscode == "TXN")
{
var limit = PaymentValidation.data.remitter_limit[0];
var limitTotal = limit.limit.total;
var beneficiarylist = PaymentValidation.data.beneficiary;
foreach (var listitem in beneficiarylist)
{
string beneid = listitem.id.Value;
var benelist = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.BeneficiaryID == beneid).FirstOrDefault();
if (benelist != null)
{
benelist.Bank = listitem.bank.Value;
db.Entry(benelist).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
//var bankdetails = db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.ISDELETED == 0 && x.MEM_ID==MemberCurrentUser.MEM_ID).ToList();
var bankdetails = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.IsActive == 0 && x.RemitterID == remitterid).ToList();
return(PartialView("IndexGrid", bankdetails));
}
public JsonResult BeneficiaryAccountdeleteValidate(string remitterID, string BeneficiaryID, string otp, string Idval)
{
try
{
var BeneficiaryValidation = MoneyTransferAPI.BeneficiaryDeleteValidate(remitterID, BeneficiaryID, otp);
if (BeneficiaryValidation.statuscode == "TXN")
{
long idval = long.Parse(Idval);
var db = new DBContext();
var deletebeneficiaryaccount = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.ID == idval).FirstOrDefault();
deletebeneficiaryaccount.IsActive = 1;
db.Entry(deletebeneficiaryaccount).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(BeneficiaryValidation.status.Value));
}
else
{
return(Json(BeneficiaryValidation.status.Value));
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- BeneficiaryAccountdeleteValidate(POST) Line No:- 492", ex);
return(Json("Error"));
throw ex;
}
}
public JsonResult PostAddBeneficiaryAccount(DMRAccountVerification objval)
{
try
{
const string agentId = "2";
var db = new DBContext();
var AcccountValidation = MoneyTransferAPI.BeneficiaryAccountVerification(objval.RemitterMobile, objval.Account, objval.IFSC, agentId);
if (AcccountValidation == "TXN")
{
return(Json(AcccountValidation));
}
else
{
return(Json(AcccountValidation));
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- PostAddBeneficiaryAccount(POST) Line No:- 291", ex);
return(Json("Error"));
throw ex;
}
//return Json("");
}
private IGrid <TBL_REMITTER_BENEFICIARY_INFO> CreateExportableGrid()
{
try
{
var db = new DBContext();
var remitterid = Session["MerchantDMRId"].ToString();
var remtterMob = db.TBL_DMR_REMITTER_INFORMATION.FirstOrDefault(x => x.RemitterID == remitterid);
var PaymentValidation = MoneyTransferAPI.RemitterDetails(remtterMob.MobileNo);
if (PaymentValidation.statuscode == "TXN")
{
var limit = PaymentValidation.data.remitter_limit[0];
var limitTotal = limit.limit.total;
var beneficiarylist = PaymentValidation.data.beneficiary;
foreach (var listitem in beneficiarylist)
{
string beneid = listitem.id.Value;
var benelist = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.BeneficiaryID == beneid).FirstOrDefault();
if (benelist != null)
{
benelist.Bank = listitem.bank.Value;
db.Entry(benelist).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
//var bankdetails = db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.ISDELETED == 0 && x.MEM_ID==MemberCurrentUser.MEM_ID).ToList();
var bankdetails = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.IsActive == 0 && x.RemitterID == remitterid).ToList();
IGrid <TBL_REMITTER_BENEFICIARY_INFO> grid = new Grid <TBL_REMITTER_BENEFICIARY_INFO>(bankdetails);
grid.ViewContext = new ViewContext {
HttpContext = HttpContext
};
grid.Query = Request.QueryString;
grid.Columns.Add(model => model.BeneficiaryID).Titled("BENEFICIARY ID").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.Bank).Titled("BANK").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.IFSC).Titled("IFSC").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.Mobile).Titled("MOBILE").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.BeneficiaryName).Titled("BENEFICIARY NAME").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.ID).Titled("").Encoded(false).Filterable(false).Sortable(false)
.RenderedAs(model => "<a href='javascript:void(0)' class='btn btn-danger btn-xs' onclick='DeActivateBeneficiary(" + model.ID + ");return 0;'>DELETE</a>");
grid.Pager = new GridPager <TBL_REMITTER_BENEFICIARY_INFO>(grid);
grid.Processors.Add(grid.Pager);
grid.Pager.RowsPerPage = 6;
//foreach (IGridColumn column in grid.Columns)
//{
// column.Filter.IsEnabled = true;
// column.Sort.IsEnabled = true;
//}
return(grid);
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- CreateExportableGrid(POST) Line No:- 421", ex);
throw ex;
}
}
public JsonResult PostVerifyBeneficiaryAccount(BeneficiaryAccountVerification objval)
{
try
{
//const string agentId = "2";
const string agentId = "395Y36706";
var db = new DBContext();
var remitterid = Session["MerchantDMRId"].ToString();
var BeneficiaryValidation = MoneyTransferAPI.BeneficiaryAccountVerification(objval.RemitterMobileNo, objval.BankAccountNo, objval.IFSCCode, agentId);
if (BeneficiaryValidation.statuscode == "TXN")
{
var Verified = BeneficiaryValidation.data.verification_status.Value;
var ipay_id = BeneficiaryValidation.data.ipay_id.Value;
//var RemitterId = ipat_id.Value;
//TBL_API_RESPONSE_OUTPUT obj = new TBL_API_RESPONSE_OUTPUT()
//{
// TXNID = RemitterId,
// REQUESTID = Benificiary_id,
// MOBILENO = objval.MobileNo,
// STATUSID = 0,
// DESCRIPTION = "Beneficiary Registration",
// AMOUNT = 0,
// BALANCE = 0,
// DATE = System.DateTime.Now,
// OPREFNO = "",
// CREATEDATE = System.DateTime.Now,
// MEM_ID = CurrentMerchant.MEM_ID,
// STATUS = true,
// RECHARGETYPE = "DMR Beneficiary Add"
//};
//db.TBL_API_RESPONSE_OUTPUT.Add(obj);
//db.SaveChanges();
var msg = BeneficiaryValidation.status.Value;
return(Json(new { IPayId = ipay_id, Verified = Verified }));
}
else
{
//return Json(PaymentValidation);
//ViewBag.Message = "Invalid Credential or Access Denied";
return(Json(BeneficiaryValidation.statuscode));
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- PostVerifyBeneficiaryAccount(POST) Line No:- 352", ex);
return(Json(ex.InnerException.InnerException));
throw ex;
}
}
public JsonResult DeleteBeneficiary(string id)
{
try
{
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 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;
return(Json(new { remitterid = remitterid, beneficiaryid = benefiVal.BeneficiaryID, status = msg, msgcode = msgcode, idval = id }));
//return Json(new {remitterid= remitterid, beneficiaryid= objbeneficiary.BeneficiaryID, status = msg }); beneficiaryid = objbeneficiary.BeneficiaryID,
//return Json(new { remitterid = obj.TXNID, beneficiaryid = obj.REQUESTID, status = msg });
}
else
{
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 ValidateBeneficiary(string remitterID, string BeneficiaryID, string otp)
{
try
{
var BeneficiaryValidation = MoneyTransferAPI.BeneficiaryRegistrationValidate(remitterID, BeneficiaryID, otp);
if (BeneficiaryValidation.statuscode == "TXN")
{
return(Json(BeneficiaryValidation.status.Value));
}
else
{
return(Json(BeneficiaryValidation.status.Value));
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- ValidateBeneficiary(POST) Line No:- 236", ex);
return(Json("Error"));
throw ex;
}
}
public JsonResult ResendDMROTP(string remitterID, string BeneficiaryID)
{
try
{
var BeneficiaryValidation = MoneyTransferAPI.BeneficiaryRegistrationResendOTP(remitterID, BeneficiaryID);
if (BeneficiaryValidation == "TXN")
{
return(Json(BeneficiaryValidation));
}
else
{
return(Json(BeneficiaryValidation));
}
//return Json("");
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- ResendDMROTP(POST) Line No:- 259", ex);
return(Json("Error"));
throw ex;
}
}
public JsonResult ValidateBeneficiary(string remitterID, string BeneficiaryID, string otp)
{
try
{
var db = new DBContext();
var MerchantOutletId = db.TBL_MERCHANT_OUTLET_INFORMATION.FirstOrDefault(x => x.MEM_ID == CurrentMerchant.MEM_ID).OUTLETID;
var BeneficiaryValidation = MoneyTransferAPI.BeneficiaryRegistrationValidate(remitterID, BeneficiaryID, otp, MerchantOutletId.ToString());
if (BeneficiaryValidation.statuscode == "TXN")
{
return(Json(BeneficiaryValidation.status.Value));
}
else
{
return(Json(BeneficiaryValidation.status.Value));
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- ValidateBeneficiary(POST) Line No:- 236", ex);
return(Json("Error"));
throw ex;
}
}
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 async Task <ActionResult> FundTransfer(MoneyTransferModelView objval)
{
try
{
const string agentId = "395Y36706";
var db = new DBContext();
var Mem_IDval = long.Parse(CurrentMerchant.MEM_ID.ToString());
var remitterid = Session["MerchantDMRId"].ToString();
if (objval.Amount > 0)
{
var remitterInfo = (from remitt in db.TBL_REMITTER_BENEFICIARY_INFO join dmrremitter in db.TBL_DMR_REMITTER_INFORMATION on remitt.RemitterID equals dmrremitter.RemitterID
where remitt.MEM_ID == CurrentMerchant.MEM_ID
select new
{
remitterMobile = remitt.Mobile
}).FirstOrDefault();
////var PaymentValidation1 = MoneyTransferAPI.BeneficiaryAccountVerification(objval.RemitterMobileNo, objval.BeneficiaryAccount, objval.BeneficiaryIFSC, agentId);
var PaymentValidation = MoneyTransferAPI.FundTransfer(objval.RemitterMobileNo, objval.BeneficiaryID, agentId, objval.Amount.ToString(), objval.PaymentMode);
string errorcode = string.IsNullOrEmpty(PaymentValidation.statuscode.Value) ? PaymentValidation.statuscode.Value : PaymentValidation.statuscode.Value;//res.res_code;
//string errorcode = "TXN";
if (errorcode == "TXN")
{
var ipat_id = PaymentValidation.data.ipay_id;
var ref_no = PaymentValidation.data.ref_no;
TimeSpan timeval = new TimeSpan();
var opr_id = PaymentValidation.data.opr_id;
var Name = PaymentValidation.data.name;
var OpeningAmt = PaymentValidation.data.opening_bal;
var amount = PaymentValidation.data.amount;
var charged_amt = PaymentValidation.data.charged_amt;
var locked_amt = PaymentValidation.data.locked_amt;
var bank_alias = PaymentValidation.data.bank_alias;
var msg = PaymentValidation.status.Value;
var msgcode = PaymentValidation.statuscode.Value;
TBL_DMR_FUND_TRANSFER_DETAILS objfund = new TBL_DMR_FUND_TRANSFER_DETAILS()
{
IPAY_ID = ipat_id,
REF_NO = ref_no,
OPR_ID = opr_id,
NAME = Name,
OPENING_BAL = Convert.ToDecimal(OpeningAmt),
AMOUNT = Convert.ToDecimal(amount),
CHARGED_AMT = Convert.ToDecimal(charged_amt),
LOCKED_AMT = Convert.ToDecimal(locked_amt),
BANK_ALIAS = bank_alias,
STATUS = msg,
STATUSCODE = msgcode,
TXNDATE = DateTime.Now,
BANKREFNO = "",
REMARKS = "",
MEM_ID = Mem_IDval,
VERIFICATIONSTATUS = "",
REFUNF_ALLOWED = 0,
REMITTER_ID = remitterid
};
db.TBL_DMR_FUND_TRANSFER_DETAILS.Add(objfund);
await db.SaveChangesAsync();
var checkPaymentStatus = MoneyTransferAPI.FundTransferStatus(ipat_id.Value);
string ipayval = ipat_id.Value;
string checktransfer = string.IsNullOrEmpty(checkPaymentStatus.statuscode.Value) ? checkPaymentStatus.statuscode.Value : checkPaymentStatus.statuscode.Value;//res.res_code;
if (checktransfer == "TXN")
{
var updatetransstatus = await db.TBL_DMR_FUND_TRANSFER_DETAILS.Where(x => x.IPAY_ID == ipayval).FirstOrDefaultAsync();
if (updatetransstatus != null)
{
updatetransstatus.VERIFICATIONSTATUS = checkPaymentStatus.status.Value;
updatetransstatus.REQ_DATE = Convert.ToDateTime(checkPaymentStatus.data.req_dt.Value);
updatetransstatus.NAME = checkPaymentStatus.data.beneficiary_name.Value;
db.Entry(updatetransstatus).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
CommissionDistributionHelper objComm = new CommissionDistributionHelper();
string valueDMRComm = objComm.DistributeCommission(long.Parse(Mem_IDval.ToString()), "DMR", decimal.Parse(objval.Amount.ToString()), decimal.Parse(charged_amt.ToString()), decimal.Parse(OpeningAmt.ToString()), "DMI", "DMR");
}
}
ViewBag.message = checkPaymentStatus.status.Value;
return(RedirectToAction("FundTransferSuccess", "MerchantDMRDashboard", new { area = "Merchant", TransID = Encrypt.EncryptMe(ipayval.ToString()) }));
//return RedirectToAction("FundTransferSuccess", "MerchantDMRDashboard", new { area = "Merchant", TransID = "12345" });
}
else
{
ViewBag.message = PaymentValidation.status;
return(View());
}
}
else
{
ViewBag.message = "Enter Some Amount";
return(View());
}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- FundTransfer(POST) Line No:- 674", ex);
throw ex;
}
}
public async Task <JsonResult> PostDMRBenificiaryform(DMRBeneficiarySenderModel objval)
{
try
{
const string agentId = "2";
var db = new DBContext();
var Mem_IDval = long.Parse(CurrentMerchant.MEM_ID.ToString());
var remitterid = Session["MerchantDMRId"].ToString();
var PaymentValidation = MoneyTransferAPI.BeneficiaryRegistration(remitterid, objval.MobileNo, objval.Name, objval.IFSC, objval.Account);
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 = PaymentValidation.data.remitter.id;
var Benificiary_id = PaymentValidation.data.beneficiary.id.Value;
var RemitterId = ipat_id.Value;
TBL_REMITTER_BENEFICIARY_INFO objbeneficiary = new TBL_REMITTER_BENEFICIARY_INFO()
{
BeneficiaryID = Benificiary_id.ToString(),
BeneficiaryName = objval.Name,
Mobile = objval.MobileNo,
Account = objval.Account,
Bank = "",
IFSC = objval.IFSC,
Status = 0,
IMPS = 0,
Last_success_Name = "",
Last_Sucess_IMPS = "",
RemitterID = remitterid,
MEM_ID = Mem_IDval,
IsActive = 0
};
db.TBL_REMITTER_BENEFICIARY_INFO.Add(objbeneficiary);
await db.SaveChangesAsync();
var msg = PaymentValidation.status.Value;
var msgcode = PaymentValidation.statuscode.Value;
return(Json(new { remitterid = remitterid, beneficiaryid = objbeneficiary.BeneficiaryID, status = msg, msgcode = msgcode }));
//return Json(new {remitterid= remitterid, beneficiaryid= objbeneficiary.BeneficiaryID, status = msg });
//return Json(new { remitterid = obj.TXNID, beneficiaryid = obj.REQUESTID, status = msg });
}
else
{
return(Json(new { remitterid = "", beneficiaryid = "", status = PaymentValidation.status.Value, msgcode = PaymentValidation.statuscode.Value }));
///return Json(PaymentValidation.status);
}
//}
//else
//{
// return Json(PaymentValidation);
//}
}
catch (Exception ex)
{
Logger.Error("Controller:- MerchantDMRDashboard(Merchant), method:- PostDMRBenificiaryform(POST) Line No:- 210", ex);
return(Json(ex.InnerException.InnerException));
throw ex;
//ViewBag.Message = "Invalid Credential or Access Denied";
//return Json("Error");
}
}
private IGrid <DMR_Bank_List> DisplayDMRBankList()
{
try
{
var db = new DBContext();
//var remitterid = Session["MerchantDMRId"].ToString();
var remitterid = "123456879";
string accountNo = "7278526668";
var PaymentValidation = MoneyTransferAPI.RemitterDetails(accountNo);
List <DMR_Bank_List> objbanklist = new List <DMR_Bank_List>();
if (PaymentValidation.data.beneficiary != null)
{
foreach (var banklist in PaymentValidation.data.beneficiary)
{
DMR_Bank_List objval = new DMR_Bank_List()
{
ID = banklist.id,
Name = banklist.name,
BANK_IIN = banklist.account,
BANK_Sort_Name = banklist.mobile,
BANK_Name = banklist.bank,
BRANCK_Ifsc = banklist.ifsc,
IS_Down = banklist.imps
};
objbanklist.Add(objval);
}
}
var DMRTransaction = objbanklist.ToList();
//var DMRTransaction = db.TBL_DMR_FUND_TRANSFER_DETAILS.Where(x => x.REMITTER_ID == remitterid).ToList();
////var bankdetails = db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.ISDELETED == 0 && x.MEM_ID==MemberCurrentUser.MEM_ID).ToList();
//var bankdetails = db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.IsActive == 0 && x.RemitterID == remitterid).ToList();
IGrid <DMR_Bank_List> grid = new Grid <DMR_Bank_List>(DMRTransaction);
grid.ViewContext = new ViewContext {
HttpContext = HttpContext
};
grid.Query = Request.QueryString;
grid.Columns.Add(model => model.ID).Titled("ID").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.Name).Titled("NAME").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.BANK_IIN).Titled("ACCOUNT").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.BANK_Name).Titled("Bank Name").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.BANK_Sort_Name).Titled("Bank Sort").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.BRANCK_Ifsc).Titled("IFSC").Filterable(true).Sortable(true);
grid.Columns.Add(model => model.IS_Down).Titled("IMPS").Filterable(true).Sortable(true);
//grid.Columns.Add(model => model.ID).Titled("").Encoded(false).Filterable(false).Sortable(false)
// .RenderedAs(model => "<a href='javascript:void(0)' class='btn btn-denger btn-xs' onclick='DeActivateBeneficiary(" + model.ID + ");return 0;'>DELETE</a>");
grid.Pager = new GridPager <DMR_Bank_List>(grid);
grid.Processors.Add(grid.Pager);
grid.Pager.RowsPerPage = 6;
//foreach (IGridColumn column in grid.Columns)
//{
// column.Filter.IsEnabled = true;
// column.Sort.IsEnabled = true;
//}
return(grid);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> Index(DMRLoginViewModel User, string ReturnURL = "")
{
try
{
const string agentId = "2";
//string OperatorName = Request.Form["OperatorName"];
//string operatorId = Request.Form["OperatorId"];
var db = new DBContext();
var checkloginStatus = await db.TBL_DMR_REMITTER_INFORMATION.Where(x => x.MobileNo == User.MobileNo).FirstOrDefaultAsync();
if (checkloginStatus.UpdateStatus == 0)
{
var PaymentValidation = MoneyTransferAPI.RemitterDetails(User.MobileNo, "");
if (PaymentValidation.statuscode == "TXN")
{
checkloginStatus.Address = PaymentValidation.data.remitter.address;
checkloginStatus.City = PaymentValidation.data.remitter.city;
checkloginStatus.State = PaymentValidation.data.remitter.state;
checkloginStatus.State = PaymentValidation.data.remitter.state;
checkloginStatus.KYCStatus = PaymentValidation.data.remitter.kycstatus;
checkloginStatus.ConsumedLimited = Convert.ToDecimal(PaymentValidation.data.remitter.consumedlimit);
checkloginStatus.RemainingLimit = Convert.ToDecimal(PaymentValidation.data.remitter.remaininglimit);
var limit = PaymentValidation.data.remitter_limit[0];
var limitTotal = limit.limit.total;
checkloginStatus.Total = Convert.ToDecimal(limitTotal);
checkloginStatus.KYCDocs = PaymentValidation.data.remitter.kycdocs;
checkloginStatus.Perm_txn_limit = Convert.ToDecimal(PaymentValidation.data.remitter.perm_txn_limit);
checkloginStatus.UpdateStatus = 1;
db.Entry(checkloginStatus).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
var beneficiarylist = PaymentValidation.data.beneficiary;
foreach (var listitem in beneficiarylist)
{
string beneid = listitem.id.Value;
var benelist = await db.TBL_REMITTER_BENEFICIARY_INFO.Where(x => x.BeneficiaryID == beneid).FirstOrDefaultAsync();
benelist.Bank = listitem.bank.Value;
db.Entry(benelist).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
}
var ipat_id = PaymentValidation.data.remitter.id;
Session["MerchantDMRId"] = ipat_id.Value;
return(RedirectToAction("DMRInformation", "MerchantDMRDashboard", new { area = "Merchant" }));
}
else
{
//return Json(PaymentValidation);
ViewBag.Message = "Invalid Credential or Access Denied";
return(View());
}
}
else
{
Session["MerchantDMRId"] = checkloginStatus.RemitterID;
return(RedirectToAction("DMRInformation", "MerchantDMRDashboard", new { area = "Merchant" }));
}
}
catch (Exception ex)
{
//throw ex;
ViewBag.Message = "Invalid Credential or Access Denied";
Logger.Error("Controller:- MerchantDMRLogin(Merchant), method:- Index(POST) Line No:- 133", ex);
return(View());
}
return(View());
}
public async Task <ActionResult> AddNewSender(DMRRegistrationViewModel objval)
{
try
{
const string agentId = "2";
//string OperatorName = Request.Form["OperatorName"];
//string operatorId = Request.Form["OperatorId"];
long merchantid = 0;
long.TryParse(Session["MerchantUserId"].ToString(), out merchantid);
var db = new DBContext();
var PaymentValidation = MoneyTransferAPI.RemitterRegistration(objval.MobileNo, objval.Name, "", objval.Pincode, "");
if (PaymentValidation.statuscode == "TXN")
{
var ipat_id = PaymentValidation.data.remitter.id;
var RemitterId = ipat_id.Value;
//double consumedlimit = double.Parse(Convert.ToDouble(PaymentValidation.data.remitter.consumedlimit.Value));
//double remaininglimit = double.Parse(Convert.ToDouble(PaymentValidation.data.remitter.remaininglimit.Value));
TBL_DMR_REMITTER_INFORMATION objremittar = new TBL_DMR_REMITTER_INFORMATION()
{
RemitterID = RemitterId,
Name = objval.Name,
MobileNo = objval.MobileNo,
Address = "",
Pincode = objval.Pincode,
City = "",
State = "",
KYCStatus = 0,
ConsumedLimited = 0,
RemainingLimit = 0,
Status = 0,
StatusCode = "",
MEM_ID = merchantid,
InsertedDate = DateTime.Now,
UpdateStatus = 0,
Total = 0,
Perm_txn_limit = 0,
KYCDocs = ""
};
db.TBL_DMR_REMITTER_INFORMATION.Add(objremittar);
await db.SaveChangesAsync();
//TBL_API_RESPONSE_OUTPUT obj = new TBL_API_RESPONSE_OUTPUT()
//{
// TXNID= RemitterId,
// REQUESTID= RemitterId,
// MOBILENO=objval.MobileNo,
// STATUSID=0,
// DESCRIPTION = "Remitter Registration",
// AMOUNT =0,
// BALANCE=0,
// DATE=System.DateTime.Now,
// OPREFNO="",
// CREATEDATE=System.DateTime.Now,
// MEM_ID=CurrentMerchant.MEM_ID,
// STATUS=true,
// RECHARGETYPE="DMR"
//};
//db.TBL_API_RESPONSE_OUTPUT.Add(obj);
//db.SaveChanges();
Session["MerchantDMRId"] = ipat_id.Value;
return(RedirectToAction("DMRInformation", "MerchantDMRDashboard", new { area = "Merchant" }));
}
else
{
//return Json(PaymentValidation);
ViewBag.Message = "Invalid Credential or Access Denied";
return(View());
}
}
catch (Exception ex)
{
//throw ex;
ViewBag.Message = "Invalid Credential or Access Denied";
Logger.Error("Controller:- MerchantDMRRegistration(Distributor), method:- AddNewSender (POST) Line No:- 158", ex);
return(RedirectToAction("Exception", "ErrorHandler", new { area = "" }));
//return View();
}
}
