public ActionResult Edit(AV_Site Site, Workorder wo, List <Workorder> Sectors)
{
//Workorder Site, List<AV_Sector> Sectors
Response res = new Response();
try
{
DataTable Sectorsdt = new DataTable();
// Sectorsdt = Sectors.ToDataTable();
Sectorsdt.Columns.Remove("TestStatus");
Sectorsdt.Columns.Remove("Latitude");
Sectorsdt.Columns.Remove("Longitude");
Sectorsdt.Columns.Remove("isActive");
Sectorsdt.Columns.Remove("sectorColor");
WorkOrderDL dl = new WorkOrderDL();
// dl.Edit(Site, Sectorsdt);
res.Status = "success";
res.Message = "save successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult CheckSiteCode(string filter, string value1)
{
Response res = new Response();
WorkOrderDL woDL = new WorkOrderDL();
//List<string> rec = sb.ToList("By_NetLayer_SiteCode", SiteCode, NetworkModeId, BandId, CarrierId, ScopeId).Select(x => x.SiteCode).ToList();
int count = woDL.SiteCodeExist(filter, value1);
if (count > 0)
{
return(Json(new { message = "Success" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { message = "Error" }, JsonRequestBehavior.AllowGet));
}
public ActionResult FileUpload(HttpPostedFileBase Upload)
{
dbDataTable ddt = new dbDataTable();
DataTable FileRecord = ddt.Tb_AV_Workorder();
try
{
if (Upload != null && Upload.ContentLength > 0)
{
if (Upload.FileName.EndsWith(".csv") || Upload.FileName.EndsWith(".CSV"))
{
Stream stream = Upload.InputStream;
using (CsvReader csvReader =
new CsvReader(new StreamReader(stream), true))
{
FileRecord.Load(csvReader);
}
WorkOrderDL wdl = new WorkOrderDL();
wdl.Insert("MarketSites", FileRecord, ViewBag.UserId, null);
TempData["msg_success"] = "Save successfully.";
}
else
{
TempData["msg_error"] = "Select .csv File";
}
}
else
{
TempData["msg_error"] = "No file selected";
}
}
catch (Exception ex)
{
TempData["msg_error"] = ex.Message;
}
return(RedirectToAction("New"));
}
public WorkOrderRepository(IConfiguration config, DataContext context)
{
_config = config;
_context = context;
_workOrderDL = new WorkOrderDL(_config);
}
