public JobDetailsSessionView() { ContractsTemplates = new List<ContractTemplateEntity>(); FunctionalLevel = new FunctionalLevelEntity(); OrganisationalUnit = new OrganizationalUnitView(); Grade = new GradeEntity(); Step = new StepEntity(); Job = new JobTitleView(); IsGenerated = false; }
public JobDetailsSessionView() { ContractsTemplates = new List <ContractTemplateEntity>(); FunctionalLevel = new FunctionalLevelEntity(); OrganisationalUnit = new OrganizationalUnitView(); Grade = new GradeEntity(); Step = new StepEntity(); Job = new JobTitleView(); IsGenerated = false; }
public OrganizationalUnitView Get(OrganizationalUnitEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetOrganisationalUnitById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); 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(); } }
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(); } }