public async Task <int> AddDeliveryAsync(DeliveryModel deliveryModel)
        {
            _dbContext.Deliveries.Add(deliveryModel);
            await _dbContext.SaveChangesAsync();

            return(deliveryModel.DeliveryId);
        }
Exemple #2
0
 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));
     }
 }
Exemple #3
0
        /// <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);
            }
        }
Exemple #4
0
        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));
        }
Exemple #10
0
        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 }));
        }
Exemple #11
0
        /// <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));
            }
        }
Exemple #12
0
        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());
            }
        }
Exemple #13
0
        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 { }
        }
Exemple #16
0
        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);
    }
Exemple #18
0
        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);
            }
        }
Exemple #19
0
        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);
        }
Exemple #20
0
        /// <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);
        }
Exemple #21
0
        /// <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);
        }
Exemple #22
0
        // 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();
        }
Exemple #23
0
        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);
        }
Exemple #24
0
        /// <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);
        }
Exemple #25
0
        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"));
        }
Exemple #26
0
        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());
        }
Exemple #27
0
        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");
            }
        }
Exemple #28
0
        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"));
        }
Exemple #30
0
 public DeliveryDetailPage(DeliveryModel delivery)
 {
     helper         = new SQLiteHelper();
     _connection    = DependencyService.Get <ISQLiteDb>().GetConnection();
     this.delivery  = delivery;
     BindingContext = this.delivery;
     InitializeComponent();
 }