public List <DateToSendClass> addDateToList(int classNum, DateToSendClass d) { // צחי הוסיף עדכון עם לוז נבחר DataSet ds1 = new DataSet(); string sql1 = "Select top 1 Id FROM Loozs where IsSelect=1"; OleDbDataAdapter adapter1 = new OleDbDataAdapter(sql1, conn); adapter1.Fill(ds1); DataTable dt = ds1.Tables[0]; string LoozId = dt.Rows[0][0].ToString(); DataSet ds = new DataSet(); string tag = "Default"; string getTagSql = "Select CurrentTag FROM ClassesDictionary WHERE ClassNumber=" + classNum; OleDbDataAdapter adapter = new OleDbDataAdapter(getTagSql, conn); adapter.Fill(ds); string temp = ds.Tables[0].Rows[0].ItemArray[0].ToString(); if (temp != "") { tag = temp; } string sql = "INSERT INTO SCHEDULE ([Hour],[Minute],[Day],[Class],[On],[Tag],[LoozId]) VALUES (" + d.Hour + "," + d.Minute + "," + (int)d.Day + "," + classNum + "," + (d.ShouldTurnOn ? 1 : 0) + ",'" + tag + "'," + LoozId + " )"; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.ExecuteNonQuery(); return(getAllDateTimesByClass(classNum)); //returns the updated list }
public List <DateToSendClass> GetAllDatesTimes(DataTable dt) { List <DateToSendClass> ans = new List <DateToSendClass>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; if (dr["UConnectLoozId"] == null || dr["UConnectLoozId"].ToString() == "") { continue; } TimeSpan time = TimeSpan.Parse(dr["Time"].ToString()); DateToSendClass d = new DateToSendClass(); d.Day = (DayOfWeek)(int.Parse(dr["DayId"].ToString()) - 1); d.Hour = int.Parse(time.Hours.ToString()); d.Minute = int.Parse(time.Minutes.ToString()); d.ShouldTurnOn = Convert.ToBoolean(dr["Status"].ToString()); // d.DBId = int.Parse(dr["ID"].ToString()); ans.Add(d); } ans.Sort(DateToSendClass.simpleDatesComparison); return(ans); }
public void updateDate(int dateId, DateToSendClass d) { string sql = "UPDATE SCHEDULE SET " + "Hour=" + d.Hour + ",Minute=" + d.Minute + ",Day=" + (int)d.Day + ",On=" + (d.ShouldTurnOn ? 1 : 0) + " WHERE [ID]=" + dateId; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.ExecuteNonQuery(); }
private void AddToListForForce(ref List <DateToSendClass> ls, int classNum, bool IsOn, DateTime t) { DateToSendClass d = new DateToSendClass(); // DateTime t = DateTime.Now; d.Day = (DayOfWeek)t.DayOfWeek;//DayOfWeek.Sunday; d.Hour = t.Hour; d.Minute = t.Minute; d.ShouldTurnOn = IsOn; d.ClassNumber = classNum; // ls = new List<DateToSendClass>(); ls.Add(d); }
//public List<DateToSendClass> getDatesList(int dateListId, int classId, DayOfWeek theDay) //{ // DateList dl = getDateList(dateListId); // return dl.getRealDates(DEFAULT_MAX_NUMBER_OF_CLASSES).FindAll(p => p.ClassNumber == classId && p.Day == theDay); //} public List <DateToSendClass> getDatesList(int classId) { List <DateToSendClass> ls = new List <DateToSendClass>(); string sql = "SELECT * FROM ClassesDictionary WHERE ClassNumber=" + classId.ToString(); OleDbDataAdapter dbCmd = new OleDbDataAdapter(sql, conn); DataTable classesDataTable = new DataTable(); dbCmd.Fill(classesDataTable); if (classesDataTable.Rows.Count == 0) { return(ls); } DataRow classDataRow = classesDataTable.Rows[0]; int startAddress = int.Parse(classDataRow["StartAddress"].ToString()); int endAddress = int.Parse(classDataRow["EndAddress"].ToString()); #if DEBUG ls = FatekObj.getDatesInShortFormat(startAddress, FatekConnection.getAreaByLetter(classDataRow["MemoryType"].ToString()), endAddress - startAddress + 1); // ls = FatekConnection.LastOpenedConnection // .getDatesInShortFormat(startAddress, FatekConnection.getAreaByLetter(classDataRow["MemoryType"].ToString()), endAddress - startAddress + 1); #else Random r = new Random(); for (int i = 0; i <= 6; i++) { int oldValue = 0; for (int j = 0; j < 6; j++) { DateToSendClass d = new DateToSendClass(); oldValue = r.Next(oldValue + 1, 12 + 2 * j); d.Hour = oldValue; d.Minute = (int)i; d.ShouldTurnOn = (j % 2 == 0); d.ClassNumber = classId; d.Day = (DayOfWeek)i; d.DBId = 0; ls.Add(d); } } #endif ls.Sort(DateToSendClass.simpleDatesComparison); return(ls); //DateList dl = getDateList(dateListId); //return dl.getRealDates(DEFAULT_MAX_NUMBER_OF_CLASSES).FindAll(p => p.ClassNumber == classId); }
public List <DateToSendClass> getAllDateTimesByClass(int classNum) { DataSet dsLooz = new DataSet(); string sqlLooz = "Select * FROM Loozs Where IsSelect=1"; OleDbDataAdapter adapterLooz = new OleDbDataAdapter(sqlLooz, conn); adapterLooz.Fill(dsLooz); DataTable dtLooz = dsLooz.Tables[0]; string LoozId = "0"; if (dtLooz.Rows.Count > 0) { LoozId = dtLooz.Rows[0]["Id"].ToString(); } DataSet ds = new DataSet(); string sql = "Select Schedule.* FROM Schedule,ClassesDictionary WHERE Schedule.LoozId=" + LoozId + " and Schedule.Class=" + classNum + " AND ClassesDictionary.ClassNumber=" + classNum + " AND ((((Schedule.Tag is null) OR (Schedule.Tag='') OR (Schedule.Tag='Default'))) AND ((ClassesDictionary.CurrentTag is null) OR (ClassesDictionary.CurrentTag='') OR (ClassesDictionary.CurrentTag='Default')) OR (Schedule.Tag = ClassesDictionary.CurrentTag))"; OleDbDataAdapter adapter = new OleDbDataAdapter(sql, conn); adapter.Fill(ds); DataTable dt = ds.Tables[0]; List <DateToSendClass> ans = new List <DateToSendClass>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; DateToSendClass d = new DateToSendClass(); d.ClassNumber = classNum; d.Day = (DayOfWeek)int.Parse(dr["Day"].ToString()); d.Hour = int.Parse(dr["Hour"].ToString()); d.Minute = int.Parse(dr["Minute"].ToString()); d.ShouldTurnOn = int.Parse(dr["On"].ToString()) == 1; d.DBId = int.Parse(dr["ID"].ToString()); ans.Add(d); } ans.Sort(DateToSendClass.simpleDatesComparison); return(ans); }
private void AddToListForForceFatek(ref List <DateToSendClass> ls, int uStaticOnHour, int uStatus, DateTime t) { if (uStatus == 0) { DateToSendClass d = new DateToSendClass(); d.Day = (DayOfWeek)t.DayOfWeek; d.Hour = t.Hour; d.Minute = t.Minute; d.ShouldTurnOn = false; ls.Add(d); } if (uStatus == 1 && uStaticOnHour == 0) { DateToSendClass d = new DateToSendClass(); d.Day = (DayOfWeek)t.DayOfWeek; d.Hour = t.Hour; d.Minute = t.Minute; d.ShouldTurnOn = true; ls.Add(d); } if (uStatus == 1 && uStaticOnHour != 0) { DateToSendClass d = new DateToSendClass(); d.Day = (DayOfWeek)t.DayOfWeek; d.Hour = t.Hour; d.Minute = t.Minute; d.ShouldTurnOn = true; ls.Add(d); t = t.AddHours(uStaticOnHour); d = new DateToSendClass(); d.Day = (DayOfWeek)t.DayOfWeek; d.Hour = t.Hour; d.Minute = t.Minute; d.ShouldTurnOn = false; ls.Add(d); } }