private void ChoosePrcForm_Load(object sender, EventArgs e)
{
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset;
int count = 0;
dataset = SqlWorker.GetDataSet("SELECT CourseName From Courses WHERE Lecturer=" + l.ID.ToString() + "");
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
courses_combo.Items.Add(dataset.Tables[0].Rows[i][0]);
count++;
}
dataset = SqlWorker.GetDataSet("SELECT Name From Users WHERE Type LIKE 'Practitioner'");
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
PrcList.Items.Add(dataset.Tables[0].Rows[i][0]);
count++;
}
PrcList.Sorted = true;
courses_combo.Sorted = true;
}
public void TestMethodUpdate()
{
DataSet dataset1, dataset2, dataset3, dataset4;
SqlWorker.GetDataSet("INSERT INTO Lecture(StartTime,EndTime,Class,Lecturer,CourseName,Day,AmountOfStudents) VALUES('" + startTime + ":00','" + endTime + ":00','" + Class + "','" + lecturerID + "','" + Course + "','" + day + "','0')");
SqlWorker.GetDataSet("INSERT INTO Class(Room,Capacity,IsLab,HasProjector,Hours,NumOfComputers,Days) VALUES('" + Class + "','" + capacity + "','" + islab + "','" + hasProjector + "','" + Shours + "','" + numComp + "','" + day + "')");
SqlWorker.GetDataSet("INSERT INTO Class(Room,Capacity,IsLab,HasProjector,Hours,NumOfComputers,Days) VALUES('" + Class2 + "','" + capacity + "','" + islab + "','" + hasProjector + "','" + Shours + "','" + numComp + "','" + day + "')");
Secretary_Change_Class_Form form = new Secretary_Change_Class_Form();
dataset4 = SqlWorker.GetDataSet("SELECT Hours From Class WHERE Room LIKE'" + Class + "'AND Days LIKE'" + day + "'");
dataset2 = SqlWorker.GetDataSet("SELECT ID FROM Lecture WHERE StartTime LIKE '" + (startTime + ":00") + "' AND EndTime LIKE '"
+ (endTime + ":00") + "' AND Class LIKE '" + Class + "' AND Lecturer LIKE '" + lecturerID + "' AND CourseName LIKE '" + Course + "' AND Day LIKE '"
+ day + "' AND AmountOfStudents LIKE '0'");
string i = dataset2.Tables[0].Rows[0][0].ToString();
dataset3 = SqlWorker.GetDataSet("SELECT Class From Lecture WHERE ID LIKE'" + dataset2.Tables[0].Rows[0][0].ToString() + "'");
form.UpdateClass(dataset2.Tables[0].Rows[0]["ID"].ToString(), hours, CurrentHours, Class2, Les, Class);
dataset1 = SqlWorker.GetDataSet("SELECT Hours From Class WHERE Room LIKE'" + Class + "'AND Days LIKE'" + day + "'");
dataset3 = SqlWorker.GetDataSet("SELECT Class From Lecture WHERE ID LIKE'" + dataset2.Tables[0].Rows[0][0].ToString() + "'");
Assert.IsTrue((dataset1.Tables[0].Rows[0]["Hours"].ToString() != dataset4.Tables[0].Rows[0]["Hours"].ToString() && dataset3.Tables[0].Rows[0]["Class"].ToString() == Class) || dataset3.Tables[0].Rows[0]["Class"].ToString() != Class);
SqlWorker.GetDataSet("DELETE FROM Lecture WHERE ID lIKE'" + dataset2.Tables[0].Rows[0]["ID"].ToString() + "'");
SqlWorker.GetDataSet("DELETE FROM Class WHERE Room LIKE'" + Class + "'");
SqlWorker.GetDataSet("DELETE FROM Class WHERE Room LIKE'" + Class2 + "'");
}
private void button1_Click(object sender, EventArgs e)
{
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int lim;
if (IsDigitsOnly(nmax.Text))
{
lim = Int32.Parse(nmax.Text);
}
else
{
MessageBox.Show("invalid input!", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (SqlWorker.LimitAmountOfStu(lim, cn))
{
MessageBox.Show("Update has succeeded!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("student limit must be at least 20!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Practitioner_Constraines_Form_Load(object sender, EventArgs e)
{
//in the formload we will change the label of the ID according to the user that is connected
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset;
string Id = "";
dataset = SqlWorker.GetDataSet("SELECT * From Users WHERE id='" + this.Teacher.ID.ToString() + "'");
Id = dataset.Tables[0].Rows[0]["id"].ToString();
ID.Text = Id;
if (Teacher is Practitioner)
{
Label1.Text = "Practitioner ID:";
}
else
{
Label1.Text = "Lecturer ID:";
}
}
public override MeetMeModel Get(int id)
{
MeetMeModel model = new MeetMeModel();
ISqlWorker worker = new SqlWorker(connection);
worker.SetupCommand(@"
SELECT id, heading, subHeading, blurb, backgroundImageUrl
FROM meetmeSection
WHERE id = @id
", CommandType.Text);
worker.AddInputParameter("@id", id);
using (var rdr = worker.GetDataReader()) {
if (rdr.Read())
{
model.Title = rdr["heading"].SafeToString();
model.SubTitle = rdr["subHeading"].SafeToString();
model.ImageUrl = rdr["backgroundImageUrl"].SafeToString();
model.Content = rdr["blurb"].SafeToString();
model.Id = rdr["id"].SafeToInt();
}
}
return(model);
}
public override WelcomeModel Get(int id)
{
ISqlWorker worker = new SqlWorker(connection);
worker.SetupCommand(@"
SELECT id, heading, subHeading, blurb, backgroundImageUrl
FROM welcomeSection
WHERE id = @id
", CommandType.Text);
worker.AddInputParameter("@id", id);
WelcomeModel model = new WelcomeModel();
using (var rdr = worker.GetDataReader()) {
if (rdr.Read())
{
model.Title = rdr["heading"].SafeToString();
model.SubTitle = rdr["subHeading"].SafeToString();
model.ImageUrl = rdr["backgroundImageUrl"].SafeToString();
model.Content = rdr["blurb"].SafeToString();
}
}
// WelcomeModel model = new WelcomeModel();
//model.Title = "Get Fit. <br/> Have Fun.";
//model.SubTitle = "Train Like a Champion";
//model.Content = "This is your Welcome section paragraph. As the first text readers encounter, this copy should clearly convey what your site is all about. Grab their attention with captivating and inviting copy, and add an image or video for extra engagement.";
//model.ImageUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRK1WQO38rPdcx8OgEKLaxarm0QnMwqKvwNBKpIR4z3VeeoU1iJ";
return(model);
}
private void Classes_SelectedIndexChanged(object sender, EventArgs e)
{
//in this function we will load the arrays with the hours that we need according to the user's choise
UpdateDB.Enabled = true;
string Hour = "";
DataSet dataset, Les;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Lesson == "Lecture")
{
Les = SqlWorker.GetDataSet("SELECT Day From Lecture WHERE ID LIKE'" + Lecture_Select.SelectedItem.ToString() + "'");
}
else
{
Les = SqlWorker.GetDataSet("SELECT Day From TeachingExercises WHERE ID LIKE'" + Lecture_Select.SelectedItem.ToString() + "'");
}
dataset = SqlWorker.GetDataSet("SELECT Hours From Class WHERE Room LIKE'" + Classes.SelectedItem.ToString() + "'AND Days LIKE'" + Les.Tables[0].Rows[0]["Day"].ToString() + "'");
Hour = dataset.Tables[0].Rows[0]["Hours"].ToString();
Convert(hours, Hour);
}
private void Practitioner_Class_Req_Form_Load(object sender, EventArgs e)
{
int Count = 0;
DataSet dataset;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string CourseName = "";
DataSet dataset1 = SqlWorker.GetDataSet("SELECT * From Users WHERE id='" + this.person.ID.ToString() + "'");
string Id = dataset1.Tables[0].Rows[0]["id"].ToString();
ID.Text = Id;
if (person is Practitioner)
{
dataset = SqlWorker.GetDataSet("SELECT * From Courses WHERE Practitioner LIKE '" + this.person.ID.ToString() + "'");
label2.Text = "Practitioner ID: ";
}
else
{
Lab.Visible = false;
dataset = SqlWorker.GetDataSet("SELECT * From Courses WHERE Lecturer LIKE '" + this.person.ID.ToString() + "'");
label2.Text = "Lecturer ID: ";
}
while (dataset.Tables[0].Rows.Count > Count)
{
CourseName = dataset.Tables[0].Rows[Count]["CourseName"].ToString();
Course.Items.Add(CourseName);
Count++;
}
}
public void getRoomEqTest()
{
int rooms = SqlWorker.getRoomEq("F110");
using (SqlConnection sConn = new SqlConnection(Globals.connString))
{
try
{
sConn.Open();
try
{
string query = "SELECT NumOfComputers FROM Class Where Room like '" + "F110" + "'";
SqlCommand sqlCmd = new SqlCommand(query, sConn);
SqlDataReader sReader = sqlCmd.ExecuteReader();
if (sReader.Read())
{
Assert.AreEqual((int)sReader["NumOfComputers"], rooms);
}
else
{
sReader.Close();
throw new Exception("Room not found!");
}
}
catch (Exception ex) { throw ex; }
}
catch (Exception ex) { throw ex; }
}
}
private void search_button_Click(object sender, EventArgs e)
{
int count = 0;
class_list.Items.Clear();
lab_check.Checked = false;
projector_check.Checked = false;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset;
string className;
dataset = searchClass(flag_has_projector.Checked, flag_is_lab.Checked);
if (dataset != null)
{
while (dataset.Tables[0].Rows.Count > count)
{
className = dataset.Tables[0].Rows[count]["Room"].ToString();
class_list.Items.Add(className);
count++;
}
}
}
private void Prac_lec_SelectedIndexChanged(object sender, EventArgs e)
{
teacher_chooser.Items.Clear();
s1.Text = "--";
s2.Text = "--";
m1.Text = "--";
m2.Text = "--";
tu1.Text = "--";
tu2.Text = "--";
w1.Text = "--";
w2.Text = "--";
tu1.Text = "--";
tu2.Text = "--";
f1.Text = "--";
f2.Text = "--";
DataSet dataset;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataset = SqlWorker.GetDataSet("SELECT Name From Users WHERE Type LIKE '" + ((ComboBox)sender).SelectedItem.ToString() + "'");
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
teacher_chooser.Items.Add(dataset.Tables[0].Rows[i][0]);
}
if (teacher_chooser.Items.Count > 0)
{
teacher_chooser.SelectedIndex = 0;
}
}
// A function for adding the user to the DB
public bool addUser(string ID, string Password, string Name, string Type, string startTime, string endTime, string day)
{
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
int dayInWeek = 0;
for (int i = 0; i < Days.Length; i++)
{
if (Days[i] == day)
{
dayInWeek = i + 1;
}
}
if (Int32.Parse(startTime.Substring(0, startTime.LastIndexOf(":"))) >= Int32.Parse(endTime.Substring(0, endTime.LastIndexOf(":"))))
{
MessageBox.Show("The Hours are incorrect! Please try again!.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
string Hours = dayInWeek + "," + startTime.Substring(0, startTime.LastIndexOf(":")) + "," + endTime.Substring(0, endTime.LastIndexOf(":"));
string sqlstring = "INSERT INTO Users(ID,PWD,Name,Type,AccHours) VALUES('" + ID + "','" + Password + "','" + Name + "','" + Type + "','" + Hours + "')";
DataSet dataset = SqlWorker.GetDataSet(sqlstring);
return(true);
}
private void class_list_SelectedIndexChanged(object sender, EventArgs e)
{
lab_check.Checked = false;
projector_check.Checked = false;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset, dataset1;
dataset = SqlWorker.GetDataSet("SELECT * From Class WHERE Room LIKE '" + class_list.SelectedItem.ToString() + "'");
if (dataset.Tables[0].Rows[0]["IsLab"].ToString() == "1")
{
lab_check.Checked = true;
dataset1 = SqlWorker.GetDataSet("SELECT * From Class WHERE Room LIKE '" + class_list.SelectedItem.ToString() + "'");
textBox1.Text = dataset1.Tables[0].Rows[0]["NumOfComputers"].ToString();
}
else
{
lab_check.Checked = false;
}
if (dataset.Tables[0].Rows[0]["HasProjector"].ToString() == "1")
{
projector_check.Checked = true;
}
else
{
projector_check.Checked = false;
}
}
public void saveTest()
{
AddStudent form = new AddStudent();
Student student = new Student();
Control name_input = (Control)(typeof(AddStudent).GetField("name_input", this.bf).GetValue(form));
Control id_input = (Control)(typeof(AddStudent).GetField("id_input", this.bf).GetValue(form));
Control pwd_input = (Control)(typeof(AddStudent).GetField("pwd_input", this.bf).GetValue(form));
Control sem_sbox = (Control)(typeof(AddStudent).GetField("sem_sbox", this.bf).GetValue(form));
// we will only test the method behavior, not the form behavior
name_input.Text = "Test User";
id_input.Text = "1212121";
pwd_input.Text = "1";
sem_sbox.Text = "1";
if (SqlWorker.GetUser(id_input.Text) != null)
{
SqlWorker.ExecuteQueries("Delete from Users where ID=" + id_input.Text);
}
Assert.IsTrue(form.SaveUser());
if (SqlWorker.GetUser(id_input.Text) != null)
{
SqlWorker.ExecuteQueries("Delete from Users where ID=" + id_input.Text);
}
else
{
Assert.Fail();
}
}
public void set_schedule_ClickTest()
{
Student stud = new Student("1000100", "Test", " ", "Student");
SqlWorker.AddStudent(stud);
Assert.IsTrue(SqlWorker.DeleteStudent(stud));
}
private void course_chooser_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet dataset, dataset1;
sPrac.Items.Clear();
sLec.Items.Clear();
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataset = SqlWorker.GetDataSet("SELECT Practitioner,Lecturer From Courses WHERE CourseName LIKE '" + ((ComboBox)sender).SelectedItem.ToString() + "'");
dataset1 = SqlWorker.GetDataSet("SELECT Name From Users WHERE ID ='" + dataset.Tables[0].Rows[0][0] + "'"); //PRAC ID
cPrac.Text = dataset1.Tables[0].Rows[0][0].ToString();
dataset1 = SqlWorker.GetDataSet("SELECT Name From Users WHERE ID ='" + dataset.Tables[0].Rows[0][1] + "'"); //LEC ID
cLec.Text = dataset1.Tables[0].Rows[0][0].ToString();
dataset1 = SqlWorker.GetDataSet("SELECT Name From Users WHERE ID != '" + dataset.Tables[0].Rows[0][0] + "' AND Type like 'Practitioner'"); // get the rest prac
for (int i = 0; i < dataset1.Tables[0].Rows.Count; i++)
{
sPrac.Items.Add(dataset1.Tables[0].Rows[i][0]);
}
dataset1 = SqlWorker.GetDataSet("SELECT Name From Users WHERE ID != '" + dataset.Tables[0].Rows[0][1] + "' AND Type like 'Lecturer'"); // get the rest lec
for (int i = 0; i < dataset1.Tables[0].Rows.Count; i++)
{
sLec.Items.Add(dataset1.Tables[0].Rows[i][0]);
}
}
private void lecpra_combo_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox1.Visible = false;
id_list.Items.Clear();
int count = 0;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset;
dataset = SqlWorker.GetDataSet("SELECT ID,Name From Users WHERE Type='" + lecpra_combo.Text + "'");
while (dataset.Tables[0].Rows.Count > count)
{
ID = dataset.Tables[0].Rows[count][0].ToString();
name = dataset.Tables[0].Rows[count][1].ToString();
id_list.Items.Add(name + " | " + ID);
count++;
}
}
private void Limit_Student_Form_Load(object sender, EventArgs e)
{
int Count = 0;
DataSet dataset;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string CourseName = "";
if (person is Practitioner)
{
dataset = SqlWorker.GetDataSet("SELECT * From Courses WHERE Practitioner LIKE '" + this.person.ID.ToString() + "'");
}
else
{
dataset = SqlWorker.GetDataSet("SELECT * From Courses WHERE Lecturer LIKE '" + this.person.ID.ToString() + "'");
}
while (dataset.Tables[0].Rows.Count > Count)
{
CourseName = dataset.Tables[0].Rows[Count]["CourseName"].ToString();
course_name.Items.Add(CourseName);
Count++;
}
}
// A function for searching the class in the DB
public DataSet searchClass(bool has_projector, bool is_lab)
{
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
string sql_string = "";
if (has_projector == true && is_lab == true)
{
sql_string = "SELECT * From Class WHERE HasProjector = '1' AND IsLab = '1'";
}
if (has_projector == true && is_lab == false)
{
sql_string = "SELECT * From Class WHERE HasProjector = '1' AND IsLab = '0'";
}
if (is_lab == true && has_projector == false)
{
sql_string = "SELECT * From Class WHERE HasProjector = '0' AND IsLab = '1'";
}
if (has_projector == false && is_lab == false)
{
sql_string = "SELECT * From Class WHERE HasProjector = '0' AND IsLab = '0'";
}
return(SqlWorker.GetDataSet(sql_string));
}
private void MainForm_Load(object sender, EventArgs e)
{
sqlQuery = $"SELECT i.id, i.othername, i.gov_number, c.dt FROM imeies i INNER JOIN coordinates c ON i.id=c.imei_id";
actUpdTable = new Action <DataTable>(UpdateDataGrid);
_source = new CancellationTokenSource();
_token = _source.Token;
LoadForm form = new LoadForm();
if (form.ShowDialog() == DialogResult.OK)
{
myTable = SqlWorker.CreateTable(DateTime.Now.ToString("dd.MM.yyyy hh:mm:ss"));
myTable.Columns.Add(new DataColumn("TimeB", typeof(DateTime)));
this.TileUpdateBD.Enabled = true;
ControlsAction(true);
Password = form.Password;
InitializeConnection();
}
else
{
this.TileUpdateBD.Enabled = false;
ControlsAction(false);
}
}
public void GetUsersListTest()
{
DataTable testGetUsersList = null;
// get data to test
try
{
testGetUsersList = SqlWorker.GetUsersList();
} catch
{
Assert.Fail();
}
// per data to test against
SqlConnection sConn = new SqlConnection(Globals.connString);
DataSet Data = new DataSet();
SqlDataAdapter da;
SqlCommandBuilder cmdBuilder;
List <User> users_list = new List <User>();
//Set the connection string of the SqlConnection object to connect
//to the SQL Server database in which you created the sample
//table.
try { sConn.Open(); }
catch (Exception ex) { throw ex; }
//Initialize the SqlDataAdapter object by specifying a Select command
//that retrieves data from the sample table.
da = new SqlDataAdapter("SELECT * FROM USERS ORDER BY ID", sConn);
//Initialize the SqlCommandBuilder object to automatically generate and initialize
//the UpdateCommand, InsertCommand, and DeleteCommand properties of the SqlDataAdapter.
cmdBuilder = new SqlCommandBuilder(da);
//Populate the DataSet by running the Fill method of the SqlDataAdapter.
da.Fill(Data, "USERS");
//Close the database connection.
sConn.Close();
DataColumn[] keyColumns = new DataColumn[1];
keyColumns[0] = Data.Tables["USERS"].Columns["id"];
Data.Tables["USERS"].PrimaryKey = keyColumns;
DataColumnCollection columns = Data.Tables["USERS"].Columns;
// testing
for (int row = 0; row < Data.Tables["USERS"].Rows.Count; row++)
{
DataRow data = Data.Tables["USERS"].Rows[row];
DataRow test = testGetUsersList.Rows[row];
foreach (DataColumn col in columns)
{
Assert.AreEqual(data[col.ToString()], test[col.ToString()]);
}
}
}
public void DeleteStudentTest()
{
Student newStud = new Student("123123", "Test Student", "1", "Student");
SqlWorker.AddStudent(newStud);
SqlWorker.DeleteStudent(newStud);
Assert.IsNull(SqlWorker.GetUser(newStud.ID));
}
static void Main(string[] args)
{
LinuxTcpManager.CreateInstance();
if (StaticObjects.InitObjects())
{
Debuger.PrintStr("Init StaticObjects done!", EPRINT_TYPE.NORMAL);
}
else
{
Debuger.PrintStr("Init StaticObjects faild!", EPRINT_TYPE.ERROR);
Debuger.ExitProgram();
return;
}
if (SqlWorker.MySqlInit())
{
Debuger.PrintStr("Init SqlWorker done!", EPRINT_TYPE.NORMAL);
}
else
{
//Debuger.PrintStr("Init SqlWorker faild!", EPRINT_TYPE.ERROR);
//Debuger.ExitProgram();
//return;
}
if (!HttpListenerManager.Instance.Init())
{
Debuger.PrintStr("Init HttpListenerManager faild!", EPRINT_TYPE.ERROR);
Debuger.ExitProgram();
return;
}
else
{
Debuger.PrintStr("Init HttpListenerManager done!", EPRINT_TYPE.NORMAL);
}
Debuger.PrintStr($"Waiting for client request,time:{DateTime.Now.ToString()}", EPRINT_TYPE.NORMAL);
if (StaticObjects.IsForceGC)
{
Debuger.StartForceGC(StaticObjects.ForceGCInterval);
}
HttpRequestHandler.CreateHttpRequestHandler <HttpHandler_ReceiveCommitMsg>("app_commit");
SmartLockTcpHandlerManager.CreateInstance();
while (true)
{
switch (Debuger.InputCommand())
{
case ECOMMAND_TYPE.EXIT:
return;
break;
case ECOMMAND_TYPE.NORMAL:
break;
}
}
}
public void GetAllStudentsTest()
{
List <Student> TestList = SqlWorker.GetAllStudents();
List <Student> Students_List = new List <Student>();
using (SqlConnection sConn = new SqlConnection(Globals.connString))
{
string query = "SELECT * FROM Users WHERE Type like 'Student'";
SqlCommand sqlCmd = new SqlCommand(query, sConn);
try
{
sConn.Open();
try
{
SqlDataReader sReader = sqlCmd.ExecuteReader();
while (sReader.Read())
{
Student stud = SqlWorker.GetUser(sReader["id"].ToString()) as Student;
foreach (string lect in stud.ActiveLects.Split(','))
{
if (lect == "")
{
continue;
}
stud.ActiveEventsList.Add(SqlWorker.GetEvent(lect));
}
foreach (string lect in stud.ActivePracLabs.Split(','))
{
if (lect == "")
{
continue;
}
stud.ActiveEventsList.Add(SqlWorker.GetEvent(lect));
}
Students_List.Add(stud);
}
sReader.Close();
}
catch (Exception ex) { throw ex; }
}
catch (Exception ex) { throw ex; }
}
foreach (Student stud in Students_List)
{
Assert.IsTrue(TestList.Find(f_stud => stud.Name == f_stud.Name) != null);
Assert.IsTrue(TestList.Find(f_stud => stud.ID == f_stud.ID) != null);
Assert.IsTrue(TestList.Find(f_stud => stud.PassedCourses == f_stud.PassedCourses) != null);
Assert.IsTrue(TestList.Find(f_stud => stud.Type == f_stud.Type) != null);
}
}
protected override void GetWhitelistedUrlsFromDatabase()
{
var localList = new List <string>();
SqlWorker.IterateRecords <UserData>(reader =>
{
localList.Add(reader["name"].ToString());
});
WhitelistedUrls = localList.Select(item => string.Format(TemplateUrl, item)).ToArray();
}
private void Search_Click(object sender, EventArgs e)
{
//this function seraches the class according to the user's choise in the combobox of choosing a lecture/practice ID
label2.Visible = true;
Classes.Visible = true;
Classes.Items.Clear();
Classes.ResetText();
int Start, End, count = 0, val2 = 0, D = 0;
string Time = "", val = "";
DataSet dataset;
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Start = Int32.Parse(StartTime.SelectedItem.ToString().Split(':')[0]);
End = Int32.Parse(EndTime.SelectedItem.ToString().Split(':')[0]);
for (int i = Start; i < End; i++)
{
Time += i;
if (i != End - 1)
{
Time += ',';
}
}
D = Int32.Parse(getday(Day.SelectedItem.ToString()));
dataset = SqlWorker.GetDataSet("SELECT Hours ,Days,Room From Class");
val2 = dataset.Tables[0].Rows.Count;
while (val2 > count)
{
val = dataset.Tables[0].Rows[count]["Hours"].ToString();
if (val.Contains(Time) && D == Int32.Parse(dataset.Tables[0].Rows[count]["Days"].ToString()))
{
if (!((val[0] == '0' && Time == "8") || (val[1] == '0' && Time == "9")))
{
Classes.Items.Add(dataset.Tables[0].Rows[count]["Room"].ToString());
}
}
count++;
}
if (Classes.Items.Count == 0)
{
MessageBox.Show("No match was found, please try to search again with new data.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private int TrackCommits(HtmlNode html, string username, out int lastYearCommits)
{
// First, check if we have any record for this user on the database
bool existsUser = SqlWorker.DoExistsTransaction <UserData>(username).HasValue;
int totalCommits;
var years = html
.OwnerDocument
.GetElementbyId("year-list-container")
.GetNodesByName("li")
.Select(li => string.Format(TemplateUrl, li.FirstChild.GetAttributeValue("href", string.Empty).Substring(1)));
// (In both cases) Then we will track only the last year
string firstDayOfCurrentYear = $"{DateTime.Now:yyyy}-01-01";
string today = DateTime.Now.ToString("yyyy-MM-dd");
string url = $"{username}/?tab=overview&from={firstDayOfCurrentYear}&to={today}";
lastYearCommits = GetContributionsFromSource(url);
if (!existsUser)
{
// If it's the first time we track it, then we will track all the years
totalCommits = years.Select(GetContributionsFromSource).Sum();
}
else
{
// TODO: Check this
int lastTotalCommits = 0;
int lastRecordedLastYearCommit = 0;
SqlWorker.DoSelect <UserData>(reader =>
{
lastTotalCommits = int.Parse(reader["commits"].ToString());
lastRecordedLastYearCommit = int.Parse(reader["commits_last_year"].ToString());
},
"*",
"name = @name",
"date",
"1",
false,
new Tuple <string, object>("@name", username));
int _commits = lastTotalCommits + (lastYearCommits - lastRecordedLastYearCommit);
totalCommits = _commits;
}
return(totalCommits);
}
private void ValidateWorkerResult(SqlWorkerTask task)
{
var result = SqlWorker.Create(accessor, task).Invoke();
var error = string.Format(ErrorMessage, task);
ValidateSchema(task, result);
if (task == SqlWorkerTask.DropSchema)
{
Assert.IsTrue(result.Schema == null, error);
Assert.IsTrue(result.Metadata == null, error);
return;
}
ValidateMetadata(task, result, task.HasFlag(SqlWorkerTask.DropSchema));
}
protected override void GetWhitelistedUrlsFromDatabase()
{
// For this, we will need an IEnumerator with all the records from the repository table
// Then, foreach record we will get the linked org/user (name) for the repository
// Then, we will form the complete url
var localList = new List <string>();
SqlWorker.IterateRecords <RepoData>(reader =>
{
string ownerName = string.Empty;
int?ownerId = (int?)reader["org_id"] ?? (int?)reader["user_id"];
if (!ownerId.HasValue)
{
throw new Exception();
}
bool isOrg = ((int?)reader["org_id"]).HasValue;
if (isOrg)
{
SqlWorker.DoSelect <OrgData>(
_reader => ReaderCallback(_reader, out ownerName),
"name",
"id = @id",
"date",
"1",
false,
new Tuple <string, object>("@id", ownerId.Value));
}
else
{
SqlWorker.DoSelect <UserData>(
_reader => ReaderCallback(_reader, out ownerName),
"name",
"id = @id",
"date",
"1",
false,
new Tuple <string, object>("@id", ownerId.Value));
}
string repoName = reader["name"].ToString();
localList.Add(string.Format(TemplateUrl, $"{ownerName}/{repoName}"));
});
WhitelistedUrls = localList.Select(item => string.Format(TemplateUrl, item)).ToArray();
}
private void update_button_Click(object sender, EventArgs e)
{
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dataset;
// updating the class type
string sql_string_TE = "UPDATE TeachingExercises SET ";
string sql_string_C = "UPDATE Class SET ";
if (lab_check.Checked)
{
if (textBox1.Text != "")
{
sql_string_C += "IsLab='1', NumOfComputers=" + textBox1.Text + ", ";
}
else
{
MessageBox.Show("Please enter the number of the computers!", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
sql_string_TE += "Type='Lab' WHERE Class LIKE '" + class_list.SelectedItem.ToString() + "'";
}
else
{
sql_string_C += "IsLab='0', NumOfComputers=0, ";
sql_string_TE += "Type='Practice' WHERE Class LIKE '" + class_list.SelectedItem.ToString() + "'";
}
if (projector_check.Checked)
{
sql_string_C += "HasProjector='1', ";
}
else
{
sql_string_C += "HasProjector='0', ";
}
sql_string_C = sql_string_C.Substring(0, sql_string_C.Length - 2);
sql_string_C += " WHERE Room LIKE '" + class_list.SelectedItem.ToString() + "'";
dataset = SqlWorker.GetDataSet(sql_string_C);
dataset = SqlWorker.GetDataSet(sql_string_TE);
MessageBox.Show("Update Has Succeeded.", "Message"
, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
