private void ToolStripBtnReports_Click(object sender, EventArgs e)
{
if (ComJobSelector.GetJobListView().GetSelectedItemID() > 0)
{
mDocManager_O.ShowJobInfoDocument(ComJobSelector.GetJobListView().GetSelectedItemID());
}
}
private void ToolStripBtnReturn_Click(object sender, EventArgs e)
{
if (mDocManager_O != null && ComJobSelector.GetJobListView().GetSelectedItemID() > 0)
{
mDocManager_O.ShowReturnDocument(ComJobSelector.GetJobListView().GetSelectedItemID());
}
}
private void ToolStripBtnCancelJob_Click(object sender, EventArgs e)
{
if (mDBManager_O != null && mDBManager_O.mConnected_b && ComJobSelector.GetJobListView().GetSelectedItemID() > 0)
{
UInt32 ComJobStatusID_UL;
UInt32.TryParse(mDBManager_O.GetTableField("ComJob", "ComStatusID", "ComJobID=" + (ComJobSelector.GetJobListView().GetSelectedItemID())), out ComJobStatusID_UL);
// If job status id is 1 (recorded) it means to nothing has been done on this job, and it can be deleted
if (ComJobStatusID_UL == 1)
{
DialogResult DlgRes_O = MessageBox.Show("La suppression d'un job est une action irréversible (les données seront perdues), êtes-vous certain de vouloir continuer ?", "Attention !", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (DlgRes_O == DialogResult.Yes)
{
mDBManager_O.ExecuteRequest("DELETE FROM ComJob WHERE ComJobID=" + ComJobSelector.GetJobListView().GetSelectedItemID());
ClearJobInfo();
ComJobSelector.GetJobListView().Refresh();
}
}
else
{
DialogResult DlgRes_O = MessageBox.Show("La suppression d'un job dont le statut n'est pas 'en cours' entraine la perte de tous les pointages associés, êtes-vous certain de vouloir continuer ?", "Attention !", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (DlgRes_O == DialogResult.Yes)
{
if (mDBManager_O.mStoredProcedureManager_O.STPROC_DeletePointageAndEtape(ComJobSelector.GetJobListView().GetSelectedItemID()))
{
mDBManager_O.ExecuteRequest("DELETE FROM ComJob WHERE ComJobID=" + ComJobSelector.GetJobListView().GetSelectedItemID());
ClearJobInfo();
ComJobSelector.GetJobListView().Refresh();
}
}
}
}
}
private void ToolStripBtnAddJob_Click(object sender, EventArgs e)
{
if (mDBManager_O != null && mDBManager_O.mConnected_b && ComJobSelector.GetComListView().GetSelectedItemID() > 0)
{
UInt32 NewJobID_UL = mDBManager_O.mStoredProcedureManager_O.STPROC_CreateEmptyJob(ComJobSelector.GetComListView().GetSelectedItemID());
ComJobSelector.GetJobListView().Refresh();
ComJobSelector.GetJobListView().SelectItemByID(NewJobID_UL);
}
}
public bool Activate(Control Container_O)
{
mParentContainer_O = Container_O;
mParentContainer_O.Controls.Add(this);
this.BringToFront();
this.Dock = DockStyle.Fill;
ComClick(ComJobSelector.GetComListView().GetSelectedItemID());
JobClick(ComJobSelector.GetJobListView().GetSelectedItemID());
return(true);
}
private void ComClick(UInt32 ComID_UL)
{
// Load client info in each control
String SQLRequest_ST;
SqlDataReader SqlDataReader_O;
int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0;
mInitializingComData_b = true;
ClearComInfo();
if (ComJobSelector.GetJobListView().GetSelectedItemID() == 0)
{
ClearJobInfo();
}
if (mDBManager_O != null && mDBManager_O.mConnected_b)
{
SQLRequest_ST = "SELECT * FROM ComSelectPop WHERE ComID=" + ComID_UL;
SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST);
while (SqlDataReader_O.Read())
{
int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i);
int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i);
int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i);
// Fill info in panel edit controls
TxtComNumber.Text = SqlDataReader_O["NumRefInterne"].ToString();
TxtClient.Text = SqlDataReader_O["ClientNom"].ToString();
try
{
DTPComDate.Value = Convert.ToDateTime(SqlDataReader_O["ComDate"].ToString());
}
catch (FormatException e)
{
DTPComDate.Value = DTPComDate.MinDate;
}
TxtNumComClient.Text = SqlDataReader_O["NumCmdClient"].ToString();
TxtComLib.Text = SqlDataReader_O["LibelleCmd"].ToString();
TxtComInfos.Text = SqlDataReader_O["Info"].ToString();
CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false;
CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false;
CheckBoxCertif.Checked = Certif_i != 0 ? true : false;
}
SqlDataReader_O.Close();
}
mInitializingComData_b = false;
}
private void ToolStripBtnAddNeCertif_Click(object sender, EventArgs e)
{
if (ComJobSelector.GetJobListView().GetSelectedItemID() > 0)
{
FormNeCertif FormNeCertif_O = new FormNeCertif(mDBManager_O, ComJobSelector.GetJobListView().GetSelectedItemID());
if (FormNeCertif_O.ShowDialog() == DialogResult.OK)
{
JobClick(ComJobSelector.GetJobListView().GetSelectedItemID());
}
}
else
{
MessageBox.Show("Veuillez sélectionner un job sur lequel ajouter une note d'envoi", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ComJobUC(DatabaseManager DBManager_O, DocumentManager DocManager_O)
{
InitializeComponent();
this.ComJobSelector.AddComToolStripBtn(this.ToolStripBtnCancelCmd);
this.ComJobSelector.AddComToolStripBtn(this.ToolStripBtnAddCom);
this.ToolStripCom.Visible = false;
this.ComJobSelector.AddJobToolStripBtn(this.ToolStripBtnCancelJob);
this.ComJobSelector.AddJobToolStripBtn(this.ToolStripBtnAddJob);
this.ToolStripJob.Visible = false;
mDBManager_O = DBManager_O;
mDocManager_O = DocManager_O;
ComJobSelector.Initialize(mDBManager_O);
SetComEditState(false);
SetJobEditState(false);
ComJobSelector.GetComListView().SelectionChanged += new DBListView.SelectionChangedHandler(this.ComClick);
ComJobSelector.GetJobListView().SelectionChanged += new DBListView.SelectionChangedHandler(this.JobClick);
JobAssociatedDep.Initialize(mDBManager_O);
JobAssociatedDep.DepartmentsModified += new DepartmentSelector.DepartmentsModifiedHandler(this.JobValueChanged);
ToolStripComTools.Renderer = new BorderlessToolStripRenderer();
ToolStripJobTools.Renderer = new BorderlessToolStripRenderer();
ToolStripComHeader.Renderer = new BorderlessToolStripRenderer();
ToolStripJobHeader.Renderer = new BorderlessToolStripRenderer();
ToolStripJobDocuments.Renderer = new BorderlessToolStripRenderer();
ToolStripNEAndCertif.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetFrameHeaderStyle(this.ToolStripComTools);
ControlStyle.SetFrameHeaderStyle(this.ToolStripJobTools);
ControlStyle.SetBackgroundStyle(this.splitContainer1.Panel2);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel2);
ControlStyle.SetFrameStyle(this.ToolStripComEditFooter);
ControlStyle.SetFrameStyle(this.PanelCmdInfo);
ControlStyle.SetFrameStyle(this.PanelJobInfo);
ControlStyle.SetFrameStyle(this.ToolStripJobEditFooter);
ControlStyle.SetFrameStyle(this.JobAssociatedDep);
ControlStyle.SetFrameStyle(this.ToolStripJobDocuments);
ControlStyle.SetFrameStyle(this.ToolStripNEAndCertif);
}
private void JobValueChanged(object sender, EventArgs e)
{
if (ComJobSelector.GetJobListView().GetSelectedItemID() > 0 && !mInitializingJobData_b && !mIgnoreJobValueChangedEvent_b)
{
// Handle special case : if delai client is changed, change delais promis with it
if (sender.GetType() == typeof(DateTimePicker) && ((DateTimePicker)sender).Equals(DTPClientDelay))
{
DTPPromiseDelay.Value = DTPClientDelay.Value;
}
// When edit a job, lock com selection
ComJobSelector.GetComListView().SetLockState(true);
ComJobSelector.GetJobListView().SetLockState(true);
SetJobEditState(true);
if (sender.GetType() == typeof(DepartmentSelector))
{
mUpdateDepartmentAssociation_b = true;
}
}
}
private void BtnCancelJobChanges_Click(object sender, EventArgs e)
{
if (mJobEditState_b)
{
DialogResult DlgRes_O = MessageBox.Show("Les modifications effectuées sur le job seront perdues, continuer ?", "Attention", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (DlgRes_O == DialogResult.Yes)
{
SetJobEditState(false);
ComJobSelector.GetJobListView().SetLockState(false);
if (!mComEditState_b)
{
ComJobSelector.GetComListView().SetLockState(false);
}
mUpdateDepartmentAssociation_b = false;
ComJobSelector.GetJobListView().SelectItemByID(ComJobSelector.GetJobListView().GetSelectedItemID());
}
}
}
private void ToolStripBtnReturnDBListView_Click(object sender, EventArgs e)
{
FormReturnListView FormReturnListView_O = new FormReturnListView(mDBManager_O, ComJobSelector.GetJobListView().GetSelectedItemID());
FormReturnListView_O.ShowDialog();
}
private void BtnSaveJobChanges_Click(object sender, EventArgs e)
{
if (mJobEditState_b)
{
UInt32 JobID_UL = ComJobSelector.GetJobListView().GetSelectedItemID();
//Build update request
if (mDBManager_O != null && mDBManager_O.mConnected_b)
{
List <String> Param_O = new List <String>();
List <Object> Values_O = new List <Object>();
String SQLCommand_st = @"UPDATE ComJob SET JobLib=@JobLib, Qte=@Qte, QteProd=@QteProd, HTravEstim=@HTravEstim, CoutEstim=@CoutEstim, DelaiClient=@DelaiClient," +
"DelaiPromis=@DelaiPromis, ChkRegie=@ChkRegie, InfoJob=@InfoJob " +
"WHERE ComJobID=@ComJobID";
Param_O.Add("@JobLib");
Param_O.Add("@Qte");
Param_O.Add("@QteProd");
Param_O.Add("@HTravEstim");
Param_O.Add("@CoutEstim");
Param_O.Add("@DelaiClient");
Param_O.Add("@DelaiPromis");
Param_O.Add("@ChkRegie");
Param_O.Add("@InfoJob");
Param_O.Add("@ComJobID");
Values_O.Add(ToolStripBtnJobLib.Text);
Values_O.Add(TxtQte.Text);
Values_O.Add(TxtQteProd.Text);
Values_O.Add(TxtHEstim.Text);
Values_O.Add(TxtPVUnitEst.Text);
Values_O.Add(DTPClientDelay.Value);
Values_O.Add(DTPPromiseDelay.Value);
Values_O.Add(CheckBoxRegieWork.Checked);
Values_O.Add(TxtJobInfo.Text);
Values_O.Add((int)JobID_UL);
mDBManager_O.ExecuteRequest(SQLCommand_st, Param_O, Values_O);
Param_O.Clear();
Values_O.Clear();
if (mUpdateDepartmentAssociation_b)
{
// Remove all association
SQLCommand_st = @"DELETE FROM RelJobTypeDep WHERE ComJobID=@ComJobID";
Param_O.Add("@ComJobID"); Values_O.Add((int)ComJobSelector.GetJobListView().GetSelectedItemID());
mDBManager_O.ExecuteRequest(SQLCommand_st, Param_O, Values_O);
Param_O.Clear();
Values_O.Clear();
// Add them back plus new ones
List <UInt32> IdList_UL = JobAssociatedDep.GetSelectedDepartmentsID();
for (int i = 0; i < IdList_UL.Count; i++)
{
SQLCommand_st = @"INSERT INTO RelJobTypeDep(TypeDepID, ComJobID) VALUES (@TypeDepID, @ComJobID)";
Param_O.Add("@TypeDepID"); Values_O.Add((int)IdList_UL[i]);
Param_O.Add("@ComJobID"); Values_O.Add((int)ComJobSelector.GetJobListView().GetSelectedItemID());
mDBManager_O.ExecuteRequest(SQLCommand_st, Param_O, Values_O);
Param_O.Clear();
Values_O.Clear();
}
mUpdateDepartmentAssociation_b = false;
}
}
SetJobEditState(false);
ComJobSelector.GetJobListView().SetLockState(false);
if (!mComEditState_b)
{
ComJobSelector.GetComListView().SetLockState(false);
}
ComJobSelector.GetJobListView().Refresh();
ComJobSelector.GetJobListView().SelectItemByID(JobID_UL);
}
}
