public ActionResult List(string value1, string value2, string value3)
{
WorkOrderBL wob = new WorkOrderBL();
var dt = wob.Search(value1, value2, value3);
return(PartialView("~/Views/WorkOrder/_List.cshtml", dt));
}
public JsonResult SiteWithSectors(Int64 Id)
{
WorkOrderBL wb = new WorkOrderBL();
var rec = wb.GetWO(Id.ToString());
return(Json(rec, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Gets all work orders.
/// </summary>
/// <returns>
/// Get All WorkOrders
/// </returns>
public IEnumerable <WorkOrderEntity> GetAllWorkOrders()
{
IList <WorkOrderEntity> result = new List <WorkOrderEntity>();
IWorkOrderBL workOrderBL = new WorkOrderBL();
List <WorkOrder> workOrderList = workOrderBL.GetAllWorkOrder();
foreach (WorkOrder source in workOrderList)
{
WorkOrderEntity target = new WorkOrderEntity();
target.WorkOrderID = source.WorkOrderID;
target.Product = source.Product;
target.OrderQuantity = source.OrderQty;
target.DueDate = source.DueDate;
result.Add(target);
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
WorkOrderModel workOrder = new WorkOrderModel();
workOrder.CurrentStatus = txtStatus.Value;
workOrder.Notes = txtNotes.Value;
workOrder.WorkOrderID = int.Parse(txtWorkOrderID.Value);
if (DateTime.TryParse(txtPromiseDate.Value, out DateTime promise))
{
workOrder.PromiseDate = promise;
}
WorkOrderBL workOrderBL = new WorkOrderBL();
workOrderBL.UpdateWorkOrder(workOrder);
Response.Redirect("WorkOrders.aspx");
}
protected void LoadData()
{
DataTable workInfo = new WorkOrderBL().GetWorkOrder(int.Parse(Request.QueryString["WorkOrderID"]));
if (workInfo.Rows.Count > 0)
{
DataTable mainInfo = new MaintenceBL().GetMaintenceRequest(int.Parse(workInfo.Rows[0]["MaintenceRequestID"].ToString()));
txtWorkOrderID.Value = workInfo.Rows[0]["WorkOrderID"].ToString();
txtRequestID.Value = workInfo.Rows[0]["MaintenceRequestID"].ToString();
txtNotes.Value = workInfo.Rows[0]["Notes"].ToString();
txtPromiseDate.Value = workInfo.Rows[0]["PromiseDate"].ToString();
txtStatus.Value = workInfo.Rows[0]["CurrentStatus"].ToString();
txtIssue.Value = mainInfo.Rows[0]["RequestDetails"].ToString();
txtUnitID.Value = mainInfo.Rows[0]["UnitID"].ToString();
}
}
protected void btnCreateOrder_Click(object sender, EventArgs e)
{
WorkOrderModel workOrder = new WorkOrderModel();
workOrder.Notes = txtNotes.Value;
workOrder.ApprovedBy = Sess.Person.UserID;
workOrder.ApprovedDate = DateTime.Now;
workOrder.MaintenceRequestID = int.Parse(Request.QueryString["requestID"]);
workOrder.CurrentStatus = "Not Started";
if (DateTime.TryParse(txtPromise.Value, out DateTime promise))
{
workOrder.PromiseDate = promise;
}
WorkOrderBL orderBL = new WorkOrderBL();
orderBL.CreateWorkOrder(workOrder);
Response.Redirect("~/Work Orders/workorders.aspx");
}
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));
}
