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