public bool Insert(CsPosteTransformation pCodePoste)
{
try
{
return(InsertOrUpdate(pCodePoste));
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertOrUpdate(CsPosteTransformation st)
{
SqlConnection cn = new SqlConnection(Session.GetSqlConnexionString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 1800;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ACC_INSERTORUPDATE_POSTETRANSFORMATION";
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
cmd.Parameters.Add("@PK_ID", SqlDbType.Int).Value = st.PK_ID;
cmd.Parameters.Add("@CODE", SqlDbType.VarChar, 6).Value = st.CODE;
cmd.Parameters.Add("@LIBELLE", SqlDbType.VarChar, 50).Value = st.LIBELLE;
cmd.Parameters.Add("@USERCREATION", SqlDbType.VarChar, 20).Value = st.USERCREATION;
cmd.Parameters.Add("@USERMODIFICATION", SqlDbType.VarChar, 20).Value = st.USERMODIFICATION;
cmd.Parameters.Add("@FK_IDDEPARTHTA", SqlDbType.Int).Value = st.FK_IDDEPARTHTA;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
return(cmd.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public UcCodePoste(object[] pObjects, SessionObject.ExecMode[] pExecMode, DataGrid[] pGrid)
{
try
{
InitializeComponent();
Translate();
var categorieClient = new CsPosteTransformation();
if (pObjects[0] != null)
{
ObjetSelectionnee = Utility.ParseObject(categorieClient, pObjects[0] as CsPosteTransformation);
}
ModeExecution = pExecMode[0];
dataGrid = pGrid[0];
RemplirDepartHTA();
if (dataGrid != null)
{
donnesDatagrid = dataGrid.ItemsSource as ObservableCollection <CsPosteTransformation>;
}
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Modification || (SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Consultation)
{
if (ObjetSelectionnee != null)
{
Txt_Code.Text = ObjetSelectionnee.CODE;
Txt_Libelle.Text = ObjetSelectionnee.LIBELLE;
btnOk.IsEnabled = false;
//Txt_Code.IsReadOnly = true;
}
}
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Consultation)
{
AllInOne.ActivateControlsFromXaml(LayoutRoot, false);
}
VerifierSaisie();
}
catch (Exception ex)
{
Message.ShowError(ex.Message, Languages.LibelleCodePoste);
}
}
public bool Delete(CsPosteTransformation del)
{
SqlConnection cn = new SqlConnection(Session.GetSqlConnexionString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 1800;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ACC_DELETE_POSTETRANSFORMATION";
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
cmd.Parameters.Add("@PK_ID", SqlDbType.Int).Value = del.PK_ID;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
return(!reader.HasRows);
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
private List <CsPosteTransformation> GetInformationsFromScreen()
{
var listObjetForInsertOrUpdate = new List <CsPosteTransformation>();
try
{
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Creation)
{
var CodePoste = new CsPosteTransformation
{
CODE = Txt_Code.Text,
LIBELLE = Txt_Libelle.Text,
DATECREATION = DateTime.Now,
USERCREATION = UserConnecte.matricule,
FK_IDDEPARTHTA = (Cbo_Depart.SelectedItem as CsCodeDepart).PK_ID
};
if (!string.IsNullOrEmpty(Txt_Code.Text) && donnesDatagrid.FirstOrDefault(p => p.CODE == CodePoste.CODE) != null)
{
throw new Exception(Languages.CetElementExisteDeja);
}
listObjetForInsertOrUpdate.Add(CodePoste);
}
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Modification)
{
ObjetSelectionnee.CODE = Txt_Code.Text;
ObjetSelectionnee.LIBELLE = Txt_Libelle.Text;
ObjetSelectionnee.DATEMODIFICATION = DateTime.Now;
ObjetSelectionnee.USERMODIFICATION = UserConnecte.matricule;
ObjetSelectionnee.FK_IDDEPARTHTA = (Cbo_Depart.SelectedItem as CsCodeDepart).PK_ID;
listObjetForInsertOrUpdate.Add(ObjetSelectionnee);
}
return(listObjetForInsertOrUpdate);
}
catch (Exception ex)
{
Message.ShowError(ex.Message, Languages.LibelleCodePoste);
return(null);
}
}
private void UpdateParentList(CsPosteTransformation pCodePoste)
{
try
{
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Creation)
{
GetDataNew();
//donnesDatagrid.Add(pCodePoste);
}
if ((SessionObject.ExecMode)ModeExecution == SessionObject.ExecMode.Modification)
{
GetDataNew();
//var nationalite = donnesDatagrid.First(p => p.PK_ID == pCodePoste.PK_ID);
//donnesDatagrid.Remove(nationalite);
//donnesDatagrid.Add(pCodePoste);
}
}
catch (Exception ex)
{
throw ex;
}
}
