public DataSet UpdateJobApplyDetails(JobApplyModel _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_update_jobdApplyetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RecID", _ur.RecID);
cmd.Parameters.AddWithValue("@NoOfEmp", _ur.NoOfEmp);
cmd.Parameters.AddWithValue("@Emp_experince", _ur.Emp_experince);
cmd.Parameters.AddWithValue("@Post_comments", _ur.post_comments);
cmd.Parameters.AddWithValue("@Other", _ur.Other);
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 JsonResult UpdateAppliedJob(JobApplyModel jm)
{
var res = "";
try
{
string jsr = arobj.UpdateAppliedJob(jm);
return(Json((new JavaScriptSerializer()).DeserializeObject(jsr), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
res = ex.Message.ToString();
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public JsonResult ApplyJob(JobApplyModel um)
{
var res = "";
try
{
JsonResult jsr = null;
string inputJson = (new JavaScriptSerializer()).Serialize(um);
jsr = GetjsonInfo("/JobDeatils/InsertJobApplyDeatails", inputJson);
return(jsr);
}
catch (Exception ex)
{
res = ex.Message.ToString();
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public string UpdateAppliedJob(JobApplyModel jm)
{
var res = "";
try
{
string inputJson = (new JavaScriptSerializer()).Serialize(jm);
string jsr = GetjsonInfo("/JobDeatils/UpdateJobApplyDeatails", inputJson);
return(jsr);
}
catch (Exception ex)
{
ErrorWriter.WriteLog(ex.GetType().ToString(), ex.GetType().Name.ToString(), ex.InnerException.ToString(), "GetAppliedUserbyJob", "AdminRepository");
res = ex.Message.ToString();
return(res);
}
}
public Response UpdateJobApplyDeatails(JobApplyModel model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.UpdateJobApplyDetails(model);
if (ds != null && ds.Tables.Count > 0)
{
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")
});
}
}
