public JsonResult InsertUpdateJobs(Core.Entity.JobEntity model) { string multipleTraining = string.Empty; if (model.multipleTrainings != null && model.multipleTrainings.Count() > 0) { foreach (var item in model.multipleTrainings) { multipleTraining += item + ","; } model.MultipleTrainingsAssignedCommaSeperated = multipleTraining; } int Id = _balService.InsertUpdate(model); var jsonResult = Json(Id, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
public ActionResult UploadExcel(HttpPostedFileBase FileUpload) { List <string> data = new List <string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); string filename = FileUpload.FileName; if (!Directory.Exists(Server.MapPath("~/Doc/"))) { // Try to create the directory. DirectoryInfo di = Directory.CreateDirectory(Server.MapPath("~/Doc/")); } string targetpath = Server.MapPath("~/Doc/"); FileUpload.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; DataTable dtable = GetDataTabletFromCSVFile(pathToExcelFile); foreach (DataRow dr in dtable.Rows) { JobPortal.Core.Entity.JobEntity jobEntity = new Core.Entity.JobEntity(); string region = Convert.ToString(dr["Region Name"]); if (!string.IsNullOrEmpty(region)) { var regiondetail = _bALRegions.GetRegionByName(region); if (regiondetail != null) { jobEntity.RegionId = regiondetail.Id; } } string training = Convert.ToString(dr["TrainingName"]); string multipletrainings = string.Empty; foreach (string item in training.Split(',')) { if (!string.IsNullOrEmpty(item)) { var trainingdetail = _bALTraining.GetTrainingsByName(item); if (trainingdetail != null) { multipletrainings += trainingdetail.ID + ","; } } } jobEntity.MultipleTrainingsAssignedCommaSeperated = multipletrainings.TrimEnd(','); jobEntity.JobTitle = dr["JobTitle"].ToString(); jobEntity.JobDescription = dr["JobDescription"].ToString(); jobEntity.JobNumber = Convert.ToString(dr["JobNumber"]); int Status = 0; switch (Convert.ToString(dr["Status"]).ToLower()) { case "open": Status = 1; break; case "in progress": Status = 2; break; case "completed": Status = 3; break; case "close": Status = 4; break; } jobEntity.Status = Status; _balService.InsertUpdate(jobEntity); } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } return(RedirectToAction("index")); } else { //alert message for invalid file format data.Add("<ul>"); data.Add("<li>Only Excel file format is allowed</li>"); data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } }