public ActionResult UploadProjectPlan(HttpPostedFileBase UploadPlan) { //HttpFileCollectionBase UploadPlans = Request.Files; //HttpPostedFileBase UploadPlan = null; //if (UploadPlans.Count > 0) //{ // UploadPlan = UploadPlans[0]; // //var tst = Request.Form["UploadPlan"]; //} dbDataTable ddt = new dbDataTable(); DataTable FileRecord = ddt.Tb_ImportProjectPlant(); dbDataTable dbdt = new dbDataTable(); DataTable dtPlan = new DataTable(); PM_ImportProjectPlanDL dd = new PM_ImportProjectPlanDL(); var model = new List <PM_ImportProjectPlan>(); try { if (UploadPlan != null && UploadPlan.ContentLength > 0) { if (UploadPlan.FileName.EndsWith(".csv") || UploadPlan.FileName.EndsWith(".CSV")) { Stream stream = UploadPlan.InputStream; using (CsvReader csvPlanReader = new CsvReader(new StreamReader(stream), true)) { FileRecord.Load(csvPlanReader); } List <PM_ImportProjectPlan> plan = FileRecord.ToList <PM_ImportProjectPlan>(); DataTable dt = dbdt.PM_ImportList(); foreach (var p in plan) { myDataTable.AddRow(dt, "Value1", p.FACode, "Value2", p.Milestone, "Value3", p.Stage, "Value4", p.Plan, "Value5", p.Forecast, "Value6", p.Target, "Value7", p.Actual, "Value8", p.Status //, "Value9", p.OldPlan, "Value10", p.OldForecast, "Value11", p.OldTarget, "Value12", p.OldActual, "Value13", p.OldStatus ); } dtPlan = dd.GetDataTable("Import_Project_Plan", "0", dt); model = dtPlan.ToList <PM_ImportProjectPlan>(); } else { TempData["msg_error"] = "Select .csv File"; } } else { TempData["msg_error"] = "No file selected"; } } catch (Exception ex) { TempData["msg_error"] = ex.Message; } return(PartialView("~/Areas/Project/Views/ImportProjectPlan/_ProjectPlan.cshtml", model)); }
public ActionResult SaveUploadPlan() { var FACode = Request["FACode"].Split(','); var Milestone = Request["Milestone"].Split(','); var Stage = Request["Stage"].Split(','); var Plan = Request["item.Plan"].Split(','); var Forecast = Request["item.Forecast"].Split(','); var Target = Request["item.Target"].Split(','); var Actual = Request["item.Actual"].Split(','); var Status = Request["Status"].Split(','); dbDataTable ddt = new dbDataTable(); //DataTable dtRecord = ddt.Tb_ImportProjectPlant(); //DataTable dtPlan = new DataTable(); PM_ImportProjectPlanDL dd = new PM_ImportProjectPlanDL(); try { // List<PM_ImportProjectPlan> plan = dtRecord.ToList<PM_ImportProjectPlan>(); DataTable dt = ddt.PM_ImportList(); for (int i = 0; i < FACode.Length; i++) { myDataTable.AddRow(dt, "Value1", FACode[i], "Value2", Milestone[i], "Value3", Stage[i], "Value4", Plan[i], "Value5", Forecast[i], "Value6", Target[i], "Value7", Actual[i], "Value8", Status[i]); } var _Flag = dd.Manage("Save_Project_Plan", "20021", dt); if (_Flag) { TempData["msg_success"] = "Save successfully."; } } catch (Exception ex) { TempData["msg_error"] = ex.Message; } return(View("~/Areas/Project/Views/ImportProjectPlan/Index.cshtml")); }