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); }