public static void MembersDataDownload()
{
members.Clear();
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.MembersDownload, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
members.Add(new Member(Convert.ToInt32(reader[0]), reader[1].ToString(), Convert.ToInt32(reader[2])));
}
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
}
public static void ScheduleInsert(DateTime timeOfLessons, int instructor, string students, int curriculum)
{
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.ScheduleInsert, connection);
command.Parameters.Add("@TimeOfLesson", SqlDbType.DateTime);
command.Parameters["@TimeOfLesson"].Value = timeOfLessons;
command.Parameters.Add("@Instructor", SqlDbType.Int);
command.Parameters["@Instructor"].Value = instructor;
command.Parameters.Add("@Students", SqlDbType.VarChar);
command.Parameters["@Students"].Value = students;
command.Parameters.Add("@Curriculum", SqlDbType.Int);
command.Parameters["@Curriculum"].Value = curriculum;
connection.Open();
command.ExecuteNonQuery();
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
}
public static void MemberDataUpload()
{
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.MembersUpload, connection);
connection.Open();
command.Parameters.Add("@MemberName", SqlDbType.VarChar);
command.Parameters.Add("@Master", SqlDbType.Bit);
for (int i = 0; i < members.Count; i++)
{
command.Parameters["@MemberName"].Value = members[i].MemberName;
command.Parameters["@Master"].Value = members[i].Master;
command.ExecuteNonQuery();
}
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
}
public static void ScheduleUpdate(int scheduleID, DateTime modifiedTimeOfLesson, int modifiedInstructor, int modifiedCurriculum)
{
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.ScheduleUpdate, connection);
command.Parameters.Add("@ScheduleID", SqlDbType.Int);
command.Parameters["@ScheduleID"].Value = scheduleID;
command.Parameters.Add("@TimeOfLesson", SqlDbType.DateTime);
command.Parameters["@TimeOfLesson"].Value = modifiedTimeOfLesson;
command.Parameters.Add("@Instructor", SqlDbType.Int);
command.Parameters["@Instructor"].Value = modifiedInstructor;
command.Parameters.Add("@Curriculum", SqlDbType.Int);
command.Parameters["@Curriculum"].Value = modifiedCurriculum;
connection.Open();
command.ExecuteNonQuery();
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
}
public static List <DateTime> LessonsTimeOfSelectedTeacher(int selectedMeberId)
{
List <DateTime> timeOfLessons = new List <DateTime>();
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.LessonsOfSelectedTeacher, connection);
command.Parameters.AddWithValue("@MemberID", selectedMeberId);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
timeOfLessons.Add(Convert.ToDateTime(reader[0]));
}
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
return(timeOfLessons);
}
public static List <Schedule> SchedulesDownload()
{
List <Schedule> lessons = new List <Schedule>();
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.ScheduleDownload, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
lessons.Add(new Schedule(Convert.ToInt32(reader[0]), Convert.ToDateTime(reader[1]), Convert.ToInt32(reader[2]), reader[3].ToString(), Convert.ToInt32(reader[4])));
}
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
return(lessons);
}
public static int TableCount(int table)
{
int result = -1;
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(table == 1 ? SQLData.DatabaseTablePosesCount : SQLData.DatabaseTableMembersCount, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
result = Convert.ToInt32(reader[0]);
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
return(result);
}
public static bool TableIsEmpty(int table)
{
object checkresult = null;
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(table == 1 ? SQLData.DatabaseTablePosesCheck : SQLData.DatabaseTableMembersCheck, connection);
connection.Open();
checkresult = command.ExecuteScalar();
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
return(checkresult == null);
}
public static bool DatabaseCheck()
{
object checkResult = null;
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.DatabaseCheck, connection);
connection.Open();
checkResult = command.ExecuteScalar();
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
return(checkResult != null);
}
public static void ScheduleDelete(int selectedSceduleID)
{
try
{
using (SqlConnection connection = new SqlConnection(SQLData.ConncectionString))
{
SqlCommand command = new SqlCommand(SQLData.ScheduleDelete, connection);
command.Parameters.Add("@ScheduleID", SqlDbType.Int);
command.Parameters["@ScheduleID"].Value = selectedSceduleID;
connection.Open();
command.ExecuteNonQuery();
}
}
catch (Exception a)
{
if (CEPrintout != null)
{
CEPrintout.Invoke(a.Message);
}
}
}
