private bool refereceChecker(string myref)
{
return(ConsommationCRUDOps.refereceChecker(myref));
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (this.fieldsAreEmpty(InsertOrUpdate))
{
MessageBox.Show("Vous devez remplir les champs nécessaires", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (InsertOrUpdate == true) // means Insert new record
{
bool UserConfirm = true;
int TransIn = TransferCRUDOps.GetSumOfQuantities(TransferCRUDOps.Target.Source, PoleCombobox.SelectedItem.Value),
TransOut = TransferCRUDOps.GetSumOfQuantities(TransferCRUDOps.Target.Destination, PoleCombobox.SelectedItem.Value),
PoleCons = ConsommationCRUDOps.getSumOfQuantities(PoleCombobox.SelectedItem.Value),
PoleAlm = AlimentationCRUDOps.getSumOfQuantities(PoleCombobox.SelectedItem.Value);
int Total = (PoleAlm + TransIn) - TransOut - PoleCons;
if (Total <= 0)
{
if (
MessageBox.Show("Attention... \n" +
"Le Stock de " + PoleCombobox.SelectedItem.Text + " : " + Total.ToString() +
"\nVous voulez validé", "Notification", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes
)
{
UserConfirm = true;
}
else
{
UserConfirm = false;
}
}
if (UserConfirm)
{
TransferCRUDOps.createTransfer(
ReftextBox.Text.Trim(),
TypeComboBox.Text.Trim(),
dateTimePicker.Value,
(EngineCombobox.SelectedItem == null) ? "0" : EngineCombobox.SelectedItem.Value,
(ProductCombobox.SelectedItem == null) ? "2" : ProductCombobox.SelectedItem.Value,
(PoleCombobox.SelectedItem == null) ? "0" : PoleCombobox.SelectedItem.Value,
(ToPoleCombobox.SelectedItem == null) ? "0" : ToPoleCombobox.SelectedItem.Value,
(DriverCombobox.SelectedItem == null) ? "0" : DriverCombobox.SelectedItem.Value,
KilotextBox.Text.Trim(),
QuanitytextBox.Text.Trim()
);
ResetFields();
}
}
else // means Update existing record
{
TransferCRUDOps.UpdateTransfer(
this.selectedID,
ReftextBox.Text.Trim(),
TypeComboBox.Text.Trim(),
dateTimePicker.Value,
(EngineCombobox.SelectedItem == null) ? null : EngineCombobox.SelectedItem.Value,
(ProductCombobox.SelectedItem == null) ? null : ProductCombobox.SelectedItem.Value,
(PoleCombobox.SelectedItem == null) ? null : PoleCombobox.SelectedItem.Value,
(ToPoleCombobox.SelectedItem == null) ? null : ToPoleCombobox.SelectedItem.Value,
(DriverCombobox.SelectedItem == null) ? null : DriverCombobox.SelectedItem.Value,
KilotextBox.Text.Trim(),
QuanitytextBox.Text.Trim()
);
this.Close();
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (this.fieldsAreEmpty(InsertOrUpdate))
{
MessageBox.Show("Vous devez remplir les champs nécessaires correctement", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
bool refConfirmation = true;
if (refereceChecker(ReftextBox.Text.Trim()))
{
if (MessageBox.Show("Attention... \n" +
"La reference utilisé, il existe déja!" +
"\nVous voulez validé", "Notification", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes)
{
refConfirmation = true;
}
else
{
refConfirmation = false;
}
}
if (refConfirmation)
{
if (InsertOrUpdate == true) // means Insert new record
{
// before you insert notify the user if the engine take productin int he same day
// get the selected engine && date
// MessageBox.Show(this.getSelectedEngine());
bool OccExist = this.FindReccurence(this.getSelectedEngine(),
dateTimePicker.Value.ToShortDateString());
bool userConfirmation = false;
// search for the selected engine in gridView with same date
if (OccExist)
{
if (MessageBox.Show("Attention... \n" +
"Ce n'est pas la première fois pour cette véhicule dans ce jour!\nVous voulez validé", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
userConfirmation = true;
}
}
// if the user accept to insert so be it ;)
if (userConfirmation || !OccExist)
{
string km = ((KilotextBox.Text.Trim() != "0") ? KilotextBox.Text.Trim() + "KM" : ""),
H = ((HeuretextBox.Text.Trim() != "0") ? HeuretextBox.Text.Trim() + "H" : "");
bool UserConfirm = true;
int TransIn = TransferCRUDOps.GetSumOfQuantities(TransferCRUDOps.Target.Source, PoleCombobox.SelectedItem.Value),
TransOut = TransferCRUDOps.GetSumOfQuantities(TransferCRUDOps.Target.Destination, PoleCombobox.SelectedItem.Value),
PoleCons = ConsommationCRUDOps.getSumOfQuantities(PoleCombobox.SelectedItem.Value),
PoleAlm = AlimentationCRUDOps.getSumOfQuantities(PoleCombobox.SelectedItem.Value);
int Total = (PoleAlm + TransIn) - TransOut - PoleCons;
if (Total <= 0)
{
if (
MessageBox.Show("Attention... \n" +
"Le Stock de " + PoleCombobox.SelectedItem.Text + " : " + Total.ToString() +
"\nVous voulez validé", "Notification", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes
)
{
UserConfirm = true;
}
else
{
UserConfirm = false;
}
}
if (UserConfirm)
{
bool res = ConsommationCRUDOps.createConsommation(
ReftextBox.Text.Trim(),
TypeComboBox.Text.Trim(),
dateTimePicker.Value,
(EngineCombobox.SelectedItem == null) ? "0" : EngineCombobox.SelectedItem.Value,
(ProductCombobox.SelectedItem == null) ? "2" : ProductCombobox.SelectedItem.Value,
(PoleCombobox.SelectedItem == null) ? "0"
: PoleCombobox.SelectedItem.Value,
(DriverCombobox.SelectedItem == null) ? "0" : DriverCombobox.SelectedItem.Value,
(ImputationComboBox.SelectedItem == null) ? "0" : ImputationComboBox.SelectedItem.Value,
((km != "" && H != "") ? km + ":" + H : ((km + H) == "") ? "CB." : (km + H)),
QuanitytextBox.Text.Trim(),
checkBoxPrinting.Checked,
checkBoxCalc.Checked
);
if (res)
{
this.ResetFields();
resetLocalFields();
}
}
}
}
else // means Update existing record
{
string km = ((KilotextBox.Text.Trim() != "0" && KilotextBox.Text.Trim() != "") ? KilotextBox.Text.Trim() + "KM" : ""),
H = ((HeuretextBox.Text.Trim() != "0" && HeuretextBox.Text.Trim() != "") ? HeuretextBox.Text.Trim() + "H" : "");
ConsommationCRUDOps.UpdateConsommation(
this.selectedID,
ReftextBox.Text.Trim(),
TypeComboBox.Text.Trim(),
dateTimePicker.Value,
(EngineCombobox.SelectedItem == null) ? null : EngineCombobox.SelectedItem.Value,
(ProductCombobox.SelectedItem == null) ? null : ProductCombobox.SelectedItem.Value,
(PoleCombobox.SelectedItem == null) ? null : PoleCombobox.SelectedItem.Value,
(DriverCombobox.SelectedItem == null) ? null : DriverCombobox.SelectedItem.Value,
(ImputationComboBox.SelectedItem == null) ? null : ImputationComboBox.SelectedItem.Value,
((km != "" && H != "") ? km + ":" + H : ((km + H) == "") ? "CB." : (km + H)),
// KilotextBox.Text.Trim() + "KM:" + HeuretextBox.Text.Trim() + "H",
QuanitytextBox.Text.Trim(),
checkBoxPrinting.Checked,
checkBoxCalc.Checked
);
this.Close();
this.ResetFields();
}
}
}
}
