private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
RESULT_QUERY res = new RESULT_QUERY();
GridView v = sender as GridView;
if (v.IsNewItemRow(e.RowHandle))
{
//Ajout
DTARIF_VENTE tarif = new DTARIF_VENTE();
tarif.TRV_ID = (decimal)(e.Row as DataRowView)["TRV_ID"];
tarif.TRV_LIBELLE = (e.Row as DataRowView)["TRV_LIBELLE"].ToString();
tarif.TRV_CODE_ARTICLE = (decimal)(e.Row as DataRowView)["TRV_CODE_ARTICLE"];
tarif.TRV_CODE_CLIENT = (e.Row as DataRowView)["TRV_CODE_CLIENT"] == null?0:(decimal)(e.Row as DataRowView)["TRV_CODE_CLIENT"];
tarif.TRV_CODE_UNITE = (decimal)(e.Row as DataRowView)["TRV_CODE_UNITE"];
tarif.TRV_CREATEUR = Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user);
tarif.TRV_MODIFICATEUR = Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user);
tarif.TRV_DATE_CREATION = Convert.ToDateTime((e.Row as DataRowView)["TRV_DATE_CREATION"]);
tarif.TRV_DATE_MODIF = Convert.ToDateTime((e.Row as DataRowView)["TRV_DATE_MODIF"]);
tarif.TRV_DEBUT_VALID = Convert.ToDateTime(Convert.ToDateTime((e.Row as DataRowView)["TRV_DEBUT_VALID"]).ToShortDateString());
tarif.TRV_FIN_VALID = Convert.ToDateTime(Convert.ToDateTime((e.Row as DataRowView)["TRV_FIN_VALID"]).ToShortDateString());
tarif.TRV_PRIX_HT = (decimal)(e.Row as DataRowView)["TRV_PRIX_HT"];
tarif.TRV_TX_REMISE = (decimal)(e.Row as DataRowView)["TRV_TX_REMISE"];
res = CLIENT_APP_PARAM.gcws.AjoutTarifVente(tarif);
if (res.OK)
{
(e.Row as DataRowView)["TRV_ID"] = res.CODE;
}
else
{
MessageBox.Show(res.MESSAGE, "Erreur création", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
//Modification
DTARIF_VENTE tarif = new DTARIF_VENTE();
tarif.TRV_ID = (decimal)(e.Row as DataRowView)["TRV_ID"];
tarif.TRV_LIBELLE = (e.Row as DataRowView)["TRV_LIBELLE"].ToString();
tarif.TRV_CODE_ARTICLE = (decimal)(e.Row as DataRowView)["TRV_CODE_ARTICLE"];
tarif.TRV_CODE_CLIENT = (decimal)(e.Row as DataRowView)["TRV_CODE_CLIENT"];
tarif.TRV_CODE_UNITE = (decimal)(e.Row as DataRowView)["TRV_CODE_UNITE"];
tarif.TRV_MODIFICATEUR = Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user);
tarif.TRV_DATE_MODIF = DateTime.Now;
tarif.TRV_DEBUT_VALID = Convert.ToDateTime(Convert.ToDateTime((e.Row as DataRowView)["TRV_DEBUT_VALID"]).ToShortDateString());
tarif.TRV_FIN_VALID = Convert.ToDateTime(Convert.ToDateTime((e.Row as DataRowView)["TRV_FIN_VALID"]).ToShortDateString());
tarif.TRV_PRIX_HT = (decimal)(e.Row as DataRowView)["TRV_PRIX_HT"];
tarif.TRV_TX_REMISE = (decimal)(e.Row as DataRowView)["TRV_TX_REMISE"];
res = CLIENT_APP_PARAM.gcws.ModifTarifVente(tarif);
if (res.OK)
{
MessageBox.Show(res.MESSAGE, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(res.MESSAGE, "Erreur modification", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void gridView1_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
GridView v = sender as GridView;
string s = v.GetRowCellValue(e.RowHandle, "TRV_CODE_CLIENT").ToString();
if (s == "")
{
e.Valid = false;
return;
}
DTARIF_VENTE trv = new DTARIF_VENTE()
{
TRV_CODE_ARTICLE = (decimal)(e.Row as DataRowView)["TRV_CODE_ARTICLE"],
TRV_CODE_CLIENT = (decimal)(e.Row as DataRowView)["TRV_CODE_CLIENT"],
TRV_DEBUT_VALID = Convert.ToDateTime((e.Row as DataRowView)["TRV_DEBUT_VALID"]),
TRV_FIN_VALID = Convert.ToDateTime((e.Row as DataRowView)["TRV_FIN_VALID"]),
TRV_CODE_UNITE = (decimal)(e.Row as DataRowView)["TRV_CODE_UNITE"],
TRV_ID = (decimal)(e.Row as DataRowView)["TRV_ID"]
};
if (CLIENT_APP_PARAM.gcws.VerifExistTarifVente(trv).Rows.Count > 0)
{
MessageBox.Show("Il exist déja un tarif dans cette periode.", "Erreur validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
e.Valid = false;
return;
}
}
