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());
}
