public List <GatewayCommon> GetGatewayList()
{
var sql = "Exec sproc_gateway_detail ";
sql += "@flag = 's' ";
//sql += ",@gateway_id = " + dao.FilterString(gateway_id);
var dt = dao.ExecuteDataTable(sql);
var list = new List <GatewayCommon>();
if (null != dt)
{
int sn = 1;
foreach (DataRow item in dt.Rows)
{
var common = new GatewayCommon
{
GatewayId = item["gateway_id"].ToString(),
GatewayName = item["gateway_name"].ToString(),
GatewayBalance = item["gateway_balance"].ToString(),
GatewayURL = item["gateway_url"].ToString(),
GatewayStatus = item["STATUS"].ToString()
};
sn++;
list.Add(common);
}
}
return(list);
}
public CommonDbResponse ManageGateway(GatewayCommon setup)
{
var sql = "Exec sproc_gateway_detail ";
sql += "@flag = '" + (string.IsNullOrEmpty(setup.GatewayId) ? "i" : "u") + "' ";
sql += ",@gateway_name = " + dao.FilterString(setup.GatewayName);
// sql += ",@gateway_balance = " + dao.FilterString(setup.GatewayBalance);
sql += ",@gateway_country = " + dao.FilterString(setup.GatewayCountry);
sql += ",@gateway_currency = " + dao.FilterString(setup.GatewayCurrency);
sql += ",@gateway_user_name = " + dao.FilterString(setup.GatewayUsername);
sql += ",@gateway_password = "******",@gateway_access_code = " + dao.FilterString(setup.GatewayAccessCode);
sql += ",@gateway_security_code = " + dao.FilterString(setup.GatewaySecurityCode);
sql += ",@gateway_api_token = " + dao.FilterString(setup.GatewayApitoken);
sql += ",@gateway_url = " + dao.FilterString(setup.GatewayURL);
sql += ",@gateway_status = " + dao.FilterString(setup.GatewayStatus);
sql += ",@gateway_contact = " + dao.FilterString(setup.GatewayContact);
sql += ",@is_direct_gateway = " + dao.FilterString(setup.IsDirectGateway == true?"Y":"N");
sql += ",@gateway_type = " + dao.FilterString(setup.GatewayType);
sql += ",@action_user = "******",@from_ip_address = " + dao.FilterString(setup.IpAddress);
sql += ",@gateway_id = " + (string.IsNullOrEmpty(setup.GatewayId) ? "''" : dao.FilterString(setup.GatewayId));
//sql += "," + (string.IsNullOrEmpty(setup.GatewayId) ? "@action_user" : "@updated_by") + " = " + dao.FilterString(setup.ActionUser);
return(dao.ParseCommonDbResponse(sql));
}
public ActionResult ManageGateway(string GatewayID = "")
{
GatewayCommon gatewaycommon = new GatewayCommon();
GatewayModel gatewaymodel = new GatewayModel();
if (!string.IsNullOrEmpty(GatewayID))
{
string gateway_id = GatewayID.DecryptParameter();
if (!string.IsNullOrEmpty(gateway_id))
{
gatewaycommon = buss.GetGatewayById(gateway_id);
gatewaymodel.GatewayId = gatewaycommon.GatewayId.EncryptParameter();
gatewaymodel.GatewayName = gatewaycommon.GatewayName;
gatewaymodel.GatewayUsername = gatewaycommon.GatewayUsername.DecryptParameter();
gatewaymodel.GatewayPwd = gatewaycommon.GatewayPwd.DecryptParameter();
gatewaymodel.GatewayBalance = gatewaycommon.GatewayBalance;
gatewaymodel.GatewayURL = gatewaycommon.GatewayURL.DecryptParameter();
gatewaymodel.GatewayAccessCode = gatewaycommon.GatewayAccessCode.DecryptParameter();
gatewaymodel.GatewaySecurityCode = gatewaycommon.GatewaySecurityCode.DecryptParameter();
gatewaymodel.GatewayApitoken = gatewaycommon.GatewayApitoken.DecryptParameter();
gatewaymodel.GatewayStatus = gatewaycommon.GatewayStatus;
gatewaymodel.IsDirectGateway = gatewaycommon.IsDirectGateway;
gatewaymodel.GatewayType = gatewaycommon.GatewayType;
gatewaymodel.GatewayCountry = gatewaycommon.GatewayCountry;
gatewaymodel.GatewayCurrency = "NPR";//gatewaycommon.GatewayCurrency;
gatewaymodel.GatewayContact = gatewaycommon.GatewayContact;
}
}
gatewaymodel.GatewayCurrency = "NPR";
gatewaymodel.IsDirectGatewayList = LoadDropdownList("directindirect") as List <SelectListItem>;
gatewaymodel.GatewayTypeList = LoadDropdownList("gatewaytype") as List <SelectListItem>;
// gatewaymodel.GatewayCurrencyList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("20"), gatewaymodel.GatewayCurrency, "Select Currency");
gatewaymodel.GatewayCountryList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("030"), gatewaymodel.GatewayCurrency, "Select Country");
return(View(gatewaymodel));
}
public ActionResult GatewayDetail(string GatewayID = "")
{
GatewayCommon gatewaycommon = new GatewayCommon();
GatewayDetailModel gatewaymodel = new GatewayDetailModel();
if (!string.IsNullOrEmpty(GatewayID))
{
string gateway_id = GatewayID.DecryptParameter();
if (!string.IsNullOrEmpty(gateway_id))
{
gatewaycommon = buss.GetGatewayById(gateway_id);
gatewaymodel.GatewayId = gatewaycommon.GatewayId.EncryptParameter();
gatewaymodel.GatewayName = gatewaycommon.GatewayName;
gatewaymodel.GatewayUsername = gatewaycommon.GatewayUsername.DecryptParameter();
gatewaymodel.GatewayPwd = gatewaycommon.GatewayPwd.DecryptParameter();
gatewaymodel.GatewayBalance = gatewaycommon.GatewayBalance;
gatewaymodel.GatewayURL = gatewaycommon.GatewayURL.DecryptParameter();
gatewaymodel.GatewayAccessCode = gatewaycommon.GatewayAccessCode.DecryptParameter();
gatewaymodel.GatewaySecurityCode = gatewaycommon.GatewaySecurityCode.DecryptParameter();
gatewaymodel.GatewayApitoken = gatewaycommon.GatewayApitoken.DecryptParameter();
gatewaymodel.GatewayStatus = gatewaycommon.GatewayStatus;
gatewaymodel.IsDirectGateway = gatewaycommon.IsDirectGateway;
gatewaymodel.GatewayType = gatewaycommon.GatewayType;
gatewaymodel.GatewayCountry = gatewaycommon.GatewayCountry;
gatewaymodel.GatewayCurrency = "NPR";//gatewaycommon.GatewayCurrency;
gatewaymodel.GatewayContact = gatewaycommon.GatewayContact;
}
}
gatewaymodel.GatewayCurrency = "NPR";
//gatewaymodel.IsDirectGatewayList = LoadDropdownList("directindirect") as List<SelectListItem>;
if (!string.IsNullOrEmpty(gatewaymodel.GatewayType))
{
if (gatewaymodel.GatewayType.ToUpper().Equals("P"))
{
gatewaymodel.GatewayType = "Payment";
}
if (gatewaymodel.GatewayType.ToUpper().Equals("S"))
{
gatewaymodel.GatewayType = "SMS";
}
if (gatewaymodel.GatewayType.ToUpper().Equals("T"))
{
gatewaymodel.GatewayType = "Transaction";
}
}
Dictionary <string, string> GatewayCountryList = new Dictionary <string, string>();
if (GatewayCountryList.Count > 0)
{
gatewaymodel.GatewayCountry = GatewayCountryList.First(x => x.Key == gatewaymodel.GatewayCurrency).Value;
}
//gatewaymodel.GatewayTypeList = LoadDropdownList("gatewaytype") as List<SelectListItem>;
// gatewaymodel.GatewayCurrencyList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("20"), gatewaymodel.GatewayCurrency, "Select Currency");
//gatewaymodel.GatewayCountryList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("030"), gatewaymodel.GatewayCurrency, "Select Country");
return(View(gatewaymodel));
}
public ActionResult ManageGateway(GatewayModel gm)
{
if (ModelState.IsValid)
{
string username = Session["UserName"].ToString();
string ipaddress = ApplicationUtilities.GetIP();
GatewayCommon gc = new GatewayCommon();
gc.GatewayId = gm.GatewayId.DecryptParameter();
if (!string.IsNullOrEmpty(gc.GatewayId))
{
if (string.IsNullOrEmpty(gm.GatewayId))
{
this.ShowPopup(1, "Gateway Not found !");
return(RedirectToAction("ManageGateway", gm));
}
}
gc.GatewayName = gm.GatewayName;
gc.GatewayUsername = gm.GatewayUsername.EncryptParameter();
gc.GatewayPwd = gm.GatewayPwd.EncryptParameter();
// gc.GatewayBalance = gm.GatewayBalance;
gc.GatewayURL = gm.GatewayURL.EncryptParameter();
gc.GatewayAccessCode = gm.GatewayAccessCode.EncryptParameter();
gc.GatewaySecurityCode = gm.GatewaySecurityCode.EncryptParameter();
gc.GatewayApitoken = gm.GatewayApitoken.EncryptParameter();
gc.GatewayStatus = gm.GatewayStatus;
gc.IsDirectGateway = gm.IsDirectGateway;
gc.GatewayType = gm.GatewayType.Trim();
gc.GatewayCountry = gm.GatewayCountry;
gc.GatewayCurrency = gm.GatewayCurrency;
gc.GatewayContact = gm.GatewayContact;
gc.ActionUser = username;
gc.IpAddress = ipaddress;
CommonDbResponse dbresp = buss.ManageGateway(gc);
if (dbresp.Code == 0)
{
this.ShowPopup(0, "Save Succesfully");
return(RedirectToAction("Detail"));
}
}
this.ShowPopup(1, "Error");
return(RedirectToAction("ManageGateway", gm));
}
/*
* public ActionResult GatewayBalanceDetail(string Search = "", int Pagesize = 10)
* {
*
* var list = buss.GetGatewayList();
*
* // dynamic list = null;
*
* foreach (var item in list)
* {
* item.Action = "<input type='button' value='Add Balance' onclick=showpopupmodel('" + item.GatewayId.EncryptParameter() + "')></input>"; // StaticData.GetActions("Gateway", item.GatewayId.EncryptParameter(), this, "/Admin/Gateway/ManageGatewayBalance", "showpopupmodel" + item.GatewayId.EncryptParameter(), item.GatewayStatus);
* item.GatewayStatus = "<span class='badge badge-" + (item.GatewayStatus.Trim().ToUpper() == "Y" ? "success" : "danger") + "'>" + (item.GatewayStatus.Trim().ToUpper() == "Y" ? "Enable" : "Disable") + "</span>";
* }
* // var list = buss.GetGatewayList(gateway_Id);
*
* IDictionary<string, string> param = new Dictionary<string, string>();
* // param.Add("GatewayId", "Gateway ID");
* param.Add("GatewayName", "Gateway Name");
* param.Add("GatewayBalance", "Available Balance");
* // param.Add("GatewayURL", "Gateway URL");
* param.Add("GatewayStatus", "Gateway Status");
* param.Add("Action", "Action");
*
* ProjectGrid.column = param;
* var grid = ProjectGrid.MakeGrid(list, "Gateway", Search, Pagesize, true, "", "", "Home", "Gateway", "/Admin/Gateway", "");
* ViewData["grid"] = grid;
* return View();
* }*/
#endregion
public JsonResult ManageGatewayBalance(string GatewayID = "")
{
GatewayCommon gatewaycommon = new GatewayCommon();
GatewayBalanceModel balance = new GatewayBalanceModel();
if (!string.IsNullOrEmpty(GatewayID))
{
string gateway_id = GatewayID.DecryptParameter();
gatewaycommon = buss.GetGatewayById(gateway_id);
balance.Gatewayid = gatewaycommon.GatewayId.EncryptParameter();
balance.GatewayName = gatewaycommon.GatewayName;
//gatewaymodel.GatewayUsername = gatewaycommon.GatewayUsername;//.DecryptParameter();
//gatewaymodel.GatewayPwd = gatewaycommon.GatewayPwd;//.DecryptParameter();
balance.AvaliableBalance = decimal.Parse(gatewaycommon.GatewayBalance);
//gatewaymodel.GatewayURL = gatewaycommon.GatewayURL;//.DecryptParameter();
//gatewaymodel.GatewayAccessCode = gatewaycommon.GatewayAccessCode;//.DecryptParameter();
//gatewaymodel.GatewaySecurityCode = gatewaycommon.GatewaySecurityCode;//.DecryptParameter();
//gatewaymodel.GatewayApitoken = gatewaycommon.GatewayApitoken;//.DecryptParameter();
//balance.GatewayStatus = "<span class='badge badge-" + (gatewaycommon.GatewayStatus.Trim().ToUpper() == "Y" ? "success" : "danger") + "'>" + (gatewaycommon.GatewayStatus.Trim().ToUpper() == "Y" ? "Enable" : "Disable") + "</span>";
//gatewaymodel.IsDirectGateway = gatewaycommon.IsDirectGateway;
//gatewaymodel.GatewayType = gatewaycommon.GatewayType;
//gatewaymodel.GatewayCountry = gatewaycommon.GatewayCountry;
balance.GatewayCurrency = gatewaycommon.GatewayCurrency;
//gatewaymodel.GatewayContact = gatewaycommon.GatewayContact;
string value = string.Empty;
value = JsonConvert.SerializeObject(balance, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
//gatewaymodel.IsDirectGatewayList = LoadDropdownList("directindirect") as List<SelectListItem>;
//gatewaymodel.GatewayTypeList = LoadDropdownList("gatewaytype") as List<SelectListItem>;
//// gatewaymodel.GatewayCurrencyList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("20"), gatewaymodel.GatewayCurrency, "Select Currency");
//gatewaymodel.GatewayCountryList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("030"), gatewaymodel.GatewayCurrency, "Select Country");
this.ShowPopup(1, "Error");
return(null);
}
public GatewayCommon GetGatewayById(string gateway_id)
{
var sql = "Exec sproc_gateway_detail ";
sql += "@flag = 's' ";
sql += ",@gateway_id = " + dao.FilterString(gateway_id);
var dt = dao.ExecuteDataTable(sql);
var item = new GatewayCommon();
if (null != dt)
{
int sn = 1;
foreach (DataRow dr in dt.Rows)
{
var common = new GatewayCommon
{
GatewayId = dr["gateway_id"].ToString(),
GatewayName = dr["gateway_name"].ToString(),
GatewayBalance = dr["gateway_balance"].ToString(),
GatewayCountry = dr["gateway_country"].ToString(),
GatewayCurrency = dr["gateway_currency"].ToString(),
GatewayUsername = dr["gateway_username"].ToString(),
GatewayPwd = dr["gateway_password"].ToString(),
GatewayAccessCode = dr["gateway_access_code"].ToString(),
GatewaySecurityCode = dr["gateway_security_code"].ToString(),
GatewayApitoken = dr["gateway_api_token"].ToString(),
IsDirectGateway = dr["is_direct_gateway"].ToString().ToUpper() == "Y"?true:false,
GatewayType = dr["gateway_type"].ToString(),
GatewayURL = dr["gateway_url"].ToString(),
GatewayStatus = dr["STATUS"].ToString()
};
return(common);
}
}
return(item);
}
public CommonDbResponse ManageGateway(GatewayCommon gatewaysetup)
{
return(repo.ManageGateway(gatewaysetup));
}
