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);
}
