public ActionResult RegisteredApplicants(string FromDate, string ToDate) { DreamJobsBAL DJBAL = new DreamJobsBAL(); List <Registration> lstReg = DJBAL.GetRegistrations(FromDate, ToDate); return(View(lstReg)); }
public ActionResult RegisteredApplicants() { DreamJobsBAL DJBAL = new DreamJobsBAL(); List <Registration> lstReg = DJBAL.GetRegistrations("", ""); return(View(lstReg)); }
public JsonResult GetQuestionSetForApplicant(int?ApplicantID) { ApplicantExamAttempt d; using (var usersContext = new UsersContext()) { d = usersContext.GetApplicantExamAttempts(ApplicantID); } DreamJobsBAL DJBAL = new DreamJobsBAL(); ApplicantExamVM _ApplicantExamVM = DJBAL.GetQuestionSetForApplicant(new ApplicantExamVM { ApplicantAttempt = new ApplicantExamAttempt { AttemptID = d == null ? 0 : d.AttemptID, Applicant = new Applicant { ApplicantID = ApplicantID } } }); string strPartialView = RenderPartialToStringExtensions.RenderPartialToString(this.ControllerContext, "_PartialQuestions", _ApplicantExamVM); if (_ApplicantExamVM.ApplicantAttempt == null) { return(Json(new JsonReurnData { ReturnStatus = 0, ReturnMessage = "No question set available for you at this moment!", ReturnData = strPartialView }, JsonRequestBehavior.AllowGet)); } return(Json(new JsonReurnData { ReturnStatus = 1, ReturnMessage = "", ReturnData = strPartialView }, JsonRequestBehavior.AllowGet)); }
public ActionResult AppliedJob() { DreamJobsBAL DJBAL = new DreamJobsBAL(); List <Registration> lstReg = DJBAL.GetRegistrations("", "", User.Identity.Name); return(View(lstReg)); }
public ActionResult GetJobType() { DreamJobsBAL DJBAL = new DreamJobsBAL(); List <Jobs> lstSM = DJBAL.fillDropDown("Jobs", "1", "").Tables[0].AsEnumerable().Select(d => new Jobs { JobID = (int)d["JobID"], JobTitle = Convert.ToString(d["JobTitle"]) }).ToList(); string ddlHtml = "<option value='0'>-Select Job Type-</option>"; ddlHtml += string.Join("", lstSM.Select(t => string.Format("<option value='{0}'>{1}</option>", t.JobID, t.JobTitle))); return(Json(ddlHtml, JsonRequestBehavior.AllowGet)); }
public ActionResult Upload(HttpPostedFileBase upload, FormCollection frm) { string JobID; JobID = frm["CampaignType"]; //ProfileID = frm["ProfileType"]; //return View(); //http://techbrij.com/read-excel-xls-xlsx-asp-net-mvc-upload if (ModelState.IsValid) { if (string.IsNullOrEmpty(JobID) || JobID == "0") { ModelState.AddModelError("File", "Please select Job Type"); } else { if (upload != null && upload.ContentLength > 0) { // ExcelDataReader works with the binary Excel file, so it needs a FileStream // to get started. This is how we avoid dependencies on ACE or Interop: Stream stream = upload.InputStream; // We return the interface, so that IExcelDataReader reader = null; if (upload.FileName.EndsWith(".xls")) { reader = ExcelReaderFactory.CreateBinaryReader(stream); } else if (upload.FileName.EndsWith(".xlsx")) { reader = ExcelReaderFactory.CreateOpenXmlReader(stream); } else { ModelState.AddModelError("File", "This file format is not supported"); return(View()); } reader.IsFirstRowAsColumnNames = true; DataSet result = reader.AsDataSet(); reader.Close(); DataSet ds = new DataSet(); ds.Tables.Add(result.Tables[0].Copy()); ds.Tables[0].TableName = "QSet"; string xmlCustomers = ds.GetXml(); DreamJobsBAL DJBAL = new DreamJobsBAL(); ViewBag.Data = result.Tables[0].Copy(); ds = new DataSet(); ds = DJBAL.uploadExccel(upload.FileName, xmlCustomers, User.Identity.Name, Convert.ToInt32(JobID)); if (ds != null) { if (ds.Tables.Count > 0) { ViewBag.Message = ds.Tables[0].Rows[0][1].ToString(); } } //return View(result.Tables[0]); return(View(ViewBag.Data)); } else { ModelState.AddModelError("File", "Please Upload Your file"); } } } return(View()); }
public ActionResult SubmitPaper(FormCollection form, string IsSubmit = "1") { DataTable dtSummary = new DataTable(); dtSummary.TableName = "ExamSummary"; dtSummary.Columns.Add("IsSubmit"); dtSummary.Columns.Add("IpAddress"); DataRow sDrow = dtSummary.NewRow(); sDrow["IsSubmit"] = IsSubmit; sDrow["IpAddress"] = System.Web.HttpContext.Current.Request.UserHostAddress; dtSummary.Rows.Add(sDrow); //if (Request.IsAjaxRequest()) //{ // return Json(new ReturnStatus { ErrorStatus = 0, ErrorMessage = "Success" }, JsonRequestBehavior.AllowGet); //} try { if (ModelState.IsValid) { ViewBag.ErrorMessage = "You're already registered!"; //return View("RegistrationSuccess", ViewBag.ErrorMessage); // TODO: Add insert logic here int count = form.Keys.Count; List <ApplicantAnswer> kv = new List <ApplicantAnswer>(); string[] strKv; foreach (string key in form.Keys) { if (key.StartsWith("_")) { continue; } strKv = form[key].Split(new char[] { '_' }); if (strKv.Length > 1) { kv.Add(new ApplicantAnswer { AttemptID = Convert.ToInt64(form["ApplicantAttempt.AttemptID"]), QuestionID = Convert.ToInt64(strKv[1]), AnswerByApplicant = strKv[2] }); } } DataTable dt = new DJ_Utilities.ListtoDataTableConverter().ToDataTable(kv); DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables[0].TableName = "ExamAttempt"; ds.Tables.Add(dtSummary); string strXml = ds.GetXml(); DreamJobsBAL DJBAL = new DreamJobsBAL(); DataSet dsResult = DJBAL.SubmitPaper(strXml); if (Request.IsAjaxRequest()) { return(Json(new ReturnStatus { ErrorStatus = 0, ErrorMessage = "Answersheet saved successfully as draft" }, JsonRequestBehavior.AllowGet)); } return(View("Result")); } return(View()); } catch { if (Request.IsAjaxRequest()) { return(Json(new ReturnStatus { ErrorStatus = 1, ErrorMessage = "Error in saving draft" }, JsonRequestBehavior.AllowGet)); } return(View()); } }