public ActionResult Interview([Bind(Prefix = "Item1")] List <ViewModels.Interview> Rating, FormCollection frm) { int Id_Interviewed; DBManager db = new DBManager(); ViewModels.Interview objInt = new ViewModels.Interview(); InterviewComments IntComments = new InterviewComments(); int ReqId = Convert.ToInt32(TempData["ReqId"]); int TempId = Convert.ToInt32(TempData["TempId"]); Id_Interviewed = Convert.ToInt32(TempData["Id_Interviewed"]); TempData.Keep(); objInt.status = frm["status"]; objInt.comments = frm["comments"]; string swg = System.Web.HttpContext.Current.Session["swgId"].ToString(); IntComments.InterviewerId = swg; IntComments.Comments = frm["comments"]; IntComments.Status = frm["status"]; IntComments.Datetime = DateTime.Now; if (Id_Interviewed != 0) { //Update interview table(new comments) db.UPDATEInterviews(Id_Interviewed, swg, IntComments.Status); } else { Id_Interviewed = db.Interviews(swg, objInt); int f = db.SetCandidateMapping(TempId, ReqId, Id_Interviewed); foreach (ViewModels.Interview i in Rating) { int rating = i.Rating; int skill = i.SkillId; db.SetRating(Id_Interviewed, rating, skill); } } int f1 = db.Interviewcomments(Id_Interviewed, swg, IntComments, TempId, ReqId); int f2 = db.UpdateCommentCandidate(frm["status"], TempId); return(RedirectToAction("GetCandidates", "Candidate", new { ReqId = ReqId })); }
// fill interview details in Interviewcomments public static string InterviewsQuerycomment(ViewModels.Interview interview, string swg) { String Query = "Insert into Interviewcomments (Interviewid,empid,comments,datetime,interviewstatus) values('" + "','" + interview.status + "')"; return(Query); }
//Get interview id first interview public static string InterviewsQuery(ViewModels.Interview interview, string swg) { String Query = "Insert into Interviews (InterviewerId,status) Output Inserted.interviewId values('" + swg + "','" + interview.status + "')"; return(Query); }