public JsonResult GetCandidateByICID(int ICID) { InterviewCandidateEntity CandidateDetails = null; try { var TktDtl = new InterviewCandidateComponent(); CandidateDetails = TktDtl.GetCandidateByICID(ICID); } catch (Exception ex) { return(null); } return(Json(CandidateDetails, JsonRequestBehavior.AllowGet)); }
//[HttpPost] //public ActionResult CreateInterviewCandidate(string FirstName,string LastName, string Email, string MobileNumber,string Password, int InterviewForPositionname,string AssignmentDate,string AssignmentTime) //{ // using (var db = new EvolutyzCornerDataEntities()) // { // try // { // InterviewCandidate nt = new InterviewCandidate(); // UserSessionInfo sessId = new UserSessionInfo(); // int IPID = Convert.ToInt32(InterviewForPositionname); // int userID = sessId.UserId; // int accid = sessId.AccountId; // // DateTime date = Convert.ToDateTime(AssignmentDate); // DateTime date = DateTime.ParseExact(AssignmentDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); // string pswd = GetMD5(Password); // EvolutyzCornerDataEntities evolutyzData = new EvolutyzCornerDataEntities(); // InterviewCandidate Depart = new InterviewCandidate(); // InterviewCandidate Departs = new InterviewCandidate(); // InterviewCandidate user = new InterviewCandidate(); // Depart.Assessment_For_Positionid = IPID; // Depart.FirstName = FirstName; // Depart.LastName = LastName; // Depart.Emailid = Email; // Depart.MobileNo = MobileNumber; // Depart.Password = pswd; // Depart.RecrutementUserid = userID; // Depart.AssessmentDate = date; // Depart.AssessmentTime = AssignmentTime; // Depart.CreatedDate = System.DateTime.Now; // Depart.status = true; // evolutyzData.InterviewCandidates.Add(Depart); // // } // int response = evolutyzData.SaveChanges(); // if (response > 0) // { // EvolutyzCornerDataEntities en = new EvolutyzCornerDataEntities(); // return Json("Data Added Successfully", JsonRequestBehavior.AllowGet); // string FName = FirstName; // string LName = LastName; // string Pswd = Password; // var Recuiteremail = (from a in en.Users where a.Usr_UserID == userID select a.Usr_LoginId).FirstOrDefault(); // SendEmailToresetpassword(FName, LName, Pswd, Recuiteremail); // } // else // { // return Json("Try Again!!", JsonRequestBehavior.AllowGet); // } // } // catch (Exception EX) // { // throw; // } // //return null; // } //} public string CreateInterviewCandidate(InterviewCandidateEntity InterviewDtl) { string strResponse = string.Empty; UserSessionInfo _objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo; int _userID = _objSessioninfo.UserId; InterviewDtl.Createdby = _userID; var Org = new InterviewCandidateComponent(); string Password = InterviewDtl.Password; InterviewDtl.Password = GetMD5(InterviewDtl.Password); int r = Org.AddIntCandidate(InterviewDtl); if (r == 0) { EvolutyzCornerDataEntities db = new EvolutyzCornerDataEntities(); strResponse = "User created successfully"; string FName = InterviewDtl.FirstName; string LName = InterviewDtl.LastName; int RecUserid = _userID; string password = Password; var RecuiterEmail = (from a in db.Users where a.Usr_UserID == RecUserid select a.Usr_LoginId).FirstOrDefault(); SendEmailToresetpassword(FName, LName, RecUserid, password, RecuiterEmail); } else if (r == 1) { strResponse = "User already exists"; } else if (r == -1) { strResponse = "Please Fill All Mandatory Fields"; } else if (r == 2) { strResponse = "UserName already Exists"; } else if (r == 3) { strResponse = "Loginid already Exists"; } return(strResponse); }
public InterviewCandidateEntity GetCandidateByICID(int ICID) { InterviewCandidateEntity response = new InterviewCandidateEntity(); using (var db = new EvolutyzCornerDataEntities()) { try { response = (from q in db.InterviewCandidates join d in db.Assessment_For_Position on q.Assessment_For_Positionid equals d.APID where q.ICID == ICID select new InterviewCandidateEntity { ICID = q.ICID, FirstName = q.FirstName, LastName = q.LastName, Email = q.Emailid, MobileNumber = q.MobileNo, Password = q.Password, Assessment_For_Positionid = d.APID, InterviewForPositionname = d.InterviewForPositionname, RecrutementUserid = q.RecrutementUserid, AssignmentDate = q.AssessmentDate.ToString(), AssignmentTime = q.AssessmentTime, APID = d.APID }).FirstOrDefault(); response.IsSuccessful = true; return(response); } catch (Exception ex) { response.IsSuccessful = false; response.Message = "Error Occured in GetCandidateByICID(ICID)"; response.Detail = ex.Message.ToString(); return(response); } } }
public int AddIntCandidate(InterviewCandidateEntity IntCandidateDetails) { int retVal = 0; //User User = new User(); //User UserName = new User(); //User UserName = new User(); int IPID = Convert.ToInt32(IntCandidateDetails.InterviewForPositionname); DateTime date = DateTime.ParseExact(IntCandidateDetails.AssignmentDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); UserSessionInfo info = new UserSessionInfo(); int Userid = info.UserId; using (var db = new DbContext(CONNECTION_NAME)) { try { db.Set <InterviewCandidate>().Add(new InterviewCandidate { FirstName = IntCandidateDetails.FirstName, LastName = IntCandidateDetails.LastName, Emailid = IntCandidateDetails.Email, MobileNo = IntCandidateDetails.MobileNumber, Password = IntCandidateDetails.Password, Assessment_For_Positionid = IPID, RecrutementUserid = Userid, AssessmentDate = date, AssessmentTime = IntCandidateDetails.AssignmentTime, CreatedDate = System.DateTime.Now, CreatedBy = Userid, }); db.SaveChanges(); } catch (Exception ex) { retVal = -1; } } return(retVal); }
public int AddIntCandidate(InterviewCandidateEntity IntCandidateDetails) { var candidateDac = new InterviewCandidateDac(); return(candidateDac.AddIntCandidate(IntCandidateDetails)); }