// GET: Annual public ActionResult Appraisal() { List <AnnualAppraisalModel> UserProfileList = new List <AnnualAppraisalModel>(); try { ds = ap_layer.GetUserProfile(Convert.ToInt32(Session["Emp_id"])); dt = ds.Tables[3]; foreach (DataRow dr in dt.Rows) { AnnualAppraisalModel ap = new AnnualAppraisalModel(); ap.EMP_ID = Convert.ToInt32(Session["emp_id"]); ap.NAME = dr["FULL_NAME"].ToString(); ap.MANAGER_NAME = dr["MANAGER_NAME"].ToString(); ap.DESIGNATION = dr["DESIGNATION"].ToString(); ap.CURRENT_DATE = dr["Cr_DATE"].ToString(); ap.DEPARTMENT = dr["department_name"].ToString(); ap.GOAL_QUARTER = dr["GOAL_QUARTER"].ToString(); ap.FINAL_RATING = dr["MNG_GOAL_RATING"].ToString(); UserProfileList.Add(ap); } return(View(UserProfileList)); } catch (Exception) { return(View()); } }
public JsonResult CreateAnnualAppraisal(AnnualAppraisalModel objResponsibility, AppraisalPerformanceModel objPerformance, AppraisalRating objRating) { List <AnnualAppraisalModel> AnnualResponsibilitylist = new List <AnnualAppraisalModel>(); AnnualResponsibilitylist.Add(objResponsibility); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = new DataTable(); dt = converter.ToDataTable(AnnualResponsibilitylist); List <AppraisalPerformanceModel> AnnualPerformanceList = new List <AppraisalPerformanceModel>(); AnnualPerformanceList.Add(objPerformance); ListtoDataTableConverter PerformanceConverter = new ListtoDataTableConverter(); DataTable dt1 = new DataTable(); dt1 = PerformanceConverter.ToDataTable(AnnualPerformanceList); List <AppraisalRating> RatingList = new List <AppraisalRating>(); RatingList.Add(objRating); ListtoDataTableConverter RatingConverter = new ListtoDataTableConverter(); DataTable dt2 = new DataTable(); dt2 = RatingConverter.ToDataTable(RatingList); MastersModel mm = new MastersModel(); string res = ""; try { res = ap_layer.CreateAnnualAppraisal(dt, dt1, dt2); string[] response = res.Split(','); if (response[0] == "Success") { mm.SuccessMsg = response[1]; } else if (response[0] == "Error") { mm.ErrorMsg = response[1]; } } catch (Exception ex) { mm.ErrorMsg = ex.Message; } return(Json(mm, JsonRequestBehavior.AllowGet)); }