public bool guardarDB(rq_Parametro_Info info)
{
try
{
using (Entities_requerimiento Context = new Entities_requerimiento())
{
rq_Parametro Entity = new rq_Parametro
{
iEstadoCierre = info.iEstadoCierre,
iEstadoCancelado = info.iEstadoCancelado,
vCorreo = info.vCorreo,
vClave = info.vClave,
Puerto = info.Puerto,
Host = info.Host,
vCorreoDestino = info.vCorreoDestino,
bSSL = info.bSSL = true,
vUserIDCreacion = info.vUserIDCreacion,
dFechaCreacion = info.dFechaCreacion = DateTime.Now
};
Context.rq_Parametro.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
tb_LogError_Data LogData = new tb_LogError_Data();
LogData.GuardarDB(new tb_LogError_Info {
Descripcion = ex.Message, InnerException = ex.InnerException == null ? null : ex.InnerException.Message, Clase = "rq_Cliente_Data", Metodo = "guardarDB", IdUsuario = info.vUserIDCreacion
});
return(false);
}
}
public ActionResult Index(rq_Parametro_Info model)
{
if (!bus_parametro.GuardarDB(model))
{
ViewBag.mensaje = "No se pudieron actualizar los registros";
}
cargar_combos();
return(View(model));
}
public ActionResult Index()
{
rq_Parametro_Info model = bus_parametro.GetInfo_Parametro();
if (model == null)
{
model = new rq_Parametro_Info();
}
cargar_combos();
return(View(model));
}
public rq_Parametro_Info GetInfo_Parametro()
{
try
{
rq_Parametro_Info info = new rq_Parametro_Info();
using (SqlConnection connection = new SqlConnection(ConexionesERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand("", connection);
command.CommandText = "SELECT iParametroID,iEstadoCierre,iEstadoCancelado,vCorreo,vClave,Puerto,Host,bSSL,vCorreoDestino"
+ " FROM rq_Parametro WITH (nolock) ";
var ResultValue = command.ExecuteScalar();
if (ResultValue == null)
{
return(null);
}
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
info = new rq_Parametro_Info
{
iParametroID = Convert.ToInt32(reader["iParametroID"]),
iEstadoCierre = Convert.ToInt32(reader["iEstadoCierre"]),
iEstadoCancelado = Convert.ToInt32(reader["iEstadoCancelado"]),
vCorreo = string.IsNullOrEmpty(reader["vCorreo = "].ToString()) ? null : reader["vCorreo = "].ToString(),
vClave = string.IsNullOrEmpty(reader["vClave"].ToString()) ? null : reader["vClave"].ToString(),
Puerto = string.IsNullOrEmpty(reader["Puerto"].ToString()) ? (int?)null : Convert.ToInt32(reader["Puerto"]),
Host = string.IsNullOrEmpty(reader["Host"].ToString()) ? null : reader["Host"].ToString(),
vCorreoDestino = string.IsNullOrEmpty(reader["vCorreoDestino"].ToString()) ? null : reader["vCorreoDestino"].ToString(),
bSSL = Convert.ToBoolean(reader["bSSL"]),
};
}
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool GuardarDB(rq_Parametro_Info info)
{
try
{
if (info.iParametroID == 0)
{
return(odata.guardarDB(info));
}
else
{
return(odata.modificarDB(info));
}
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(rq_Parametro_Info info)
{
try
{
using (Entities_requerimiento Context = new Entities_requerimiento())
{
rq_Parametro Entity = Context.rq_Parametro.FirstOrDefault(q => q.iParametroID == info.iParametroID);
if (Entity == null)
{
return(false);
}
Entity.iEstadoCierre = info.iEstadoCierre;
Entity.iEstadoCancelado = info.iEstadoCancelado;
Entity.vCorreo = info.vCorreo;
Entity.vClave = info.vClave;
Entity.Puerto = info.Puerto;
Entity.Host = info.Host;
Entity.vCorreoDestino = info.vCorreoDestino;
Entity.bSSL = info.bSSL;
Entity.vUserIDModificacion = info.vUserIDModificacion;
Entity.dFechaModificacion = info.dFechaModificacion = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
tb_LogError_Data LogData = new tb_LogError_Data();
LogData.GuardarDB(new tb_LogError_Info {
Descripcion = ex.Message, InnerException = ex.InnerException == null ? null : ex.InnerException.Message, Clase = "rq_Cliente_Data", Metodo = "modificarDB", IdUsuario = info.vUserIDModificacion
});
return(false);
}
}
