public JsonResult SiteExistOrNot(string SiteCode, string NetworkModeId, string BandId, string CarrierId, string ScopeId) { int i = 0; AV_SitesBL sb = new AV_SitesBL(); List <string> rec = sb.ToList("By_NetLayer_SiteCode", SiteCode, NetworkModeId, BandId, CarrierId, ScopeId).Select(x => x.SiteCode).ToList(); foreach (var item in rec) { if (item == SiteCode) { i = 1; } } if (i == 0) { rec.Clear(); } return(Json(rec, JsonRequestBehavior.AllowGet)); }
public Response UploadFiles() { Response r = new Response(); try { string sPath = ""; sPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Content/AirViewLogs/"); System.Web.HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files; for (int iCnt = 0; iCnt <= hfc.Count - 1; iCnt++) { System.Web.HttpPostedFile hpf = hfc[iCnt]; if (hpf.ContentLength > 0) { DirectoryHandler dh = new DirectoryHandler(); myFile file = new myFile(); string FileText = file.StreamToString(hpf.InputStream); XML xml = new XML(); string asAscii = Encoding.ASCII.GetString( Encoding.Convert(Encoding.UTF8, Encoding.GetEncoding(Encoding.ASCII.EncodingName, new EncoderReplacementFallback(string.Empty), new DecoderExceptionFallback() ), Encoding.UTF8.GetBytes(FileText) ) ); string json = xml.ToJson(FileText); string[] FileName = hpf.FileName.Split('_'); if (FileName.Length > 6) { AV_SitesBL sitb = new AV_SitesBL(); var SiteRecord = sitb.ToList("BySiteCodeWithLayer", FileName[3], null, null, null, null, null).FirstOrDefault(); if (SiteRecord != null) { // var fileList = new DirectoryInfo(sPath + SiteRecord.ClientPrefix + "\\" + FileName[2]).GetFiles("*.xml", SearchOption.AllDirectories); string BAlpha = System.Text.RegularExpressions.Regex.Replace(FileName[5], "[^a-zA-Z]", ""); string BNumaric = System.Text.RegularExpressions.Regex.Replace(FileName[5], "[^0-9]", ""); string Band = (!string.IsNullOrEmpty(BAlpha.Trim())) ? BAlpha.Trim() + " " + BNumaric : BNumaric; //string Band = ""; //if (FileName[3].Equals("LTE")) //{ // Band = FileName[4].Substring(0, 3) + " " + FileName[4].Substring(3, FileName[4].Length - 3); //} //else if (FileName[3].Equals("WCDMA")) //{ // Band = FileName[4].Substring(0, 4) + " " + FileName[4].Substring(4, FileName[4].Length - 4); //} //else if (FileName[3].Equals("GSM")) //{ // Band = FileName[4].Substring(0, 3) + " " + FileName[4].Substring(3, FileName[4].Length - 3); //} string Alpha = System.Text.RegularExpressions.Regex.Replace(FileName[6], "[^a-zA-Z]", ""); string Numaric = System.Text.RegularExpressions.Regex.Replace(FileName[6], "[^0-9]", ""); string Carrier = (!string.IsNullOrEmpty(Alpha.Trim()))? Alpha.Trim() + " " + Numaric:Numaric; sPath = sPath + SiteRecord.ClientPrefix + "\\" + FileName[3] + "\\" + FileName[4] + "_" + Band + "_" + Carrier + "\\"; dh.CreateDirectory(sPath); string[] files = Directory.GetFiles(sPath, "*.xml"); string TempFileName = hpf.FileName.Replace(FileName[6], Carrier); TempFileName = hpf.FileName.Replace(FileName[5], Band); TempFileName = TempFileName.Replace("PSC1900", "PSC 1900"); file.Write(sPath, TempFileName, "json", json); file.Write(sPath, TempFileName, "xml", FileText); // hpf.SaveAs(sPath + Path.GetFileName(hpf.FileName)); r.Status = "success"; r.Message = "files save successfully."; } else { r.Status = "error"; r.Message = "Site not found."; } } else { r.Status = "error"; r.Message = "File name not correct"; } } else { r.Status = "error"; r.Message = "File not found."; } } } catch (Exception ex) { r.Status = "error"; r.Message = ex.Message; } return(r); }
public ActionResult Edit(int Id = 0) { ViewBag.FormType = "Edit"; AV_SitesBL sb = new AV_SitesBL(); AV_Site Site = new AV_Site(); List <AV_Sector> Sectors = new List <AV_Sector>(); sb.SiteWithSectors(Id, ref Site, ref Sectors); ViewBag.Site = Site; Common.SelectedList sl = new Common.SelectedList(); AD_DefinationBL db = new AD_DefinationBL(); ViewBag.NetworkModes = db.SelectedList("NetworkModes", null, "-NetworkMode-"); ViewBag.Bands = db.ToList("Bands"); ViewBag.Carriers = db.ToList("Carriers"); ViewBag.Scopes = sl.Scopes(); ViewBag.Sectors = sl.Sectors(); List <SWI.Libraries.Common.SelectedList> Markets = new List <SelectedList>(); if (ViewBag.IsAdmin) { ViewBag.UserMarkets = db.SelectedList("AllCities"); Markets = ViewBag.UserMarkets; } else { ViewBag.UserMarkets = db.SelectedList("UserCities", Convert.ToString(ViewBag.UserId)); Markets = ViewBag.UserMarkets; } //bands network mode etc dropdowns WorkorderEdit we = new WorkorderEdit(); Sec_UserSettingsDL udl = new Sec_UserSettingsDL(); we.Site = Site; we.Site.StateId = we.Site.State; we.Site.RegionId = we.Site.Region; we.Site.MarketId = we.Site.Market; we.Site.SiteType = we.Site.SiteTypeId; we.Site.SiteClass = we.Site.SiteClassId; we.Bands = ViewBag.Bands; ViewBag.Id = Id; we.Carriers = ViewBag.Carriers; DataTable Table = udl.GetDataTable("UserProjects", Convert.ToString(ViewBag.UserId), null, null); we.Projects = Table.ToList <PM_Projects>(); we.Cities = db.ToList("UserCities", Convert.ToString(ViewBag.UserId)); we.SubCheckList = db.ToList("byDefinationType", "Sub CheckList"); we.NetworkModes = ViewBag.NetworkModes; var hjh = db.MultiSelecet("NetworkModes", null, "-NetworkMode-"); we.NetworkModesm = hjh; we.States = sl.Definations("UserStates", Convert.ToString(ViewBag.UserId), "-State-"); //sl.States(); we.Regions = db.ToList("UserRegions", Convert.ToString(ViewBag.UserId)); // we.Regions = we.Regions.Where(x => x.PDefinationId ==we.State).ToList(); we.UserMarkets = Markets; // we.UserMarkets = we.UserMarkets; //.Where(x=>x.Value==Convert.ToString(we.Region)).ToList(); TSS_SurveyDocumentBL sdb = new TSS_SurveyDocumentBL(); we.Surveys = sdb.ToList("GetAll_byIsActive", true.ToString()); we.Clients = sl.Clients("UserClients", Convert.ToString(ViewBag.UserId)); we.Scopes = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes(); we.SiteTypes = sl.Definations("SiteTypes"); we.SiteClasses = sl.Definations("SiteClasses"); we.CheckList = sl.Definations("byDefinationType", "CheckList", "-CheckList-"); we.Sectors = Sectors; we.Sectors[0].Bands = we.Bands; we.Sectors[0].Carriers = we.Carriers; return(View("Workorder", we)); // return View(Sectors); }