/// <summary>
/// הוספת תלמיד חדש.
/// </summary>
/// <param name="id">ת.ז</param>
/// <param name="fname">שם פרטי</param>
/// <param name="lname">שם משפחה</param>
/// <param name="classid">קוד כיתה</param>
/// <param name="gender">מין</param>
/// <param name="phone">טלפון</param>
public static void Add(string id, string fname, string lname, string classid, App.Gender gender, string phone)
{
Classes.SQL.Insert("Students", "`id`,`firstname`,`lastname`,`classid`,`regdate`,`enddate`,`gender`,`phone`,`active`,`fastnote`", string.Format("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'", id, fname, lname, classid, DateTime.Now.ToString("dd/MM/yyyy"), DateTime.Now.ToString("dd/MM/yyyy"), App.GenderNum(gender), phone, true, string.Empty));
}
/// <summary>
/// עריכת תלמיד.
/// </summary>
/// <param name="id">ת.ז</param>
/// <param name="fname">שם פרטי</param>
/// <param name="lname">שם משפחה</param>
/// <param name="classid">קוד כיתה</param>
/// <param name="regdate">תאריך הרשמה</param>
/// <param name="enddate">תאריך יציאה</param>
/// <param name="gender">מין</param>
/// <param name="phone">טלפון</param>
/// <param name="active">פעיל</param>
/// <param name="fastnote">הערה מהירה</param>
public static void Edit(string id, string fname, string lname, string classid, DateTime regdate, DateTime enddate, App.Gender gender, string phone, bool active, string fastnote)
{
Classes.SQL.Update("Students", "`id` = '" + id + "', `firstname` = '" + fname + "', `lastname` = '" + lname + "', `classid` = '" + classid + "', `regdate` = '" + regdate.ToShortDateString() + "', `enddate` = '" + enddate.ToShortDateString() + "', `gender` = '" + App.GenderNum(gender) + "', `phone` = '" + phone + "', `active` = " + active + ", `fastnote` = '" + fastnote + "'", "id", id);
}
/// <summary>
/// הוספת מורה חדש.
/// </summary>
/// <param name="id">ת.ז</param>
/// <param name="fname">שם פרטי</param>
/// <param name="lname">שם משפחה</param>
/// <param name="gender">מין</param>
/// <param name="phone">טלפון</param>
/// <param name="pass">סיסמת כניסה</param>
/// <param name="admin">ניהול ראשי</param>
/// <param name="dutyid">מספר תפקיד</param>
public static void Add(string id, string fname, string lname, App.Gender gender, string phone, string pass, bool admin, int dutyid)
{
Classes.SQL.Insert("Teachers", "`tid`,`firstname`,`lastname`,`gender`,`phone`,`password`,`admin`,`dutyid`,`active`", string.Format("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8}", id, fname, lname, Classes.App.GenderNum(gender), phone, pass, Convert.ToInt32(admin), dutyid, true));
}
