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