/// <summary>
/// Devuelve los datos de un banco según su id
/// </summary>
/// <param name="id">Id del banco</param>
/// <returns>BEBanco</returns>
public BEBanco Listar_byId(int id)
{
BEBanco Banco = new BEBanco();
try
{
using (SqlConnection oConexion = new SqlConnection(DBConexion))
{
SqlCommand oComando = new SqlCommand(sp_listar_byId, oConexion);
oComando.CommandType = CommandType.StoredProcedure;
oComando.Parameters.Add("@p_sid", SqlDbType.Int).Value = id;
oConexion.Open();
using (SqlDataReader dr = oComando.ExecuteReader())
{
while (dr.Read() && dr.HasRows)
{
Banco.CID = Peach.EncriptToBase64(DataUtil.ObjectToString(dr["i_sid"]));
Banco.Nombre = DataUtil.ObjectToString(dr["s_nom"]);
Banco.Url = DataUtil.ObjectToString(dr["s_url"]);
Banco.Situacion = new ItemGenerico {
IntValue = DataUtil.ObjectToInt(dr["i_sit"])
};
}
}
oComando.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
return(Banco);
}
/// <summary>
/// Graba o actualiza los datos de un banco
/// </summary>
/// <param name="model">modelo</param>
/// <returns>ResponserData</returns>
public ResponserData Grabar(BEBanco model)
{
try
{
return(DA.Grabar(model));
}
catch (Exception ex)
{
throw ex;
}
}
public List <BEBanco> EliminarBanco(BEBanco obeBanco)
{
try
{
DABanco odaBanco = new DABanco();
return(odaBanco.EliminarBanco(obeBanco));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
public ActionResult enNBUT09(List <string> dat)
{
CustomJSON globalResponse = new CustomJSON();
ResponserData oResponse = new ResponserData();
if (User != null)
{
try
{
var nom = dat[0].Trim().ToUpper();
var url = dat[1].Trim().ToUpper();
var sit = dat[2];
var sid = dat[3];
if (nom == string.Empty)
{
globalResponse.ERR = "No ha ingresado un nombre para el banco";
}
else
{
BEBanco Banco = new BEBanco
{
Id = (sid != "") ? Convert.ToInt16(Peach.DecriptFromBase64(sid)) : 0,
Nombre = nom,
Url = url,
Situacion = new ItemGenerico {
IntValue = Convert.ToByte(sit)
},
RowAudit = new IRowAudit
{
IUsr = Convert.ToInt16(Peach.DecriptText(User.CID)),
IP = Common.PageUtility.GetUserIpAddress()
}
};
oResponse = new BLBanco().Grabar(Banco);
globalResponse.DATA = oResponse;
}
}
catch (Exception ex)
{
globalResponse.ERR = ex.Message;
}
}
else
{
return(RedirectToAction("Index", "Account", new { act = "timeout" }));
}
return(Json(globalResponse, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Pagina de detalle del banco (Detalles del banco y Agencias Bancarias)
/// </summary>
/// <param name="sid">sid del banco</param>
/// <returns>Vista detalle de banco</returns>
public ActionResult Detalle(string sid)
{
BEBanco Banco = new BEBanco();
var strControlador = this.ControllerContext.RouteData.Values["controller"].ToString();
var strMetodo = this.ControllerContext.RouteData.Values["action"].ToString();
if (User != null)
{
if (this.IsPermitido())
{
if (sid != string.Empty && sid != null)
{
ViewBag.Controller = strControlador;
ViewBag.Method = strMetodo;
ViewBag.Paises = new SelectList(
new BLPais().Listar(), "CID", "Nombre");
ViewBag.Tipo = new SelectList(new BLParametro().ListarDetalle(Parametros.TipoAgenciaBancaria), "Valor", "Texto");
// Datos del Banco
if (sid != "0")
{
string Id = Peach.DecriptFromBase64(sid);
Banco = new BLBanco().Listar_byId(Convert.ToInt16(Id));
}
return(View(Banco));
}
else
{
AddToastMessage("Error", "No se ha recibido los datos principales del banco.", BootstrapAlertType.danger);
return(RedirectToAction("Lista", "Banco"));
}
}
else
{
AddToastMessage("No permitido", "Esta opcion no esta permitida para su perfil.", BootstrapAlertType.danger);
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account", new { act = "timeout" }));
}
}
/// <summary>
/// Graba o actualiza los datos de una agencia bancaria
/// </summary>
/// <param name="model">modelo</param>
/// <returns>ResponserData</returns>
public ResponserData GrabarAgencia(BEBanco model)
{
ResponserData Responser = new ResponserData();
try
{
using (SqlConnection oConexion = new SqlConnection(DBConexion))
{
SqlCommand oComando = new SqlCommand(sp_grabar_agencia, oConexion);
oComando.CommandType = CommandType.StoredProcedure;
oComando.Parameters.Add("@p_ida", SqlDbType.Int).Value = model.Agencia.Id;
oComando.Parameters.Add("@p_idb", SqlDbType.VarChar, 35).Value = model.Id;
oComando.Parameters.Add("@p_nom", SqlDbType.VarChar, 35).Value = model.Agencia.Nombre;
oComando.Parameters.Add("@p_dir1", SqlDbType.VarChar, 35).Value = model.Agencia.Direccion1;
oComando.Parameters.Add("@p_dir2", SqlDbType.VarChar, 35).Value = model.Agencia.Direccion2;
oComando.Parameters.Add("@p_tip", SqlDbType.Int).Value = model.Agencia.Tipo.IntValue;
oComando.Parameters.Add("@p_pai", SqlDbType.Int).Value = model.Agencia.Pais.Id;
oComando.Parameters.Add("@p_usr", SqlDbType.SmallInt).Value = model.RowAudit.IUsr;
oComando.Parameters.Add("@p_ipc", SqlDbType.VarChar, 15).Value = model.RowAudit.IP;
oConexion.Open();
using (SqlDataReader dr = oComando.ExecuteReader())
{
while (dr.Read())
{
Responser.Mensaje = DataUtil.ObjectToString(dr["s_msg"]);
Responser.Estado = (ResponserEstado)DataUtil.ObjectToInt(dr["i_est"]);
Responser.TipoAlerta = (BootstrapAlertType)DataUtil.ObjectToInt(dr["i_btp"]);
}
}
oComando.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
return(Responser);
}
/// <summary>
/// Graba o actualiza los datos de un banco
/// </summary>
/// <param name="model">modelo</param>
/// <returns>ResponserData</returns>
public ResponserData Grabar(BEBanco model)
{
ResponserData Responser = new ResponserData();
try
{
using (SqlConnection oConexion = new SqlConnection(DBConexion))
{
SqlCommand oComando = new SqlCommand(sp_grabar, oConexion);
oComando.CommandType = CommandType.StoredProcedure;
oComando.Parameters.Add("@p_idb", SqlDbType.SmallInt).Value = model.Id;
oComando.Parameters.Add("@p_nom", SqlDbType.VarChar, 35).Value = model.Nombre;
oComando.Parameters.Add("@p_url", SqlDbType.VarChar, 120).Value = model.Url;
oComando.Parameters.Add("@p_sit", SqlDbType.TinyInt).Value = model.Situacion.IntValue;
oComando.Parameters.Add("@p_usr", SqlDbType.SmallInt).Value = model.RowAudit.IUsr;
oComando.Parameters.Add("@p_ipc", SqlDbType.VarChar, 15).Value = model.RowAudit.IP;
oConexion.Open();
using (SqlDataReader dr = oComando.ExecuteReader())
{
while (dr.Read())
{
Responser.CID = Peach.EncriptToBase64(DataUtil.ObjectToString(dr["i_id"]));
Responser.Mensaje = DataUtil.ObjectToString(dr["s_msg"]);
Responser.Estado = (ResponserEstado)DataUtil.ObjectToInt(dr["i_est"]);
Responser.TipoAlerta = (BootstrapAlertType)DataUtil.ObjectToInt(dr["i_btp"]);
}
}
oComando.Dispose();
}
}
catch (Exception ex)
{
new DAError().GrabarLog("Data", "DABanco", "Grabar",
string.Concat(ex.Message, "Ip:", model.RowAudit.IP, ", Len:", model.RowAudit.IP.Length.ToString()),
model.RowAudit.IUsr, model.RowAudit.IP);
throw ex;
}
return(Responser);
}
public ActionResult NGZIbEEr(List <string> dat)
{
// L0hWZz09
CustomJSON globalResponse = new CustomJSON();
ResponserData oResponse = new ResponserData();
if (User != null)
{
try
{
var nom = dat[0].Trim().ToUpper();
var dir1 = dat[1].Trim().ToUpper();
var dir2 = dat[2].Trim().ToUpper();
var tpo = dat[3];
var pai = dat[4];
var agen = dat[5];
var banc = dat[6];
if (nom == string.Empty)
{
globalResponse.ERR = "No ha ingresado un nombre para la agencia";
}
else if (tpo == null)
{
globalResponse.ERR = "No ha seleccionado el Tipo";
}
else if (pai == null)
{
globalResponse.ERR = "No ha seleccionado un País";
}
else
{
BEBanco Banco = new BEBanco
{
Id = Convert.ToInt16(Peach.DecriptFromBase64(banc)),
Agencia = new BEAgenciaBancaria
{
Id = (agen == "0") ? 0 : Convert.ToInt16(Peach.DecriptFromBase64(agen)),
Nombre = nom,
Direccion1 = dir1,
Direccion2 = dir2,
Tipo = new ItemGenerico {
IntValue = Convert.ToInt16(Peach.DecriptText(tpo))
},
Pais = new BEPais {
Id = Convert.ToInt16(Peach.DecriptText(pai))
}
},
RowAudit = new IRowAudit
{
IUsr = Convert.ToInt16(Peach.DecriptText(User.CID)),
IP = Common.PageUtility.GetUserIpAddress()
}
};
oResponse = new BLBanco().GrabarAgencia(Banco);
globalResponse.DATA = oResponse;
}
}
catch (Exception ex)
{
globalResponse.ERR = ex.Message;
}
}
else
{
return(RedirectToAction("Index", "Account", new { act = "timeout" }));
}
return(Json(globalResponse, JsonRequestBehavior.AllowGet));
}
