public List <OrganizationalUnitView> ListWithAdvancedFilter(string title, int?parentOrgId, int?orgUnitGroup) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListOrganisationalUnitsWithAdvancedFilter", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", title); if (parentOrgId != null) { cmd.Parameters.AddWithValue("@ParentOrganizationUnitId", parentOrgId); } if (orgUnitGroup != null) { cmd.Parameters.AddWithValue("@OrganizationUnitGroupId", orgUnitGroup); } SqlDataReader rdr = cmd.ExecuteReader(); List <OrganizationalUnitView> list = new List <OrganizationalUnitView>(); while (rdr.Read()) { OrganizationalUnitView entity = new OrganizationalUnitView(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Description = Convert.ToString(rdr["Description"]); entity.OrganizationaUnitGroup = Convert.ToString(rdr["OrganizationaUnitGroup"]); entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); entity.Title = Convert.ToString(rdr["Title"]); list.Add(entity); } return(list); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public List <OrganizationalUnitView> List(string search) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListOrganisationalUnits", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Search", search); SqlDataReader rdr = cmd.ExecuteReader(); List <OrganizationalUnitView> list = new List <OrganizationalUnitView>(); while (rdr.Read()) { OrganizationalUnitView entity = new OrganizationalUnitView(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); entity.Title = Convert.ToString(rdr["Title"]); entity.Description = Convert.ToString(rdr["Description"]); entity.OrganizationaUnitGroup = Convert.ToString(rdr["OrganizationaUnitGroup"]); list.Add(entity); } return(list); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public OrganizationalUnitView Get(string name) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetOrganisationalUnitByName", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", name); SqlDataReader rdr = cmd.ExecuteReader(); OrganizationalUnitView organisationalUnitView = new OrganizationalUnitView(); if (rdr.Read()) { organisationalUnitView.Id = Convert.ToInt32(rdr["Id"]); organisationalUnitView.Title = Convert.ToString(rdr["Title"]); organisationalUnitView.Description = Convert.ToString(rdr["Description"]); organisationalUnitView.OrganizationaUnitGroup = Convert.ToString(rdr["OrganizationaUnitGroup"]); organisationalUnitView.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); } return(organisationalUnitView); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }