public InsertData(string etat, ReservationTypes ele, ReservationTypesViewModel view)
{
InitializeComponent();
this.DataContext = viewVM = view;
Etat = etat;
if (etat == "AJOUT")
{
this.Title = "Enregistrement d'un Quartier";
}
else
{
this.Title = "Modification d'un Quartier";
}
}
private void btnValider_Click(object sender, RoutedEventArgs e)
{
try
{
ReservationTypesViewModel vm = this.DataContext as ReservationTypesViewModel;
ReservationTypes ent = vm.SelectedData;
if (Etat == "AJOUT")
{
try
{
ent.Etat = "ACTIF";
ent.idHotel = 1;
viewVM.model.ReservationTypes.Add(ent);
viewVM.model.SaveChanges();
Msg = "OK";
this.Close();
}
catch (Exception ex)
{
Msg = "Error";
ErrorMsg = ex.Message;
}
}
else
{
try
{
viewVM.model.SaveChanges();
Msg = "OK";
this.Close();
}
catch (Exception ex)
{
Msg = "Error";
ErrorMsg = ex.Message;
}
}
}
catch (Exception)
{
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
//if (GlobalData.VerificationDroit("CanAddReservationTypes"))
//{
var result = MessageBox.Show("Voulez vous vraiment supprimer ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
if (dataGrid.SelectedItem != null)
{
try
{
viewM = this.Main.DataContext as ReservationTypesViewModel;
ReservationTypes ent = dataGrid.SelectedItem as ReservationTypes;
ent.Etat = "SUPPRIMER";
viewM.model.SaveChanges();
viewM.Refresh();
MessageBox.Show("Opération effectuée avec succès", "ReservationTypes", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ReservationTypes", MessageBoxButton.OK, MessageBoxImage.Warning);
viewM.Refresh();
}
}
else
{
MessageBox.Show("Aucune ligne selectionnée dans la liste", "ReservationTypes", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
//}
}
private void UpdateMontant()
{
if (rcbChambres.SelectedItem != null)
{
Chambres Cham = rcbChambres.SelectedItem as Chambres;
int NbreHr = -rtHD.SelectedTime.Value.Subtract(rtHF.SelectedTime.Value).Hours;
if (NbreHr > 0)
{
ReservationTypes resSer = GlobalData.model.ReservationTypes.Where(c => c.Etat == "ACTIF" && c.ReservationType == "PASSAGE").FirstOrDefault();
TypePrix tpPrix = GlobalData.model.TypePrix.Where(c => c.Etat == "ACTIF" && c.idReservationType == resSer.ID).FirstOrDefault();
var resreserv = from res in GlobalData.model.PrixChambres
where res.Etat == "ACTIF" && res.idTypePrix == tpPrix.idTypePrix && res.idTypeChambre == Cham.TypeChambre
select res;
if (resreserv != null && resreserv.Count() != 0)
{
PrixChambres prix = resreserv.FirstOrDefault();
var resOR = from res in GlobalData.model.OperationRules
where res.Etat == "ACTIF" && res.idReservationTypes == resSer.ID && res.idTypeChambre == Cham.TypeChambre
select res;
if (resOR != null && resOR.Count() != 0)
{
rntarif.Value = NbreHr * (double)prix.Prix;
foreach (OperationRules OpRule in resOR)
{
int nbr = (int)(NbreHr / (OpRule.Quantite + 1));
double h = NbreHr;
double n = (double)OpRule.Quantite;
double r = (double)OpRule.Reductions.Valeur;
double p = (double)prix.Prix;
double pc = 0;
switch (OpRule.Rules.idRules)
{
case 1:
pc = (r * (int)(h / (n + 1)));
rntarif.Value -= pc;
break;
case 2:
if (h > n)
{
pc = (r * (h - n));
}
else
{
pc = 0;
}
rntarif.Value -= pc;
break;
case 3:
pc = (r * h);
rntarif.Value -= pc;
break;
case 4:
pc = (r);
rntarif.Value -= pc;
break;
case 5:
pc = (r);
rntarif.Value -= pc;
break;
default:
break;
}
}
}
else
{
rntarif.Value = Convert.ToDouble(prix.Prix * NbreHr);
}
DisableBoutton(true);
}
else
{
return;
}
}
else
{
DisableBoutton(false);
}
}
}
private void btnEnregistrer_Click(object sender, RoutedEventArgs e)
{
try
{
//if (!GlobalData.VerifyClotureSession())
//{
// var result = MessageBox.Show("Voulez-vous fermer la session précédente ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Warning);
// if (result == MessageBoxResult.Yes)
// {
// RadDocumentPane radMenu = new RadDocumentPane();
// radMenu.Content = new GESHOTEL.ReservationsModules.Views.Win.ClotureJourneeFrm("Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString());
// radMenu.Header = "Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString();
// GlobalData.rrvMain.Title = "Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString();
// radMenu.FontFamily = new FontFamily("Perpetua Titling MT");
// radMenu.HorizontalAlignment = System.Windows.HorizontalAlignment.Stretch;
// radMenu.VerticalAlignment = System.Windows.VerticalAlignment.Stretch;
// if (!GlobalData.VerifyDock("Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString()))
// {
// GlobalData.PaneGroup.AddItem(radMenu, Telerik.Windows.Controls.Docking.DockPosition.Center);
// }
// else
// {
// }
// }
// return;
//}
Chambres Cham = chambreAutoCompleteBox.SelectedItem as Chambres;
if (Cham.EtatOperation == "SALLE")
{
MessageBox.Show("La chambre est salle veuillez la nettoyée", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
var results = MessageBox.Show("Voulez-vous enregistrer ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (results == MessageBoxResult.Yes)
{
int NbreHr = -rtHD.SelectedTime.Value.Subtract(rtHF.SelectedTime.Value).Hours;
if (rnHeure.Value <= 0)
{
MessageBox.Show("Le nombre d'heure ne peut pa etre egale a 0", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
if (chambreAutoCompleteBox.SelectedItem == null)
{
MessageBox.Show("Choisissez une chambre svp", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
if (NbreHr <= 0)
{
MessageBox.Show("Le nombre d'heure ne peut pa etre egale a 0", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
Transactions Trans = new Transactions();
Trans.DateTransaction = DateTime.Now;
Trans.TotalPaye = Convert.ToDecimal(rntarif.Value);
Trans.TotalTTC = Convert.ToDecimal(rntarif.Value);
Trans.TotalHT = Convert.ToDecimal(rntarif.Value);
Trans.TVA = 0;
Trans.TotalReste = 0;
Trans.Etat = "PAYE";
DetailPaiements dtPaie = new DetailPaiements();
dtPaie.Montant = rntarif.Value;
dtPaie.DatePaiement = DateTime.Now;
dtPaie.MethodePaiements = GlobalData.model.MethodePaiements.Where(c => c.Libelle == "ESPECE").First();
dtPaie.Transactions = Trans;
dtPaie.Etat = "ACTIF";
//dtPaie.idHotel = GlobalData.HotId;
Trans.DetailPaiements.Add(dtPaie);
if (Cham.EtatOperation == "LIBRE" || Cham.EtatOperation == "RESERVER")
{
Cham.EtatOperation = "OCCUPER";
}
DetailTransactions dtTrans = new DetailTransactions();
dtTrans.Date = DateTime.Now;
dtTrans.Descriptions = "CHAMBRE " + Cham.TypeChambres.Libelle + " " + Cham.Numero;
dtTrans.prix = Convert.ToDecimal(rntarif.Value);
dtTrans.Quantite = 1;
dtTrans.Montant = Convert.ToDecimal(rntarif.Value);
dtTrans.Transactions = Trans;
dtTrans.Etat = "ACTIF";
//dtTrans.idHotel = GlobalData.HotId;
dtTrans.Produits = GlobalData.model.Produits.Where(c => c.Libelle == "CHAMBRE").First();
Trans.DetailTransactions.Add(dtTrans);
ReservationTypes resType = GlobalData.model.ReservationTypes.Where(c => c.ReservationType == "PASSAGE").First();
Reservations Reservations = new Reservations();
Reservations.ReservationDate = DateTime.Now;
Reservations.Chambres = Cham;
Reservations.Transactions.Add(Trans);
Reservations.ReservationTypes = resType;
Reservations.NbreNuit = NbreHr;
Reservations.Etat = "ACTIF";
Reservations.EtatOperation = "ARRIVEE";
Reservations.TotalPaye = Trans.TotalPaye;
Reservations.TotalReste = Trans.TotalReste;
Reservations.TotalTTC = Trans.TotalTTC;
Reservations.DateDepart = new DateTime(rtHF.SelectedDate.Value.Year, rtHF.SelectedDate.Value.Month, rtHF.SelectedDate.Value.Day, rtHF.SelectedTime.Value.Hours, rtHF.SelectedTime.Value.Minutes, rtHF.SelectedTime.Value.Seconds);
Reservations.DateArrive = new DateTime(rtHD.SelectedDate.Value.Year, rtHD.SelectedDate.Value.Month, rtHD.SelectedDate.Value.Day, rtHD.SelectedTime.Value.Hours, rtHD.SelectedTime.Value.Minutes, rtHD.SelectedTime.Value.Seconds);
Reservations.TypeOperation = "LOCATION CHAMBRE";
Reservations.DateCheckIn = DateTime.Now;
Reservations.isCheckIn = true;
//Reservations.idHotel = GlobalData.HotId;
Reservations.idRegistre = GlobalData.RegId;
//Trans.idHotel = GlobalData.HotId;
Trans.idRegistre = GlobalData.RegId;
Trans.TypeTransaction = resType.ReservationType;
Parametres param = GlobalData.model.Parametres.Where(c => c.IdParametre == 1).First();
Trans.TransactionNumero = GlobalData.GenerateFacture(param.TransNum.ToString(), 6);
param.TransNum++;
GlobalData.model.Transactions.Add(Trans);
GlobalData.model.Reservations.Add(Reservations);
GlobalData.model.SaveChanges();
var result = MessageBox.Show("Voulez vous imprimer le recu?", "Vente", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
try
{
//RapportWindows frm = new RapportWindows(Reservations.ID, "", "ALL");
//frm.ShowDialog();
//frm.Print();
}
catch (Exception ex)
{
}
}
//MessageBox.Show("Operation terminée", "Message", MessageBoxButton.OK, MessageBoxImage.None);
Clear();
GlobalFO.rpVM.Load();
chambreAutoCompleteBox.Focus();
}
}
catch (Exception ex)
{
if (ex.Message == "Échec du fournisseur sous-jacent sur Commit.")
{
}
else
{
}
}
}
public void Update(ReservationTypes item)
{
_efreservationtypeDAL.Update(item);
}
public void Delete(ReservationTypes item)
{
_efreservationtypeDAL.Delete(item);
}
public void Add(ReservationTypes item)
{
_efreservationtypeDAL.Add(item);
}
// Transform the given rental orders to custom appointments ready to be bound to the scheduler
public ObservableCollection <CustomAppointment> LoadAppointments(IEnumerable <Reservations> rentalOrders)
{
IEnumerable <Chambres> cars = GlobalData.model.Chambres.Where(c => c.Etat != "SUPPRIMER");
IEnumerable <ReservationTypes> cats = GlobalData.model.ReservationTypes.Where(c => c.Etat != "SUPPRIMER");
IEnumerable <TimeMarkers> tm = GlobalData.model.TimeMarkers;
ObservableCollection <CustomAppointment> appointments = new ObservableCollection <CustomAppointment>();
if (rentalOrders != null)
{
foreach (Reservations order in rentalOrders)
{
try
{
CustomAppointment app = new CustomAppointment();
Chambres cham = cars.First(x => x.ID == order.idChambre);
ReservationTypes category = cats.First(x => x.ID == order.idReservationType);
TimeMarkers timemarker = tm.First(x => x.TimeMarkerName == order.EtatOperation);
app.UniqueId = order.ID.ToString();
app.ReservationID = order.ID;
app.ChambreID = order.idChambre.ToString();
app.Start = order.DateArrive.Value;
app.End = order.DateDepart.Value;
app.Category = category;
app.TimeMarker = timemarker;
app.Chambre = "Chambres : " + cham.Numero;
//app.TypeChambreID = cham.TypeChambre.ToString();
if (order.ReservationTypes.ReservationType == "PASSAGE")
{
app.Subject = order.ReservationTypes.ReservationType;
int nbr = -order.DateArrive.Value.Subtract(order.DateDepart.Value).Hours;
app.NbreHeure = "" + nbr + " Hr";
}
else if (order.ReservationTypes.ReservationType == "MAINTENANCE")
{
app.Subject = order.ReservationTypes.ReservationType;
app.NbreHeure = "" + order.NbreNuit + " Nuit";
}
else
{
app.Subject = order.Clients.Noms;
app.NbreHeure = "" + order.NbreNuit + " Nuit";
}
if (order.Etat == "RESERVER")
{
ReservationTypes Dcategory = cats.First(x => x.CategoryName == "RESERVATION");
Dcategory.ReservationEtat = order.Etat;
app.Category = Dcategory;
}
if (order.Etat == "DUE OUT")
{
ReservationTypes Dcategory = cats.First(x => x.CategoryName == "DUE OUT");
Dcategory.ReservationEtat = order.Etat;
app.Category = Dcategory;
}
//category.ReservationEtat = order.Etat;
app.Etat = order.Etat;
//app.Localite = order.Localite;
appointments.Add(app);
}
catch (Exception)
{
}
}
}
return(appointments);
}
