public List <IVacancy> VacancyWithNULLRecruitmentRequestID() // { //used for creating RecruitmentRequests //ADO.NET program for searching vacancies with recruitmentRequestID as null SqlConnection conn = DBUtility.GetConnection(); vacancyList.Clear(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_vacancyWithNULLRecruitmentRequestID_667015"; //cmd.Parameters.AddWithValue("@recruitmentRequestID", recruitmentRequestID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int vacancyID = reader.GetInt32(0); int noOfPositions = reader.GetInt32(1); string skills = reader.GetString(2); string domain = reader.GetString(3); int experience = reader.GetInt32(4); DateTime requiredDate = reader.GetDateTime(5); string location = reader.GetString(6); int status = reader.GetInt32(7); //retrieving all vacancies associated to the recruitmentrequestID given vacancy = VacancyFactory.CreateVacancy(vacancyID, noOfPositions, skills, domain, experience, requiredDate, location, status); vacancyList.Add(vacancy); } conn.Close(); return(vacancyList); }
//FUNCTION FOR DISPLAYING VACANCY public List <IVacancy> SelectVacancy(int employeeID) { SqlConnection conn = DBUtility.GetConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_selectVacancy_667015"; cmd.Parameters.AddWithValue("@employeeId", employeeID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int vacancyID = reader.GetInt32(0); int noOfPositions = reader.GetInt32(1); string skills = reader.GetString(2); string domain = reader.GetString(3); int experience = reader.GetInt32(4); DateTime requiredDate = reader.GetDateTime(5); string location = reader.GetString(6); int status = reader.GetInt32(7); //retirving all vacancies associated to the recruitmentrequestID given vacancy = VacancyFactory.CreateVacancy(vacancyID, noOfPositions, skills, domain, experience, requiredDate, location, status); vacancyList.Add(vacancy); } conn.Close(); return(vacancyList); }
public void SetLinkValue <T>(T obj) { if (obj is IStudent) { LinkStudent = obj as IStudent; } if (obj is IVacancy) { LinkVacancy = obj as IVacancy; } }
// Нажатие на элемент управления "Очистить". Обработка события. private void linkClear_Click(object sender, EventArgs e) { var link = sender as Label; if (link.Name == "linkStudent" || link.Name == "linkStudentClear") { LinkStudent = null; } else { LinkVacancy = null; } }
public List <IVacancy> SearchRecruitmentRequest(int recruitmentRequestID) { //used for displays the vacancies wrt to given recruitmentRequest //ADO.NET program for searching recruitmentRequest //SqlConnection myConnection = DBUtility.getConnection(); //using (myConnection) //{ // SqlCommand myCommand = new SqlCommand("sp_searchRecruitmentRequest_667961", myConnection); // myCommand.CommandType = CommandType.StoredProcedure; // myCommand.Parameters.AddWithValue("@RecruitmentRequestID", recruitmentRequestID); // myConnection.Open(); // myCommand.ExecuteNonQuery(); // myConnection.Close(); //} //ADO.NET program for searching recruitmentrequest SqlConnection conn = DBUtility.GetConnection(); vacancyList.Clear(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_searchRecruitmentRequest_667015"; cmd.Parameters.AddWithValue("@recruitmentRequestID", recruitmentRequestID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int vacancyID = reader.GetInt32(0); int noOfPositions = reader.GetInt32(1); string skills = reader.GetString(2); string domain = reader.GetString(3); int experience = reader.GetInt32(4); DateTime requiredDate = reader.GetDateTime(5); string location = reader.GetString(6); int status = reader.GetInt32(7); //retirving all vacancies associated to the recruitmentrequestID given vacancy = VacancyFactory.CreateVacancy(vacancyID, noOfPositions, skills, domain, experience, requiredDate, location, status); vacancyList.Add(vacancy); } conn.Close(); return(vacancyList); }
// To retrieve all the vacancies public List <IVacancy> GetVacancy() { List <IVacancy> lstVacancy = new List <IVacancy>(); SqlCommand objMyCommand; SqlConnection objMyConnection = DBUtility.getConnection(); try { using (objMyConnection) { objMyCommand = new SqlCommand("sp_getVacancy", objMyConnection); objMyCommand.CommandType = CommandType.StoredProcedure; objMyConnection.Open(); SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader(); while (objSqlDataReader.Read()) { int VacancyID = Int32.Parse(objSqlDataReader["VacancyID"].ToString()); int NoOfPositions = Int32.Parse(objSqlDataReader["NoOfPositions"].ToString()); String Skills = objSqlDataReader["Skills"].ToString(); int Experience = Int32.Parse(objSqlDataReader["Experience"].ToString()); String Location = objSqlDataReader["Location"].ToString(); String BusinessDomain = objSqlDataReader["BusinessDomain"].ToString(); DateTime RequiredByDate = DateTime.Parse(objSqlDataReader["RequiredByDate"].ToString()); int Status = Int32.Parse(objSqlDataReader["Status"].ToString()); int VacancyRequestID = Int32.Parse(objSqlDataReader["VacancyRequestID"].ToString()); int RecruitmentRequestID = Int32.Parse(objSqlDataReader["RecruitmentRequestID"].ToString()); IVacancy v = VacancyFactory.Create_Vacancy(VacancyID, NoOfPositions, Skills, Experience, Location, BusinessDomain, RequiredByDate, Status, VacancyRequestID, RecruitmentRequestID); lstVacancy.Add(v); } objSqlDataReader.Close(); } return(lstVacancy); } catch (Exception EE) { Console.WriteLine(EE); Console.Read(); return(null); } finally { objMyConnection.Close(); } }
//FUNCTION FOR DISPALYING UNAPPROVED VACANCY public List <IVacancy> ViewUnapprovedVacancies(int employeeID) { vacancyList.Clear(); //ADO.NET program for displaying unapproved vacancies SqlConnection myConnection = DBUtility.GetConnection(); //make the connection object SqlCommand myCommand = new SqlCommand(); //make sqlcommand object myCommand.Connection = myConnection; //give connection with the command object myCommand.CommandType = CommandType.StoredProcedure; //bind with CommandType myCommand.CommandText = "sp_viewUnapprovedVacancies_545444"; //bind with CommandText myCommand.Parameters.AddWithValue("@employeeId", employeeID); myConnection.Open(); //Open the connection DataTable unapprovedTable = new DataTable(); //make DataTable SqlDataReader unapprovedDataReader = myCommand.ExecuteReader(); //Make DataReader unapprovedTable.Load(unapprovedDataReader); //Put all values from DataReader to DataTable for (int index = 0; index < unapprovedTable.Rows.Count; index++) //Use for loop to count the rows of the table { int vacancyID = (int)unapprovedTable.Rows[index][0]; //get the value from the 1st column of the table int noOfPositions = (int)unapprovedTable.Rows[index][1]; //get the value from the 2nd column of the table string skills = (string)unapprovedTable.Rows[index][2]; //get the value from the 3rd column of the table string domain = (string)unapprovedTable.Rows[index][3]; int experience = (int)unapprovedTable.Rows[index][4]; //get the value from the 4th column of the table DateTime requiredDate = (DateTime)unapprovedTable.Rows[index][5]; //get the value from the 5th column of the table string location = (string)unapprovedTable.Rows[index][6]; int status = (int)unapprovedTable.Rows[index][7]; //get the value from the 6th column of the table vacancy = VacancyFactory.CreateVacancy(vacancyID, noOfPositions, skills, domain, experience, requiredDate, location, status); vacancyList.Add(vacancy); } myConnection.Close(); //Close the connection return(vacancyList); //Return the Vacancy type list }
private void cbUnivercityEmployment_CheckedChanged(object sender, EventArgs e) { vacancyPanel.Enabled = cbUnivercityEmployment.Checked; tbCompany.Enabled = !cbUnivercityEmployment.Checked; tbPost.Enabled = !cbUnivercityEmployment.Checked; tbSalary.Enabled = !cbUnivercityEmployment.Checked; tbNameOfStateDepartment.Enabled = !cbUnivercityEmployment.Checked; if (!cbUnivercityEmployment.Checked) { LinkVacancy = null; tbCompany.Focus(); errorProvider.SetError(linkVacancy, ""); } else { linkVacancy.Focus(); errorProvider.SetError(tbCompany, ""); errorProvider.SetError(tbPost, ""); } }
public VacancyForm(MainMDIForm mainForm, IVacancy entity) : base(mainForm, entity) { InitializeComponent(); }
public VacancyForm(ActionType type, IVacancy entity, IDataListView <IVacancy> viewContext) : base(type, entity, viewContext) { InitializeComponent(); }
public VacancyForm(ActionType type, IVacancy entity = null) : base(type, entity) { InitializeComponent(); }
public VacancyController(IVacancy vacancyrepository) { _vacancyrepository = vacancyrepository; } // GET: /<controller>/
public static IVacancy CreateVacancy(int vacancyID, int noOfPositions, string skills, string domain, int experience, DateTime requiredDate, string location, int status) { vacancy = new Vacancy(vacancyID, noOfPositions, skills, domain, experience, requiredDate, location, status); return(vacancy); }
public static IVacancy Create_Vacancy(int VacancyID, int NoOfPositions, String Skills, int Experience, String Location, String BusinessDomain, DateTime RequiredByDate, int Status, int VacancyRequestID, int RecruitmentRequestID) { objVacancy = new Vacancy(VacancyID, NoOfPositions, Skills, Experience, Location, BusinessDomain, RequiredByDate, Status, VacancyRequestID, RecruitmentRequestID); return(objVacancy); }
public StudentCompanyForm(IStudentCompany entity, IVacancy vacancy) : base(ActionType.Add, entity) { InitializeComponent(); LinkVacancy = vacancy; linkVacancy.Enabled = linkVacancyClear.Visible = false; }