public void setValues(WorkOrder s) { data = s; latitude.text = "" + Mathf.Round(s.latitude * 10000f) / 10000f; longitude.text = "" + Mathf.Round(s.longitude * 10000f) / 10000f; hours.text = "" + s.duration.Hours; minutes.text = "" + s.duration.Minutes; switch ((Data.ResourceNames)s.enumType) { case Data.ResourceNames.Clay: res.sprite = clay; break; case Data.ResourceNames.Ore: res.sprite = iron; break; case Data.ResourceNames.Stone: res.sprite = stone; break; case Data.ResourceNames.Wood: res.sprite = wood; break; } }
public void Relational_Store_Inserts_record_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var newWorkOrder = new WorkOrder { Description = "Take out the Trash" }; WorkOrderStore.Add(newWorkOrder); var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault(); Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.WorkOrderId == 1); }
public void Relational_Store_Inserts_range_of_records_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var myBatch = new List<WorkOrder>(); int qtyToAdd = 10; for (int i = 1; i <= qtyToAdd; i++) { var newWorkOrder = new WorkOrder { Description = "Replace Lightbulbs " + i }; myBatch.Add(newWorkOrder); } WorkOrderStore.Add(myBatch); var workOrders = WorkOrderStore.TryLoadData(); Assert.IsTrue(workOrders.Count == qtyToAdd); }
// PUT api/awbuildversion/5 public void Put(WorkOrder value) { var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault(); if (GetActionType.Key != null) { if (GetActionType.Value.ToList()[0].Equals("DELETE")) adventureWorks_BC.WorkOrderDelete(value); if (GetActionType.Value.ToList()[0].Equals("UPDATE")) adventureWorks_BC.WorkOrderUpdate(value); } }
public List <DTOWorkOrder> Add(WorkOrder workOrder) { foreach (Product_WorkOrder item in workOrder.Product_WorkOrder) { foreach (Product product in listProduct) { if (product.ID == item.ProductID) { product.Stock = product.Stock - item.Used; } } } return(MapperWorkOrder.ToDToList(repWorkOrder.Add(workOrder))); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrder workOrder = db.WorkOrders.Find(id); if (workOrder == null) { return(HttpNotFound()); } string query = $@"SELECT C.LT, S.SampleId, S.Sequence, SUM(T.BasePrice + T.MaterialsCost + T.WageEstimate) AS Cost FROM Work_Order WO INNER JOIN Compound C ON C.OrderId = WO.OrderId INNER JOIN Sample S ON S.CompoundId = C.CompoundId INNER JOIN Sample_Test ST ON S.SampleId = ST.SampleId INNER JOIN Test T ON T.TestId = ST.TestId WHERE WO.OrderId = {workOrder.OrderId} GROUP BY S.SampleId, C.LT, S.Sequence"; var sampleTotalCostList = db.Database.SqlQuery <SampleCost>(query).ToList <SampleCost>(); ViewBag.SampleCosts = sampleTotalCostList; var chargesList = db.Charges.SqlQuery("SELECT * FROM Charge WHERE OrderId = " + workOrder.OrderId).ToList <Charge>(); ViewBag.Charges = chargesList; decimal amountDue = 0; foreach (var item in sampleTotalCostList) { amountDue += item.Cost; } foreach (var item in chargesList) { amountDue += item.Cost; } ViewBag.AmountDue = amountDue; var associatedCompounds = db.Compounds.SqlQuery("SELECT * FROM Compound WHERE OrderId = " + id).ToList <Compound>(); workOrder.Compounds = associatedCompounds; return(View(workOrder)); }
public async Task <ActionResult <WorkOrderViewModel> > DeleteWorkOrder(int id) { WorkOrder workOrder = await _workOrdersRepository.FindByIdAsync(id); if (workOrder == null) { return(NotFound($"No se pudo eliminar la orden de trabjo con código { id }. Verifique la existencia de esta.")); } _workOrdersRepository.Delete(workOrder); await _unitWork.SaveAsync(); return(_mapper.Map <WorkOrderViewModel>(workOrder)); }
public ActionResult Create([Bind(Include = "OrderNumber,OrderTypeID,CustomerID,QuoteDate,OrderDate,StatusID,Comments")] WorkOrder workOrder) { if (ModelState.IsValid) { db.WorkOrders.Add(workOrder); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "FirstName", workOrder.CustomerID); ViewBag.StatusID = new SelectList(db.OrderStatus, "StatusID", "Status", workOrder.StatusID); ViewBag.OrderTypeID = new SelectList(db.OrderTypes, "OrderTypeID", "OrderTypeDesc", workOrder.OrderTypeID); return(View(workOrder)); }
public void SeEmployer_Create_workorder() { //Arrange Employer _emp = frb.CloneEmployer(); WorkOrder _wo = frb.CloneWorkOrder(); _wo.statusID = frb.ToLookupCache().getByKeys(LCategory.orderstatus, LOrderStatus.Pending); // start work order off as pending //Act ui.employerCreate(_emp); ui.workOrderCreate(_emp, _wo); //Assert ui.workOrderValidate(_wo); }
public static void Initialize(WorkOrderContext context) { context.Database.EnsureCreated(); if (context.WorkOrders.Any()) { return; } var workorders = new WorkOrder[] { new WorkOrder { WorkOrderID = 1 , WorkOrderType = "Install" , PropertyInfo = "Trevors House" , SchedulingManager = "Trevor Carter" , TechInfo = "Mickey Mouse" , CurrentStatus = "Complete" , ProposedDate = DateTime.Parse("2010-10-02") , ScheduledDate = DateTime.Parse("2013-01-04") }, new WorkOrder { WorkOrderID = 2 , WorkOrderType = "Review" , PropertyInfo = "Conservice" , SchedulingManager = "Tom Brady" , TechInfo = "Josh Groban" , CurrentStatus = "Eternal Work Order" , ProposedDate = DateTime.Parse("1960-10-07") , ScheduledDate = DateTime.Parse("2017-01-05") }, new WorkOrder { WorkOrderID = 3 , WorkOrderType = "New System" , PropertyInfo = "White House" , SchedulingManager = "George Washington" , TechInfo = "Donald Trump" , CurrentStatus = "Patriotic" , ProposedDate = DateTime.Parse("1776-07-04") , ScheduledDate = DateTime.Parse("2018-08-24") } }; foreach (WorkOrder w in workorders) { context.WorkOrders.Add(w); } context.SaveChanges(); }
public ActionResult PlaceOrder([Bind(Include = "OrderID,AgentID,CustomerID,TestTubeID,PaymentInfo,Comments,DiscountApplied,Deposit")] WorkOrder workOrder) { if (ModelState.IsValid) { workOrder.CustomerID = currentCustID; db.WorkOrders.Add(workOrder); db.SaveChanges(); return(RedirectToAction("SampleForm", new { OrderID = workOrder.OrderID })); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustName", workOrder.CustomerID); ViewBag.AgentID = new SelectList(db.SalesAgents, "AgentID", "AgentName", workOrder.AgentID); return(View()); }
public ActionResult Edit([Bind(Include = "WorkOrderID,BillID,UserID,StatusID,StartTime,EndTime,EarlyDate,DueDate,Description,PriorityID,TotalQuote,ActualPrice,AdvanceAmtPaid,ConfirmationDate")] WorkOrder workOrder) { if (ModelState.IsValid) { db.Entry(workOrder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BillID = new SelectList(db.BillDetails, "BillID", "BillFirstName", workOrder.BillID); ViewBag.PriorityID = new SelectList(db.Priorities, "PriorityID", "Description", workOrder.PriorityID); ViewBag.StatusID = new SelectList(db.Status, "StatusID", "StatusDescription", workOrder.StatusID); ViewBag.UserID = new SelectList(db.Users, "UserID", "UserFirstName", workOrder.UserID); return(View(workOrder)); }
public IHttpActionResult DeleteWorkOrder(int id) { WorkOrder workOrder = db.WorkOrders.FirstOrDefault(wo => wo.Property.UserId == User.Identity.Name); if (workOrder == null) { return(NotFound()); } db.WorkOrders.Remove(workOrder); db.SaveChanges(); return(Ok(workOrder)); }
public void Relational_Store_Updates_record_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var newWorkOrder = new WorkOrder { Description = "Snake toilet" }; WorkOrderStore.Add(newWorkOrder); // Now go fetch the record again and update: string newValue = "Update: Call Roto-Rooter"; var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault(); foundWorkOrder.Description = newValue; WorkOrderStore.Update(foundWorkOrder); foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault(); Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.Description == newValue); }
public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrder workOrder = await _applicationDbContext.WorkOrders.FindAsync(id); if (workOrder == null) { return(HttpNotFound()); } return(View(workOrder)); }
public string[] InsertWorkOrder(int typeRequest, int userId) { var workOrder = new WorkOrder { idTypeRequest = typeRequest, secureCode = GenerateSecureCode(), idProjectStatus = 1, idUser = userId }; DbContext.WorkOrders.Add(workOrder); DbContext.SaveChanges(); return(new[] { workOrder.uniqueId.ToString(), workOrder.secureCode }); }
private static JobStatusUpdate CreateJobStatusUpdateRequest (WorkOrder workOrder, Generated.JobStatusUpdateTypeCode jobStatus) { return(new JobStatusUpdate { RelatedWorkOrder = workOrder, TypeCode = jobStatus, MoreSpecificSORCode = new WorkElement { Trade = new List <Trade>(), RateScheduleItem = new List <RateScheduleItem>() } }); }
private async Task <order> CreateOrder(WorkOrder workOrder) { var property = workOrder.Site?.PropertyClass.FirstOrDefault(); var locationAlerts = property != null ? (await _alertsGateway.GetLocationAlertsAsync(property.PropertyReference)).Alerts : new List <Alert>(); var tenureInfo = await _tenureInformationUseCase.GetTenureInformationWithPropertyReference(property?.PropertyReference); var personAlerts = tenureInfo != null ? (await _alertsGateway.GetPersonAlertsAsync(tenureInfo.TenancyAgreementReference)).Alerts : new List <Alert>(); var uniqueCodes = locationAlerts?.Union(personAlerts); var orderComments = @$ "{uniqueCodes.ToCodeString()} {workOrder.DescriptionOfWork}".Truncate(250); var orderCommentsExtended = ($"Property Alerts {locationAlerts?.ToCommentsExtendedString()} " + $"Person Alerts {personAlerts?.ToCommentsExtendedString()}").Truncate(250); var priorityCharacter = workOrder.WorkPriority.PriorityCode.HasValue ? await _sorPriorityGateway.GetLegacyPriorityCode(workOrder.WorkPriority.PriorityCode.Value) : " "; var phoneNumber = workOrder.Customer.Person.Communication.GetPhoneNumber(); return(new order { status = orderStatus.PLANNED, primaryOrderNumber = workOrder.Id.ToString(CultureInfo.InvariantCulture), orderComments = orderComments, contract = workOrder.AssignedToPrimary.ContractorReference, locationID = workOrder.Site?.PropertyClass.FirstOrDefault()?.PropertyReference, priority = priorityCharacter, targetDate = workOrder.WorkPriority.RequiredCompletionDateTime.HasValue ? DrsHelpers.ConvertToDrsTimeZone(workOrder.WorkPriority.RequiredCompletionDateTime.Value) : DateTime.UtcNow, userId = workOrder.AgentEmail ?? workOrder.AgentName, contactName = workOrder.Customer.Name, phone = phoneNumber, orderCommentsExtended = orderCommentsExtended, theLocation = new location { locationId = workOrder.Site?.PropertyClass.FirstOrDefault()?.PropertyReference, name = workOrder.Site?.Name, address1 = workOrder.Site?.PropertyClass.FirstOrDefault()?.Address.AddressLine, postCode = workOrder.Site?.PropertyClass.FirstOrDefault()?.Address.PostalCode, contract = workOrder.AssignedToPrimary.ContractorReference, citizensName = workOrder.Customer.Name }, theBookingCodes = await BuildBookingCodes(workOrder), message = phoneNumber != null && Regex.IsMatch(phoneNumber, @"^(07\d{8,12}|447\d{7,11})$") }); }
public ActionResult CreateOrder([Bind(Include = "WrkOrderID,DueDate,RushOrder,Comments,ClientID")] WorkOrder workOrder) { if (ModelState.IsValid) { db.WorkOrders.Add(workOrder); db.SaveChanges(); int?OldId = workOrder.ClientID; return(RedirectToAction("ViewOrders", new { id = OldId })); } return(View(workOrder)); }
public IHttpActionResult PostWorkOrder(WorkOrderModel workOrder) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var dbWorkOrder = new WorkOrder(workOrder); db.WorkOrders.Add(dbWorkOrder); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = dbWorkOrder.WorkOrderId }, Mapper.Map <WorkOrderModel>(workOrder))); }
public IHttpActionResult DeleteWorkOrder(int id) { WorkOrder workOrder = db.WorkOrders.Find(id); if (workOrder == null) { return(NotFound()); } db.WorkOrders.Remove(workOrder); db.SaveChanges(); return(Ok(Mapper.Map <WorkOrderModel>(workOrder))); }
public ActionResult WorkOrderEdit([Bind(Include = "WrkOrdID,ReceivedDate,DueDate,RushedOrder,Comments,WOReport,ReceivedBy,ClientID,SummaryStatus")] WorkOrder workOrder) { ViewBag.Clients = db.Clients.ToList(); ViewBag.Summary = testStatus; ViewBag.Employees = db.Employees.ToList(); if (ModelState.IsValid) { db.Entry(workOrder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("WorkIndex")); } return(View(workOrder)); }
public async Task <IActionResult> Create([Bind("WorkOrderId,WorkOrderDate,OwnerId")] WorkOrder workOrder) { if (ModelState.IsValid) { workOrder.WorkOrderDate = DateTime.Now; _context.Add(workOrder); await _context.SaveChangesAsync(); return(Redirect("/home/processing")); } ViewData["OwnerId"] = new SelectList(_context.Owners, "OwnerId", "OwnerId", workOrder.OwnerId); return(View(workOrder)); }
public async Task <WorkOrderAdapterModel> GetAsync(int id) { WorkOrder item = await context.WorkOrder .Include(x => x.CategoryMain) .Include(x => x.CategorySub) .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); WorkOrderAdapterModel result = Mapper.Map <WorkOrderAdapterModel>(item); await OhterDependencyData(result); return(result); }
public ActionResult DownloadTestResult(int LTNum) { if (Authorized.userAuth == "technician") { WorkOrder workOrder = db.WorkOrders.Find(LTNum); Response.AppendHeader("content-disposition", "attachment; filename=" + LTNum + "TestResults.txt"); //this will download the file return(File(workOrder.TestResultFile, "plain/text")); } else { return(RedirectToAction("NotAuthorized", "Home")); } }
private async Task SetStatus(WorkOrder workOrder) { var user = _currentUserService.GetUser(); var authorised = await _authorizationService.AuthorizeAsync(user, workOrder, "RaiseSpendLimit"); if (await _featureManager.IsEnabledAsync(FeatureFlags.SpendLimits) && !authorised.Succeeded) { workOrder.StatusCode = WorkStatusCode.PendingApproval; } else { workOrder.StatusCode = WorkStatusCode.Open; } }
private async Task <WorkOrderOpened> NotifyHandlers(WorkOrder workOrder) { if (workOrder.StatusCode != WorkStatusCode.Open) { await _notifier.Notify(new HighCostWorkOrderCreated(workOrder)); return(null); } var notification = new WorkOrderOpened(workOrder); await _notifier.Notify(notification); return(notification); }
public void MapEFToBOList() { var mapper = new DALWorkOrderMapper(); WorkOrder entity = new WorkOrder(); entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1, 1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1); List <BOWorkOrder> response = mapper.MapEFToBO(new List <WorkOrder>() { entity }); response.Count.Should().Be(1); }
public ActionResult Edit([Bind(Include = "WorkOrderID,OrderCompleteDate,OrderFinalPrice,OrderDueDate,CustomerID,DiscountID,EmployeeID,QuoteID")] WorkOrder workOrder) { if (ModelState.IsValid) { db.Entry(workOrder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "FirstName", workOrder.CustomerID); ViewBag.DiscountID = new SelectList(db.Discounts, "DiscountID", "DiscountID", workOrder.DiscountID); ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "FirstName", workOrder.EmployeeID); ViewBag.QuoteID = new SelectList(db.Quotes, "QuoteID", "QuoteID", workOrder.QuoteID); return(View(workOrder)); }
public async Task <ActionResult> Edit([Bind(Include = "WorkOrderId,CustomerId,OrderDateTime,TargetDateTime,DropDeadDateTime,Description,WorkOrderStatus,Total,CertificationRequirements,CurrentWorkerId")] WorkOrder workOrder) { if (ModelState.IsValid) { workOrder.CurrentWorkerId = User.Identity.GetUserId(); _applicationDbContext.Entry(workOrder).State = EntityState.Modified; await _applicationDbContext.SaveChangesAsync(); return(RedirectToAction("Index")); } //ViewBag.CurrentWorkerId = new SelectList(_applicationDbContext.ApplicationUsers, "Id", "FirstName", workOrder.CurrentWorkerId); ViewBag.CustomerId = new SelectList(_applicationDbContext.Customers, "CustomerId", "AccountNumber", workOrder.CustomerId); return(View(workOrder)); }
public static void LinkKeypartDataloader(MESStationBase Station, MESStationInput Input, List <R_Station_Action_Para> Paras) { if (Paras.Count != 3) { string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000057"); throw new MESReturnMessage(errMsg); } string Sn = Input.Value.ToString(); MESStationSession WOSession = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY); if (WOSession == null) { WOSession = new MESStationSession() { MESDataType = Paras[0].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[0].SESSION_KEY, ResetInput = Input }; Station.StationSession.Add(WOSession); } MESStationSession SubKPSession = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY); if (SubKPSession == null) { SubKPSession = new MESStationSession() { MESDataType = Paras[1].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[1].SESSION_KEY, ResetInput = Input }; Station.StationSession.Add(SubKPSession); } MESStationSession MainKPSession = Station.StationSession.Find(t => t.MESDataType == Paras[2].SESSION_TYPE && t.SessionKey == Paras[2].SESSION_KEY); if (MainKPSession == null) { MainKPSession = new MESStationSession() { MESDataType = Paras[2].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[2].SESSION_KEY, ResetInput = Input }; Station.StationSession.Add(MainKPSession); } SN sn = null; WorkOrder wo = null; T_C_KEYPART tck = new T_C_KEYPART(Station.SFCDB, DB_TYPE_ENUM.Oracle); sn.Load(Sn, Station.SFCDB, DB_TYPE_ENUM.Oracle); wo.Init(sn.WorkorderNo, Station.SFCDB, DB_TYPE_ENUM.Oracle); List <C_KEYPART> keyparts = tck.GetKeypartListByWOAndStation(Station.SFCDB, wo.WorkorderNo, Station.StationName); SubKPSession.Value = keyparts.Where(s => s.SEQ_NO == 10).ToList(); MainKPSession.Value = keyparts.Where(s => s.SEQ_NO != 10).ToList().OrderBy(s => s.SEQ_NO); }
public static IncidentWorkOrderDomain ToDomainModel(this WorkOrder obj) { return(obj == null ? null : new IncidentWorkOrderDomain() { WorkOrderId = obj.WorkOrderId, DateCreated = obj.DateCreated, CreatedBy = obj.CreatedBy, ModifiedBy = obj.ModifiedBy, DateModified = obj.DateModified, TenantId = obj.TenantId, IncidentId = obj.IncidentId, IncidentSettlementId = obj.IncidentSettlementId }); }
//获取工单明细 public WorkOrder GetWorkOrder(string orderNumber) { WorkOrder workOrder = new WorkOrder(); using (WorkOrderServiceClient client = new WorkOrderServiceClient()) { MethodReturnResult <WorkOrder> result = client.Get(orderNumber); if (result.Code <= 0) { workOrder = result.Data; } } return(workOrder); }
private void MakeNextWorkOrder(int?id) { activeCustomer = db.Customers.Find(id); WorkOrder newOrder = new WorkOrder() { CustomerId = activeCustomer.Id, ScheduledPickup = AccountController.GetNextWeekday(DateTime.Today, activeCustomer.PickupDay), PickupCompleted = false, ServicePaidFor = false }; db.WorkOrders.Add(newOrder); db.SaveChanges(); }
// GET: WorkOrder/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrder workOrder = db.WorkOrders.Find(id); if (workOrder == null) { return(HttpNotFound()); } return(View(workOrder)); }
/// <summary> /// Inserts a mock WorkOrder entity into the database. /// </summary> private void Step_01_Insert_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); Assert.IsTrue(DataRepository.WorkOrderProvider.Insert(tm, mock), "Insert failed"); System.Console.WriteLine("DataRepository.WorkOrderProvider.Insert(mock):"); System.Console.WriteLine(mock); //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
public void Relational_Store_Updates_range_of_records_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var myBatch = new List<WorkOrder>(); int qtyToAdd = 10; for (int i = 1; i <= qtyToAdd; i++) { var newWorkOrder = new WorkOrder { Description = "Caulk Tub " + i }; myBatch.Add(newWorkOrder); } WorkOrderStore.Add(myBatch); // Re-load, and update: var workOrders = WorkOrderStore.TryLoadData(); for (int i = 0; i < qtyToAdd; i++) { workOrders.ElementAt(i).Description = "Updated Tubs" + i; } WorkOrderStore.Update(workOrders); // Reload, and check updated names: workOrders = WorkOrderStore.TryLoadData().Where(c => c.Description.Contains("Updated")).ToList(); Assert.IsTrue(workOrders.Count == qtyToAdd); }
public void AddToWorkOrders(WorkOrder workOrder) { base.AddObject("WorkOrders", workOrder); }
public static WorkOrder CreateWorkOrder(int ID, string workOrderNumber, global::System.DateTime workOrderDate, int workOrder_Machine, bool isReceiveComplete, byte[] rowVersion) { WorkOrder workOrder = new WorkOrder(); workOrder.Id = ID; workOrder.WorkOrderNumber = workOrderNumber; workOrder.WorkOrderDate = workOrderDate; workOrder.WorkOrder_Machine = workOrder_Machine; workOrder.IsReceiveComplete = isReceiveComplete; workOrder.RowVersion = rowVersion; return workOrder; }
// POST api/awbuildversion public void Post(WorkOrder value) { adventureWorks_BC.WorkOrderAdd(value); }
public void ReceiveGCMMessage(string message) { Dictionary<string, string> json = JsonConvert.DeserializeObject<Dictionary<string, string>>(message); //Is our packet class sent via GCM if (json.ContainsKey("packetType")) { if (getPacketType(json) == Packet.PacketType.LoginReturn) { DebugConsole.Log("Received Login Packet."); if (JsonConvert.DeserializeObject<bool[]>(json["sendBool"])[0]) { loginID = JsonConvert.DeserializeObject<string[]>(json["sendString"])[0]; loggedIn = true; GCM.ShowToast("You have logged in!"); } lastMessage = JsonConvert.DeserializeObject<string[]>(json["sendString"])[1]; } else if (getPacketType(json) == Packet.PacketType.NearbyPlayers) { DebugConsole.Log("Received Nearby Players Packet."); if (JsonConvert.DeserializeObject<float[]>(json["sendFloat"])[0] == 0.0f) { Data.Instance.nearbyPlayersIDs = JsonConvert.DeserializeObject<string[]>(json["sendString"]); } else Data.Instance.nearbyPlayersNames = JsonConvert.DeserializeObject<string[]>(json["sendString"]); } else if (getPacketType(json) == Packet.PacketType.Friends) { DebugConsole.Log("Received Friends Packet."); if (JsonConvert.DeserializeObject<int[]>(json["sendInt"])[0] == 0) { Data.Instance.friendsIDs = JsonConvert.DeserializeObject<string[]>(json["sendString"]); } else Data.Instance.friendsNames = JsonConvert.DeserializeObject<string[]>(json["sendString"]); } else if (getPacketType(json) == Packet.PacketType.Dictionary) { int type = JsonConvert.DeserializeObject<int[]>(json["sendInt"])[0]; switch (type) { //Resources Packet case 0: DebugConsole.Log("Received Resources Packet."); Data.Instance.UpdateResources(JsonConvert.DeserializeObject<Dictionary<int, uint>>(json["sendDictionary"])); break; //Food Packet case 1: DebugConsole.Log("Received Food Packet."); Data.Instance.UpdateFood(JsonConvert.DeserializeObject<Dictionary<int, uint>>(json["sendDictionary"])); break; //Units Packet case 2: DebugConsole.Log("Received Units Packet."); Data.Instance.UpdateUnits(JsonConvert.DeserializeObject<Dictionary<int, uint>>(json["sendDictionary"])); break; //Keep Packet case 3: DebugConsole.Log("Received Keep Packet."); Data.Instance.UpdateKeep(JsonConvert.DeserializeObject<Dictionary<int, uint>>(json["sendDictionary"])); break; } } else if (getPacketType(json) == Packet.PacketType.RequestWorker) { DebugConsole.Log("Received Current Workers Packet."); Data.Instance.workOrders.Clear(); List<TimeSpan> tList = new List<TimeSpan>(JsonConvert.DeserializeObject<TimeSpan[]>(json["sendTime"])); List<int> rList = new List<int>(JsonConvert.DeserializeObject<int[]>(json["sendInt"])); List<float> latList = new List<float>(JsonConvert.DeserializeObject<float[]>(json["sendFloat"])); List<float> longList = new List<float>(JsonConvert.DeserializeObject<float[]>(json["sendFloat2"])); List<int> aList = new List<int>(JsonConvert.DeserializeObject<int[]>(json["sendInt2"])); List<WorkOrder> temp = new List<WorkOrder>(); for (int i = 0; i < tList.Count; i++) { WorkOrder w = new WorkOrder(); w.type = WorkOrder.OrderType.Resource; w.duration = tList[i]; w.enumType = rList[i]; w.latitude = latList[i]; w.longitude = longList[i]; w.amount = aList[i]; temp.Add(w); } Data.Instance.workerPositions = temp; } else if (getPacketType(json) == Packet.PacketType.TileResources) { DebugConsole.Log("Received Tile Resources Packet."); Data.Instance.currentResources = JsonConvert.DeserializeObject<int[]>(json["sendInt"]); Data.mapReady = true; } else if (getPacketType(json) == Packet.PacketType.PlayerInfo) { DebugConsole.Log("Received Player Info Packet."); Data.Instance.playerName = JsonConvert.DeserializeObject<string[]>(json["sendString"])[0]; Data.Instance.gender = JsonConvert.DeserializeObject<bool[]>(json["sendBool"])[0]; } else if (getPacketType(json) == Packet.PacketType.WorkOrders) { DebugConsole.Log("Received Work Orders Packet."); string[] sArr = JsonConvert.DeserializeObject<string[]>(json["sendString"]); int[] iArr = JsonConvert.DeserializeObject<int[]>(json["sendInt"]); float[] fArr = JsonConvert.DeserializeObject<float[]>(json["sendFloat"]); System.TimeSpan[] tArr = JsonConvert.DeserializeObject<System.TimeSpan[]>(json["sendTime"]); List<WorkOrder> orders = new List<WorkOrder>(); for (int i = 0; i < sArr.Length; i++) { WorkOrder w = new WorkOrder(); w.type = (WorkOrder.OrderType)(int.Parse(sArr[i])); w.enumType = iArr[i]; w.amount = (int)fArr[i]; w.duration = tArr[i]; orders.Add(w); DebugConsole.Log(w.type.ToString() + "," + w.enumType + "," + w.amount + "," + w.duration.ToString()); } Data.Instance.workOrders = orders; } else if (getPacketType(json) == Packet.PacketType.AttackOrders) { DebugConsole.Log("Received Attack Order Packet."); AttackOrder a = new AttackOrder(); Dictionary<int, uint> tempDict = JsonConvert.DeserializeObject<Dictionary<int, uint>>(json["sendDictionary"]); Data.Instance.attackOrder.units.Clear(); foreach (KeyValuePair<int, uint> entry in tempDict) { Data.Instance.attackOrder.units.Add((Data.UnitNames)entry.Key, entry.Value); } Data.Instance.attackOrder.timeToDestination = JsonConvert.DeserializeObject<TimeSpan[]>(json["sendTime"])[0]; } } foreach (KeyValuePair<string, string> entry in json) { //DebugConsole.Log(entry.Key + ":" + entry.Value); } // DebugConsole.Log("/////////////////////"); }
/// <summary> /// Deep load all WorkOrder children. /// </summary> private void Step_03_DeepLoad_Generated() { using (TransactionManager tm = CreateTransaction()) { int count = -1; mock = CreateMockInstance(tm); mockCollection = DataRepository.WorkOrderProvider.GetPaged(tm, 0, 10, out count); DataRepository.WorkOrderProvider.DeepLoading += new EntityProviderBaseCore<WorkOrder, WorkOrderKey>.DeepLoadingEventHandler( delegate(object sender, DeepSessionEventArgs e) { if (e.DeepSession.Count > 3) e.Cancel = true; } ); if (mockCollection.Count > 0) { DataRepository.WorkOrderProvider.DeepLoad(tm, mockCollection[0]); System.Console.WriteLine("WorkOrder instance correctly deep loaded at 1 level."); mockCollection.Add(mock); // DataRepository.WorkOrderProvider.DeepSave(tm, mockCollection); } //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
/// <summary> /// Serialize a WorkOrder collection into a temporary file. /// </summary> private void Step_08_SerializeCollection_Generated() { using (TransactionManager tm = CreateTransaction()) { string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_WorkOrderCollection.xml"); mock = CreateMockInstance(tm); TList<WorkOrder> mockCollection = new TList<WorkOrder>(); mockCollection.Add(mock); EntityHelper.SerializeXml(mockCollection, fileName); Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found"); System.Console.WriteLine("TList<WorkOrder> correctly serialized to a temporary file."); } }
///<summary> /// Returns a Typed WorkOrder Entity with mock values. ///</summary> static public WorkOrder CreateMockInstance_Generated(TransactionManager tm) { WorkOrder mock = new WorkOrder(); mock.OrderQty = TestUtility.Instance.RandomNumber(); mock.ScrappedQty = TestUtility.Instance.RandomShort(); mock.StartDate = TestUtility.Instance.RandomDateTime(); mock.EndDate = TestUtility.Instance.RandomDateTime(); mock.DueDate = TestUtility.Instance.RandomDateTime(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); int count0 = 0; TList<Product> _collection0 = DataRepository.ProductProvider.GetPaged(tm, 0, 10, out count0); //_collection0.Shuffle(); if (_collection0.Count > 0) { mock.ProductId = _collection0[0].ProductId; } int count1 = 0; TList<ScrapReason> _collection1 = DataRepository.ScrapReasonProvider.GetPaged(tm, 0, 10, out count1); //_collection1.Shuffle(); if (_collection1.Count > 0) { mock.ScrapReasonId = _collection1[0].ScrapReasonId; } // create a temporary collection and add the item to it TList<WorkOrder> tempMockCollection = new TList<WorkOrder>(); tempMockCollection.Add(mock); tempMockCollection.Remove(mock); return (WorkOrder)mock; }
private static XmlDocument BuildAddOrModRq(WorkOrder wo) { RotoTrackDb db = new RotoTrackDb(); XmlDocument doc = XmlUtils.MakeRequestDocument(); XmlElement parent = XmlUtils.MakeRequestParentElement(doc); BillingInstruction bi = db.BillingInstructions.Find(wo.BillingInstructionsId); Area area = db.Areas.Find(wo.AreaId); Customer customer = db.Customers.Find(wo.CustomerId); WorkOrderType wot = db.WorkOrderTypes.Find(wo.WorkOrderTypeId); Contact contact = db.Contacts.Find(wo.ContactId); Site site = db.Sites.Find(wo.SiteId); JobType jt = db.JobTypes.Find(wo.JobTypeId); XmlElement CustomerAddOrModRq = null; XmlElement CustomerAddOrMod = null; if (wo.QBListId == null) { CustomerAddOrModRq = doc.CreateElement("CustomerAddRq"); parent.AppendChild(CustomerAddOrModRq); CustomerAddOrMod = doc.CreateElement("CustomerAdd"); CustomerAddOrModRq.AppendChild(CustomerAddOrMod); } else { CustomerAddOrModRq = doc.CreateElement("CustomerModRq"); parent.AppendChild(CustomerAddOrModRq); CustomerAddOrMod = doc.CreateElement("CustomerMod"); CustomerAddOrModRq.AppendChild(CustomerAddOrMod); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "ListID", wo.QBListId)); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "EditSequence", wo.QBEditSequence)); } CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "Name", wo.WorkOrderNumber)); string isActive = (wo.statusValue != (int)WorkOrderStatus.Inactive) ? "1" : "0"; CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "IsActive", isActive)); XmlElement ParentRef = doc.CreateElement("ParentRef"); CustomerAddOrMod.AppendChild(ParentRef); ParentRef.AppendChild(XmlUtils.MakeSimpleElem(doc, "ListID", customer.QBListId)); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "CompanyName", customer.CompanyName)); if (contact != null) { string[] namePieces = contact.Name.Split(' '); string firstName; string lastName; string middleName; if (namePieces.Count() == 2) { firstName = namePieces[0]; lastName = namePieces[1]; if (firstName.Length > 15) firstName = firstName.Substring(0, 15); if (lastName.Length > 18) lastName = lastName.Substring(0, 18); contact.Name = firstName + " " + lastName; CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "FirstName", firstName)); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "LastName", lastName)); } else if (namePieces.Count() == 3) { firstName = namePieces[0]; middleName = namePieces[1]; lastName = namePieces[2]; if (firstName.Length > 15) firstName = firstName.Substring(0, 15); if (middleName.Length > 5) middleName = middleName.Substring(0, 5); if (lastName.Length > 18) lastName = lastName.Substring(0, 18); contact.Name = firstName + " " + middleName + " " + lastName; CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "FirstName", firstName)); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "MiddleName", middleName)); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "LastName", lastName)); } else if (namePieces.Count() == 1) { firstName = namePieces[0]; if (firstName.Length > 15) firstName = firstName.Substring(0, 15); contact.Name = firstName; CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "FirstName", firstName)); } } XmlElement BillAddress = doc.CreateElement("BillAddress"); CustomerAddOrMod.AppendChild(BillAddress); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "Addr1", customer.Address.Address1)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "Addr2", customer.Address.Address2)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "Addr3", customer.Address.Address3)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "Addr4", customer.Address.Address4)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "Addr5", customer.Address.Address5)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "City", customer.Address.City)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "State", customer.Address.State)); BillAddress.AppendChild(XmlUtils.MakeSimpleElem(doc, "PostalCode", customer.Address.Zip)); if (contact != null) { if (contact.Name.Length > 40) contact.Name = contact.Name.Substring(0, 40); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "Contact", contact.Name)); if (contact.Phone != null && contact.Phone != "") { XmlElement AdditionalContactRef1 = doc.CreateElement("AdditionalContactRef"); CustomerAddOrMod.AppendChild(AdditionalContactRef1); AdditionalContactRef1.AppendChild(XmlUtils.MakeSimpleElem(doc, "ContactName", "Main Phone")); AdditionalContactRef1.AppendChild(XmlUtils.MakeSimpleElem(doc, "ContactValue", contact.Phone)); } if (contact.Email != null && contact.Email != "") { XmlElement AdditionalContactRef2 = doc.CreateElement("AdditionalContactRef"); CustomerAddOrMod.AppendChild(AdditionalContactRef2); AdditionalContactRef2.AppendChild(XmlUtils.MakeSimpleElem(doc, "ContactName", "Main Email")); AdditionalContactRef2.AppendChild(XmlUtils.MakeSimpleElem(doc, "ContactValue", contact.Email)); } } XmlElement CustomerTypeRef = doc.CreateElement("CustomerTypeRef"); CustomerAddOrMod.AppendChild(CustomerTypeRef); CustomerTypeRef.AppendChild(XmlUtils.MakeSimpleElem(doc, "ListID", bi.QBListId)); switch (wo.JobStatus) { case JobStatus.Awarded: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "Awarded")); break; case JobStatus.Complete: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "Closed")); break; case JobStatus.InProgress: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "InProgress")); break; case JobStatus.NotApplicable: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "None")); break; case JobStatus.NotAwarded: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "NotAwarded")); break; case JobStatus.Pending: CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStatus", "Pending")); break; default: break; } CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobStartDate", wo.EstStartDate.ToString("yyyy-MM-dd"))); CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobProjectedEndDate", wo.EstEndDate.ToString("yyyy-MM-dd"))); if (wo.ActualEndDate != DateTime.Parse("1900-01-01 00:00:00.000")) { CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobEndDate", wo.ActualEndDate.ToString("yyyy-MM-dd"))); } if (wo.JobDescription != null) { CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "JobDesc", wo.JobDescription)); } if (jt != null) { XmlElement JobTypeRef = doc.CreateElement("JobTypeRef"); CustomerAddOrMod.AppendChild(JobTypeRef); JobTypeRef.AppendChild(XmlUtils.MakeSimpleElem(doc, "ListID", jt.QBListId)); } if (wo.BillingNotes != null) { CustomerAddOrMod.AppendChild(XmlUtils.MakeSimpleElem(doc, "Notes", wo.BillingNotes)); } return doc; }
///<summary> /// Update the Typed WorkOrder Entity with modified mock values. ///</summary> static public void UpdateMockInstance(TransactionManager tm, WorkOrder mock) { WorkOrderTest.UpdateMockInstance_Generated(tm, mock); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); }
/// <summary> /// Serialize the mock WorkOrder entity into a temporary file. /// </summary> private void Step_06_SerializeEntity_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_WorkOrder.xml"); EntityHelper.SerializeXml(mock, fileName); Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock not found"); System.Console.WriteLine("mock correctly serialized to a temporary file."); } }
public static void Update(WorkOrder workOrder) { WcfData.WorkOrder inDbWorkOrder = (WcfData.WorkOrder)workOrder; WcfData.WorkOrderDbOperations.Update(inDbWorkOrder); }
/// <summary> /// Test methods exposed by the EntityHelper class. /// </summary> private void Step_20_TestEntityHelper_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); WorkOrder entity = mock.Copy() as WorkOrder; entity = (WorkOrder)mock.Clone(); Assert.IsTrue(WorkOrder.ValueEquals(entity, mock), "Clone is not working"); } }
public void Relational_Store_Deletes_all_records_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var myBatch = new List<WorkOrder>(); int qtyToAdd = 10; for (int i = 0; i < qtyToAdd; i++) { var newWorkOrder = new WorkOrder { Description = "Kill Roaches dead " + i }; myBatch.Add(newWorkOrder); } WorkOrderStore.Add(myBatch); // Re-load from back-end: var workOrders = WorkOrderStore.TryLoadData(); int qtyAdded = workOrders.Count; // Delete: WorkOrderStore.DeleteAll(); int remaining = WorkOrderStore.TryLoadData().Count; Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0); }
///<summary> /// Update the Typed WorkOrder Entity with modified mock values. ///</summary> static public void UpdateMockInstance_Generated(TransactionManager tm, WorkOrder mock) { mock.OrderQty = TestUtility.Instance.RandomNumber(); mock.ScrappedQty = TestUtility.Instance.RandomShort(); mock.StartDate = TestUtility.Instance.RandomDateTime(); mock.EndDate = TestUtility.Instance.RandomDateTime(); mock.DueDate = TestUtility.Instance.RandomDateTime(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); int count0 = 0; TList<Product> _collection0 = DataRepository.ProductProvider.GetPaged(tm, 0, 10, out count0); //_collection0.Shuffle(); if (_collection0.Count > 0) { mock.ProductId = _collection0[0].ProductId; } int count1 = 0; TList<ScrapReason> _collection1 = DataRepository.ScrapReasonProvider.GetPaged(tm, 0, 10, out count1); //_collection1.Shuffle(); if (_collection1.Count > 0) { mock.ScrapReasonId = _collection1[0].ScrapReasonId; } }
public static XmlDocument BuildUpdateRq(WorkOrder wo) { RotoTrackDb db = new RotoTrackDb(); XmlDocument doc = XmlUtils.MakeRequestDocument(); XmlElement parent = XmlUtils.MakeRequestParentElement(doc); string listID = wo.QBListId; Site site = db.Sites.Find(wo.SiteId); string salesRep = ""; UserProfile up = db.UserProfiles.Find(wo.SalesRepId); if (up != null) { salesRep = up.FirstName + " " + up.LastName; } doc = BuildDataExtModOrDelRq(doc, parent, listID, "Site Name", site.SiteName); doc = BuildDataExtModOrDelRq(doc, parent, listID, "Site Unit Number", site.UnitNumber); doc = BuildDataExtModOrDelRq(doc, parent, listID, "Site County", site.County); doc = BuildDataExtModOrDelRq(doc, parent, listID, "Site City/State", site.CityState); doc = BuildDataExtModOrDelRq(doc, parent, listID, "Site POAFE", wo.POAFENumber); doc = BuildDataExtModOrDelRq(doc, parent, listID, "Work Order Sales Rep", salesRep); switch (wo.CloseStatus) { case CloseStatus.BillPerPreCloseSalePrice: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Bill per PreClose Sale Price"); break; case CloseStatus.BillPerQuote: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Bill per Quote"); break; case CloseStatus.BillWithCore: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Bill with Core"); break; case CloseStatus.ClosedAtZeroDollars: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Closed at Zero $"); break; case CloseStatus.NotApplicable: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", ""); break; case CloseStatus.PreClose: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Pre-close"); break; case CloseStatus.PreCloseHold: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Pre-close HOLD"); break; case CloseStatus.PreInvoice: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Pre-Invoice"); break; case CloseStatus.Approved: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Approved"); break; case CloseStatus.ReadyForPreClose: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Ready for Pre-close"); break; case CloseStatus.Warranty: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "Warranty"); break; case CloseStatus.RnDResearchAndDev: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", "R&D-Research & Development"); break; default: doc = BuildDataExtModOrDelRq(doc, parent, listID, "Close Status", ""); break; } return doc; }
public void Relational_Store_Deletes_range_of_records_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var myBatch = new List<WorkOrder>(); int qtyToAdd = 10; for (int i = 0; i < qtyToAdd; i++) { var newWorkOrder = new WorkOrder { Description = "Kill mice dead " + i }; myBatch.Add(newWorkOrder); } WorkOrderStore.Add(myBatch); // Re-load from back-end: var workOrders = WorkOrderStore.TryLoadData(); int qtyAdded = workOrders.Count; // Select 5 for deletion: int qtyToDelete = 5; var deleteThese = workOrders.Where(c => c.WorkOrderId <= qtyToDelete); // Delete: WorkOrderStore.Delete(deleteThese); int remaining = WorkOrderStore.TryLoadData().Count; Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete); }
public static XmlDocument BuildUpdateSalesRepRq(WorkOrder wo) { RotoTrackDb db = new RotoTrackDb(); XmlDocument doc = XmlUtils.MakeRequestDocument(); XmlElement parent = XmlUtils.MakeRequestParentElement(doc); string listID = wo.QBListId; Site site = db.Sites.Find(wo.SiteId); string salesRep = ""; UserProfile up = db.UserProfiles.Find(wo.SalesRepId); if (up != null) { salesRep = up.FirstName + " " + up.LastName; } doc = BuildDataExtModOrDelRq(doc, parent, listID, "Work Order Sales Rep", salesRep); return doc; }
/// <summary> /// Make any alterations necessary (i.e. for DB check constraints, special test cases, etc.) /// </summary> /// <param name="mock">Object to be modified</param> static private void SetSpecialTestData(WorkOrder mock) { //Code your changes to the data object here. mock.EndDate = mock.StartDate.AddDays(1); }
/// <summary> /// Create a new WorkOrder object. /// </summary> /// <param name="workOrderID">Initial value of WorkOrderID.</param> /// <param name="orderQty">Initial value of OrderQty.</param> /// <param name="stockedQty">Initial value of StockedQty.</param> /// <param name="scrappedQty">Initial value of ScrappedQty.</param> /// <param name="startDate">Initial value of StartDate.</param> /// <param name="dueDate">Initial value of DueDate.</param> /// <param name="modifiedDate">Initial value of ModifiedDate.</param> public static WorkOrder CreateWorkOrder(int workOrderID, int orderQty, int stockedQty, short scrappedQty, global::System.DateTime startDate, global::System.DateTime dueDate, global::System.DateTime modifiedDate) { WorkOrder workOrder = new WorkOrder(); workOrder.WorkOrderID = workOrderID; workOrder.OrderQty = orderQty; workOrder.StockedQty = stockedQty; workOrder.ScrappedQty = scrappedQty; workOrder.StartDate = startDate; workOrder.DueDate = dueDate; workOrder.ModifiedDate = modifiedDate; return workOrder; }
/// <summary> /// Create a new WorkOrder object. /// </summary> /// <param name="workOrderId">Initial value of WorkOrderId.</param> /// <param name="computedOrderId">Initial value of ComputedOrderId.</param> /// <param name="createDate">Initial value of CreateDate.</param> public static WorkOrder CreateWorkOrder(int workOrderId, string computedOrderId, global::System.DateTime createDate) { WorkOrder workOrder = new WorkOrder(); workOrder.WorkOrderId = workOrderId; workOrder.ComputedOrderId = computedOrderId; workOrder.CreateDate = createDate; return workOrder; }
public static void Add(WorkOrder workOrder) { WcfData.WorkOrder inDbWorkOrder = (WcfData.WorkOrder)workOrder; WcfData.WorkOrderDbOperations.Add(inDbWorkOrder); }
public void Relational_Store_Deletes_record_with_name_attributes() { var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db); var newWorkOrder = new WorkOrder { Description = "Eradicate bed bugs" }; WorkOrderStore.Add(newWorkOrder); // Load from back-end: var workOrders = WorkOrderStore.TryLoadData(); int qtyAdded = workOrders.Count; // Delete: var foundWorkOrder = workOrders.FirstOrDefault(); WorkOrderStore.Delete(foundWorkOrder); int remaining = WorkOrderStore.TryLoadData().Count; Assert.IsTrue(qtyAdded == 1 && remaining == 0); }
public static XmlDocument BuildModRq(WorkOrder wo) { return BuildAddOrModRq(wo); }