public static ReadOnlyCollection <Unidad> GetAll(int companyId) { /* CREATE PROCEDURE Provider_GetByCompany * @CompanyId int */ List <Unidad> res = new List <Unidad>(); using (SqlCommand cmd = new SqlCommand("Unidad_GetAll")) { cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cns"].ConnectionString); try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataParameter.Input("@CompanyId", companyId)); cmd.Connection.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Unidad objetivo = new Unidad() { Id = rdr.GetInt32(ColumnsUnidadGet.Id), Description = rdr.GetString(ColumnsUnidadGet.Description), CompanyId = companyId, CreatedBy = new ApplicationUser() { Id = rdr.GetInt32(ColumnsUnidadGet.CreatedBy), UserName = rdr.GetString(ColumnsUnidadGet.CreatedByName) }, CreatedOn = rdr.GetDateTime(ColumnsUnidadGet.CreatedOn), ModifiedBy = new ApplicationUser() { Id = rdr.GetInt32(ColumnsUnidadGet.ModifiedBy), UserName = rdr.GetString(ColumnsUnidadGet.ModifiedByName) }, ModifiedOn = rdr.GetDateTime(ColumnsUnidadGet.ModifiedOn), Active = rdr.GetBoolean(ColumnsUnidadGet.Active), CanBeDeleted = rdr.GetInt32(ColumnsUnidadGet.Deletable) == 1 }; res.Add(objetivo); } } finally { if (cmd.Connection.State != ConnectionState.Closed) { cmd.Connection.Close(); } } } return(new ReadOnlyCollection <Unidad>(res)); }
public static Unidad GetById(int objetivoId, int companyId) { /* CREATE PROCEDURE Unidad_GetByCompany * @UnidadId int */ Unidad res = Unidad.Empty; using (SqlCommand cmd = new SqlCommand("Unidad_GetById")) { cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cns"].ConnectionString); try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataParameter.Input("@UnidadId", objetivoId)); cmd.Parameters.Add(DataParameter.Input("@CompanyId", companyId)); cmd.Connection.Open(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); res.Id = rdr.GetInt32(ColumnsUnidadGet.Id); res.Description = rdr.GetString(ColumnsUnidadGet.Description); res.CompanyId = companyId; res.CreatedBy = new ApplicationUser() { Id = rdr.GetInt32(ColumnsUnidadGet.CreatedBy), UserName = rdr.GetString(ColumnsUnidadGet.CreatedByName) }; res.CreatedOn = rdr.GetDateTime(ColumnsUnidadGet.CreatedOn); res.ModifiedBy = new ApplicationUser() { Id = rdr.GetInt32(ColumnsUnidadGet.ModifiedBy), UserName = rdr.GetString(ColumnsUnidadGet.ModifiedByName) }; res.ModifiedOn = rdr.GetDateTime(ColumnsUnidadGet.ModifiedOn); res.Active = rdr.GetBoolean(ColumnsUnidadGet.Active); res.CanBeDeleted = rdr.GetInt32(ColumnsUnidadGet.Deletable) == 1; } } finally { if (cmd.Connection.State != ConnectionState.Closed) { cmd.Connection.Close(); } } } return(res); }