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