public async Task <Courier> CreateCourier(Courier courier) { var savedCourier = await Couriers.AddAsync(courier); SaveChanges(); return(savedCourier.Entity); }
public static void Mailing(TelegramBotClient bot, string text) { foreach (var id in Couriers.Select(x => x.ChatId)) { bot.SendTextMessageAsync(id, text); } }
public OrdersDataGenerator() { Regions = GetRegionFaker(GetRegions()).Generate(5); Temperatures = GetTemperatureFaker(GetTemperatures()).Generate(4); Addresses = GetAddressFaker(GetCities(), GetStreets(), GetZipCodes(), Regions.Select(x => x.RegionId)).Generate(20); Restaurants = GetRestaurantFaker(GetRestaurants(), Addresses.Select(x => x.AddressId)).Generate(10); Menus = GetMenuFaker(GetMenus(), Restaurants.Select(x => x.RestaurantId)).Generate(3); MenuItems = GetMenuItemFaker(GetMenuItems(), Temperatures.Select(x => x.TemperatureId), Menus.Select(x => x.MenuId)).Generate(20); Customers = GetCustomerFaker(GetFirstNames(), GetLastNames(), Addresses.Select(x => x.AddressId)).Generate(5); Ingredients = GetIngredientFaker(GetIngredients(), Temperatures.Select(x => x.TemperatureId)).Generate(15); InventoryItems = GetInventoryItemFaker(Ingredients.Select(x => x.IngredientId), Restaurants.Select(x => x.RestaurantId)).Generate(20); MenuItemIngredients = GetMenuItemIngredientFaker(MenuItems.Select(x => x.MenuItemId), Ingredients.Select(x => x.IngredientId)).Generate(50); var shelves = new List <ShelfEntity>(); for (int i = 0; i < 3; i++) { shelves.AddRange(GetShelfFaker(Temperatures.Select(x => x.TemperatureId), Restaurants.Select(x => x.RestaurantId)).Generate(1)); } shelves.AddRange(GetShelfFaker(Temperatures.Select(x => x.TemperatureId), Restaurants.Select(x => x.RestaurantId), true).Generate(1)); Shelves = shelves; Couriers = GetCourierFaker(GetFirstNames(), GetLastNames(), Addresses.Select(x => x.AddressId)).Generate(20); Orders = GetOrderFaker(Customers.Select(x => x.CustomerId), Restaurants.Select(x => x.RestaurantId), Addresses.Select(x => x.AddressId), Couriers.Select(x => x.CourierId)).Generate(10); OrderItems = GetOrderItemFaker(MenuItems.Select(x => x.MenuItemId), Orders.Select(x => x.OrderId), Shelves.Select(x => x.ShelfId)).Generate(20); }
// מחזיר משלוחן עם רשימת נקודות על המפה public static MapTOCurios GetCourierDetailMaps(CourierDTO courier) { Couriers C = db.Couriers.FirstOrDefault(c => c.CourierId == courier.CourierId); MapTOCurios MTC = new MapTOCurios(); MTC.CourierId = courier.CourierId; MTC.CourierFirstName = courier.CourierFirstName; MTC.CourierLastName = courier.CourierLastName; List <Packages> P = db.Packages.Where(p => p.CourierCode == courier.CourierId).ToList(); MTC.LatLng = new List <LanLng>(); LanLng latlng; if (P.Count != 0) { MTC.latitude = P.First(p => p.CourierCode == courier.CourierId).SourcePackageLat; MTC.longitude = P.First(p => p.CourierCode == courier.CourierId).SourcePackageLon; } foreach (var pac in P) { latlng = new LanLng(); latlng.Lat = pac.SourcePackageLat; latlng.Lng = pac.SourcePackageLon; MTC.LatLng.Add(latlng); latlng = new LanLng(); latlng.Lat = pac.DestinationPackageLat; latlng.Lng = pac.DestinetionPackageLon; MTC.LatLng.Add(latlng); } return(MTC); }
private void btnEditDirectSales_Click(object sender, RoutedEventArgs e) { courierToUpdate = dgvCourier.SelectedItem as Couriers; if (courierToUpdate != null) { txtCourierName.Text = courierToUpdate.CourierName; txtDescription.Text = courierToUpdate.Description; btnUpdate.Visibility = Visibility.Visible; btnSave.Visibility = Visibility.Hidden; } }
/// <summary> /// Asynchroniczne zadanie wczytujące wszystkich kurierów do kolekcji Couriers /// </summary> /// <param name="viewState"></param> /// <returns></returns> public async Task LoadDataAsync(MasterDetailsViewState viewState) { Couriers.Clear(); var data = await DataService.GetAllFromDatabaseAsync().ConfigureAwait(false); foreach (var item in data) { Couriers.Add((Courier)item); } if (viewState == MasterDetailsViewState.Both) { Selected = Couriers.First(); } }
public static bool UpdatePersonalDetails(Couriers courier) { var courierDetail = db.Couriers.FirstOrDefault(p => p.CourierTz == courier.CourierTz); courierDetail.CourierAddress = courier.CourierAddress; courierDetail.CourierCity = courier.CourierCity; courierDetail.CourierFirstName = courier.CourierFirstName; courierDetail.CourierId = courier.CourierId; //courierDetail.pa = courier.CourierPackage; courierDetail.CourierPersonalCode = courier.CourierPersonalCode; courierDetail.CourierPhone = courier.CourierPhone; courierDetail.CourierStatus = courier.CourierStatus; courierDetail.CourierTypeOfTransport = courier.CourierTypeOfTransport; db.SaveChanges(); return(true); }
private async void saveRecord() { try { conDB = new ConnectionDB(); MongoClient client = conDB.initializeMongoDB(); var db = client.GetDatabase("DBFH"); Couriers cr = new Couriers(); cr.CourierName = txtCourierName.Text; cr.Description = txtDescription.Text; var collection = db.GetCollection <Couriers>("Couriers"); collection.InsertOne(cr); } catch (Exception ex) { await window.ShowMessageAsync("ERROR", "Caused by: " + ex.StackTrace); } }
public static CourierDto ConvertDto(Couriers cou) { if (cou == null) { return(null); } return(new CourierDto() { CourierAddress = cou.CourierAddress, CourierCity = cou.CourierCity, CourierFirstName = cou.CourierFirstName, CourierId = cou.CourierId, CourierLastName = cou.CourierLastName, CourierPersonalCode = cou.CourierPersonalCode, CourierPhone = cou.CourierPhone, CourierStatus = cou.CourierStatus, CourierTypeOfTransport = cou.CourierTypeOfTransport, CourierTz = cou.CourierTz, }); }
private async void saveRecord() { Banks bank = cmbCashBank.SelectedItem as Banks; Couriers courier = cmbCourier.SelectedItem as Couriers; Clients cl = cmbClients.SelectedItem as Clients; try { conDB = new ConnectionDB(); MongoClient client = conDB.initializeMongoDB(); var db = client.GetDatabase("DBFH"); DirectSalesDaily ds = new DirectSalesDaily(); DateTime dte = DateTime.Parse(deliveryDateDS.Text); ds.DateOrdered = DateTime.Parse(dte.ToLocalTime().ToShortDateString()); ds.Client = cl; ds.Bank = bank; ds.Courier = courier; ds.Expenses = txtExpenses.Text; ds.Total = txtTotalPrice.Text; ds.Remarks = txtRemarks.Text; ds.TrackingNo = txtTrackingNumber.Text; ds.ProductsOrdered = lstProductsOrderedDS; ds.isCancelled = chkCancelled.IsChecked.Value; if (UserModel.isDSConsoAdmin) { ds.isPaid = chkPaid.IsChecked.Value; } var collection = db.GetCollection <DirectSalesDaily>("DirectSalesDaily"); collection.InsertOne(ds); } catch (Exception ex) { await window.ShowMessageAsync("ERROR", "Caused by: " + ex.StackTrace); } }
//public static Dal.Courier_TBL ConvertDal(Courier c) //{ //} public static CourierDTO ConvertDto(Couriers c) { if (c == null) { return(null); } return(new CourierDTO() { CourierId = c.CourierId, CourierPersonalCode = c.CourierPersonalCode, CourierTz = c.CourierTz, CourierFirstName = c.CourierFirstName, CourierLastName = c.CourierLastName, CourierAddress = c.CourierAddress, CourierCity = c.CourierCity, CourierPhone = c.CourierPhone, CourierStatus = c.CourierStatus, CourierTypeOfTransport = c.CourierTypeOfTransport, Lon = c.Lon, Lat = c.Lat, }); }
private async void updateRecord() { Clients slctdClients = cmbClients.SelectedItem as Clients; Banks slctdBnk = cmbCashBank.SelectedItem as Banks; Couriers slctdCourier = cmbCourier.SelectedItem as Couriers; try { conDB = new ConnectionDB(); MongoClient client = conDB.initializeMongoDB(); var db = client.GetDatabase("DBFH"); var filter = Builders <DirectSalesDaily> .Filter.And( Builders <DirectSalesDaily> .Filter.Where(p => p.Id == directSalesDailyToUpdate.Id)); var updte = Builders <DirectSalesDaily> .Update.Set("Client", slctdClients) .Set("Bank", slctdBnk) .Set("Courier", slctdCourier) .Set("Expenses", txtExpenses.Text) .Set("Total", txtTotalPrice.Text) .Set("Remarks", txtRemarks.Text) .Set("TrackingNo", txtTrackingNumber.Text) .Set("DateOrdered", DateTime.Parse(deliveryDateDS.Text)) .Set("isConsolidated", false) .Set("ProductsOrdered", lstProductsOrderedDS) .Set("isCancelled", chkCancelled.IsChecked.Value) .Set("isPaid", UserModel.isDSConsoAdmin ? chkPaid.IsChecked.Value : false) .Set("isConsolidated", UserModel.isDSConsoAdmin ? true : false); var collection = db.GetCollection <DirectSalesDaily>("DirectSalesDaily"); collection.UpdateOne(filter, updte); } catch (Exception ex) { await window.ShowMessageAsync("ERROR", "Cause by: " + ex.StackTrace); } }
public static void getNewPackage(Packages package1) { double? distance = 9999999999999999; Couriers selectC = new Couriers(); var CourierTypeOfTransport = 0; if (package1.Weigth <= 50) { CourierTypeOfTransport = 1; } if (package1.Weigth > 50 && package1.Weigth < 200) { CourierTypeOfTransport = 2; } if (package1.Weigth > 200) { CourierTypeOfTransport = 3; } List <Couriers> LC = db.Couriers.Where(c => c.CourierStatus == 2 && c.CourierTypeOfTransport.Value == CourierTypeOfTransport).ToList(); foreach (var c in LC) { // שליחה לפנויקציה שבןדקת מרחק // בחירת השליח שהצרחק שלו אכ קטן double?dis1 = GetDistance(c.Lat.Value, c.Lon.Value, package1.SourcePackageLat.Value, package1.SourcePackageLon.Value); double?dis2 = GetDistance(c.Lat.Value, c.Lon.Value, package1.SourcePackageLat.Value, package1.SourcePackageLon.Value); if (dis1 + dis2 < distance) { selectC = c; distance = dis1 + dis2; } } package1.CourierCode = selectC.CourierId; db.Packages.Add(package1); db.SaveChanges(); }
public bool packagesToCourier([FromBody] Couriers newCourier) { return(BL.CourierBL.AddNewCourier(newCourier)); }
public bool addCourier([FromBody] Couriers newCourier) { return(BL.CourierBL.AddNewCourier(newCourier)); }
public bool UpdateCourier([FromBody] Couriers courier) { return(BL.CourierBL.UpdatePersonalDetails(courier)); }
public async Task <Courier> GetCourier(int userId) { return(await Couriers.FirstOrDefaultAsync(courier => courier.UserId == userId)); }
public static CourierDTO Login(string CourierCode) { Couriers courier = db.Couriers.FirstOrDefault(p => p.CourierPersonalCode == CourierCode && p.CourierStatus == 1); return(CourierDTO.ConvertDto(courier)); }
public static void Update(EventArgs args) { if (!CanUpdate()) { return; } //var tempSummonlist = Var.Summons; //if (MenuVar.LastHitEnable) //{ // if (Var.Summons.Count > 0 && Var.Summons.Any(x => !x.Key.IsAlive)) // { // //foreach (var summon in Var.Summons.Where(x => !x.Key.IsAlive)) // //{ // // tempSummonlist.Remove(summon.Key); // //} // //Var.Summons.Clear(); // //Var.Summons = tempSummonlist; // } //} EnemyHeroes.Update(); AllyHeroes.Update(); Couriers.Update(); if (MenuVar.Maphack || MenuVar.DodgeEnable) { Methods.ShowMeMore.Maphack(); } MenuVar.TestEffectMenu = MainMenu.Menu.Item("effects"); MenuVar.CameraDistance = MainMenu.MenuSettings.Item("cameradistance"); if (!Utils.SleepCheck("Update.sleep")) { return; } Utils.Sleep(500, "Update.sleep"); if (MenuVar.ShowRoshanTimer) { Methods.ShowMeMore.Roshan(); } #region Runes Runes.Update(); #endregion Runes if (MenuVar.LastHitEnable && MenuVar.SummonsEnable || MenuVar.StackKey) { Common.UpdateAttackableSummons(); } #region Menu MainMenu.Update(); #endregion Menu #region Hero Var.Q = Var.Me.Spellbook.SpellQ; Var.W = Var.Me.Spellbook.SpellW; Var.E = Var.Me.Spellbook.SpellE; Var.R = Var.Me.Spellbook.SpellR; double apoint = Var.Me.ClassID == ClassID.CDOTA_Unit_Hero_ArcWarden ? 0.3 : UnitDatabase.Units.Find(x => x.UnitName == Var.Me.Name).AttackPoint; Var.HeroAPoint = apoint / (1 + Var.Me.AttacksPerSecond * Var.Me.BaseAttackTime / 100) * 1000; #endregion Hero #region Autoattack if (Var.AutoAttackMode != MenuVar.AutoAttackMode) { switch (MenuVar.AutoAttackMode) { case 0: Var.AutoAttackMode = 0; Common.Autoattack(Var.AutoAttackMode); break; case 1: Var.AutoAttackMode = 1; Common.Autoattack(Var.AutoAttackMode); break; case 2: Var.AutoAttackMode = 2; Common.Autoattack(Var.AutoAttackMode); break; } } #endregion Autoattack #region Target if (Var.Target != null && !Var.Target.IsVisible && !Orbwalking.AttackOnCooldown(Var.Target)) { Var.Target = TargetSelector.ClosestToMouse(Var.Me); } else if (Var.Target == null || !Orbwalking.AttackOnCooldown(Var.Target)) { var bestAa = Var.Me.BestAATarget(); if (bestAa != null) { Var.Target = Var.Me.BestAATarget(); } } #endregion Target #region Towers if (!Towers.TowerLoad) { Buildings.GetBuildings(); Towers.TowerLoad = true; } //else //{ // Towers.Load(); //} #endregion Towers }
// найти курьера с нужным Id public static Courier FindById(long chatId) { return(Couriers.Where(x => x.ChatId == chatId)?.FirstOrDefault()); }
// есть ли в базе курьер с таким Id public static bool IsAuth(long chatId) { return(Couriers.Any(x => x.ChatId == chatId)); }
public static CourierDTO ManagerLogin(string ManagerCode) { Couriers manager = db.Couriers.FirstOrDefault(p => p.CourierPersonalCode == ManagerCode && p.CourierStatus == 2); return(CourierDTO.ConvertDto(manager)); }
public IActionResult getUserDetails(int userId) { string StoredProcedureName = UsersProcedures.getUserDetails; Dictionary <string, object> Parameters = new Dictionary <string, object>(); Parameters.Add("@userId", userId); DataTable dt; dt = dbMan.ExecuteReader(StoredProcedureName, Parameters); if (dt == null) { return(StatusCode(500, "User not found")); } string type = Convert.ToString(dt.Rows[0]["type"]); if (type == "Normal") { NormalUsers user = new NormalUsers(); user.id = Convert.ToInt16(dt.Rows[0]["id"]); user.name = Convert.ToString(dt.Rows[0]["name"]); user.registrationDate = Convert.ToDateTime(dt.Rows[0]["registeration_date"]); user.email = Convert.ToString(dt.Rows[0]["email"]); user.address = Convert.ToString(dt.Rows[0]["address"]); user.rating = Convert.ToInt16(dt.Rows[0]["rating"]); user.password = Convert.ToString(dt.Rows[0]["password"]); user.imgUrl = Convert.ToString(dt.Rows[0]["img_url"]); user.type = type; user.gender = Convert.ToChar(dt.Rows[0]["gender"]); user.balance = Convert.ToInt32(dt.Rows[0]["balance"]); user.area = Convert.ToString(dt.Rows[0]["area"]); user.phoneNumbers = aux_getPhoneNumbers(user.id); return(Json(user)); } else if (type == "Courier") { Couriers user = new Couriers(); user.id = Convert.ToInt16(dt.Rows[0]["id"]); user.name = Convert.ToString(dt.Rows[0]["name"]); user.registrationDate = Convert.ToDateTime(dt.Rows[0]["registeration_date"]); user.email = Convert.ToString(dt.Rows[0]["email"]); user.address = Convert.ToString(dt.Rows[0]["address"]); user.rating = Convert.ToInt16(dt.Rows[0]["rating"]); user.password = Convert.ToString(dt.Rows[0]["password"]); user.imgUrl = Convert.ToString(dt.Rows[0]["img_url"]); user.type = type; user.area = Convert.ToString(dt.Rows[0]["area"]); user.phoneNumbers = aux_getPhoneNumbers(user.id); return(Json(user)); } else { User_Details user = new User_Details(); user.id = Convert.ToInt16(dt.Rows[0]["id"]); user.name = Convert.ToString(dt.Rows[0]["name"]); user.registrationDate = Convert.ToDateTime(dt.Rows[0]["registeration_date"]); user.email = Convert.ToString(dt.Rows[0]["email"]); user.address = Convert.ToString(dt.Rows[0]["address"]); user.rating = Convert.ToInt16(dt.Rows[0]["rating"]); user.password = Convert.ToString(dt.Rows[0]["password"]); user.imgUrl = Convert.ToString(dt.Rows[0]["img_url"]); user.type = type; user.phoneNumbers = aux_getPhoneNumbers(user.id); return(Json(user)); } }
public static bool AddNewCourier(Couriers courier) { //db.Customers.AddRange(courier); db.SaveChanges(); return(true); }
public async Task <ICollection <Courier> > GetCouriers() { return(await Couriers.ToListAsync()); }