public bool Save(int id, int idArea, string descripcion, string sigla) { bool resultado = false; SubAreaBE obj = new SubAreaBE(); obj.Id = id; obj.IdArea = idArea; obj.Descripcion = descripcion; obj.Sigla = sigla; SubAreaBL bl = new SubAreaBL(); if (obj.Id == 0) { //FALTA: utilizar usuario obj.UsuarioCreacion = User.Identity.Name; resultado = bl.Insert(connstring, obj); } else { //FALTA: utilizar usuario obj.UsuarioModificacion = User.Identity.Name; resultado = bl.Update(connstring, obj); } return(resultado); }
public List <SubAreaBE> GetByIdArea(int IdArea) { List <SubAreaBE> oLista = new List <SubAreaBE>(); string connectionString = ConfigurationManager.ConnectionStrings["DB_Valua"].ConnectionString; SqlConnection con = new SqlConnection(); con.ConnectionString = connectionString; con.Open(); string nombreProcedure = "SubAreaGetByIdArea"; SqlCommand cmd = new SqlCommand(nombreProcedure, con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter Sp1 = new SqlParameter("@IdArea", IdArea); cmd.Parameters.Add(Sp1); using (IDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { SubAreaBE oSubArea = new SubAreaBE(); oSubArea.Id = Convert.ToInt32(dataReader["IdSubArea"].ToString()); oSubArea.Descripcion = dataReader["Descripcion"].ToString(); oLista.Add(oSubArea); } } return(oLista); }
public bool Delete(DBHelper pDBHelper, SubAreaBE pSubArea) { DBHelper.Parameters[] colParameters = null; try { colParameters = new DBHelper.Parameters[] { new DBHelper.Parameters("@ID", pSubArea.Id == Constantes.INT_NULO ? (object)DBNull.Value : pSubArea.Id), new DBHelper.Parameters("@USUARIOMODIFICACION", string.IsNullOrEmpty(pSubArea.UsuarioModificacion) ? (object)DBNull.Value : pSubArea.UsuarioModificacion) }; pDBHelper.CreateDBParameters(colParameters); int lfilasAfectadas = pDBHelper.ExecuteNonQuery(pDBHelper.concatOwner("SubAreaDelete"), CommandType.StoredProcedure, Utility.ConnectionState.KeepOpen, ParameterError.notInclude, CleanParameters.preserve); return(lfilasAfectadas > 0); } catch (Exception ex) { throw ex; } finally { colParameters = null; if (pDBHelper != null && pDBHelper.Command.Transaction == null) { pDBHelper.Dispose(); } } }
public bool Delete(string connstring, SubAreaBE obj) { try { DBHelper _oDBHelper = new DBHelper(connstring, Providers.SqlServer); return(SubAreaDA.Instanse.Delete(_oDBHelper, obj)); } catch (Exception ex) { throw ex; } }
public bool Delete(int id) { bool resultado = false; SubAreaBE obj = new SubAreaBE(); obj.Id = id; SubAreaBL bl = new SubAreaBL(); //FALTA: utilizar usuario obj.UsuarioModificacion = User.Identity.Name; resultado = bl.Delete(connstring, obj); return(resultado); }
public List <SubAreaBE> GetAll(DBHelper pDBHelper) { List <SubAreaBE> lst = null; SubAreaBE obj = null; DBHelper.Parameters[] colParameters = null; lst = new List <SubAreaBE>(); try { // Parámetros colParameters = new DBHelper.Parameters[] { }; pDBHelper.ClearParameter(); pDBHelper.CreateDBParameters(colParameters); using (IDataReader dr = pDBHelper.ExecuteReader(pDBHelper.concatOwner("SubAreaGetAll"), CommandType.StoredProcedure, Utility.ConnectionState.CloseOnExit)) { // Leyendo reader while (dr.Read()) { obj = new SubAreaBE(); obj.Id = int.Parse(dr["IdSubArea"].ToString()); obj.Descripcion = dr["Descripcion"].ToString(); obj.Sigla = dr["Sigla"].ToString(); obj.IdArea = int.Parse(dr["IdArea"].ToString()); obj.Area = dr["Area"].ToString(); obj.IdDepartamento = int.Parse(dr["IdDepartamento"].ToString()); obj.Departamento = dr["Departamento"].ToString(); obj.IdEmpresa = int.Parse(dr["IdEmpresa"].ToString()); obj.UsuarioModificacion = dr["UsuarioModificacionConfidencial"].ToString() == "1" ? ConfigurationManager.AppSettings["UsuarioAdministracion"].ToString() : dr["UsuarioModificacion"].ToString(); obj.UsuarioCreacion = dr["UsuarioCreacionConfidencial"].ToString() == "1" ? ConfigurationManager.AppSettings["UsuarioAdministracion"].ToString() : dr["UsuarioCreacion"].ToString(); if (string.IsNullOrEmpty(dr["FechaCreacion"].ToString())) { obj.FechaCreacion = null; } else { obj.FechaCreacion = DateTime.Parse(dr["FechaCreacion"].ToString()); } if (string.IsNullOrEmpty(dr["FechaModificacion"].ToString())) { obj.FechaModificacion = null; } else { obj.FechaModificacion = DateTime.Parse(dr["FechaModificacion"].ToString()); } lst.Add(obj); } } return(lst); } catch (Exception ex) { throw ex; } finally { colParameters = null; if (pDBHelper != null && pDBHelper.Command.Transaction == null) { pDBHelper.Dispose(); } } }