public List <TransactionLimitCommon> GetTransactionLimitList() { string sql = "exec sproc_transaction_limit "; sql += " @flag='s'"; var dt = dao.ExecuteDataTable(sql); List <TransactionLimitCommon> list = new List <TransactionLimitCommon>(); if (dt != null) { foreach (DataRow item in dt.Rows) { var common = new TransactionLimitCommon { transacation_id = item["txnl_Id"].ToString(), transacation_type = item["txn_type"].ToString(), transaction_limit_maximum = item["transaction_limit_max"].ToString(), daily_maximum_limit = item["transaction_daily_limit_max"].ToString(), monthly_maximum_limit = item["transaction_monthly_limit_max"].ToString(), kyc_status = item["KYC_Status"].ToString(), // Action = item["action_by"].ToString() }; list.Add(common); } } return(list); }
public CommonDbResponse ManageTransactionlimit(TransactionLimitCommon TLC) { string sql = "exec sproc_transaction_limit "; sql += "@flag ='" + (!string.IsNullOrEmpty(TLC.transacation_id) ? "u" : "") + "' "; sql += ",@txnl_Id = " + dao.FilterString(TLC.transacation_id); sql += ",@txn_type = " + dao.FilterString(TLC.transacation_type); sql += ",@KYC_Status = " + dao.FilterString(TLC.kyc_status); sql += ", @transaction_limit_max=" + dao.FilterString(TLC.transaction_limit_maximum); sql += ", @daily_max_limit=" + dao.FilterString(TLC.daily_maximum_limit); sql += ", @monthly_max_limit=" + dao.FilterString(TLC.monthly_maximum_limit); return(dao.ParseCommonDbResponse(sql)); }
public TransactionLimitCommon GetTransactionLimitForUser(string AgentId) { string sql = "exec sproc_transaction_limit @flag='r'"; sql += ",@agent_id = " + dao.FilterString(AgentId); var dt = dao.ExecuteDataRow(sql); TransactionLimitCommon tl = new TransactionLimitCommon(); if (dt != null) { tl.TxnLimitMax = dt["transaction_limit_max"].ToString(); tl.TxnDailyLimitMax = dt["transaction_daily_limit_max"].ToString(); tl.TxnDailyRemainingLimit = dt["daily_remaining_limit"].ToString(); tl.TxnMonthlyLimitMax = dt["transaction_monthly_limit_max"].ToString(); tl.TxnMonthlyRemainingLimit = dt["monthly_remaining_limit"].ToString(); } return(tl); }
public TransactionLimitCommon GetTransactionLimitById(string Id) { string sql = "exec sproc_transaction_limit "; sql += " @flag='s'"; sql += ",@txnl_Id = " + dao.FilterString(Id); var dt = dao.ExecuteDataRow(sql); TransactionLimitCommon tl = new TransactionLimitCommon(); if (dt != null) { tl.transacation_id = dt["txnl_Id"].ToString(); tl.transacation_type = dt["txn_type"].ToString(); tl.kyc_status = dt["KYC_Status"].ToString(); tl.transaction_limit_maximum = dt["transaction_limit_max"].ToString(); tl.daily_maximum_limit = dt["transaction_daily_limit_max"].ToString(); tl.monthly_maximum_limit = dt["transaction_monthly_limit_max"].ToString(); } return(tl); }
public static string TransactionLimit <T>(T obj) { var jstring = Newtonsoft.Json.JsonConvert.SerializeObject(obj); TransactionLimitCommon trancommon = Newtonsoft.Json.JsonConvert.DeserializeObject <TransactionLimitCommon>(jstring); StringBuilder sb = new StringBuilder(); sb.AppendLine(" <div class=\"col-md-6 alert alert-success bg-white\">"); sb.AppendLine("<div class=\"row\"> "); sb.AppendLine("<label style =\"font-weight:bold; font-size:80%; \">Transaction Limit: "); sb.AppendLine(trancommon.TxnLimitMax); sb.AppendLine("</label>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"row\"> "); sb.AppendLine("<label style =\"font-weight:bold; font-size:80%; \">Daily Transaction Limit: "); sb.AppendLine(trancommon.TxnDailyLimitMax); sb.AppendLine("</label>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"row\"> "); sb.AppendLine("<label style =\"font-weight:bold; font-size:80%; \"> Monthly Transaction Limit: "); sb.AppendLine(trancommon.TxnMonthlyLimitMax); sb.AppendLine("</label>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"row\"> "); sb.AppendLine("<label style =\"font-weight:bold; font-size:80%; \">Remaining Daily Transaction Limit: "); sb.AppendLine(trancommon.TxnDailyRemainingLimit); sb.AppendLine("</label>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"row\"> "); sb.AppendLine("<label style =\"font-weight:bold; font-size:80%; \">Remaining Monthly Transaction Limit: "); sb.AppendLine(trancommon.TxnMonthlyRemainingLimit); sb.AppendLine("</label>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); return(sb.ToString()); }
public ActionResult ManageTransaction(TransactionLimitModel TLC) { if (TLC.transacation_type == "Cash In" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 20000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 20000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Cash In" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 25000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 25000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 25000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 25000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 100000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 100000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Card Fund Load" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 30000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 30000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Card Fund Load" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 16000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 16000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 50000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 50000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 300000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 300000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Transfer" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 10000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 10000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Transfer" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 25000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 25000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 100000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 100000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 500000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 500000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Withdraw" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 20000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 20000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Withdraw" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 25000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 25000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 100000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 100000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 500000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 500000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Card Fund Load(SCT)" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 30000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 30000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Card Fund Load(SCT)" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 500000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 500000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 100000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 100000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 500000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 500000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Wallet Payment" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 20000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 20000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Wallet Payment" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 1000000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 1000000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 1000000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 1000000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 5000000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 5000000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Load" && TLC.kyc_status == "not verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 5000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 5000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 5000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 30000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 30000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (TLC.transacation_type == "Load" && TLC.kyc_status == "verified") { int flag = 0; if (/*Convert.ToDouble( TLC.transaction_limit_maximum) <= 0 && */ Convert.ToDouble(TLC.transaction_limit_maximum) > 100000) { ModelState.AddModelError("transaction_limit_maximum", "Transaction limit should be less than 100000"); flag = 1; } if (Convert.ToDouble(TLC.daily_maximum_limit) > 1000000) { ModelState.AddModelError("daily_maximum_limit", "Daily Transaction limit should be less than 1000000"); flag = 1; } if (Convert.ToDouble(TLC.monthly_maximum_limit) > 1000000) { ModelState.AddModelError("monthly_maximum_limit", "Monthly Transaction limit should be less than 1000000"); flag = 1; } if (flag == 1) { return(View(TLC)); } } if (ModelState.IsValid) { TransactionLimitCommon tl = new TransactionLimitCommon(); tl.transacation_id = TLC.transacation_id.DecryptParameter(); tl.transaction_limit_maximum = TLC.transaction_limit_maximum; tl.daily_maximum_limit = TLC.daily_maximum_limit; tl.monthly_maximum_limit = TLC.monthly_maximum_limit; tl.ActionUser = Session["username"].ToString(); CommonDbResponse dbresp = tbuss.ManageTransactionlimit(tl); if (dbresp.Code == 0) { this.ShowPopup((int)dbresp.Code, dbresp.Message); return(RedirectToAction("Index")); } } this.ShowPopup(1, "Error"); return(View()); }
public CommonDbResponse ManageTransactionlimit(TransactionLimitCommon TLC) { return(_repo.ManageTransactionlimit(TLC)); }