public int UpdatePostStatus(JobPostsBO ObjJobPostsBO1) { ObjDatabaseObject.DBCommand = new SqlCommand(); ObjDatabaseObject.DBCommand.CommandText = @"uspUpdatePostStatus"; ObjDatabaseObject.DBCommand.CommandType = CommandType.StoredProcedure; SqlParameter Param1 = new SqlParameter(); Param1.ParameterName = "@PostingStatus"; Param1.Value = ObjJobPostsBO1.PostingStatus; SqlParameter Param2 = new SqlParameter(); Param2.ParameterName = "@UniqueCode"; Param2.Value = ObjJobPostsBO1.UniqueCode; SqlParameter Param3 = new SqlParameter(); Param3.ParameterName = "@PostId"; Param3.Value = ObjJobPostsBO1.PostId; try { ObjDatabaseObject.DBCommand.Connection = ObjDatabaseObject.DBConnection; ObjDatabaseObject.DBConnection.Open(); ObjDatabaseObject.DBCommand.Parameters.Add(Param1); ObjDatabaseObject.DBCommand.Parameters.Add(Param2); ObjDatabaseObject.DBCommand.Parameters.Add(Param3); return ObjDatabaseObject.DBCommand.ExecuteNonQuery(); } catch (Exception e) { return 0; } finally { ObjDatabaseObject.DBConnection.Close(); } }
public int UpdateJobPostDetails(JobPostsBO jobPostBOObject) { return jobPostDALObject.UpdateJobPostDetails(jobPostBOObject); }
public int InsertJobPostDetails(JobPostsBO jobPostBOObject) { return jobPostDALObject.InsertJobPostDetails(jobPostBOObject); }
public DataTable ViewPostsByStatus(JobPostsBO ObjJobPostsBO1) { return ObjJobPostingApprovalDAL.ViewPostsByStatus(ObjJobPostsBO1); }
public int UpdatePostStatus(JobPostsBO ObjJobPostsBO1) { return ObjJobPostingApprovalDAL.UpdatePostStatus(ObjJobPostsBO1); }
public int UpdateJobPostDetails(JobPostsBO jobPostBOObject) { int queryStatus = 0; databaseObject.DBCommand = new SqlCommand(); databaseObject.DBCommand.CommandText = @"uspUpdateJobDetails"; databaseObject.DBCommand.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@UniqueCode"; param1.Value = jobPostBOObject.UniqueCode; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@PositionName"; param2.Value = jobPostBOObject.PositionName; SqlParameter param3 = new SqlParameter(); param3.ParameterName = "@NumberOfOpening"; param3.Value = jobPostBOObject.NumberOfOpenings; SqlParameter param4 = new SqlParameter(); param4.ParameterName = "@LocationOfOpening"; param4.Value = jobPostBOObject.LocationOfTheOpenings; SqlParameter param5 = new SqlParameter(); param5.ParameterName = "@ExperienceRequired"; param5.Value = jobPostBOObject.ExperienceRequired; SqlParameter param6 = new SqlParameter(); param6.ParameterName = "@SkillSet"; param6.Value = jobPostBOObject.SkillSet; SqlParameter param7 = new SqlParameter(); param7.ParameterName = "@TentativeSalary"; param7.Value = jobPostBOObject.TentativeSalary; SqlParameter param8 = new SqlParameter(); param8.ParameterName = "@CloseDate"; param8.Value = jobPostBOObject.CloseDate; SqlParameter param9 = new SqlParameter(); param9.ParameterName = "@JoiningDate"; param9.Value = jobPostBOObject.JoiningDate; SqlParameter param10 = new SqlParameter(); param10.ParameterName = "@PostingStatus"; param10.Value = jobPostBOObject.PostingStatus; SqlParameter param11 = new SqlParameter(); param11.ParameterName = "@PostId"; param11.Value = jobPostBOObject.PostId; try { databaseObject.DBCommand.Connection = databaseObject.DBConnection; databaseObject.DBConnection.Open(); databaseObject.DBCommand.Parameters.Add(param1); databaseObject.DBCommand.Parameters.Add(param2); databaseObject.DBCommand.Parameters.Add(param3); databaseObject.DBCommand.Parameters.Add(param4); databaseObject.DBCommand.Parameters.Add(param5); databaseObject.DBCommand.Parameters.Add(param6); databaseObject.DBCommand.Parameters.Add(param7); databaseObject.DBCommand.Parameters.Add(param8); databaseObject.DBCommand.Parameters.Add(param9); databaseObject.DBCommand.Parameters.Add(param10); databaseObject.DBCommand.Parameters.Add(param11); queryStatus = databaseObject.DBCommand.ExecuteNonQuery(); } catch (SqlException ex) { } finally { databaseObject.DBConnection.Close(); } return queryStatus; }
public int InsertJobPostDetails(JobPostsBO jobPostBOObject) { int queryStatus = 0; databaseObject.DBCommand = new SqlCommand(); databaseObject.DBCommand.CommandText = @"uspInsertJobPost"; databaseObject.DBCommand.CommandType = CommandType.StoredProcedure; databaseObject.DBDataTable = new DataTable(); databaseObject.DBDataTable.Columns.Add("UniqueCode", typeof(string)); databaseObject.DBDataTable.Columns.Add("PostId", typeof(int)); databaseObject.DBDataTable.Columns.Add("PositionName", typeof(string)); databaseObject.DBDataTable.Columns.Add("NumberOfOpenings", typeof(string)); databaseObject.DBDataTable.Columns.Add("LocationOfTheOpenings", typeof(string)); databaseObject.DBDataTable.Columns.Add("ExperienceRequired", typeof(int)); databaseObject.DBDataTable.Columns.Add("SkillSet", typeof(string)); databaseObject.DBDataTable.Columns.Add("TentativeSalary", typeof(double)); databaseObject.DBDataTable.Columns.Add("CloseDate", typeof(DateTime)); databaseObject.DBDataTable.Columns.Add("JoiningDate", typeof(DateTime)); databaseObject.DBDataTable.Columns.Add("PostingStatus", typeof(string)); databaseObject.DBDataTable.Columns.Add("Comments", typeof(string)); databaseObject.DBDataTable.Rows.Add(jobPostBOObject.UniqueCode, jobPostBOObject.PostId, jobPostBOObject.PositionName, jobPostBOObject.NumberOfOpenings, jobPostBOObject.LocationOfTheOpenings, jobPostBOObject.ExperienceRequired, jobPostBOObject.SkillSet, jobPostBOObject.TentativeSalary, jobPostBOObject.CloseDate, jobPostBOObject.JoiningDate, jobPostBOObject.PostingStatus, jobPostBOObject.Comments); SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@JobPostDetails"; param1.Value = databaseObject.DBDataTable; try { databaseObject.DBCommand.Connection = databaseObject.DBConnection; databaseObject.DBConnection.Open(); databaseObject.DBCommand.Parameters.Add(param1); queryStatus = databaseObject.DBCommand.ExecuteNonQuery(); } catch (SqlException ex) { } finally { databaseObject.DBConnection.Close(); } return queryStatus; }
public DataTable ViewPostsByStatus(JobPostsBO ObjJobPostsBO1) { ObjDatabaseObject.DBDataTable = new DataTable(); ObjDatabaseObject.DBAdapter = new SqlDataAdapter(); //ObjDatabaseObject.DBCommand = new SqlCommand(@"uspViewPostsByStatus", ObjDatabaseObject.DBConnection); ObjDatabaseObject.DBAdapter.SelectCommand = new SqlCommand(@"uspViewPostsByStatus", ObjDatabaseObject.DBConnection); SqlParameter Param1=new SqlParameter(); Param1.ParameterName="@PostingStatus"; Param1.Value=ObjJobPostsBO1.PostingStatus; ObjDatabaseObject.DBAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; ObjDatabaseObject.DBAdapter.SelectCommand.Parameters.Add(Param1); ObjDatabaseObject.DBAdapter.Fill(ObjDatabaseObject.DBDataTable); return ObjDatabaseObject.DBDataTable; }