public void Add(HttpRequestBase req) { TimeTable u_TimeTab; List<TimeTable> list_u_TimeTab = new List<TimeTable>(); for (int i = 0; i < 13; ++i) { u_TimeTab = new TimeTable() { UserID = Convert.ToInt32(req.Cookies[GLB.id].Value), Section = Convert.ToInt16(i + 1), FirstDay = req.Form["row" + i + "cell0"] == "on" ? '1' : '0', SecondDay = req.Form["row" + i + "cell1"] == "on" ? '1' : '0', ThirdDay = req.Form["row" + i + "cell2"] == "on" ? '1' : '0', FourthDay = req.Form["row" + i + "cell3"] == "on" ? '1' : '0', FifthDay = req.Form["row" + i + "cell4"] == "on" ? '1' : '0', SixthDay = req.Form["row" + i + "cell5"] == "on" ? '1' : '0', SeventhDay = req.Form["row" + i + "cell6"] == "on" ? '1' : '0' }; list_u_TimeTab.Add(u_TimeTab); } tmTabDal = new TimeTableDAL(); tmTabDal.Add(list_u_TimeTab); tmTabDal.ReturnUnitToPool(); }
//public static TimeTableDAL Instance() //{ // if (tmTab == null) // { // tmTab = new TimeTableDAL(); // } // return tmTab; //} public void GetDetails(int id) { dalBase.sql = "SELECT * FROM db_user_timetable WHERE id = @id"; dalBase.Param = new MySqlParameter("@id", id); dalBase.Run(Behavious.SELECT_WITH_SINGLEPARAM, false); list_t.Clear(); while (dalBase.DataRead.Read()) { t = new TimeTable() { Section = Convert.ToInt16(dalBase.DataRead["class"]), FirstDay = Convert.ToChar(dalBase.DataRead["firstDay"]), SecondDay = Convert.ToChar(dalBase.DataRead["secondDay"]), ThirdDay = Convert.ToChar(dalBase.DataRead["thirdDay"]), FourthDay = Convert.ToChar(dalBase.DataRead["fourthDay"]), FifthDay = Convert.ToChar(dalBase.DataRead["fifthDay"]), SixthDay = Convert.ToChar(dalBase.DataRead["sixthDay"]), SeventhDay = Convert.ToChar(dalBase.DataRead["seventhDay"]) }; list_t.Add(t); } dalBase.CloseConnect(); }