예제 #1
0
 public static Models.Planning MapReaderToPlannings(SqlDataReader reader)
 {
     Models.Planning planning = new Models.Planning {
         IdPlan  = Convert.ToInt32(reader["PLAN_ID"]),
         DateVol = Convert.ToDateTime(reader["PLAN_VOL_DATE"].ToString()),
         IdVol   = Convert.ToInt32(reader["PLAN_VOL_ID"].ToString())
     };
     return(planning);
 }
예제 #2
0
        private void cmbDateVol_SelectedIndexChanged(object sender, EventArgs e)
        {
            Models.Vol      oVol      = (Models.Vol)cmbVolDetails.SelectedItem;
            Models.Planning oPlanning = (Models.Planning)cmbDateVol.SelectedItem;

            DataSet dataSet = new DataSet();
            DataSet oDataCa = new DataSet();
            int     nbPassagers;
            int     nbPlacesRes;
            decimal tauxOcp;
            decimal ca;

            try {
                dataSet = BLPlannings.GetListePassagers(oVol.IdVol, oPlanning.IdPlan);
                dataGridViewPassagers.DataSource = dataSet.Tables[0].DefaultView;
                BLVols.GetStatsVol(oVol.IdVol, oPlanning.IdPlan, out nbPassagers, out nbPlacesRes, out tauxOcp, out ca);
                oDataCa = BLVols.GetCaTrancheVol(oPlanning.IdPlan);
                if (oDataCa == null)
                {
                    dataGridViewCA.DataSource = null;
                }
                else
                {
                    dataGridViewCA.DataSource = oDataCa.Tables[0].DefaultView;
                }
                txtNbPassagers.Text       = nbPassagers.ToString();
                txtNbPlacesRestantes.Text = nbPlacesRes.ToString();
                txtOccupationVol.Text     = tauxOcp.ToString();
                txtCAVol.Text             = ca.ToString();
            }
            catch (CustomError cEx) {
                MessageBox.Show(cEx.Message);
            }
            catch (Exception ex) {
                CustomError cEx = new CustomError(666);
                MessageBox.Show(cEx.Message);
            }
        }