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 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);
}
}
}
}
public bool Save()
{
bool hasErrors = CheckSaveErrors();
if (State == States.ADD || State == States.EDIT)
{
if (!hasErrors)
{
DialogResult result = MessageBox.Show("Do you want to save the information?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
switch (result)
{
case DialogResult.Yes:
try
{
DTR_Arrive.EndEdit();
DTR_De.EndEdit();
TA_ARRIVE.Update(ds_master.ARRIVE);
TA_DE.Update(ds_master.DE);
Link_All(true);
this.TA_RESERVATION.FillByARRIVE(this.ds_master.RESERVATION);
Sync_ForeignTables();
}
catch (Exception e)
{
hasErrors = true;
MessageBox.Show(e.Message);
}
return(true);
case DialogResult.No:
return(false);
default:
return(false);
}
}
}
return(!hasErrors);
}
