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