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;
}
