/// <summary> /// get bill nubmer /// </summary> public static void LBN() { try { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("bills").Order("ID", true); MySqlReader r = new MySqlReader(cmd); BillNO = r.Read() ? r.ReadUInt32("ID") : 0; r.Close(); } catch (Exception ee) { Program.SaveException(ee); } }
/// <summary> /// login check code /// </summary> public static bool UserLogin() { try { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT); cmd.Select("accounts").Where("Username", UserName).And("Password", UserPassword); MySqlReader r = new MySqlReader(cmd); if (r.Read()) { State = (States.AccountState)r.ReadByte("State"); switch (State) { case States.AccountState.Manager: { Manager ma = new Manager(); ma.Show(); SaveLogin(); return(true); } case States.AccountState.Employee: { CPanal gui = new CPanal(); gui.Show(); SaveLogin(); return(true); } default: MessageBox.Show("من انت؟ هل تعمل فى هذه الصيدليه؟"); return(false); } } else { MessageBox.Show("أسم المستخدم و/او كلمه المرور خطأ"); return(false); } } catch (Exception ll) { Program.SaveException(ll); return(false); } }
/// <summary> /// load a bell for user /// </summary> private static void LoadBill() { try { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("bills").Where("Name", Client).And("ID", BillNO); MySqlReader r = new MySqlReader(cmd); if (r.Read()) { MList = r.ReadString("Medic"); } r.Close(); } catch (Exception ee) { Program.SaveException(ee); } }