private static string BuildBody(ProductsSet product, ClientSet client, int Price)
{
StringBuilder body = new StringBuilder();
string introduction = "De acuerdo a conversaciones previas habiendo expresado su interes por un/una "
+ product.Producto;
body.Append(introduction);
if(product.Marca !="")
{
body.Append(" de la marca " + product.Marca);
}
if (product.Modelo != "")
{
body.Append(" modelo " + product.Modelo);
}
body.AppendLine(" le envio informacion sobre este/esta " + product.Producto + "el cual podria interesarle:");
body.AppendLine();
body.AppendLine("Producto: " + product.Producto);
body.AppendLine("Modelo: " + product.Modelo);
body.AppendLine("Marca: " + product.Marca);
body.AppendLine("Año: " + product.Año);
body.AppendLine("Peso: " + product.Peso + " Kilos");
body.AppendLine("Potencia: " + product.Potencia + "CV");
body.AppendLine("Precio: " + Price + " Euros");
return body.ToString();
}
public Client(ClientSet client)
{
this.InitializeComponent();
_dataDC = ModelSingleton.getDataDC;
lps = new ObservableProductSearch(_dataDC);
lvProductSearched.ItemsSource = lps.Where(S => S.Enbusca == true.ToString() && S.Proveedor_ID == client.Id).ToList();
_client = client;
this.DataContext = client;
UpdateRequestedProductList();
Update_ListSoldProducts();
// Insert code required on object creation below this point.
}
private ClientSet <PickupDeliveryClient> GetDivisiblePDClientSet()
{
int lastID = Clients.Count;
ClientSet <PickupDeliveryClient> extSet = new ClientSet <PickupDeliveryClient>();
foreach (var delivery in Clients)
{
extSet.Add(new PickupDeliveryClient(delivery.ID, delivery.Delivery, 0));
}
foreach (var pickup in Clients)
{
extSet.Add(new PickupDeliveryClient(pickup.ID + lastID, 0, pickup.Pickup));
}
return(extSet);
}
private ConnectionHolder[] ClientsFor(ClientSet clientSet)
{
if (clientSet == ClientSet.ContactDiscovery)
{
return(contactDiscoveryClients);
}
else if (clientSet == ClientSet.KeyBackup)
{
throw new NotImplementedException("Needs to be implemented.");
}
else
{
throw new InvalidOperationException("Unknown attestation purpose");
}
}
public string JoinRoom(Client client, Server server)
{
if (RoomState == ClientRoomState.WaitingJoin)
{
ClientSet.Add(client);
if (ClientSet.Count >= roomMaxCount)
{
RoomState = ClientRoomState.WaitingBattle;
}
var awayUserData = ControllerManager.Instance.GetController <UserDataController>(RequestCode.UserData)
.UserData_Get(client.GetUsername, client, server);
BroadcastMessage(server, client, ActionCode.ClientRoom_Come, awayUserData);
return(awayUserData);
}
return("");
}
private void Editar()
{
if (clientSet1ViewSource.Items.Count > 0 && clientSet1ViewSource.SelectedItem != null)
{
String file = clientSet1ViewSource.SelectedItem.ToString();
ClientSet p = (ClientSet)clientSet1ViewSource.SelectedItem;
Client clientdetails = new Client(p);
clientdetails._new = false;
clientdetails.ShowDialog();
if (!clientdetails.Cancel)
{
_dataDC.SaveChanges();
}
}
}
private static ClientSet <PickupDeliveryClient> BuildSalhiMixedClientSet(List <Tuple <double, double, double> > clientInfo, int clientInterval)
{
ClientSet <PickupDeliveryClient> mixedSet = new ClientSet <PickupDeliveryClient>();
for (int i = 1; i < clientInfo.Count; i++)
{
if (i % clientInterval == 0)
{
mixedSet.Add(new PickupDeliveryClient(i, 0, clientInfo[i].Item3));
}
else
{
mixedSet.Add(new PickupDeliveryClient(i, clientInfo[i].Item3, 0));
}
}
return(mixedSet);
}
private void ClientList_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (ClientList.Items.Count > 0 && ClientList.SelectedItem != null)
{
String file = ClientList.SelectedItem.ToString();
ClientSet p = (ClientSet)ClientList.SelectedItem;
Client clientdetails = new Client(p);
clientdetails._new = false;
clientdetails.ShowDialog();
if (!clientdetails.Cancel)
{
_dataDC.SaveChanges();
}
}
}
private ClientSet <PickupDeliveryClient> GetMixedPCClienteSet(int clientInterval)
{
ClientSet <PickupDeliveryClient> extSet = new ClientSet <PickupDeliveryClient>();
foreach (var item in Clients)
{
if (item.ID % clientInterval == 0)
{
extSet.Add(new PickupDeliveryClient(item.ID, 0, item.Delivery));
}
else
{
extSet.Add(new PickupDeliveryClient(item.ID, item.Delivery, 0));
}
}
return(extSet);
}
public static VRPSimultaneousPickupDelivery LoadDenthoffProblem(string path)
{
Tuple <DethloffType, int, int> dataName = ParseDethloffName(path);
DethloffType type = dataName.Item1;
int x = dataName.Item2;
int y = dataName.Item3;
StreamReader reader = new StreamReader(path);
Fleet f = ParseFleetInfo(reader, x + 1);
int clientAmount = int.Parse(reader.ReadLine().Trim());
TravelData m = ParseTravelMatrix(reader, clientAmount);
ClientSet <PickupDeliveryClient> c = ParseClientInfo(reader, clientAmount);
VRPSimultaneousPickupDelivery instance = new VRPSimultaneousPickupDelivery(c, f, m);
instance.ProblemName = type.ToString() + x.ToString() + "-" + y.ToString();
return(instance);
}
public static VRPSimultaneousPickupDelivery LoadSalhiNagyProblem(string path, int fleet, bool serieX)
{
//formato del fichero
//clientes capacidad tiempo-maximo tiempo-ruptura
//depot-x depot-y
//para cada clietne
//x y demand
int id = ParseNagySalhiName(path);
StreamReader reader = new StreamReader(path);
string[] specification = reader.ReadLine().Split(' ');
int clientAmount = int.Parse(specification[1]);
int vehicleCapacity = int.Parse(specification[2]);
string[] depot = reader.ReadLine().Split(' ');
double xDepot = double.Parse(depot[1]);
double yDepot = double.Parse(depot[2]);
List <Tuple <double, double, double> > clientsInfo = new List <Tuple <double, double, double> >(clientAmount + 1);
clientsInfo.Add(new Tuple <double, double, double>(xDepot, yDepot, 0));
while (!reader.EndOfStream)
{
string[] client = reader.ReadLine().Split(' ');
if (client.Length == 4)
{
clientsInfo.Add(new Tuple <double, double, double>(double.Parse(client[1]), double.Parse(client[2]), double.Parse(client[3])));
}
}
TravelData matrix = BuildTravelCostMatrix(clientsInfo);
ClientSet <PickupDeliveryClient> clientSet = BuildClientSet(clientsInfo, serieX);
Fleet vehicles = Fleet.CreateHomogeneousFleet(fleet, vehicleCapacity);
reader.Close();
VRPSimultaneousPickupDelivery problem = new VRPSimultaneousPickupDelivery(clientSet, vehicles, matrix);
string serie = (serieX) ? "X" : "Y";
problem.ProblemName = string.Format("CMT{0}-{1}-{2}{3}", id, clientAmount, fleet, serie);
return(problem);
}
private static ClientSet <PickupDeliveryClient> BuildClientSet(List <Tuple <double, double, double> > clientsInfo, bool serieX)
{
ClientSet <PickupDeliveryClient> clients = new ClientSet <PickupDeliveryClient>();
for (int i = 1; i < clientsInfo.Count; i++)
{
double rate = Math.Min(clientsInfo[i].Item1 / clientsInfo[i].Item2, clientsInfo[i].Item2 / clientsInfo[i].Item1);
double demand1 = Math.Round(rate * clientsInfo[i].Item3, 8);
double demand2 = Math.Round((1 - rate) * clientsInfo[i].Item3, 8);
if (serieX)
{
clients.Add(new PickupDeliveryClient(i, demand1, demand2));
}
else
{
clients.Add(new PickupDeliveryClient(i, demand2, demand1));
}
}
return(clients);
}
public async Task <JsonResult> AddClientSet(ClientSetViewModel item)
{
var entity = new ClientSet
{
UpgradeItemId = item.ItemId,
ParkId = item.ParkId,
ParkName = item.ParkName,
Creater = "sys",
CreateTime = DateTimeOffset.Now.DateTime,
};
_clientSetRepository.Add(entity);
if (await UnitOfWork.SaveAsync())
{
return(Json(new { result = true, msg = "保存成功" }));
}
else
{
return(Json(new { result = false, msg = "服务器保存失败" }));
}
}
public static VRPSimultaneousPickupDelivery ParseSalhiNagyMixed(string path, int clientInterval, int[] fleet)
{
int id = ParseNagySalhiName(path);
int fleetSize = fleet[id - 1];
StreamReader reader = new StreamReader(path);
var sp = SalhiNagyProblemSpecification(reader);
int clientAmount = sp.Item1;
int vehicleCapacity = sp.Item2;
List <Tuple <double, double, double> > clientsInfo = LoadClientInfo(reader, clientAmount);
reader.Close();
TravelData matrix = BuildTravelCostMatrix(clientsInfo);
ClientSet <PickupDeliveryClient> clientSet = BuildSalhiMixedClientSet(clientsInfo, clientInterval);
Fleet vehicles = Fleet.CreateHomogeneousFleet(fleetSize, vehicleCapacity);
VRPSimultaneousPickupDelivery problem = new VRPSimultaneousPickupDelivery(clientSet, vehicles, matrix);
problem.ProblemName = string.Format("CMT{0}", id);
return(problem);
}
private void MenuItem_MouseDown(object sender, RoutedEventArgs e)
{
//provmenu.PlacementTarget = this;
//provmenu.IsOpen = true;
ClientSet p = new ClientSet();
Client clientdetails = new Client(p);
clientdetails._new = true;
clientdetails.ShowDialog();
if (clientdetails._new && !clientdetails.Cancel)
{
lcl.Add(p);
_dataDC.ClientSet.AddObject(p);
_dataDC.SaveChanges();
filter();
}
}
public async Task <IActionResult> ToExcel([FromBody] Excel excel)
{
List <ContractSet> contractsRes = new List <ContractSet>();
IEnumerable <ContractSet> contracts = _context.ContractSet;
IEnumerable <ObjectSet> objects = _context.ObjectSet;
IEnumerable <ObjectSetFlat> flats = _context.ObjectSetFlat;
IEnumerable <ObjectSetCar> cars = _context.ObjectSetCar;
IEnumerable <ObjectSetParcel> parcels = _context.ObjectSetParcel;
IEnumerable <ClientSet> clients = _context.ClientSet;
IEnumerable <ClientSetIndividual> clientsIndiv = _context.ClientSetIndividual;
IEnumerable <ClientSetEntity> clientsEnt = _context.ClientSetEntity;
IEnumerable <UserSetAppraiser> apraisers = _context.UserSetAppraiser;
IEnumerable <AppraiserContract> apraisersContract = _context.AppraiserContract;
IEnumerable <UserSet> users = _context.UserSet;
IEnumerable <AddressSet> addresses = _context.AddressSet;
ContractSet cntr = new ContractSet();
ClientSet clnt = new ClientSet();
ClientSetIndividual indv = new ClientSetIndividual();
ClientSetEntity ent = new ClientSetEntity();
ObjectSet obj = new ObjectSet();
ObjectSetFlat flt = new ObjectSetFlat();
ObjectSetCar cr = new ObjectSetCar();
ObjectSetParcel prcl = new ObjectSetParcel();
UserSetAppraiser apr = new UserSetAppraiser();
AppraiserContract aprCntr = new AppraiserContract();
UserSet usr = new UserSet();
AddressSet adr = new AddressSet();
for (int i = 0; i < excel.Ids.Count(); i++)
{
cntr = contracts.FirstOrDefault(u => u.Id == excel.Ids[i]);
clnt = clients.FirstOrDefault(u => u.Id == cntr.ClientId);
clnt.ContractSet = null;
indv = clientsIndiv.FirstOrDefault(u => u.Id == clnt.Id);
ent = clientsEnt.FirstOrDefault(u => u.Id == clnt.Id);
if (indv != null)
{
indv.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == indv.AddressOfResidenceId);
adr.ClientSetIndividual = null;
indv.AddressOfResidence = adr;
clnt.ClientSetIndividual = indv;
}
else
{
ent.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == ent.LegalAddressId);
adr.ClientSetEntity = null;
ent.LegalAddress = adr;
clnt.ClientSetEntity = ent;
}
cntr.Client = clnt;
obj = objects.FirstOrDefault(u => u.Id == cntr.ObjectId);
obj.ContractSet = null;
flt = flats.FirstOrDefault(u => u.Id == obj.Id);
cr = cars.FirstOrDefault(u => u.Id == obj.Id);
prcl = parcels.FirstOrDefault(u => u.Id == obj.Id);
if (flt != null)
{
flt.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == flt.AddressId);
adr.ObjectSetFlat = null;
flt.Address = adr;
obj.ObjectSetFlat = flt;
}
else
{
if (prcl != null)
{
prcl.IdNavigation = null;
obj.ObjectSetParcel = prcl;
}
else
{
cr.IdNavigation = null;
obj.ObjectSetCar = cr;
}
}
cntr.Object = obj;
aprCntr = apraisersContract.FirstOrDefault(u => u.ContractId == cntr.Id);
apr = apraisers.FirstOrDefault(u => u.Id == aprCntr.AppraiserId);
apr.AppraiserContract = null;
usr = users.FirstOrDefault(u => u.Id == apr.Id);
usr.UserSetAppraiser = null;
apr.IdNavigation = usr;
aprCntr.Appraiser = apr;
aprCntr.Contract = null;
AppraiserContract[] arr = new AppraiserContract[1];
arr[0] = aprCntr;
cntr.AppraiserContract = arr;
contractsRes.Add(cntr);
}
var fileDownloadName = "Договоры.xlsx";
using (var package = createExcelPackage(contractsRes))
{
package.SaveAs(new FileInfo(Path.Combine(@"C:\Users\user\Downloads", fileDownloadName)));
}
return(Ok());
}
public void UpdateClient(Client client)
{
ClientSet.Update(client);
SaveChanges();
}
public async Task <Client> GetClientById(int id)
{
return(await ClientSet.FindAsync(id));
}
public async Task <List <Client> > GetAllClients()
{
List <Client> clients = await ClientSet.Where(i => (!i.Deleted)).ToListAsync();
return(clients);
}
private void MenuItem_MouseDown(object sender, RoutedEventArgs e)
{
//provmenu.PlacementTarget = this;
//provmenu.IsOpen = true;
ClientSet p = new ClientSet();
Client clientdetails = new Client(p);
clientdetails._new = true;
clientdetails.ShowDialog();
if (clientdetails._new && !clientdetails.Cancel)
{
lcl.Add(p);
_dataDC.ClientSet.AddObject(p);
_dataDC.SaveChanges();
filter();
}
}
public VRPSimultaneousPickupDelivery(ClientSet <PickupDeliveryClient> clientSet, Fleet vehicles, TravelData travelDistance)
: base(clientSet, vehicles, travelDistance)
{
}
public IEnumerable <ContractSet> GetContractSet()
{
IEnumerable <ContractSet> contracts = _context.ContractSet;
IEnumerable <ObjectSet> objects = _context.ObjectSet;
IEnumerable <ObjectSetFlat> flats = _context.ObjectSetFlat;
IEnumerable <ObjectSetCar> cars = _context.ObjectSetCar;
IEnumerable <ObjectSetParcel> parcels = _context.ObjectSetParcel;
IEnumerable <ClientSet> clients = _context.ClientSet;
IEnumerable <ClientSetIndividual> clientsIndiv = _context.ClientSetIndividual;
IEnumerable <ClientSetEntity> clientsEnt = _context.ClientSetEntity;
IEnumerable <UserSetAppraiser> apraisers = _context.UserSetAppraiser;
IEnumerable <AppraiserContract> apraisersContract = _context.AppraiserContract;
IEnumerable <UserSet> users = _context.UserSet;
IEnumerable <AddressSet> addresses = _context.AddressSet;
ContractSet cntr = new ContractSet();
ClientSet clnt = new ClientSet();
ClientSetIndividual indv = new ClientSetIndividual();
ClientSetEntity ent = new ClientSetEntity();
ObjectSet obj = new ObjectSet();
ObjectSetFlat flt = new ObjectSetFlat();
ObjectSetCar cr = new ObjectSetCar();
ObjectSetParcel prcl = new ObjectSetParcel();
UserSetAppraiser apr = new UserSetAppraiser();
AppraiserContract aprCntr = new AppraiserContract();
UserSet usr = new UserSet();
AddressSet adr = new AddressSet();
for (int i = 0; i < contracts.Count(); i++)
{
clnt = clients.FirstOrDefault(u => u.Id == contracts.ElementAt(i).ClientId);
clnt.ContractSet = null;
indv = clientsIndiv.FirstOrDefault(u => u.Id == clnt.Id);
ent = clientsEnt.FirstOrDefault(u => u.Id == clnt.Id);
if (indv != null)
{
indv.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == indv.AddressOfResidenceId);
adr.ClientSetIndividual = null;
indv.AddressOfResidence = adr;
clnt.ClientSetIndividual = indv;
}
else
{
ent.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == ent.LegalAddressId);
adr.ClientSetEntity = null;
ent.LegalAddress = adr;
clnt.ClientSetEntity = ent;
}
contracts.ElementAt(i).Client = clnt;
obj = objects.FirstOrDefault(u => u.Id == contracts.ElementAt(i).ObjectId);
obj.ContractSet = null;
flt = flats.FirstOrDefault(u => u.Id == obj.Id);
cr = cars.FirstOrDefault(u => u.Id == obj.Id);
prcl = parcels.FirstOrDefault(u => u.Id == obj.Id);
if (flt != null)
{
flt.IdNavigation = null;
adr = addresses.FirstOrDefault(u => u.Id == flt.AddressId);
adr.ObjectSetFlat = null;
flt.Address = adr;
obj.ObjectSetFlat = flt;
}
else
{
if (prcl != null)
{
prcl.IdNavigation = null;
obj.ObjectSetParcel = prcl;
}
else
{
cr.IdNavigation = null;
obj.ObjectSetCar = cr;
}
}
contracts.ElementAt(i).Object = obj;
aprCntr = apraisersContract.FirstOrDefault(u => u.ContractId == contracts.ElementAt(i).Id);
apr = apraisers.FirstOrDefault(u => u.Id == aprCntr.AppraiserId);
apr.AppraiserContract = null;
usr = users.FirstOrDefault(u => u.Id == apr.Id);
usr.UserSetAppraiser = null;
apr.IdNavigation = usr;
aprCntr.Appraiser = apr;
aprCntr.Contract = null;
AppraiserContract[] arr = new AppraiserContract[1];
arr[0] = aprCntr;
contracts.ElementAt(i).AppraiserContract = arr;
}
return(contracts);
}
public static VRPSimultaneousPickupDelivery Combine(VRPSimultaneousPickupDelivery problem1, VRPSimultaneousPickupDelivery problem2)
{
ClientSet <PickupDeliveryClient> clientSet = new ClientSet <PickupDeliveryClient>();
foreach (var item in problem1.Clients)
{
clientSet.Add(item);
}
for (int i = 0; i < problem2.Clients.Count; i++)
{
PickupDeliveryClient newClient = (PickupDeliveryClient)problem2.Clients[i + 1].Clone();
newClient.ID = clientSet.Count + 1;
clientSet.Add(newClient);
}
Fleet fleet = new Fleet();
foreach (var item in problem1.Vehicles)
{
fleet.Add(item);
}
foreach (var item in problem2.Vehicles)
{
fleet.Add(item);
}
double[,] travel = new double[clientSet.Count + 1, clientSet.Count + 1];
double maxCost = int.MaxValue / 10;
for (int i = 0; i < travel.GetLength(0); i++)
{
for (int j = i + 1; j < travel.GetLength(1); j++)
{
travel[i, j] = travel[j, i] = maxCost;
}
}
for (int i = 0; i < problem1.Clients.Count + 1; i++)
{
for (int j = 0; j < problem1.Clients.Count + 1; j++)
{
travel[i, j] = problem1.TravelDistance[i, j];
}
}
for (int i = 0; i < problem2.Clients.Count + 1; i++)
{
for (int j = 0; j < problem2.Clients.Count + 1; j++)
{
if (i == 0 && j != 0)
{
travel[0, problem1.Clients.Count + j] = problem2.TravelDistance[0, j];
}
else if (j == 0 && i != 0)
{
travel[problem1.Clients.Count + i, 0] = problem2.TravelDistance[i, 0];
}
else if (i != 0 && j != 0)
{
travel[problem1.Clients.Count + i, problem1.Clients.Count + j] = problem2.TravelDistance[i, j];
}
}
}
return(new VRPSimultaneousPickupDelivery(clientSet, fleet, new TravelData(travel)));
}
private void buttonOpenYcet_Click(object sender, EventArgs e)
{
Form clientSet = new ClientSet();
clientSet.Show();
}
