private void SavePropositionExecute(object obj)
{
if (_addNewProposition.IsCreated && !_saveFlag)
{
// tworzy obiekt z aktualnymi danymi tabeli Proposition i dodaje go do bazy
// !! PROPOSITION !!
string propstate;
if (SelectedPropState != null)
propstate = SelectedPropState; //TODO uaktualnić ewentualnie z enuma lub obgadać jak rozwiązać
else
propstate = _propStates[0];
var propositionToBase = new Proposition
{
Id_user = _userId,
UpdateDate = _addNewProposition.UpdateDate,
Status = propstate //TODO uaktualnić ewentualnie z enuma lub obgadać jak rozwiązać
};
_ctx.Proposition.Add(propositionToBase);
_addNewProposition.IsCreated = false;
_ctx.SaveChanges();
/* wyciągnięcie Id dodanej propozycji który potrzebny bedzie przy dodawaniu
* do bazy pozostałych tabel (klucz obcy) */
var lastPropId = (from prop in _ctx.Proposition
select prop).ToList().Last();
int currentPropositionId = lastPropId.Id;
//------------------------------
// !! PROPCLIENT !!
PropositionClient.Id_proposition = currentPropositionId;
_ctx.PropClient.Add(PropositionClient);
//------------------------------
// !! PROPRESERVATIONDETAILS !!
PropositionReservDetails.Id_proposition = currentPropositionId;
if (PropositionReservDetails.Hall != " ")
_ctx.PropReservationDetails.Add(PropositionReservDetails);
//------------------------------
// !! PROPHALLEQUPMENT !!
// dodaje do bazy tylko te elementy listy, które posiadaja nazwe i cene brutto TODO: review solution
for (int i = 0; i < _propHallEquipment.Count; i++)
{
if (_propHallEquipment[i].Things != null && _propHallEquipment[i].BruttoPrice != null
&& _propHallEquipment[i].Amount != null && _propHallEquipment[i].Days != null
&& _propHallEquipment[i].Things != " " && _propHallEquipment[i].BruttoPrice != 0)
{
_propHallEquipment[i].Id_proposition = currentPropositionId;
_ctx.PropHallEquipment.Add(_propHallEquipment[i]);
}
}
//------------------------------
// !! PROPHALLEQUPMENTDISCOUNT !!
HallEquipmentDiscount.Id_proposition = currentPropositionId;
_ctx.PropHallEquipmentDiscount.Add(HallEquipmentDiscount);
//------------------------------
// !! PROPMENUMERGES !!
for (int i = 0; i < PropMenuMerges.Count; i++)
{
PropMenuMerges[i].Id_proposition = currentPropositionId;
_ctx.PropMenuMerge.Add(PropMenuMerges[i]);
}
//------------------------------
// !! PROPMENUPOSITIONS !!
for (int i = 0; i < _propMenuPositions.Count; i++)
{
if (_propMenuPositions[i].TypeOfService != null && _propMenuPositions[i].Amount != null &&
_propMenuPositions[i].Days != null && _propMenuPositions[i].TypeOfService != " ")
{
_propMenuPositions[i].Id_proposition = currentPropositionId;
_ctx.PropMenuPosition.Add(_propMenuPositions[i]);
}
}
//------------------------------
// !! PROPACCOMODATIONS !!
for (int i = 0; i < _propAccomodations.Count; i++)
{
if (_propAccomodations[i].Amount != null && _propAccomodations[i].Days != null)
{
_propAccomodations[i].Id_proposition = currentPropositionId;
_ctx.PropAccomodation.Add(_propAccomodations[i]);
}
}
//------------------------------
// !! PROPACCOMODATIONSDISCOUNT !!
PropAccomDiscount.Id_proposition = currentPropositionId;
_ctx.PropAccomodationDiscount.Add(PropAccomDiscount);
//------------------------------
// !! PROPEXTRASERVICES !!
for (int i = 0; i < _propExtraServ.Count; i++)
{
if (_propExtraServ[i].ServiceType != null && _propExtraServ[i].BruttoPrice != null &&
_propExtraServ[i].Days != null && _propExtraServ[i].Amount != null &&
_propExtraServ[i].ServiceType != " ")
{
_propExtraServ[i].Id_proposition = currentPropositionId;
_ctx.PropExtraServices.Add(_propExtraServ[i]);
}
}
//------------------------------
// !! PROPPAYMENTSUGGESTIONS !!
_propPaymentSugg.Id_proposition = currentPropositionId;
_ctx.PropPaymentSuggestions.Add(_propPaymentSugg);
try
{
_ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine(@"Entity of type ""{0}"" in state ""{1}"" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine(@"- Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage);
}
}
MessageBox.Show(e.ToString());
throw;
}
Xceed.Wpf.Toolkit.MessageBox.Show("Dodano nową propozycję cenową!", "Informacja", MessageBoxButton.OK, MessageBoxImage.Information);
// po dodaniu propozycji odśwież listę propozycji
ChangeView(false);
SelectAllPropositions();
}
else
{
//Edycja Propozycji
// !! PROPCLIENT !!
var prop = (from q in _ctx.Proposition
where q.Id == _idProposition
select q).SingleOrDefault();
int idProposition = _idProposition;
prop.Status = SelectedPropState;
prop.UpdateDate = AddNewProposition.UpdateDate;
prop.Id_user = _userId;
_ctx.SaveChanges();
var editClient = (from q in _ctx.PropClient
where q.Id_proposition == idProposition
select q).SingleOrDefault();
if (editClient != null)
{
//editClient.Id_proposition = idProposition;
editClient.CompanyName = PropositionClient.CompanyName;
editClient.CompanyAdress = PropositionClient.CompanyAdress;
editClient.NIP = PropositionClient.NIP;
editClient.CustomerFullName = PropositionClient.CustomerFullName;
editClient.PhoneNum = PropositionClient.PhoneNum;
}
else
{
PropClient addNewClient = new PropClient();
addNewClient.Id_proposition = idProposition;
addNewClient.CompanyName = PropositionClient.CompanyName;
addNewClient.CompanyAdress = PropositionClient.CompanyAdress;
addNewClient.NIP = PropositionClient.NIP;
addNewClient.CustomerFullName = PropositionClient.CustomerFullName;
addNewClient.PhoneNum = PropositionClient.PhoneNum;
_ctx.PropClient.Add(addNewClient);
}
//-Edycja----------------------
// !! PROPRESERVATIONDETAILS !!
var propReservation = (from q in _ctx.PropReservationDetails
where q.Id_proposition == _idProposition
select q).SingleOrDefault();
if (propReservation == null)
{
PropReservationDetails addPropReservationDetails = new PropReservationDetails();
addPropReservationDetails.Id_proposition = _idProposition;
addPropReservationDetails.StartData = PropositionReservDetails.StartData;
addPropReservationDetails.EndData = PropositionReservDetails.EndData;
addPropReservationDetails.Hall = PropositionReservDetails.Hall;
addPropReservationDetails.HallSetting = PropositionReservDetailsHallSetting;
addPropReservationDetails.PeopleNumber = PropositionReservDetailsPeopleNumber;
addPropReservationDetails.EndTime = PropositionReservDetails.EndTime;
addPropReservationDetails.StartTime = PropositionReservDetails.StartTime;
//ddPropReservationDetails.Proposition = PropositionReservDetails.Proposition;
_ctx.PropReservationDetails.Add(addPropReservationDetails);
}
else
{
//propReservation.Id_proposition = _idProposition;
propReservation.StartData = PropositionReservDetailsStartData;
propReservation.EndData = PropositionReservDetailsEndData;
propReservation.Hall = PropositionReservDetailsHall;
propReservation.HallSetting = PropositionReservDetailsHallSetting;
propReservation.PeopleNumber = PropositionReservDetailsPeopleNumber;
propReservation.EndTime = PropositionReservDetailsEndTime;
propReservation.StartTime = PropositionReservDetailsStartTime;
//propReservation.Proposition = PropositionReservDetails.Proposition;
}
_ctx.SaveChanges();
var dicount = (from q in _ctx.PropHallEquipmentDiscount
where q.Id_proposition == idProposition
select q).SingleOrDefault();
if (dicount != null)
{
dicount.Discount = PropHallEquipmentDiscountValue;
dicount.StandardPrice = HallPrice;
}
else
{
PropHallEquipmentDiscount newDiscount = new PropHallEquipmentDiscount();
newDiscount.Id_proposition = _idProposition;
newDiscount.StandardPrice = HallPrice;
newDiscount.Discount = PropHallEquipmentDiscountValue;
}
_ctx.SaveChanges();
var propEquipment = (from q in _ctx.PropHallEquipment
where q.Id_proposition == idProposition
select q).ToList();
var myRegex = new Regex(@"Sala *");
var hall = propEquipment.Find(f => myRegex.IsMatch(f.Things));
if (hall != null)
{
if (PropHallEqAmount0 != null && PropHallEqDays0 != null)
{
hall.Things = PropHallEqThing0;
hall.Days = PropHallEqDays0;
hall.Amount = PropHallEqAmount0;
hall.BruttoPrice = PropHallEqBrutto0;
hall.Vat = PropHallEqVat0;
propEquipment.Remove(hall);
_ctx.SaveChanges();
}
}
else if (PropHallEqThing0 != null)
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing0;
newqEquipment.Amount = PropHallEqAmount0;
newqEquipment.Days = PropHallEqDays0;
newqEquipment.BruttoPrice = PropHallEqBrutto0;
newqEquipment.Vat = PropHallEqVat0;
newqEquipment.Id_proposition = _idProposition;
_ctx.PropHallEquipment.Add(newqEquipment);
}
//wposażenie
_ctx.SaveChanges();
if (PropHallEqThing1 != null)
{
var thing1 = propEquipment.ElementAtOrDefault(0);
if (thing1 != null)
{
thing1.Id_proposition = _idProposition;
thing1.Things = PropHallEqThing1;
thing1.Amount = PropHallEqAmount1;
thing1.Days = PropHallEqDays1;
thing1.Vat = PropHallEqVat1;
thing1.BruttoPrice = PropHallEqBrutto1;
}
else
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing1;
newqEquipment.Amount = PropHallEqAmount1;
newqEquipment.Days = PropHallEqDays1;
newqEquipment.BruttoPrice = PropHallEqBrutto1;
newqEquipment.Id_proposition = _idProposition;
newqEquipment.Vat = PropHallEqVat1;
_ctx.PropHallEquipment.Add(newqEquipment);
}
}
_ctx.SaveChanges();
if (PropHallEqThing2 != null)
{
var thing1 = propEquipment.ElementAtOrDefault(1);
if (thing1 != null)
{
thing1.Id_proposition = _idProposition;
thing1.Things = PropHallEqThing2;
thing1.Amount = PropHallEqAmount2;
thing1.Days = PropHallEqDays2;
thing1.BruttoPrice = PropHallEqBrutto2;
thing1.Vat = PropHallEqVat2;
}
else
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing2;
newqEquipment.Amount = PropHallEqAmount2;
newqEquipment.Days = PropHallEqDays2;
newqEquipment.BruttoPrice = PropHallEqBrutto2;
newqEquipment.Id_proposition = _idProposition;
newqEquipment.Vat = PropHallEqVat2;
_ctx.PropHallEquipment.Add(newqEquipment);
}
}
_ctx.SaveChanges();
if (PropHallEqThing3 != null)
{
var thing1 = propEquipment.ElementAtOrDefault(2);
if (thing1 != null)
{
thing1.Id_proposition = _idProposition;
thing1.Things = PropHallEqThing3;
thing1.Amount = PropHallEqAmount3;
thing1.Days = PropHallEqDays3;
thing1.BruttoPrice = PropHallEqBrutto3;
thing1.Vat = PropHallEqVat3;
}
else
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing3;
newqEquipment.Amount = PropHallEqAmount3;
newqEquipment.Days = PropHallEqDays3;
newqEquipment.BruttoPrice = PropHallEqBrutto3;
newqEquipment.Id_proposition = _idProposition;
newqEquipment.Vat = PropHallEqVat3;
_ctx.PropHallEquipment.Add(newqEquipment);
}
}
_ctx.SaveChanges();
if (PropHallEqThing4 != null)
{
var thing1 = propEquipment.ElementAtOrDefault(3);
if (thing1 != null)
{
thing1.Id_proposition = _idProposition;
thing1.Things = PropHallEqThing4;
thing1.Amount = PropHallEqAmount4;
thing1.Days = PropHallEqDays4;
thing1.BruttoPrice = PropHallEqBrutto4;
thing1.Vat = PropHallEqVat4;
}
else
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing4;
newqEquipment.Amount = PropHallEqAmount4;
newqEquipment.Days = PropHallEqDays4;
newqEquipment.BruttoPrice = PropHallEqBrutto4;
newqEquipment.Id_proposition = _idProposition;
newqEquipment.Vat = PropHallEqVat4;
_ctx.PropHallEquipment.Add(newqEquipment);
}
}
if (PropHallEqThing5 != null)
{
var thing1 = propEquipment.ElementAtOrDefault(4);
if (thing1 != null)
{
thing1.Id_proposition = _idProposition;
thing1.Things = PropHallEqThing5;
thing1.Amount = PropHallEqAmount5;
thing1.Days = PropHallEqDays5;
thing1.BruttoPrice = PropHallEqBrutto5;
thing1.Vat = PropHallEqVat5;
}
else
{
PropHallEquipment newqEquipment = new PropHallEquipment();
newqEquipment.Things = PropHallEqThing5;
newqEquipment.Amount = PropHallEqAmount5;
newqEquipment.Days = PropHallEqDays5;
newqEquipment.BruttoPrice = PropHallEqBrutto5;
newqEquipment.Id_proposition = _idProposition;
newqEquipment.Vat = PropHallEqVat5;
_ctx.PropHallEquipment.Add(newqEquipment);
_ctx.SaveChanges();
}
}
_ctx.SaveChanges();
var propEquipment1 = (from q in _ctx.PropHallEquipment
where q.Id_proposition == idProposition
select q).ToList();
foreach (var check in propEquipment1)
{
if (check.Things == " " || check.Things == null
|| check.Days == null || check.Days == 0
|| check.Amount == 0 || check.Amount == null
|| check.BruttoPrice == 0)
{
_ctx.PropHallEquipment.Remove(check);
}
}
_ctx.SaveChanges();
//Gastronomia
var editGastronomic = (from q in _ctx.PropMenuPosition
where q.Id_proposition == _idProposition
select q).ToList();
var service = editGastronomic.ElementAtOrDefault(0);
if (service != null)
{
service.Id_proposition = idProposition;
service.TypeOfService = PropMenuTypeOfServ0;
service.Amount = PropMenuPosAmount0;
service.Days = PropMenuPosDays0;
service.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ0);
service.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ0);
service.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ0);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ0;
newPosition.Amount = PropMenuPosAmount0;
newPosition.Days = PropMenuPosDays0;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ0);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ0);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ0);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service1 = editGastronomic.ElementAtOrDefault(1);
if (service1 != null)
{
service1.Id_proposition = idProposition;
service1.TypeOfService = PropMenuTypeOfServ1;
service1.Amount = PropMenuPosAmount1;
service1.Days = PropMenuPosDays1;
service1.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ1);
service1.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ1);
service1.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ1);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ1;
newPosition.Amount = PropMenuPosAmount1;
newPosition.Days = PropMenuPosDays1;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ1);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ1);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ1);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service2 = editGastronomic.ElementAtOrDefault(2);
if (service2 != null)
{
service2.Id_proposition = idProposition;
service2.TypeOfService = PropMenuTypeOfServ2;
service2.Amount = PropMenuPosAmount2;
service2.Days = PropMenuPosDays2;
service2.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ2);
service2.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ2);
service2.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ2);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ2;
newPosition.Amount = PropMenuPosAmount2;
newPosition.Days = PropMenuPosDays2;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ2);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ2);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ2);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service3 = editGastronomic.ElementAtOrDefault(3);
if (service3 != null)
{
service3.Id_proposition = idProposition;
service3.TypeOfService = PropMenuTypeOfServ3;
service3.Amount = PropMenuPosAmount3;
service3.Days = PropMenuPosDays3;
service3.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ3);
service3.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ3);
service3.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ3);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ3;
newPosition.Amount = PropMenuPosAmount3;
newPosition.Days = PropMenuPosDays3;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ3);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ3);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ3);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service4 = editGastronomic.ElementAtOrDefault(4);
if (service4 != null)
{
service4.Id_proposition = idProposition;
service4.TypeOfService = PropMenuTypeOfServ4;
service4.Amount = PropMenuPosAmount4;
service4.Days = PropMenuPosDays4;
service4.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ4);
service4.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ4);
service4.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ4);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ4;
newPosition.Amount = PropMenuPosAmount4;
newPosition.Days = PropMenuPosDays4;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ4);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ4);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ4);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service5 = editGastronomic.ElementAtOrDefault(5);
if (service5 != null)
{
service5.Id_proposition = idProposition;
service5.TypeOfService = PropMenuTypeOfServ5;
service5.Amount = PropMenuPosAmount5;
service5.Days = PropMenuPosDays5;
service5.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ5);
service5.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ5);
service5.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ5);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.Amount = PropMenuPosAmount5;
newPosition.Days = PropMenuPosDays5;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ5);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ5);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ5);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var service6 = editGastronomic.ElementAtOrDefault(6);
if (service6 != null)
{
service6.Id_proposition = idProposition;
service6.TypeOfService = PropMenuTypeOfServ6;
service6.Amount = PropMenuPosAmount6;
service6.Days = PropMenuPosDays6;
service6.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ6);
service6.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ6);
service6.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ6);
}
else
{
PropMenuPosition newPosition = new PropMenuPosition();
newPosition.Id_proposition = idProposition;
newPosition.TypeOfService = PropMenuTypeOfServ6;
newPosition.Amount = PropMenuPosAmount6;
newPosition.Days = PropMenuPosDays6;
newPosition.MergeType = SetMenuPosDefaultMergeType(PropMenuTypeOfServ6);
newPosition.BruttoPrice = SetMenuPosDefaultBrutto(PropMenuTypeOfServ6);
newPosition.Vat = SetMenuPosDefaultVat(PropMenuTypeOfServ6);
_ctx.PropMenuPosition.Add(newPosition);
}
_ctx.SaveChanges();
var clearGast = (from q in _ctx.PropMenuPosition
where q.Id_proposition == _idProposition
select q).ToList();
var tmpClearGast =
clearGast.FindAll(
item =>
item.Amount == null || item.Amount == 0
|| item.Days == null || item.Days == 0 ||
item.TypeOfService == " " || item.TypeOfService == null).ToList();
_ctx.PropMenuPosition.RemoveRange(tmpClearGast);
var merge = (from q in _ctx.PropMenuMerge
where q.Id_proposition == idProposition
select q).ToList();
merge[0].DefaultValue = PropMenuMerge0;
merge[1].DefaultValue = PropMenuMerge1;
merge[2].DefaultValue = PropMenuMerge2;
merge[3].DefaultValue = PropMenuMerge3;
merge[4].DefaultValue = PropMenuMerge4;
_ctx.SaveChanges();
var room = (from q in _ctx.PropAccomodation
where q.Id_proposition == idProposition
select q).ToList();
for (int i = 0; i < room.Count; i++)
{
switch (room[i].TypeOfRoom)
{
case "POKÓJ 1-OSOBOWY":
room[i].Amount = PropAccomAmount0;
room[i].Days = PropAccomDays0;
room[i].BruttoPrice = PropAccomBrutto0;
room[i].Vat = PropAccomVat0;
break;
case "POKÓJ 2-OSOBOWY":
room[i].Amount = PropAccomAmount1;
room[i].Days = PropAccomDays1;
room[i].BruttoPrice = PropAccomBrutto1;
room[i].Vat = PropAccomVat1;
break;
case "POKÓJ BUSSINES 1-OSOBOWY":
room[i].Amount = PropAccomAmount2;
room[i].Days = PropAccomDays2;
room[i].BruttoPrice = PropAccomBrutto2;
room[i].Vat = PropAccomVat2;
break;
case "POKÓJ BUSSINES 2-OSOBOWY":
room[i].Amount = PropAccomAmount3;
room[i].Days = PropAccomDays3;
room[i].BruttoPrice = PropAccomBrutto3;
room[i].Vat = PropAccomVat3;
break;
case "APARTAMENT":
room[i].Amount = PropAccomAmount4;
room[i].Days = PropAccomDays4;
room[i].BruttoPrice = PropAccomBrutto4;
room[i].Vat = PropAccomVat4;
break;
case "POKOJ DLA NIEPEŁNOSPRAWNYCH":
room[i].Amount = PropAccomAmount5;
room[i].Days = PropAccomDays5;
room[i].BruttoPrice = PropAccomBrutto5;
room[i].Vat = PropAccomVat5;
break;
}
}
for (int i = 0; i < _roomExistList.Count; i++)
{
switch (_roomExistList[i])
{
case "POKÓJ 1-OSOBOWY":
if (PropAccomAmount0 != null && PropAccomDays0 != null && PropAccomAmount0 != 0 && PropAccomDays0 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount0;
newroom.BruttoPrice = PropAccomBrutto0;
newroom.Days = PropAccomDays0;
newroom.TypeOfRoom = PropAccomTypeOfRoom0;
newroom.Vat = PropAccomVat0;
_ctx.PropAccomodation.Add(newroom);
}
break;
case "POKÓJ 2-OSOBOWY":
if (PropAccomAmount1 != null && PropAccomDays1 != null && PropAccomAmount1 != 0 && PropAccomDays1 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount1;
newroom.BruttoPrice = PropAccomBrutto1;
newroom.Days = PropAccomDays1;
newroom.TypeOfRoom = PropAccomTypeOfRoom1;
newroom.Vat = PropAccomVat1;
_ctx.PropAccomodation.Add(newroom);
}
break;
case "POKÓJ BUSSINES 1-OSOBOWY":
if (PropAccomAmount2 != null && PropAccomDays2 != null && PropAccomAmount2 != 0 && PropAccomDays2 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount2;
newroom.BruttoPrice = PropAccomBrutto2;
newroom.Days = PropAccomDays2;
newroom.TypeOfRoom = PropAccomTypeOfRoom2;
newroom.Vat = PropAccomVat2;
_ctx.PropAccomodation.Add(newroom);
}
break;
case "POKÓJ BUSSINES 2-OSOBOWY":
if (PropAccomAmount3 != null && PropAccomDays3 != null && PropAccomAmount3 != 0 && PropAccomDays3 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount3;
newroom.BruttoPrice = PropAccomBrutto3;
newroom.Days = PropAccomDays3;
newroom.TypeOfRoom = PropAccomTypeOfRoom3;
newroom.Vat = PropAccomVat3;
_ctx.PropAccomodation.Add(newroom);
}
break;
case "APARTAMENT":
if (PropAccomAmount4 != null && PropAccomDays4 != null && PropAccomAmount4 != 0 && PropAccomDays5 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount4;
newroom.BruttoPrice = PropAccomBrutto4;
newroom.Days = PropAccomDays4;
newroom.TypeOfRoom = PropAccomTypeOfRoom4;
newroom.Vat = PropAccomVat4;
_ctx.PropAccomodation.Add(newroom);
}
break;
case "POKOJ DLA NIEPEŁNOSPRAWNYCH":
if (PropAccomAmount5 != null && PropAccomDays5 != null && PropAccomAmount5 != 0 && PropAccomDays5 != 0)
{
PropAccomodation newroom = new PropAccomodation();
newroom.Id_proposition = _idProposition;
newroom.Amount = PropAccomAmount5;
newroom.BruttoPrice = PropAccomBrutto5;
newroom.Days = PropAccomDays5;
newroom.TypeOfRoom = PropAccomTypeOfRoom5;
newroom.Vat = PropAccomVat5;
_ctx.PropAccomodation.Add(newroom);
}
break;
}
}
var clearAcc =
(from q in _ctx.PropAccomodation
where q.Id_proposition == _idProposition
select q).ToList().FindAll(item => item.Amount == 0
|| item.Amount == null || item.Days == 0
|| item.Days == null);
_ctx.PropAccomodation.RemoveRange(clearAcc);
_ctx.SaveChanges();
var mergeaccom = (from q in _ctx.PropAccomodationDiscount
where q.Id_proposition == _idProposition
select q).SingleOrDefault();
mergeaccom.Discount = PropAccomDiscountValue;
_ctx.SaveChanges();
// usługi dodatkowe
var propextr = (from q in _ctx.PropExtraServices
where q.Id_proposition == idProposition
select q).ToList();
var parking = new Regex(@"PARKING .+");
if (PropExtraServType0 != null)
{
var position = propextr.Find(f => parking.IsMatch(f.ServiceType));
if (position != null)
{
position.ServiceType = PropExtraServType0;
position.Amount = PropExtraServAmount0;
position.Days = PropExtraServDays0;
position.BruttoPrice = PropExtraServBrutto0;
position.Vat = PropExtraServVat0;
propextr.Remove(position);
}
else
{
PropExtraServices newextra = new PropExtraServices();
newextra.Id_proposition = idProposition;
newextra.ServiceType = PropExtraServType0;
newextra.Amount = PropExtraServAmount0;
newextra.Days = PropExtraServDays0;
newextra.BruttoPrice = PropExtraServBrutto0;
newextra.Vat = PropExtraServVat0;
_ctx.PropExtraServices.Add(newextra);
}
}
if (PropExtraServType1 != null)
{
if (propextr.ElementAtOrDefault(0) != null)
{
propextr[0].ServiceType = PropExtraServType1;
propextr[0].Amount = PropExtraServAmount1;
propextr[0].Days = PropExtraServDays1;
propextr[0].BruttoPrice = PropExtraServBrutto1;
propextr[0].Vat = PropExtraServVat1;
}
else
{
PropExtraServices newextra = new PropExtraServices();
newextra.Id_proposition = idProposition;
newextra.ServiceType = PropExtraServType1;
newextra.Amount = PropExtraServAmount1;
newextra.Days = PropExtraServDays1;
newextra.BruttoPrice = PropExtraServBrutto1;
newextra.Vat = PropExtraServVat1;
_ctx.PropExtraServices.Add(newextra);
}
}
if (PropExtraServType2 != null)
{
if (propextr.ElementAtOrDefault(1) != null)
{
propextr[1].ServiceType = PropExtraServType2;
propextr[1].Amount = PropExtraServAmount2;
propextr[1].Days = PropExtraServDays2;
propextr[1].BruttoPrice = PropExtraServBrutto2;
propextr[1].Vat = PropExtraServVat2;
}
else
{
PropExtraServices newextra = new PropExtraServices();
newextra.Id_proposition = idProposition;
newextra.ServiceType = PropExtraServType2;
newextra.Amount = PropExtraServAmount2;
newextra.Days = PropExtraServDays2;
newextra.BruttoPrice = PropExtraServBrutto2;
newextra.Vat = PropExtraServVat2;
_ctx.PropExtraServices.Add(newextra);
}
}
if (PropExtraServType3 != null)
{
if (propextr.ElementAtOrDefault(2) != null)
{
propextr[2].ServiceType = PropExtraServType3;
propextr[2].Amount = PropExtraServAmount3;
propextr[2].Days = PropExtraServDays3;
propextr[2].BruttoPrice = PropExtraServBrutto3;
propextr[2].Vat = PropExtraServVat3;
}
else
{
PropExtraServices newextra = new PropExtraServices();
newextra.Id_proposition = idProposition;
newextra.ServiceType = PropExtraServType3;
newextra.Amount = PropExtraServAmount3;
newextra.Days = PropExtraServDays3;
newextra.BruttoPrice = PropExtraServBrutto3;
newextra.Vat = PropExtraServVat3;
_ctx.PropExtraServices.Add(newextra);
}
}
_ctx.SaveChanges();
var extrClear = (from x in _ctx.PropExtraServices
where x.Id_proposition == _idProposition
select x).ToList().FindAll(item => item.Days == null ||
item.Amount == null || item.Days == 0 ||
item.Amount == 0 || item.ServiceType == " "
|| item.ServiceType == "" || item.BruttoPrice == 0f && !parking.IsMatch(item.ServiceType));
_ctx.PropExtraServices.RemoveRange(extrClear);
_ctx.SaveChanges();
var paysug = (from q in _ctx.PropPaymentSuggestions
where q.Id_proposition == _idProposition
select q).SingleOrDefault();
if (paysug != null)
{
paysug.PaymentForm = PaymentSuggestPaymentForm;
paysug.InvoiceServiceName = PaymentSuggestInvServName;
paysug.CarPark = PaymentSuggestCarPark;
paysug.IndividualOrders = PaymentSuggestIndividOrder;
}
else
{
PropPaymentSuggestions paysug1 = new PropPaymentSuggestions();
paysug1.Id_proposition = idProposition;
paysug1.PaymentForm = PaymentSuggestPaymentForm;
paysug1.InvoiceServiceName = PaymentSuggestInvServName;
paysug1.CarPark = PaymentSuggestCarPark;
paysug1.IndividualOrders = PaymentSuggestIndividOrder;
_ctx.PropPaymentSuggestions.Add(paysug1);
}
_ctx.SaveChanges();
Xceed.Wpf.Toolkit.MessageBox.Show("Edytowano istniejącą propozycję cenową!", "Informacja", MessageBoxButton.OK, MessageBoxImage.Information);
SelectedProposition = null;
_idProposition = 0;
SelectAllPropositions();
ChangeView(false);
}
}
private void InitializeObjects()
{
_propositionClient = new PropClient();
_propositionReservDetails = new PropReservationDetails();
_hallCapacity = new PropReservationDetails_Dictionary_HallCapacity();
_propHallEquipmentDiscount = new PropHallEquipmentDiscount();
_propHallEquipment = new List<PropHallEquipment>(6);
_secondTabNettoPrice = new List<decimal>(6);
_secondTabNettoValue = new List<decimal>(6);
_secondTabBruttoValue = new List<decimal>(6);
_vatList = new List<float?>(2);
_propMenuPositions = new List<PropMenuPosition>(7);
_thirdTabNettoPrice = new List<decimal?>(7);
_propMenuMerges = new List<PropMenuMerge>(5);
_thirdTabNettoValue = new List<decimal>(7);
_thirdTabBruttoValue = new List<decimal>(7);
_propAccomodations = new List<PropAccomodation>(6);
_propAccomDictionary = new List<PropAccomodation_Dictionary>();
_propAccomDiscount = new PropAccomodationDiscount();
_vatList4 = new List<float?>(2);
_fourthTabNettoPrice = new List<decimal?>(6);
_fourthTabNettoValue = new List<decimal>(6);
_fourthTabBruttoValue = new List<decimal>(6);
_propExtraServ = new List<PropExtraServices>(2);
_fifthTabNettoPrice = new List<decimal?>(4);
_fifthTabNettoValue = new List<decimal>(4);
_fifthTabBruttoValue = new List<decimal>(4);
_propPaymentSugg = new PropPaymentSuggestions();
_selectedType = new List<string>(7);
_filter = new List<string>(7);
_propMenuGastThingDict0 = new ObservableCollection<string>();
_propMenuGastThingDict1 = new ObservableCollection<string>();
_propMenuGastThingDict2 = new ObservableCollection<string>();
_propMenuGastThingDict3 = new ObservableCollection<string>();
_propMenuGastThingDict4 = new ObservableCollection<string>();
_propMenuGastThingDict5 = new ObservableCollection<string>();
_propMenuGastThingDict6 = new ObservableCollection<string>();
}