public async Task <int> AddDeliveryAsync(DeliveryModel deliveryModel) { _dbContext.Deliveries.Add(deliveryModel); await _dbContext.SaveChangesAsync(); return(deliveryModel.DeliveryId); }
public ActionResult Edit(DeliveryModel model) { try { var delivery = _deliveryService.GetDeliveryById(model.Id); if (delivery == null) { return(RedirectToAction("List")); } if (!ModelState.IsValid) { return(View(model)); } var currentUser = Session[Values.USER_SESSION] as UserModel; model.UpdatedBy = currentUser.Id; model.UpdatedDateTime = DateTime.Now; _deliveryService.UpdateDelivery(model); SuccessNotification("Chỉnh sửa thông tin phiếu xuất thành công"); return(model.ContinueEditing ? RedirectToAction("Edit", new { id = model.Id }) : RedirectToAction("List")); } catch (Exception e) { ErrorNotification("Chỉnh sửa phiếu xuất thất bại"); return(View(model)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DeliveryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Delivery set "); strSql.Append("UserId=@UserId,"); strSql.Append("Consignee=@Consignee,"); strSql.Append("Complete=@Complete,"); strSql.Append("Phone=@Phone"); strSql.Append(" where DeliveryID=@DeliveryID"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Consignee", SqlDbType.NVarChar, 50), new SqlParameter("@Complete", SqlDbType.NVarChar, 200), new SqlParameter("@Phone", SqlDbType.NVarChar, 12), new SqlParameter("@DeliveryID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.Consignee; parameters[2].Value = model.Complete; parameters[3].Value = model.Phone; parameters[4].Value = model.DeliveryID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public async void DeclineAction(object sender, EventArgs e) { var mi = ((MenuItem)sender); try { if (int.TryParse(mi.CommandParameter.ToString(), out int IDint)) { DeliveryModel selectedDelivery = listOfDeliveries.Where(x => x.DeliveryID == IDint).First(); if (selectedDelivery != null) { await Navigation.PushModalAsync(new DeclineDeliveryReasonModalPage(selectedDelivery)); } else { await DisplayAlert("Greška", " Odbijanje neuspešno", "ok"); } } else { await DisplayAlert("Greška", " Odbijanje neuspešno", "ok"); } } catch (Exception ex) { await DisplayAlert("Delivery confimation failed.", " Try again. Check internet connection. Error : " + ex.Message + ex.InnerException, "ok"); } }
public async Task <ActionResult> DeliverProduct([FromBody] DeliveryModel deliveryModel) { try { //deliver product var identity = (System.Security.Claims.ClaimsIdentity)HttpContext.User.Identity; var userId = identity.Claims.FirstOrDefault(c => c.Type == "userId").Value; DeliveryDb.deliveryList.Add(new DeliveryModel(DeliveryDb.deliveryList.Count + 1, deliveryModel.orderId, userId, deliveryModel.DeliveredBy, deliveryModel.DeliveryStatus)); //change status in order Uri uri = new Uri($"rabbitmq://{_config.GetValue<string>("RabbitMQHostName")}/delStatus"); var endPoint = await _bus.GetSendEndpoint(uri); var order = new Common.OrderDetails(); order.OrderId = deliveryModel.orderId; order.UserId = deliveryModel.userId; order.IsDeliverySuccessful = deliveryModel.DeliveryStatus; await endPoint.Send(order); _log.LogInformation("Order has been delivered."); return(Ok("Order Delivered")); } catch (Exception ex) { _log.LogInformation("Order can't be delivered."); return(Ok("Order can't be delivered.")); } }
public ActionResult DEdit(int id) { DeliveryService objService = new DeliveryService(); DeliveryModel objModel = new DeliveryModel(); objModel = objService.getByID(id); QuotationService objService1 = new QuotationService(); List <DataCenterModel> ListDC = new List <DataCenterModel>(); ListDC = objService1.getDataCenter(); objModel.ListDC = new List <DataCenterModel>(); objModel.ListDC.AddRange(ListDC); QuotationService objCompUSerService = new QuotationService(); List <CompanyModel> objCompList = new List <CompanyModel>(); objCompList = objCompUSerService.getActiveComp(); objModel.ListComp = new List <CompanyModel>(); objModel.ListComp.AddRange(objCompList); List <UserModel> objUserList = new List <UserModel>(); objUserList = objCompUSerService.getActiveUser(); objModel.UserList = new List <UserModel>(); objModel.UserList.AddRange(objUserList); var comp = Dbcontext.UserMasters.Where(m => m.UID == objModel.CreatedBy).SingleOrDefault(); int?cid = comp.CompID; objModel.comp = cid; return(View(objModel)); }
//导出数据 protected void Button1_Click(object sender, EventArgs e) { string Sendpersonnel1 = Sendpersonnel.Value; string SendTime1 = SendTime.Value; string Sendstate1 = Sendstate.Value; if (SendTime1 == "") { SendTime1 = "0"; } if (Sendpersonnel1 == "") { Sendpersonnel1 = "0"; } DeliveryModel rm = new DeliveryModel(); // DataBaseLayer db = new DataBaseLayer(); // string str = "select * from lossiInfor where type ='" + type + "'"; DataTable dt = rm.findDeliveryInfoDao(Sendstate1, SendTime1, Sendpersonnel1); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; string now = currentTime.ToString("yyyyMMdd"); CreateExcel(dt, "application/ms-excel", "发货管理" + now); }
public IActionResult Register([FromBody] DeliveryModel deliveryModel) { // map dto to entity var delivery = _iMapper.Map <Delivery>(deliveryModel); try { // save var result = _iDeliveryService.Create(delivery, delivery.PostId, delivery.ResumeId); var count = 1; if (result != null) { return(Output(new DeliveryModel { DeliveryId = result.DeliveryId, PostId = result.PostId, ResumeId = result.ResumeId, DeliveryUpdateTime = result.DeliveryUpdateTime }, count)); } throw new Exception("创建失败!"); } catch (AppException ex) { // return error message if there was an exception return(BadRequest(new { message = ex.Message })); } }
// // GET: /Delivery/Edit/5 public IActionResult Edit(string id = null) { DeliveryModel delivery = _context.Deliveries.Find(id); if (delivery == null) { return(NotFound()); } DepartmentModel c = _context.Departments.Find(delivery.AccDpt); if (c != null) { delivery.AccDptNam = c.Name_C; } VendorModel v = _context.BMEDVendors.Where(vv => vv.UniteNo == delivery.VendorId).FirstOrDefault(); if (v != null) { delivery.VendorNam = v.VendorName; } AppUserModel u = _context.AppUsers.Find(Convert.ToInt32(delivery.DelivPson)); if (u != null) { delivery.DelivPsonNam = u.FullName; } BuyEvaluateModel b = _context.BuyEvaluates.Find(delivery.PurchaseNo); if (b != null) { delivery.BudgetId = b.BudgetId; } return(View(delivery)); }
public async Task <IActionResult> CompleteDelivery(string id, [FromBody] DeliveryModel deliveryModel) { var userId = User.Claims.Where(c => c.Type == ClaimTypes.NameIdentifier).FirstOrDefault(); var deliveryId = Guid.Parse(id); if (userId == null) { return(Unauthorized()); } var delivery = await _deliveryRepository.GetDeliveryForUser(userId.Value, deliveryId); delivery.Order.IsClosed = true; delivery.IsDelivered = true; delivery.Order.IsPaid = true; delivery.DeliveredTime = DateTime.Now; deliveryModel.IsPaid = true; deliveryModel.IsDelivered = true; deliveryModel.DeliveryTime = DateTime.Now; var employee = await _employeeRepository.GetEmployeeFromUserId(userId.Value); await _cashDeskRepository.AddCash(employee.Id, deliveryModel.PaidPrice); _deliveryRepository.Update(delivery); return(Ok(new { delivery = deliveryModel })); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DeliveryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Delivery("); strSql.Append("UserId,Consignee,Complete,Phone)"); strSql.Append(" values ("); strSql.Append("@UserId,@Consignee,@Complete,@Phone)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Consignee", SqlDbType.NVarChar, 50), new SqlParameter("@Complete", SqlDbType.NVarChar, 200), new SqlParameter("@Phone", SqlDbType.NVarChar, 12) }; parameters[0].Value = model.UserId; parameters[1].Value = model.Consignee; parameters[2].Value = model.Complete; parameters[3].Value = model.Phone; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult <DeliveryModel> UpdateOne(DeliveryModel delivery) { if (_validationService.ValidateDeliveryUpdate(delivery)) { if (delivery.ItemId != default && !_validationService.ValidateItem(delivery.ItemId)) { return(BadRequest(new { message = "There is no Item with such ItemId" })); } if (!_validationService.ValidateCustomer(delivery.CustomerId)) { return(BadRequest(new { message = "There is no Item with such ItemId" })); } if (!_validationService.ValidateDeliveryVolume(delivery)) { return(BadRequest(new { message = "Delivery is over storage capacity" })); } var dto = _orderService.UpdateOneDelivery(delivery); return(Ok(delivery)); } else { return(BadRequest()); } }
public ActionResult <DeliveryModel> InsertOne(DeliveryModel delivery) { // Validate reference ids. if (!_validationService.ValidateStorage(delivery.StorageId)) { return(BadRequest(new { message = "StorageId does not point to existing storage" })); } if (delivery.ItemId == default || !_validationService.ValidateItem(delivery.ItemId)) { return(BadRequest(new { message = "There is no Item with such ItemId" })); } if (!_validationService.ValidateCustomer(delivery.CustomerId)) { return(BadRequest(new { message = "There is no Customer with such CustomerId" })); } if (!_validationService.ValidateDeliveryVolume(delivery)) { return(BadRequest(new { message = "Delivery is over storage capacity" })); } var dto = _orderService.InsertOneDelivery(delivery); if (dto != null) { return(CreatedAtAction("GetOne", dto)); } else { return(BadRequest()); } }
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p) { dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult(); result.page = p.page; //设定当前返回的页号 result.total = 100; //总计的数据条数,此处用100进行模拟,查询和筛选时需要根据实际 DeliveryModel rm = new DeliveryModel(); result.table = rm.MedicineDisplayInfo(); dotNetFlexGrid.FieldFormatorHandle proc2 = delegate(DataRow dr) { int bstatus = Convert.ToInt32(dr["Sendstate"].ToString()); if (bstatus == 1) { return("已发货"); } else { return("待发货"); } }; result.FieldFormator.Register("Sendstate", proc2); return(result); }
public async void DirectionAction(object sender, EventArgs e) { var mi = ((MenuItem)sender); try { if (int.TryParse(mi.CommandParameter.ToString(), out int IDint)) { DeliveryModel selectedDelivery = listOfDeliveries.Where(x => x.DeliveryID == IDint).First(); if (selectedDelivery != null) { if (selectedDelivery.EndAddress.LocationID > 1) { LocationModel l = await locationService.GetByID(Convert.ToInt32(selectedDelivery.EndAddress.LocationID)); await Map.OpenAsync(l.Latitude, l.Longitude, new MapLaunchOptions() { NavigationMode = NavigationMode.Walking }); } } } } catch { } }
public async Task <IViewComponentResult> InvokeAsync(string id = null, string upload = null, int page = 1) { List <AssetModel> at = new List <AssetModel>(); if (upload == "採購人員") { DeliveryModel dd = _context.Deliveries.Find(id); if (dd != null) { at = _context.BMEDAssets.Where(a => a.Docid == dd.DocId).ToList(); } } else { at = _context.BMEDAssets.Where(a => a.Docid == id).ToList(); } foreach (AssetModel e in at) { e.upload = upload; } if (upload == "查看") { return(View("_BuyEvaluateListItem2", at)); } if (at.ToPagedList(page, pageSize).Count <= 0) { return(View(at.ToPagedList(1, pageSize))); } return(View(at.ToPagedList(page, pageSize))); }
public static GameObject Instantiate(GameObject prefab, DeliveryModel delivery) { GameObject go = GameObject.Instantiate(prefab); CreateDeliveryElement cd = go.GetComponent <CreateDeliveryElement> (); cd.remetente.text = delivery.remetente; cd.destinatario.text = delivery.destinatario; cd.date.text = delivery.deliveryDate; cd.key = delivery.deliveryID; DateTime current = System.DateTime.Now; string dateStr = delivery.deliveryDate.Replace("/", "-"); DateTime date = DateTime.ParseExact(dateStr, "dd-MM-yyyy", null); //if today is before the other date if (current > date) { cd.status.text = DeliveryStatus.Atrasado.ToString(); } else { cd.status.text = DeliveryStatus.OK.ToString(); } return(go); }
public async Task <DeliveryModel> GetDeliveryByID(int id) { try { var uri = ServerLink + "/GetDelivery/" + id; var res = await _client.GetAsync(uri); if (res.StatusCode == System.Net.HttpStatusCode.OK && res.Content != null) { var resStringD = await res.Content.ReadAsStringAsync(); DeliveryModel delivery = JsonConvert.DeserializeObject <DeliveryModel>(resStringD); return(delivery); } else { return(null); } } catch (Exception ex) { Debug.WriteLine(ex.InnerException); return(null); } }
public async Task <DeliveryModel> FindDelivery(string routeId, string vehicleId) { // routes and vehicles are unique to events, so we can find by either of these values without risk // of event crossover IEnumerable <DeliveryModel> availableDeliveries = await _repoDeliveries.GetItemsAsyncOrderByDescending(p => p.RouteId == routeId && p.VehicleId == vehicleId && (p.Status == DeliveryModel.kDeliveryStatusNotStarted || p.Status == DeliveryModel.kDeliveryStatusInProgress), p => p.Date); DeliveryModel delivery = availableDeliveries.FirstOrDefault(); // if there are no deliveries for the route, look at the most recent delivery for the vehicle if (delivery == null) { availableDeliveries = await _repoDeliveries.GetItemsAsyncOrderByDescending(p => p.VehicleId == vehicleId, p => p.Date); DeliveryModel candidate = availableDeliveries.FirstOrDefault(); if (candidate != null && candidate.Status == DeliveryModel.kDeliveryStatusNotStarted) { // typical scenario of a delivery that hasn't yet started - this is our target delivery = candidate; } else if (candidate != null && candidate.Status == DeliveryModel.kDeliveryStatusInProgress) { // assume delivery is resuming if the most recent delivery for the vehicle never ended delivery = candidate; } } return(delivery); }
/// <summary> /// 得到一个对象实体 /// </summary> public DeliveryModel DataRowToModel(DataRow row) { DeliveryModel model = new DeliveryModel(); if (row != null) { if (row["DeliveryID"] != null && row["DeliveryID"].ToString() != "") { model.DeliveryID = int.Parse(row["DeliveryID"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["Consignee"] != null) { model.Consignee = row["Consignee"].ToString(); } if (row["Complete"] != null) { model.Complete = row["Complete"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } } return(model); }
/// <returns></returns> private async Task <ProcessResult <DeliveryModel> > DeliveryNotificationsAsync(long deliveryKey) { ProcessResult <DeliveryModel> retVal; try { DeliveryModel dmodel = await _deliveryQueries.GetDeliveryAsync(deliveryKey); var aps = new Aps(dmodel.Notification.Title, dmodel.Notification.Message, string.Empty, new List <string> { dmodel.Notification.NotificationId.ToString() }); ProcessResult result = await _pushService.SendAsync(dmodel.Subscription.DeviceToken, aps); retVal = new ProcessResult <DeliveryModel>(dmodel); retVal.PopulateErrorFromResult(result); } catch (Exception ex) { retVal = new ProcessResult <DeliveryModel>(); retVal.SetErrorInfo($"DeliveryNotification Error: {ex.Message}"); } return(retVal); }
// private readonly SQLiteAsyncConnection _connection; public StartAddressPage() { // _connection = DependencyService.Get<ISQLiteDb>().GetConnection(); locationService = new LocationService(); addressService = new AddressService(); GetUserAddresses(); EditEnabled = false; delivery = new DeliveryModel() { DeliveryPrice = 160, DeliveryID = 0, StartAddressID = 0, EndAddress = null, EndAddressID = 0, CreateTime = DateTime.Now, StartTime = Convert.ToDateTime("0001 - 01 - 01 00:00:00.0000000"), EndTime = Convert.ToDateTime("0001 - 01 - 01 00:00:00.0000000"), PaymentTypeID = 1, DeliveryTypeID = 1, Description = "", WaitingInMinutes = 0, DeliveryStatusImageSource = "zuti50.png", CourierID = 0, DispatcherID = 0, UserID = Convert.ToInt32(Application.Current.Properties["UserID"]), StartAddress = new FullAddressModel() { UserID = Convert.ToInt32(Application.Current.Properties["UserID"]), Address = "", Phone = "+3816", Name = "" }, DeliveryStatus = 0 }; InitializeComponent(); }
private async Task <DeliveryModel> UpdateDeliveryStatus(DeliveryModel delivery, DeliveryIoTMessage update) { var distanceToDestination = CalculateDistance(Double.Parse(update.Latitude), Double.Parse(update.Longitude), Decimal.ToDouble(delivery.DestinationLocation.latitude), Decimal.ToDouble(delivery.DestinationLocation.longitude)); var threshold = _config.DistanceToDestinationMilesThreshold; var state = distanceToDestination < threshold ? DeliveryModel.kDeliveryStatusComplete : DeliveryModel.kDeliveryStatusInProgress; delivery.Status = state; delivery.MilesToDestination = (decimal)distanceToDestination; delivery.MilesTraveled = update.Distance; delivery.RouteId = update.TripId; var putResult = await _transportRestService.UpdateDeliveryStatus(delivery); if (putResult == HttpStatusCode.OK) { _logger.LogDebug($"UpdateDeliveryStatus: Delivery {delivery.DeliveryId} " + $"updated successfully with status {delivery.Status}"); } else { _logger.LogError($"UpdateDeliveryStatus: {putResult}"); } return(delivery); }
/// <returns></returns> private async Task <ProcessResult <DeliveryModel> > DeliveryNotificationsAsync(long deliveryKey) { ProcessResult <DeliveryModel> retVal; try { DeliveryModel dmodel = await _deliveryQueries.GetDeliveryAsync(deliveryKey); var pushNotification = new PushNotification(dmodel.Notification.Title, dmodel.Notification.Message, dmodel.Notification.IconUrl, dmodel.Notification.Url, dmodel.Notification.ImageUrl); PushNotificationPayload payload = new PushNotificationPayload(pushNotification); ProcessResult result = await _pushService.SendAsync(dmodel.Subscription.Endpoint, dmodel.Subscription.PublicKey, dmodel.Subscription.Token, payload); retVal = new ProcessResult <DeliveryModel>(dmodel); retVal.PopulateErrorFromResult(result); } catch (Exception ex) { retVal = new ProcessResult <DeliveryModel>(); retVal.SetErrorInfo($"DeliveryNotification Error: {ex.Message}"); } return(retVal); }
public ActionResult InsertDelivery(string IDNumber, string FirstName, string Surname, string DOB, int Age, string Gender) { DeliveryModel x = new DeliveryModel(); string query = "INSERT INTO [DeliveryDb].[dbo].[DeliveryTbl]([IDNumber],[FirstName],[Surname],[DOB],[Age],[Gender])VALUES(@IDNumber, @FirstName, @Surname, @DOB, @Age, @Gender)"; string conne = ConfigurationManager.ConnectionStrings["conne"].ConnectionString; using (SqlConnection con = new SqlConnection(conne)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@IDNumber", IDNumber); cmd.Parameters.AddWithValue("@FirstName", FirstName); cmd.Parameters.AddWithValue("@Surname", Surname); cmd.Parameters.AddWithValue("@DOB", DOB); cmd.Parameters.AddWithValue("@Age", Age); cmd.Parameters.AddWithValue("@Gender", Gender); cmd.Connection = con; con.Open(); cmd.ExecuteReader(); con.Close(); } } return(View("Index")); }
public ActionResult UpdateDelivery(int id) { DeliveryModel delivery = new DeliveryModel(); string query = "UPDATE [DeliveryDb].[dbo].[DeliveryTbl] SET IdNo= [IDNumber], Fname=[FirstName], Sname=[Surname], WHERE id=[IDNumber]"; string conne = ConfigurationManager.ConnectionStrings["conne"].ConnectionString; using (SqlConnection con = new SqlConnection(conne)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@IDNumber", delivery.IDNumber); cmd.Parameters.AddWithValue("@FirstName", delivery.FirstName); cmd.Parameters.AddWithValue("@Surname", delivery.Surname); cmd.Connection = con; con.Open(); cmd.ExecuteReader(); con.Close(); } } return(new EmptyResult()); }
private async void DeliveryButton_Clicked(object sender, EventArgs e) { CourierModel courier = CourierPicker.SelectedItem as CourierModel; if (DeliveryButton.Text.ToLower() == "završi" && PotencialDelivery != null) { if (await CheckDelivery(PotencialDelivery)) { try { PotencialDelivery.PaymentTypeID = PaymentTypePicker.SelectedIndex + 1; PotencialDelivery.DeliveryTypeID = DeliverTypePicker.SelectedIndex + 1; PotencialDelivery.CourierID = courier.CourierID; PotencialDelivery.StartAddress.Zone = Convert.ToInt32(ZoneStart.Value); PotencialDelivery.EndAddress.Zone = Convert.ToInt32(ZoneEnd.Value); PotencialDelivery.CreateTime = DateTime.Now; if (await StartAddressCheck()) { await DisplayAlert("Greska", "", "Potvrdi"); } if (await EndAddressCheck()) { await DisplayAlert("Greska", "", "Potvrdi"); } DeliveryModel dtodel = PotencialDelivery; dtodel.StartAddress = null; dtodel.EndAddress = null; var PostDelivery = await deliveryService.CreateDelivery(dtodel); if (PostDelivery != null) { await DisplayAlert("BaraBara", "Dostava je poslata kuriru", "Potvrdi."); await Navigation.PopToRootAsync(); } else { await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi"); } } catch (Exception ex) { await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo. " + Environment.NewLine + "Tekst greške : " + ex.Message, "Potvrdi"); } } else { await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi"); } } else { await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi"); } }
public void confirmDeliver([FromBody] DeliveryModel deliveryModel) { int empid = (int)deliveryModel.EmployeeID; int depid = deliveryModel.DepartmentID; new DeliverRepo().ConfirmDeliveryToDep(empid, depid); }
public IActionResult DeleteConfirmed(string id) { DeliveryModel delivery = _context.Deliveries.Find(id); _context.Deliveries.Remove(delivery); _context.SaveChanges(); return(RedirectToAction("Index")); }
public DeliveryDetailPage(DeliveryModel delivery) { helper = new SQLiteHelper(); _connection = DependencyService.Get <ISQLiteDb>().GetConnection(); this.delivery = delivery; BindingContext = this.delivery; InitializeComponent(); }