protected DataSet GetCurrentMonthData(DateTime firstDate,
DateTime lastDate)
{
DataSet dsMonth = new DataSet();
/*query = "SELECT HolidayDate FROM Holidays " + _
* " WHERE HolidayDate >= @firstDate AND HolidayDate < @lastDate";*/
string _constr = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDb"].ToString();
DAL.DAL _dal = new DAL.DAL(_constr, DAL.DAL.Moteurs.SQLSERVER.ToString());
if (_dal.IsConnexionFermee())
{
//Ouverture de la connection
_dal.OuvrirConnexion();
}
string[] _param = new string[2];
_param[0] = "@MOIS" + ";" + SqlDbType.NVarChar + ";" + DateTime.Parse(datemy.Value).ToString("MM");
_param[1] = "@ANNEE" + ";" + SqlDbType.NVarChar + ";" + DateTime.Parse(datemy.Value).ToString("yyyy");
//_param[2] = "@RESSOURCE" + ";" + SqlDbType.Int + ";" + _ressource.ToString();
//_param[3] = "@JOUR" + ";" + SqlDbType.NVarChar + ";" + _day.ToString();
//_param[4] = "@JOURINFO" + ";" + SqlDbType.Int + ";" + _jourinfo.ToString();
try
{
dsMonth = _dal.GetInformationInDataSet("LoadMonthValues", CommandType.StoredProcedure, _param);
_dal.FermeConnexion();
}
catch {}
return(dsMonth);
}
protected void LoadLegende()
{
string _constr = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDb"].ToString();
DAL.DAL _dal = new DAL.DAL(_constr, DAL.DAL.Moteurs.SQLSERVER.ToString());
if (_dal.IsConnexionFermee())
{
//Ouverture de la connection
_dal.OuvrirConnexion();
}
string[] _param = new string[0];
DataTable _tbl_legende = _dal.GetInformationInDataTable("LoadLegende", CommandType.StoredProcedure, _param);
_dal.FermeConnexion();
BulletedList1.DataSource = _tbl_legende;
BulletedList1.DataBind();
}
public static void DeleteMonthValues(string _month, string _year, string _day)
{
string _constr = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDb"].ToString();
DAL.DAL _dal = new DAL.DAL(_constr, DAL.DAL.Moteurs.SQLSERVER.ToString());
if (_dal.IsConnexionFermee())
{
//Ouverture de la connection
_dal.OuvrirConnexion();
}
string[] _param = new string[3];
_param[0] = "@MOIS" + ";" + SqlDbType.NVarChar + ";" + _month.ToString();
_param[1] = "@ANNEE" + ";" + SqlDbType.NVarChar + ";" + _year.ToString();
_param[2] = "@JOUR" + ";" + SqlDbType.NVarChar + ";" + _day.ToString();
_dal.ExecuteQueryNoResult("DeleteDayMonthValues", CommandType.StoredProcedure, _param);
_dal.FermeConnexion();
}
public static DataTable LoadMonthValues(string _month, string _year)
{
string _constr = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDb"].ToString();
DAL.DAL _dal = new DAL.DAL(_constr, DAL.DAL.Moteurs.SQLSERVER.ToString());
if (_dal.IsConnexionFermee())
{
//Ouverture de la connection
_dal.OuvrirConnexion();
}
string[] _param = new string[2];
_param[0] = "@MOIS" + ";" + SqlDbType.NVarChar + ";" + _month.ToString();
_param[1] = "@ANNEE" + ";" + SqlDbType.NVarChar + ";" + _year.ToString();
DataTable _tbl_activity = _dal.GetInformationInDataTable("LoadMonthValues", CommandType.StoredProcedure, _param);
_dal.FermeConnexion();
return(_tbl_activity);
}
