public List <BalanceCommon> GetDistributorReport(string AgentId = "", string BalanceId = "")
{
var balanceCommons = new List <BalanceCommon>();
string sql = "sproc_balance_transfer @flag = 'r'";
sql += (string.IsNullOrEmpty(AgentId) ? "" : ", @agent_id =" + DAO.FilterString(AgentId));
sql += (string.IsNullOrEmpty(BalanceId) ? "" : ", @balance_id =" + DAO.FilterString(BalanceId));
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
BalanceCommon balanceCommon = new BalanceCommon();
balanceCommon.BalanceId = dr["balance_id"].ToString();
balanceCommon.AgentId = dr["agent_id"].ToString();
balanceCommon.Name = dr["agent_name"].ToString();
balanceCommon.Amount = dr["amount"].ToString();
balanceCommon.OldBalance = dr["Agent_old_balance"].ToString();
balanceCommon.NewBalance = dr["New_Balance"].ToString();
balanceCommon.BankBranch = dr["funding_bank_branch"].ToString();
balanceCommon.BankAcccountNo = dr["funding_account_number"].ToString();
balanceCommon.BankName = dr["bank_name"].ToString();
balanceCommon.Type = dr["txn_type"].ToString();
balanceCommon.TxnMode = dr["txn_mode"].ToString();
balanceCommon.Remarks = dr["agent_remarks"].ToString();
balanceCommon.CreatedBy = dr["created_by"].ToString();
balanceCommon.CreatedDate = dr["Created_date"].ToString();
balanceCommon.CreatedNepaliDate = dr["created_nepali_Date"].ToString(); //DateTime.Parse(dr["createddatelocal"].ToString()).ToLongDateString();
balanceCommons.Add(balanceCommon);
}
}
return(balanceCommons);
}
public ActionResult AgentRT(BalanceModel balanceModel)
{
//BalanceModel balanceModel = new BalanceModel();
List <BalanceCommon> balanceCommons = _balance.GetAgentName();
Dictionary <string, string> agentName = new Dictionary <string, string>();
Dictionary <string, string> bankList = _balance.GetBankList();
foreach (BalanceCommon bcommon in balanceCommons)
{
agentName.Add(bcommon.AgentId, bcommon.Name);
}
balanceModel.NameList = ApplicationUtilities.SetDDLValue(agentName, "", "--Agent--");
balanceModel.BankAccountList = ApplicationUtilities.SetDDLValue(bankList, "", "--Bank--");
if (Convert.ToDecimal(balanceModel.Amount) > 500000 && balanceModel.Type == "T")
{
ModelState.AddModelError("Amount", "Amount Cannot Be Greater then 500000 (5 Lakhs)");
return(View(balanceModel));
}
if (balanceModel.Type == "R")
{
ModelState.Remove(("BankId"));
if (Convert.ToDecimal(balanceModel.Amount) > 100000 && balanceModel.Type == "R")
{
ModelState.AddModelError("Amount", "Amount Cannot Be Greater then 100000 (1 Lakh)");
return(View(balanceModel));
}
}
if (ModelState.IsValid)
{
balanceModel.CreatedBy = Session["UserName"].ToString();
balanceModel.AgentId = agentName.FirstOrDefault(x => x.Key == balanceModel.Name).Key.ToString();
balanceModel.Name = agentName.FirstOrDefault(x => x.Key == balanceModel.Name).Value.ToString();
if (balanceModel.Type == "T")
{
balanceModel.BankName = bankList.FirstOrDefault(x => x.Key == balanceModel.BankId).Value.ToString();
}
balanceModel.CreatedIp = ApplicationUtilities.GetIP();
BalanceCommon balanceCommon = balanceModel.MapObject <BalanceCommon>();
CommonDbResponse dbResponse = _balance.AgentTR(balanceCommon);
if (dbResponse.Code == 0)
{
dbResponse.SetMessageInTempData(this);
return(RedirectToAction("AgentRT", ControllerName));
}
}
else
{
return(View(balanceModel));
}
return(RedirectToAction("AgentRT", ControllerName));
}
public CommonDbResponse DistributorTR(BalanceCommon balanceCommon)
{
string sql = "sproc_balance_transfer ";
sql += "@flag =" + DAO.FilterString((balanceCommon.Type == "T") ? "t" : "rt");
sql += ", @agent_id=" + DAO.FilterString(balanceCommon.AgentId);
//sql += ", @agent_name=" + DAO.FilterString(balanceCommon.Name);
sql += ", @bank_id=" + DAO.FilterString(balanceCommon.BankId);
sql += ", @bank_name=" + DAO.FilterString(balanceCommon.BankName);
sql += ", @amount=" + DAO.FilterString(balanceCommon.Amount);
sql += ", @type=" + DAO.FilterString(balanceCommon.Type);
sql += ", @remarks=" + DAO.FilterString(balanceCommon.Remarks);
sql += ", @action_user="******", @created_ip=" + DAO.FilterString(balanceCommon.CreatedIp);
return(DAO.ParseCommonDbResponse(sql));
}
public ActionResult AgentReportDetail(string Id = "", string ExtraId1 = "")
{
BalanceModel balanceModel = new BalanceModel();
List <BalanceCommon> balanceCommons = new List <BalanceCommon>();
BalanceCommon balanceCommon = new BalanceCommon();
string ID = Id.DecryptParameter();
string BalanceId = ExtraId1.DecryptParameter();
if (!String.IsNullOrEmpty(ID))
{
balanceCommons = _balance.GetAgentReport(ID, BalanceId);
}
balanceCommon = balanceCommons.FirstOrDefault();
//balanceCommon = balanceCommons.FirstOrDefault(x => x.AgentId == ID);
balanceModel = balanceCommon.MapObject <BalanceModel>();
balanceModel.Type = balanceModel.Type == "T" ? "Transfer" : "Retrieve";
return(View(balanceModel));
}
public List <BalanceCommon> GetSubAgentName(string AgentId)
{
string sql = "sproc_get_dropdown_list @flag = 'getsubagent'";
sql += (string.IsNullOrEmpty(AgentId) ? "" : ", @search_field1 =" + DAO.FilterString(AgentId));
var dbres = DAO.ExecuteDataTable(sql);
var balanceCommons = new List <BalanceCommon>();
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
BalanceCommon balanceCommon = new BalanceCommon();
balanceCommon.AgentId = dr["value"].ToString();
balanceCommon.Name = dr["text"].ToString();
balanceCommon.ParentId = dr["Agent_Parent_Id"].ToString();
balanceCommon.ParentName = dr["AgentParentName"].ToString();
balanceCommons.Add(balanceCommon);
}
}
return(balanceCommons);
}
public CommonDbResponse AgentTR(BalanceCommon balanceCommon)
{
return(_repo.AgentTR(balanceCommon));
}
public CommonDbResponse DistributorTR(BalanceCommon balanceCommon)
{
return(_repo.DistributorTR(balanceCommon));
}