static void Main(string[] args)
{
List <IMensaje> mensajes = new List <IMensaje>();
Paloma paloma = new Paloma("Azir", "Shurima");
Courier courier = new Courier("Leandro", "Sobrino", "42429218");
Carta carta = new Carta("A4", 1, "Lobo");
Email mail = new Email("*****@*****.**", "*****@*****.**");
mensajes.Add(paloma);
mensajes.Add(courier);
mensajes.Add(carta);
mensajes.Add(mail);
foreach (IMensaje item in mensajes)
{
Console.WriteLine(item.EnviarMensaje());
}
Console.ReadKey();
}
public Courier <AppRole> GetUserRole(AppUser user)
{
Courier <AppRole> courier = new Courier <AppRole>();
string userRoleId = user.Roles.Single().RoleId;
courier.Package = roleMgr.FindById(userRoleId);
if (courier.Package != null &&
userMgr.IsInRole(user.Id, courier.Package.Name))
{
courier.Success = true;
}
else
{
courier.Success = false;
courier.Message = "Given user did not match with a role";
}
return(courier);
}
public async Task <Guid> AddRouteAsync(Guid courierId, RouteDto newCurrentRoute)
{
using (var db = new CourierHelperDb(_connectionString))
{
Courier courier = db.CouriersRepo.Get(courierId);
if (courier == null)
{
throw new ArgumentException(); //todo: exception
}
if (courier.Routes.Any(r => r.IsCurrent))
{
throw new Exception(); //todo: exception
}
Route route = new Route
{
Created = DateTime.Now,
Edited = DateTime.Now,
Synced = DateTime.Now,
IsCurrent = true,
Distance = newCurrentRoute.Distance
};
foreach (var point in newCurrentRoute.Points)
{
route.Points.Add(new ActivePoint()
{
Coordinates = new Point(point.Longitude, point.Latitude)
});
}
courier.Routes.Add(route);
await db.SaveAsync();
return(route.Id);
}
}
public Courier GetCourierByUsernamePassword(string login, string password)
{
Courier courier = null;
string connectionString = "Data Source=153.109.124.35;Initial Catalog=VsEatPiguetBerthouzoz;Integrated Security=False;User Id=6231db;Password=Pwd46231.;MultipleActiveResultSets=True";
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
string query = "Select * from Courier where login = @login and @password = password";
SqlCommand cmd = new SqlCommand(query, cn);
cmd.Parameters.AddWithValue("@login", login);
cmd.Parameters.AddWithValue("@password", password);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
courier = new Courier();
courier.IdCourier = (int)dr["IdCourier"];
courier.name = (string)dr["name"];
courier.login = (string)dr["login"];
courier.password = (string)dr["password"];
courier.IdCity = (int)dr["IdCity"];
}
}
}
}
catch (Exception e)
{
throw e;
}
return(courier);
}
public Courier <Manufacturer> CreateNewMake(string newMakeName, string username)
{
Courier <Manufacturer> courier = new Courier <Manufacturer>();
List <Manufacturer> currentMakes = repo.GetMakes();
foreach (var m in currentMakes)
{
if (m.ManufacturerName.ToUpper() == newMakeName.ToUpper())
{
throw new Exception();
}
}
Manufacturer newMake = new Manufacturer()
{
ManufacturerName = newMakeName,
DateAdded = DateTime.Now,
Username = username
};
repo.AddMake(newMake);
var changedState = repo.GetMakes();
foreach (var m in changedState)
{
if (m.ManufacturerName == newMakeName &&
m.Username == username)
{
courier.Success = true;
courier.Package = m;
return(courier);
}
}
courier.Success = false;
courier.Message = "Add make was unsuccessful at inserting a new make into the database";
return(courier);
}
// Вивести СЛУЖБИ ДОСТАВКИ
public static List <Courier> getCouriers()
{
List <Courier> list = new List <Courier>();
try
{
MySqlCommand command = new MySqlCommand("SELECT * FROM fruitsvegetables.couriers", connect);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Courier x = new Courier(reader.GetInt32(0), reader.GetString(1),
reader.GetString(2), reader.GetFloat(3));
list.Add(x);
}
reader.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show(ex.Message);
}
return(list);
}
public JsonResult Create([Bind(Include = "WarehouseID,NumberCode,Fk_BranchID,CreationDate,Fk_ShipperID,Fk_Consignee,Fk_Agent,Fk_DeliveryCompany,Fk_Condition,Description,Fk_Origin,Fk_Destination")] Warehouse wareHouse, List <Courier> courier, string[] types)
{
GenerateId generator = new GenerateId();
wareHouse.WarehouseID = generator.generateID();
db.Warehouses.Add(wareHouse);
db.SaveChanges();
////Add Types
List <WarehouseTypeRelation> typeList = new List <WarehouseTypeRelation>();
foreach (var item in types)
{
var idType = db.WarehouseTypes.Where(x => x.TypeName == item).Select(x => x.TypeId).SingleOrDefault();
WarehouseTypeRelation typeItem = new WarehouseTypeRelation();
typeItem.WarehouseTypeRelationId = generator.generateID();
typeItem.WarehouseId = wareHouse.WarehouseID;
typeItem.TypeId = idType;
typeList.Add(typeItem);
}
foreach (var item in courier)
{
Courier courierItem = new Courier();
item.CourierID = generator.generateID();
item.CreationDate = DateTime.Now;
item.Deleted = false;
item.Fk_WarehouseID = wareHouse.WarehouseID;
db.Couriers.Add(item);
}
foreach (var item in typeList)
{
db.WarehouseTypeRelations.Add(item);
}
db.SaveChanges();
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public FrayteResult DeleteCourier(int courierId)
{
FrayteResult result = new FrayteResult();
try
{
var courier = new Courier {
CourierId = courierId
};
dbContext.Couriers.Attach(courier);
dbContext.Couriers.Remove(courier);
dbContext.SaveChanges();
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
result.Errors = new List <string>();
result.Errors.Add(ex.Message);
}
return(result);
}
public int AddEditCourier(Courier courier)
{
string sqlCommand = "spAddEditCourier";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@kode", courier.kode);
parameters.Add("@nm", courier.nm);
parameters.Add("@statusx", courier.statusx);
parameters.Add("@tlp", courier.tlp);
parameters.Add("@jns_kendaraan", courier.jns_kendaraan);
using (SqlCommand cmd = General.GetCommand(sqlCommand, parameters))
{
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
return(cmd.ExecuteNonQuery());
}
}
public Courier GetCourier(int id)
{
Courier courier = null;
//string connectionString = Configuration.GetConnectionString("DefaultConnection");
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
string query = "SELECT * FROM Courier WHERE IdCourier = @id ";
SqlCommand cmd = new SqlCommand(query, cn);
cmd.Parameters.AddWithValue("@id", id);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
courier = new Courier();
courier.IdCourier = (int)dr["IdCourier"];
courier.name = (string)dr["name"];
courier.login = (string)dr["login"];
courier.password = (string)dr["password"];
courier.IdCity = (int)dr["IdCity"];
}
}
}
}
catch (Exception e)
{
throw e;
}
return(courier);
}
public Courier GetCourier(int id)
{
Courier courier = null;
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
string query = "Select * from Courier where IdCourier = @id";
SqlCommand cmd = new SqlCommand(query, cn);
cmd.Parameters.AddWithValue("@id", id);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
courier = new Courier();
courier.IdCourier = (int)dr["IdCourier"];
courier.Firstname = (string)dr["Firstname"];
courier.Lastname = (String)dr["Lastname"];
courier.Country_code = (int)dr["Country_code"];
courier.Email = (String)dr["Email"];
courier.Password = (String)dr["Password"];
}
}
}
}
catch (Exception e)
{
throw e;
}
return(courier);
}
public FrayteCourier SaveCourier(FrayteCourier courier)
{
Courier newCourier;
if (courier.CourierId > 0)
{
newCourier = dbContext.Couriers.Where(p => p.CourierId == courier.CourierId).FirstOrDefault();
newCourier.CourierName = courier.Name;
newCourier.DisplayName = CommonConversion.DisplayName(courier.Name);
newCourier.Website = courier.Website;
newCourier.ShipmentType = courier.CourierType;
newCourier.LatestBookingTime = UtilityRepository.GetTimeFromString(courier.LatestBookingTime).Value;
}
else
{
newCourier = new Courier();
newCourier.CourierId = courier.CourierId;
newCourier.CourierName = courier.Name;
newCourier.DisplayName = CommonConversion.DisplayName(courier.Name);
newCourier.Website = courier.Website;
newCourier.ShipmentType = courier.CourierType;
newCourier.LatestBookingTime = UtilityRepository.GetTimeFromString(courier.LatestBookingTime).Value;
dbContext.Couriers.Add(newCourier);
}
try
{
dbContext.SaveChanges();
}
catch (Exception ex)
{
}
courier.CourierId = newCourier.CourierId;
return(courier);
}
public List <Courier> getFutarFromDatabaseTable()
{
List <Courier> futarok = new List <Courier>();
MySqlConnection connection = new MySqlConnection(connectionString);
try
{
connection.Open();
string query = Courier.getSQLCommandGetAllRecord();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
bool goodResult = false;
string name = dr["fnev"].ToString();
int id = -1;
goodResult = int.TryParse(dr["fazon"].ToString(), out id);
if (goodResult)
{
string tel = dr["ftel"].ToString();
if (goodResult)
{
Courier f = new Courier(id, name, tel);
futarok.Add(f);
}
}
}
connection.Close();
}
catch (Exception e)
{
connection.Close();
Debug.WriteLine(e.Message);
throw new RepositoryException("Futar adatok beolvasása az adatbázisból nem sikerült!");
}
return(futarok);
}
public Courier <Vehicle> UpdateVehicle(Vehicle item)
{
Courier <Vehicle> courier = new Courier <Vehicle>();
item.Model = repo.GetModels().FirstOrDefault(n => n.NameplateId == item.NameplateId);
repo.EditVehicle(item);
var check = repo.GetVehicle(item.VehicleId);
if (check != null &&
check.Description == item.Description)
{
courier.Package = check;
courier.Success = true;
}
else
{
throw new Exception();
}
return(courier);
}
private void AddCourierButtonClick(object sender, RoutedEventArgs e)
{
string firstname = FirstNameCourier.Text;
string lastname = LastNameCourier.Text;
bool isFirstnameValid = firstname.All(Char.IsLetter);
bool isLastnameValid = lastname.All(Char.IsLetter);
if (isFirstnameValid == true && isLastnameValid == true)
{
Courier courier = new Courier()
{
FirstName = firstname, LastName = lastname, isFree = false
};
courierServices.AddData(courier);
MessageBox.Show("Row was inserted successfully");
RefreshCourierDataGridView();
}
else
{
MessageBox.Show("Invalid data!");
}
}
private void OnNewCour(object sender, Courier courier)
{
//if (courier.Team==Main.Owner.Team)
// return;
if (Couriers.Any(x => x.Cour.Equals(courier)))
{
Log.Error($"Cant init this Cour -> {courier.GetDisplayName()} [{courier.Handle}]");
return;
}
var myTeam = Main.Context.Value.Owner.Team;
var targetTeam = courier.Team;
var isAlly = myTeam == targetTeam;
var newHero = new CourContainer(courier, isAlly, Main);
try
{
Couriers.Add(newHero);
if (isAlly)
{
AllyCouriers.Add(newHero);
}
else
{
EnemyCouriers.Add(newHero);
}
Log.Info(
$"New courier -> {courier.GetDisplayName()} [{courier.Handle}] [{(isAlly ? "Ally" : "Enemy")}]");
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
// Personal data and list of the orders of the courier
public ActionResult Deliver()
{
string name = User.Identity.Name;
User user = UserManager.GetUserByEmail(name);
Courier courier = CourierManager.GetCourierByUserId(user.IdUser);
var orderslist = new List <Order>();
if (OrderManager.GetOrdersByCourier(courier.IdCourier) != null)
{
orderslist = OrderManager.GetOrdersByCourier(courier.IdCourier);
}
//order by the idOrder descending
var descendingOrder = orderslist.OrderByDescending(i => i.IdOrder);
var orderCustomer = new List <OrderCustomer>();
foreach (var item in descendingOrder)
{
var order = new OrderCustomer();
order.order = item;
var customer = CustomerManager.GetCustomer(item.IdClient);
var customerdata = UserManager.GetUser(customer.IdUser);
order.user = customerdata;
order.city = CityManager.GetCity(customerdata.IdCity);
orderCustomer.Add(order);
}
var deliverData = new DeliverData();
deliverData.orderlist = orderCustomer;
deliverData.user = user;
deliverData.city = CityManager.GetCity(user.IdCity);
return(View(deliverData));
}
static void Main(string[] args)
{
var array = new Courier[]
{
new Courier {
IsFree = true
},
new Courier {
IsFree = true
},
new Courier {
IsFree = true
},
};
CourierCollection collection = new CourierCollection(array);
var order = new Order <ShopDelivery>();
order.Delivery.MakeDelivery();
//
//
//
}
public async Task <RouteDto> SyncRoute(Guid courierId)
{
using (var db = new CourierHelperDb(_connectionString))
{
Courier courier = db.CouriersRepo.Get(courierId);
if (courier == null)
{
throw new Exception(); //todo: exception
}
Route notSyncedRoute = courier.Routes.Single(r => r.IsCurrent && (r.Synced == null || r.Edited > r.Synced));
notSyncedRoute.Synced = DateTime.Now;
db.RoutesRepo.Update(notSyncedRoute);
await db.SaveAsync();
RouteDto notSyncedRouteDto = Mapper.Map <RouteDto>(notSyncedRoute);
return(notSyncedRouteDto);
}
}
/// <summary>
/// Update courier
/// </summary>
public async Task <CourierResponse> UpdateAsync(int id, Courier courier)
{
var courierToBeUpdated = await _courierRepository.FindByIdAsync(id);
if (courierToBeUpdated == null)
{
return(new CourierResponse("Courier not found."));
}
courierToBeUpdated.Name = courier.Name;
try
{
_courierRepository.Update(courierToBeUpdated);
await _unitOfWork.CompleteAsync();
return(new CourierResponse(courierToBeUpdated));
}
catch (Exception e)
{
// TODO logging
return(new CourierResponse($"An error occurred when updating the courier: {e.Message}"));
}
}
public async Task <Guid> AddCourierAsync(CourierDto courierDto)
{
if (string.IsNullOrWhiteSpace(courierDto.PhoneNumber))
{
throw new ArgumentException("Phone number is required"); //todo: better exception
}
using (var db = new CourierHelperDb(_connectionString))
{
Courier courier = new Courier
{
FirstName = courierDto.FirstName,
LastName = courierDto.LastName,
MiddleName = courierDto.MiddleName,
Email = courierDto.Email,
PhoneNumber = courierDto.PhoneNumber,
State = (CourierState)courierDto.State
};
if (courierDto.Location != null)
{
ActivePoint location = new ActivePoint
{
Coordinates = new Point(courierDto.Location.Longitude, courierDto.Location.Latitude)
};
courier.Location = location;
}
db.CouriersRepo.Create(courier);
await db.SaveAsync();
courierDto.Id = courier.Id;
return(courier.Id);
}
}
public Courier <VehicleUnitReportParcel> GetVehicleAccount(Vehicle vehicle)
{
Courier <VehicleUnitReportParcel> courier = new Courier <VehicleUnitReportParcel>();
VehicleUnitReportParcel parcel = new VehicleUnitReportParcel()
{
NameplateId = vehicle.NameplateId,
ProductionYear = vehicle.ProductionYear,
MSRP = vehicle.MSRP
};
if (vehicle.Mileage > 1000)
{
parcel.InventoryType = InventoryType.Used;
}
else
{
parcel.InventoryType = InventoryType.New;
}
courier.Package = parcel;
return(courier);
}
public string GetCourierSearchPGUrl(About about, Courier courier, int pageNum)
{
string result = "";
string loginUrl = about.ServerUrl;
IDictionary <string, string> parameters = new Dictionary <string, string>();
string datetime = UnixTime.ConvertDateTimeToUnixTime(DateTime.Now).ToString();
string token = CMD5.UserMd5(about.CabinetCode) + CMD5.UserMd5(datetime);
parameters.Add("token", CMD5.UserMd5(token));
parameters.Add("cabinetCode", about.CabinetCode);
parameters.Add("courierCode", courier.Code);
parameters.Add("datetime", datetime);
parameters.Add("reqPageNum", pageNum.ToString());
parameters.Add("c", "Courier");
parameters.Add("a", "packstatus");
StringBuilder buffer = new StringBuilder();
int i = 0;
foreach (string key in parameters.Keys)
{
if (i > 0)
{
buffer.AppendFormat("&{0}={1}", key, parameters[key]);
}
else
{
buffer.AppendFormat("{0}={1}", key, parameters[key]);
}
i++;
}
result = about.ServerUrl + "?" + buffer.ToString();
return(result);
}
public void AddCourier(Courier courier)
{
_context.Courier.Add(courier);
_context.SaveChanges();
}
public int Add(Courier courier)
{
courier.CourierCreateTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
courier.CourierNum = DateTime.Now.ToString("yyMMddhhmmssffff");
return(Cdal.Add(courier));
}
public Courier <List <Vehicle> > GetSearchResult(SearchParcel parcel)
{
IEnumerable <Vehicle> list = repo.GetInventory(parcel.InventoryType);
if (!string.IsNullOrWhiteSpace(parcel.Keyword))
{
list = list.Where(v =>
v.Model.NameplateMarque.ToUpper().Contains(parcel.Keyword.ToUpper()) ||
v.Model.Manufacturer.ManufacturerName.ToUpper().Contains(parcel.Keyword.ToUpper()) ||
v.ProductionYear.ToString().Contains(parcel.Keyword));
}
list = list.Where(v =>
v.ProductionYear <= parcel.MaxYear &&
v.ProductionYear >= parcel.MinYear);
list = list.Where(v =>
(v.SalePrice <= parcel.MaxPrice &&
v.SalePrice >= parcel.MinPrice) ||
(v.MSRP <= parcel.MaxPrice &&
v.MSRP >= parcel.MinPrice));
Courier <List <Vehicle> > courier = new Courier <List <Vehicle> >();
courier.Package = list.ToList();
if (courier.Package.Count == 0)
{
courier.Success = false;
courier.Message = "No results found given filter settings.";
}
else
{
courier.Success = true;
}
return(courier);
//switch (parcel.GetParcelDirection())
//{
// case 1:
// return ByPrice(parcel.MinPrice, parcel.MaxPrice, parcel.InventoryType);
// case 10:
// return ByYear(parcel.MinYear, parcel.MaxYear, parcel.InventoryType);
// case 11:
// return ByYearAndPrice(parcel);
// case 100:
// return ByKeyword(parcel.Keyword, parcel.InventoryType);
// case 101:
// return ByKeywordAndPrice(parcel);
// case 110:
// return ByKeywordAndYear(parcel);
// case 111:
// return FullSearch(parcel);
// default:
// return new Courier<SearchResultPackage>() { Success = true, Package = new SearchResultPackage() { Vehicles = repo.GetInventory(parcel.InventoryType).OrderByDescending(v => v.MSRP).Take(20).ToList() } };
//}
//if (parcel.PackagedKeyword && parcel.PackagedYearRange && parcel.PackagedPriceRange)
//{
// return FullSearch(parcel);
//}
//else if (parcel.PackagedKeyword && parcel.PackagedYearRange || parcel.PackagedKeyword && parcel.PackagedPriceRange)
//{
// if (parcel.PackagedYearRange)
// {
// return ByKeywordAndYear(parcel);
// }
// else
// {
// return ByKeywordAndPrice(parcel);
// }
//}
//else if (parcel.PackagedYearRange && parcel.PackagedPriceRange)
//{
// return ByYearAndPrice(parcel);
//}
//else
//{
// if (parcel.PackagedKeyword)
// {
// return ByKeyword(parcel.Keyword, parcel.InventoryType);
// }
// else if (parcel.PackagedYearRange)
// {
// return ByYear(parcel.MinYear, parcel.MaxYear, parcel.InventoryType);
// }
// else if (parcel.PackagedPriceRange)
// {
// return ByPrice(parcel.MinPrice, parcel.MaxPrice, parcel.InventoryType);
// }
// else
// {
// return new Courier<SearchResultPackage>() { Success = true, Package = new SearchResultPackage() { Vehicles = repo.GetInventory(parcel.InventoryType).OrderByDescending(v => v.MSRP).Take(20).ToList() } };
// }
//}
}
public void Remove(Courier courier)
{
_context.Couriers.Remove(courier);
}
/// <summary>
/// Update existing Courier
/// </summary>
public void Update(Courier courier)
{
_context.Couriers.Update(courier);
}
public ResponseDetail SaveCourierAmount(Courier objModel)
{
ResponseDetail objResponse = objTransacAPI.SaveCourierAmount(objModel);
return(objResponse);
}
/// <summary>
/// Add courier to database
/// </summary>
public async Task AddAsync(Courier courier)
{
await _context.Couriers.AddAsync(courier);
}
