public bool Undo()
{
if (State == States.ADD || State == States.EDIT)
{
if (Convert.ToInt16(DTR_Arrive["NoCham"]) != -1)
{
if (DTR_De != null)
{
string old_room = DTR_De["NoCham"].ToString();
if (old_room != DTR_De["NoCham"].ToString())
{
BS_RESERVATION.Position = BS_RESERVATION.Find("IdReser", DTR_Arrive["IdReser"]);
DataRowView De = (DataRowView)BS_CHAMBRE[BS_CHAMBRE.Find("NoCham", old_room)];
DataRow DTR_De_old = De.Row;
DTR_De_old.BeginEdit();
DTR_De_old["Attribuee"] = false;
DTR_De_old.EndEdit();
}
}
}
if (State == States.ADD)
{
DTR_Arrive.Delete();
}
Fill(States.CONSULT);
Sync_ForeignTables();
Link_All(true);
}
return(true);
}
public void OnReservSelected(int IdReser)
{
//lc_arrive.SetListButton(true);
ir_arrive.BS = BS_RESERVATION;
if (Convert.ToInt16(DTR_Arrive["NoCham"]) != -1)
{
BS_RESERVATION.Position = BS_RESERVATION.Find("IdReser", DTR_Arrive["IdReser"]);
DataRowView De = (DataRowView)BS_CHAMBRE[BS_CHAMBRE.Find("NoCham", DTR_Arrive["NoCham"])];
DTR_De = De.Row;
DTR_De.BeginEdit();
DTR_De["Attribuee"] = false;
DTR_Arrive["NoCham"] = -1;
DTR_Arrive.SetColumnError(DTR_Arrive.Table.Columns["NoCham"], "Une chambre doit être sélectionnée.");
}
DTR_Arrive["IdReser"] = IdReser;
DTR_Arrive.EndEdit();
if (DTR_Arrive.GetColumnError("IdReser") != "")
{
DTR_Arrive.SetColumnError(DTR_Arrive.Table.Columns["IdReser"], "");
}
errorProvider.SetError(ir_arrive.tb_noReserv, "");
Link_RESERVATION(true);
Link_CHAMBRE(true);
Sync_ForeignTables();
}
public bool Undo()
{
if (State == States.ADD || State == States.EDIT)
{
bool stateEdit = (State == States.EDIT);
State = States.CONSULT; //STATE??
prixAjust = false;
userChangePrix = false;
errorProvider.Clear();
if (mustFocusNoCham)
{
tb_noCham.ReadOnly = true;
LinkTextData();
}
else
{
DTR_Chambre.EndEdit();
dS_Master.Tables["CHAMBRE"].RejectChanges();
dS_Master.Tables["AYANT"].RejectChanges();
BS_CHAMBRE.ResetCurrentItem();
}
mustFocusNoCham = false;
BS_CHAMBRE.Position = 0;
if (stateEdit)
{
TA_CHAMBRE.FillByCHAMBRE(dS_Master.CHAMBRE);
}
}
return(true);
}
private bool IsNoChamValide(int validationCase)
{
if (validationCase == 0 || validationCase == 1)
{
errorProvider.SetError(tb_noCham, string.Empty);
}
if (tb_noCham.Text.Length != 3 || !IsNumeric(tb_noCham.Text))
{
errorProvider.SetError(tb_noCham, "Vous devez entrez un numéro de chambre composé de 3 chiffres");
return(false);
}
else
{
int index = BS_CHAMBRE.Find("NoCham", tb_noCham.Text);
if (index < 0)
{
if (State != States.ADD)
{
errorProvider.SetError(tb_noCham, "Ce numéro de chambre n'existe pas");
return(false);
}
else
{
errorProvider.SetError(tb_noCham, string.Empty);
return(true);
}
}
else
{
if (State == States.ADD && validationCase == 0)
{
errorProvider.SetError(tb_noCham, "Vous devez entrez un numéro de chambre qui n'existe pas");
return(false);
}
else if (State == States.ADD && validationCase == 1)
{
errorProvider.SetError(tb_noCham, string.Empty);
return(true);
}
else
{
errorProvider.SetError(tb_noCham, string.Empty);
return(true);
}
}
}
}
public void Fill()
{
string safeNoCham = tb_noCham.Text;
if (State == States.CONSULT)
{
TA_CHAMBRE.FillByCHAMBRE(this.dS_Master.CHAMBRE);
TA_AYANT.FillBy(this.dS_Master.AYANT);
}
TA_COMMODITE.Fill(this.dS_Master.COMMODITE);
TA_TYPECHAM.Fill(this.dS_Master.TYPECHAM);
TA_LOCALISATION.Fill(this.dS_Master.LOCALISATION);
if (tb_noCham.ReadOnly && BS_CHAMBRE.DataSource != null)
{
BS_CHAMBRE.Position = BS_CHAMBRE.Find("NoCham", safeNoCham);
}
}
public bool Delete()
{
bool hasDepartB = hasDepart(ds_master.ARRIVE[BS_ARRIVE.Position]["IdArrive"].ToString());
bool hasTrxB = hasTrx(ds_master.ARRIVE[BS_ARRIVE.Position]["IdArrive"].ToString());
if (!hasDepartB && !hasTrxB)
{
DialogResult result = MessageBox.Show("Do you want to delete the arrive?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
switch (result)
{
case DialogResult.Yes:
DataRowView De = (DataRowView)BS_CHAMBRE[BS_CHAMBRE.Find("NoCham", ds_master.ARRIVE[BS_ARRIVE.Position]["NoCham"])];
DTR_De = De.Row;
DTR_De.BeginEdit();
DTR_De["Attribuee"] = false;
DTR_De.EndEdit();
BS_ARRIVE.RemoveCurrent();
TA_ARRIVE.Update(ds_master.ARRIVE);
TA_DE.Update(ds_master.DE);
if (BS_ARRIVE.Count == 0)
{
Link_All(false);
ic_arrive.WipeInformation();
ir_arrive.WipeInformation();
}
Sync_ForeignTables();
MessageBox.Show("Deletion successful");
return(true);
case DialogResult.No:
return(false);
default:
return(false);
}
}
else
{
MessageBox.Show("Can't delete an arrive with a " + (hasDepartB ? (hasTrxB ? "depart and a transaction" : "depart") : "transaction"), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public void OnChambreSelected(int NoCham)
{
if (State == States.ADD || State == States.EDIT)
{
DataRowView De = (DataRowView)BS_CHAMBRE[BS_CHAMBRE.Find("NoCham", NoCham)];
DTR_De = De.Row;
if (Convert.ToInt16(DTR_De["NoCham"]) != Convert.ToInt16(DTR_Arrive["NoCham"]))
{
if (Convert.ToBoolean(DTR_De["Attribuee"]) == false)
{
DTR_De.BeginEdit();
DTR_De["Attribuee"] = true;
DTR_De.EndEdit();
if (Convert.ToInt16(DTR_Arrive["NoCham"]) != -1)
{
De = (DataRowView)BS_CHAMBRE[BS_CHAMBRE.Find("NoCham", Convert.ToInt16(DTR_Arrive["NoCham"]))];
DataRow DTR_De_old = De.Row;
DTR_De_old.BeginEdit();
DTR_De_old["Attribuee"] = false;
DTR_De_old.EndEdit();
}
DTR_Arrive["NoCham"] = NoCham;
if (DTR_Arrive.GetColumnError("NoCham") != "")
{
DTR_Arrive.SetColumnError(DTR_Arrive.Table.Columns["NoCham"], "");
}
errorProvider.SetError(ic_arrive.tb_noChambre, "");
Sync_ForeignTables();
}
else
{
MessageBox.Show("Chambre déjà attribuée", "Erreur chambre", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void DeleteChambre()
{
BS_AYANT.Position = 0;
DTR_Chambre = dS_Master.Tables["CHAMBRE"].Rows[BS_CHAMBRE.Position];
foreach (DataRow DTR_toDel in DTR_Chambre.GetChildRows("AYANT_FK_NoCham"))
{
BS_AYANT.RemoveCurrent();
BS_AYANT.Position++;
}
BS_CHAMBRE.RemoveCurrent();
BS_CHAMBRE.MoveFirst();
try
{
TA_AYANT.Update(dS_Master.AYANT);
TA_CHAMBRE.Update(dS_Master.CHAMBRE);
AjustNbDispoInTypeCham();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Go_End()
{
BS_CHAMBRE.MoveLast();
}
public void Go_Forward()
{
BS_CHAMBRE.MoveNext();
}
public void Go_Back()
{
BS_CHAMBRE.MovePrevious();
}
public void Go_Start()
{
BS_CHAMBRE.MoveFirst();
}
