public ActionResult NewFiles() { Response res = new Response(); var wolt = TempData["clusters"] as List <Workorder>; var wo = TempData["SiteCluster"].ToString(); var wo2 = wo.Split(','); try { HttpFileCollectionBase files = HttpContext.Request.Files; var wolst = HttpContext.Request["mydata"]; for (int i = 0; i < files.Count; i++) { #region File Save string Path = "/Content/AirViewLogs/" + wo2[2] + "/" + wolt[i].clusterId; HttpPostedFileBase file = HttpContext.Request.Files[i] as HttpPostedFileBase; if (!Directory.Exists(HttpContext.Server.MapPath("~" + Path))) { // if it doesn't exist, create System.IO.Directory.CreateDirectory(HttpContext.Server.MapPath("~" + Path)); } string fname = HttpContext.Server.MapPath("~" + Path + "/" + wolt[i].clusterName + "_" + wolt[i].networkmodename); HttpContext.Request.Files[i].SaveAs(fname + ".csv"); #endregion #region site count List <CSVParser> values = System.IO.File.ReadAllLines(fname + ".csv") .Skip(1) .Select(v => CSVParser.FromCsv(v)).Distinct() .ToList(); List <string> a = new List <string>(); foreach (var item in values) { a.Add(item.siteCode); } // a = new List<string>(); //// Int64 SiteCount = 0; // Stream stream = files[i].InputStream; // DataTable sitesTable = new DataTable(); // using (CsvReader csvReader = // new CsvReader(new StreamReader(stream), true)) // { // sitesTable.Load(csvReader); // } // DataView view = new DataView(sitesTable); // DataTable tblsectors = view.ToTable(true, new string[] { "clusterCode", "siteCode" }); // if (tblsectors.Rows.Count > 0) // { // for (int j = 0; j < tblsectors.Rows.Count; j++) // { // DataRow crow = tblsectors.Rows[j]; // string abc = crow["siteCode"].ToString(); // a.Add(abc); // } // a = a.Distinct().ToList(); // } WorkOrderBL wb = new WorkOrderBL(); wb.Insert("InsertSiteCount", a.Distinct().ToList().Count, Path + "/" + wolt[i].clusterName + "_" + wolt[i].networkmodename + ".csv"); #endregion } res.Status = "success"; res.Message = "save successfully"; } catch (Exception ex) { res.Status = "danger"; res.Message = ex.Message; } return(RedirectToAction("New")); }
public ActionResult New(Workorder wo, List <Workorder> wolst, List <AV_TSSCheckList> tss, long SiteTypeIds = 0, long SiteClassIds = 0, long ProjectIds = 0, string Clonetype = "") { Response res = new Response(); try { if (Clonetype == "Clone") { wo.SiteTypeId = SiteTypeIds.ToString(); wo.SiteClassId = SiteClassIds; wo.ProjectId = ProjectIds; } if (wo.SiteId != 0) { wo.SiteTypeId = SiteTypeIds.ToString(); wo.SiteClassId = SiteClassIds; wo.ProjectId = ProjectIds; } ClientsBL ub = new ClientsBL(); var ClientPrefix = ub.ToList("AllRecords").Where(x => x.ClientId == Convert.ToDecimal(wo.Client)).FirstOrDefault().ClientPrefix; wolst[0].ClientPrefix = ClientPrefix; Common.SelectedList sl = new Common.SelectedList(); var obj = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes(); TempData["clusters"] = wolst; TempData["SiteCluster"] = wo.siteCode + "," + wo.clusterCode + "," + ClientPrefix; foreach (var df in obj) { if (wo.Scope == df.Value && df.Text == "TSS" || wo.Scope == df.Value && df.Text == "CLS") { foreach (var item in wolst) { item.VerticalBeamWidth = "0"; item.RFHeight = 0; item.MTilt = 0; item.ETilt = 0; item.BandWidth = "0"; item.SectorLatitude = 0; item.SectorLongitude = 0; item.CellId = "0"; item.MRBTS = "0"; } } } WorkOrderBL wb = new WorkOrderBL(); if (wolst.Count > 0 && wolst[0].clusterId != null) { var fname = wo.siteCode + "," + wo.clusterCode; if (wo.SiteId == 0) { wb.Insert("NewWorkOrder", wo, wolst, ViewBag.UserId, null, fname); } else { wb.ChangeFolderName(wo, wolst); wb.Insert("Edit_Work_Order", wo, wolst, ViewBag.UserId, null, fname); } } else { if (wo.SiteId == 0) { wb.Insert("NewWorkOrder", wo, wolst, ViewBag.UserId, null); } else { wb.ChangeFolderName(wo, wolst); wb.Insert("Edit_Work_Order", wo, wolst, ViewBag.UserId, null); } } res.Status = "success"; res.Message = "save successfully"; } catch (Exception ex) { res.Status = "danger"; res.Message = ex.Message; } return(Json(new { response = res }, JsonRequestBehavior.AllowGet)); }