public DataSet UpdateJobDetailsRecordStatus(JobDeatils _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_update_recdStatus_jobdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RecID", _ur.Rec_ID);
cmd.Parameters.AddWithValue("@Recd_status", _ur.Recd_status);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public DataSet GetJobDetailsByAccess(JobDeatils _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_get_PublicPrivate_jobdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", _ur.UserID);
cmd.Parameters.AddWithValue("@RecordType", _ur.RecordType);
cmd.Parameters.AddWithValue("@access_status", _ur.Access_status);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public DataSet UpdateJobDetails(JobDeatils _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_update_jobdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RecID", _ur.Rec_ID);
cmd.Parameters.AddWithValue("@Post_Category", _ur.Post_Category);
cmd.Parameters.AddWithValue("@Post_SubCategory", _ur.Post_SubCategory);
cmd.Parameters.AddWithValue("@NoOfEmp", _ur.NoOfEmp);
cmd.Parameters.AddWithValue("@Emp_experince", _ur.Emp_experince);
cmd.Parameters.AddWithValue("@shifttimings", _ur.shifttimings);
cmd.Parameters.AddWithValue("@ContractPeriod", _ur.ContractPeriod);
cmd.Parameters.AddWithValue("@WorkLocation", _ur.WorkLocation);
cmd.Parameters.AddWithValue("@TransaposrtFacility", _ur.TransaposrtFacility);
cmd.Parameters.AddWithValue("@UserID", _ur.UserID);
cmd.Parameters.AddWithValue("@RecordType", _ur.RecordType);
cmd.Parameters.AddWithValue("@post_explanation", _ur.post_explanation);
cmd.Parameters.AddWithValue("@CompanyName", _ur.CompanyName);
/////////////////////////////////
cmd.Parameters.AddWithValue("@Country", _ur.Country);
cmd.Parameters.AddWithValue("@State", _ur.State);
cmd.Parameters.AddWithValue("@City", _ur.City);
cmd.Parameters.AddWithValue("@ZipCode", _ur.ZipCode);
cmd.Parameters.AddWithValue("@PaymentType", _ur.PaymentType);
cmd.Parameters.AddWithValue("@PayMode", _ur.PayMode);
cmd.Parameters.AddWithValue("@CurrencyType", _ur.CurrencyType);
cmd.Parameters.AddWithValue("@Amount", _ur.Amount);
cmd.Parameters.AddWithValue("@post_comments", _ur.post_comments);
cmd.Parameters.AddWithValue("@post_title", _ur.Post_Title);
cmd.Parameters.AddWithValue("@other_category", _ur.Other);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public DataSet GetJobDetailsByIDForEdit(JobDeatils _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_GETJobDeatailsByJobID_edit", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@JobID", _ur.Rec_ID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public DataSet GetAppliedJobDetailsByUSERID(JobDeatils _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_GETAppliedJobDeatailsByUserIDID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", _ur.UserID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public Response UpdateJobRecordStatus(JobDeatils model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.UpdateJobDetailsRecordStatus(model);
if (ds != null && ds.Tables.Count > 0)
{
List <JobDeatils> joblist = new List <JobDeatils>();
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
};
}
else
{
response = new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}
public Response GetAppliedJobDetailsByUSERIDWithRecordType(JobDeatils model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.GetAppliedJobDetailsByUSERIDWithRecordType(model);
if (ds != null && ds.Tables.Count > 0)
{
List <AppliedJobDetails> joblist = new List <AppliedJobDetails>();
if (ds.Tables[0].Rows[0][0].ToString() == "200")
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
AppliedJobDetails data = new AppliedJobDetails();
data.JobAplliedRecID = dr["JobAplliedRecID"].ToString();
data.JobID = dr["Rec_ID"].ToString();
data.shifttimings = dr["shifttimings"].ToString();
data.Category = dr["Post_Category"].ToString();
data.Access_status = dr["ReqAccess_status"].ToString();
data.SubCategory = dr["Post_SubCategory"].ToString();
data.ContractPeriod = dr["ContractPeriod"].ToString();
data.JobPostEntdt = dr["Entdt"].ToString();
data.JobAppliedDate = dr["JobAppliedDate"].ToString();
data.WorkLocation = dr["WorkLocation"].ToString();
data.Emp_experince = dr["Emp_experince"].ToString();
data.CompanyName = dr["CompanyName"].ToString();
data.NoOfEmp = dr["NoOfEmp"].ToString();
data.PostReqNoOfEmp = dr["PostReqNoOfEmp"].ToString();
data.Country = dr["Country"].ToString();
data.State = dr["State"].ToString();
data.City = dr["City"].ToString();
data.ZipCode = dr["ZipCode"].ToString();
data.PaymentType = dr["PaymentType"].ToString();
data.PayMode = dr["PayMode"].ToString();
data.CurrencyType = dr["CurrencyType"].ToString();
data.Amount = dr["Amount"].ToString();
data.post_comments = dr["post_comments"].ToString();
data.Post_Title = dr["post_title"].ToString();
data.Other = dr["other_category"].ToString();
data.TransaposrtFacility = dr["TransaposrtFacility"].ToString();
data.post_explanation = dr["post_explanation"].ToString();
joblist.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
joblist
}
};
}
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
};
}
}
else
{
response = new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}