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