public List<Depot> GetDepotByCompanyId(int compId) { SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@company_id", compId) }; List<Depot> result = new List<Depot>(); string sql = "SELECT id, name, department_id, contact_person, phone, fax, address, status, company_id FROM depots WHERE company_id = @company_id AND is_delete = 0"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { Depot depot = new Depot(); depot.Id = dr.GetInt32(0); depot.Name = dr.GetString(1); Department depart = new DepartmentDAL().GetDepartmentById(dr.GetInt32(2)); depot.Department = depart; depot.ContactPerson = dr.GetString(3); depot.Phone = dr.GetString(4); depot.Fax = dr.GetString(5); depot.Address = dr.GetString(6); depot.Status = dr.GetBoolean(7); depot.CompanyId = dr.GetInt32(8); result.Add(depot); } } return result; }
public List<Depot> GetDepot() { List<Depot> result = new List<Depot>(); string sql = "SELECT id, name, department_id, contact_person, phone, fax, address, status, company_id FROM depots WHERE is_delete = 0"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, null)) { while (dr.Read()) { Depot depot = new Depot(); depot.Id = dr.GetInt32(0); depot.Name = dr.GetString(1); Department depart = new DepartmentDAL().GetDepartmentById(dr.GetInt32(2)); depot.Department = depart; depot.ContactPerson = dr.GetString(3); depot.Phone = dr.GetString(4); depot.Fax = dr.GetString(5); depot.Address = dr.GetString(6); depot.Status = dr.GetBoolean(7); depot.CompanyId = dr.GetInt32(8); result.Add(depot); } } return result; }
public Depot GetDepotByName(string name) { Depot depot = null; SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputNVarcharParameter("@name", 50, name) }; string sql = "SELECT id, name, department_id, contact_person, phone, fax, address, status, company_id FROM depots WHERE name = @name AND is_delete = 0"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { depot = new Depot(); depot.Id = dr.GetInt32(0); depot.Name = dr.GetString(1); Department depart = new DepartmentDAL().GetDepartmentById(dr.GetInt32(2)); depot.Department = depart; depot.ContactPerson = dr.GetString(3); depot.Phone = dr.GetString(4); depot.Fax = dr.GetString(5); depot.Address = dr.GetString(6); depot.Status = dr.GetBoolean(7); depot.CompanyId = dr.GetInt32(8); } } return depot; }