private void loadCourierCombo() { try { conDB = new ConnectionDB(); CourierModel courier = new CourierModel(); string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); cmbCourier.Items.Clear(); while (reader.Read()) { courier.ID = reader["ID"].ToString(); courier.CourierName = reader["couriername"].ToString(); courier.Description = reader["description"].ToString(); cmbCourier.Items.Add(courier); courier = new CourierModel(); } conDB.closeConnection(); } catch (Exception ex) { conDB.writeLogFile("LOAD COURIER COMBO NO PARAM" + "-" + ex.Message.ToString()); } }
private void loadCourierCombo(DirectSalesModel directSales) { conDB = new ConnectionDB(); CourierModel courier = new CourierModel(); string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); cmbCourier.Items.Clear(); while (reader.Read()) { courier.ID = reader["ID"].ToString(); courier.CourierName = reader["couriername"].ToString(); courier.Description = reader["description"].ToString(); cmbCourier.Items.Add(courier); if (directSales.CourierID.Equals(courier.ID)) { cmbCourier.SelectedItem = courier; } courier = new CourierModel(); } conDB.closeConnection(); }
private void loadCourierCombo(DirectSalesModel directSales) { try { conDB = new ConnectionDB(); CourierModel courier = new CourierModel(); string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); cmbCourier.Items.Clear(); while (reader.Read()) { courier.ID = reader["ID"].ToString(); courier.CourierName = reader["couriername"].ToString(); courier.Description = reader["description"].ToString(); cmbCourier.Items.Add(courier); if (directSales.CourierID.Equals(courier.ID)) { cmbCourier.SelectedItem = courier; } courier = new CourierModel(); } conDB.closeConnection(); } catch (Exception ex) { conDB.writeLogFile("LOAD COURIER ON COMBO" + "-" + ex.Message.ToString() + "||" + ex.StackTrace); } }
public List <CourierModel> GetCouriers() { var couriers = new List <CourierModel>(); const string query = "Select * from couriers;"; using (MySqlConnection conn = new MySqlConnection(WebApiConfig.ConnectionString)) using (MySqlCommand command = new MySqlCommand(query, conn)) { conn.Open(); using (var reader = command.ExecuteReader()) { while (reader.HasRows) { while (reader.Read()) { var courier = new CourierModel { Id = reader.GetInt32(0), Courier = reader.GetString(1), URL = reader.GetString(2), }; couriers.Add(courier); } reader.NextResult(); } } } return(couriers); }
public async Task <IEnumerable <CourierModel> > GetAllCouriers() { try { List <CourierModel> CourierList = new List <CourierModel>(); var listOfUsers = await context.Users.ToListAsync(); var listOfUserRoles = context.UserRoles.Where(ur => ur.RoleID == 4).ToList(); foreach (var item in listOfUserRoles) { var usr = listOfUsers.Where(u => u.UserID == item.UserID).FirstOrDefault(); if (usr != null) { CourierModel c = new CourierModel() { CourierFullName = usr.FirstName + " " + usr.LastName, CourierID = usr.UserID }; CourierList.Add(c); } } return(CourierList); } catch { return(null); } }
public void UpdateCourier(CourierModel c) { Courier c1 = db.Courier.Where(i => i.Id == c.Id).FirstOrDefault(); db.Entry(toCourier(c1, c)).State = EntityState.Modified; db.SaveChanges(); }
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 Courier toCourier(Courier c, CourierModel c1) { c.Id = c1.Id; c.LastName = c1.LastName; c.MiddleName = c1.MiddleName; c.FirstName = c1.FirstName; c.Phone = c1.Phone; c.Login = c1.Login; c.Password = c1.Password; return(c); }
private void updateDirectSalesRecord(DirectSalesModel directSalesModel) { conDB = new ConnectionDB(); BankModel bb = cmbCashBank.SelectedItem as BankModel; CourierModel cc = cmbCourier.SelectedItem as CourierModel; string queryString = "UPDATE dbfh.tbldirectsales SET deliverydate = ?, clientname = ?, cashbankID = ?, " + "courierID = ?, expenses = ?, totalprice = ?, officeID = ?, remarks = ?, isPaid = ? WHERE ID = ?"; List <string> parameters = new List <string>(); DateTime date = DateTime.Parse(deliveryDateDS.Text); parameters.Add(date.Year + "/" + date.Month + "/" + date.Day); parameters.Add(txtClientName.Text); parameters.Add(bb.ID); parameters.Add(cc.ID); parameters.Add(txtExpenses.Text); parameters.Add(txtTotalPrice.Text); parameters.Add(cmbSalesOffice.SelectedValue.ToString()); parameters.Add(txtRemarks.Text); if (chkPaid.IsChecked.Value) { parameters.Add("1"); } else { parameters.Add("0"); } parameters.Add(directSalesModel.ID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private async Task <bool> GetDeliveriesFromServer() { CourierModel cmNull = new CourierModel { CourierFullName = "???" }; var list = await deliveryService.GetDeliveriesForDispatcher(); if (list != null) { listOfDeliveries = new List <ExtendedDeliveryModel>(list); #region sqlLite //await _connection.DropTableAsync<DeliveryModel>(); // await _connection.CreateTableAsync<DeliveryModel>(); //int x = await _connection.UpdateAsync(item); //if (x == 0) //{ // await _connection.InsertAsync(item); //} #endregion if (listOfCouriers != null) { foreach (var item in listOfDeliveries) { var cm = listOfCouriers.Where(u => u.CourierID == item.CourierID).FirstOrDefault(); if (cm != null) { item.Courier = cm; } else { item.Courier = cmNull; } //Delivery detail image switch (item.DeliveryStatus) { case 4: item.DeliveryStatusImageSource = "delivered.png"; break; case 3: item.DeliveryStatusImageSource = "zeleni50.png"; break; case 2: item.DeliveryStatusImageSource = "zuti50.png"; break; case 1: item.DeliveryStatusImageSource = "crveni50.png"; break; default: item.DeliveryStatusImageSource = "crveni50.png"; break; } } } DeliveryList.ItemsSource = listOfDeliveries; return(true); } else { Message.Text = "No deliveries to show."; Message.IsVisible = true; Message.IsEnabled = true; return(false); } }
private async void DeliveryButton_Clicked(object sender, EventArgs e) { CourierModel courier = CourierPicker.SelectedItem as CourierModel; if (delivery != null) { if (await CheckDelivery(delivery)) { //switch (delivery.DeliveryStatus) //{ // case 0: // delivery.DeliveryStatus = 1; // break; // case 1: // delivery.DeliveryStatus = 1; // break; // case 2: // delivery.DeliveryStatus = 2; // break; // case 3: // delivery.DeliveryStatus = 3; // break; // case 4: // delivery.DeliveryStatus = 4; // break; //} delivery.PaymentTypeID = PaymentTypePicker.SelectedIndex + 1; delivery.DeliveryTypeID = DeliverTypePicker.SelectedIndex + 1; delivery.CourierID = courier.CourierID; delivery.StartAddress.Zone = Convert.ToInt32(ZoneStart.Value); delivery.EndAddress.Zone = Convert.ToInt32(ZoneEnd.Value); if (!await StartAddressCheck()) { await DisplayAlert("Greska", "", "Potvrdi"); } ///Nova End Addressa // var postEndAddress = await addressService.PostFullAddress(startAddress); //PotencialDelivery.EndAddressID = await TypeHelp(postEndAddress); if (!await EndAddressCheck()) { await DisplayAlert("Greska", "", "Potvrdi"); } //if (!checkStartAddress(startAddress)) // { // // delivery.StartAddressID = delivery.StartAddressID; // object sAddress = await addressService.PostFullAddress(startAddress); // delivery.StartAddressID = await TypeHelp(sAddress); //} // if (!checkEndAddress(endAddress)) // { // // newDelivery.EndAddressID = delivery.EndAddressID; // object eAddress = await addressService.PostFullAddress(endAddress); // delivery.EndAddressID = await TypeHelp(eAddress); //} try { var PostDelivery = await deliveryService.EditDelivery(delivery as DeliveryModel); if (PostDelivery != null) { await DisplayAlert("BaraBara", "Dostava je ažurirana.", "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"); } } } }
private async Task <bool> GetDeliveriesFromServer(DateTime OD, DateTime DO) { CourierModel cmNull = new CourierModel { CourierFullName = "???" }; ////erro casting list of objects /// var list = await deliveryService.GetDeliveriesByDate(OD, DO); if (list != null) { listOfDeliveries = new List <ExtendedDeliveryModel>(); foreach (var item in list) { switch (item.DeliveryStatus) { case 4: item.DeliveryStatusImageSource = "delivered.png"; break; case 3: item.DeliveryStatusImageSource = "zeleni50.png"; break; case 2: item.DeliveryStatusImageSource = "zuti50.png"; break; case 1: item.DeliveryStatusImageSource = "crveni50.png"; break; default: item.DeliveryStatusImageSource = "crveni50.png"; break; } ExtendedDeliveryModel extD = new ExtendedDeliveryModel(); extD = item.ConvertToExtended(); if (listOfCouriers != null) { var cm = listOfCouriers.Where(u => u.CourierID == item.CourierID).FirstOrDefault(); if (cm != null) { extD.Courier = cm; } else { extD.Courier = cmNull; } } //Delivery detail image listOfDeliveries.Add(extD); } DeliveryList.ItemsSource = listOfDeliveries; DeliveryListOrderBy(); return(true); } else { Message.Text = "No deliveries to show."; Message.IsVisible = true; Message.IsEnabled = true; return(false); } }
public void DeleteCourier(CourierModel s) { db.Courier.Remove(db.Courier.Find(s.Id)); }
public void addCourier(CourierModel z) { db.Courier.Add(toCourier(new Courier(), z)); }