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