public FrmOfficerOccurrence(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
 public FrmOfficerprofile(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
 public FrmOfficerParadestate(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
示例#4
0
 public FrmOfficerMeals(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
 public FrmOfficerRollcall(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
示例#6
0
 public FrmOfficerReports(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
示例#7
0
 public FrmOfficerPasswordChange(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
 public FrmOfficerAnnouncements(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
 public FrmOfficerAttendance(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }
        private void btngo_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtusername.Text == "")
                {
                    MessageBox.Show("User ID is required");
                }
                else if (txtpassword.Text == "")
                {
                    MessageBox.Show("Password is required");
                }
                else if (txtusername.Text.Length > 9)
                {
                    MessageBox.Show("Please input valid username");
                }
                else
                {
                    //Username ok. Password ok. Now Login user.
                    string query = @"SELECT Id, Userid,Userpassword,Name, UsertypeId, GETDATE() AS 'TodayDate' 
                        FROM KDUusers WHERE Userid = @Userid AND Userpassword = @Userpassword AND UserStatusId = " + UserStatusId.Active.ToString();

                    SqlCommand sqlcmd = new SqlCommand();
                    DataAccessLayer.AddParameters(sqlcmd, "@Userid", SqlDbType.Int, txtusername.Text);
                    DataAccessLayer.AddParameters(sqlcmd, "@Userpassword", SqlDbType.NVarChar, txtpassword.Text);
                    DataTable dt = DataAccessLayer.ExecuteQuery(query, sqlcmd);
                    //Got data

                    if ((dt != null) && (dt.Rows.Count == 1))
                    {
                        //user found
                        int usertypeid = Convert.ToInt32(dt.Rows[0]["UsertypeId"]);

                        if (usertypeid == UserTypeId.Cadet)
                        {
                            Ocadet c = new Ocadet();
                            c.Id        = Convert.ToInt32(dt.Rows[0]["Id"]);
                            c.Name      = dt.Rows[0]["Name"].ToString();
                            c.Userid    = Convert.ToInt32(dt.Rows[0]["Userid"]);
                            c.Password  = dt.Rows[0]["Userpassword"].ToString();
                            c.Intake    = GetCadetIntake(Convert.ToInt32(dt.Rows[0]["Id"]));
                            c.TodayDate = Convert.ToDateTime(dt.Rows[0]["TodayDate"]).ToString("yyyy-MM-dd");


                            FrmCadetHome cdthm = new FrmCadetHome(c);
                            cdthm.Show();
                            this.Close();
                        }
                        else if (usertypeid == UserTypeId.Officer)
                        {
                            Officer o = new Officer();
                            o.Id        = Convert.ToInt32(dt.Rows[0]["Id"]);
                            o.Name      = dt.Rows[0]["Name"].ToString();
                            o.Userid    = Convert.ToInt32(dt.Rows[0]["Userid"]);
                            o.Password  = dt.Rows[0]["Userpassword"].ToString();
                            o.TodayDate = Convert.ToDateTime(dt.Rows[0]["TodayDate"]).ToString("yyyy-MM-dd");

                            FrmOfficerHome ofhm = new FrmOfficerHome(o);
                            ofhm.Show();
                            this.Close();
                        }
                        else if (usertypeid == UserTypeId.Instructor)
                        {
                            Instructor a = new Instructor();
                            a.Id       = Convert.ToInt32(dt.Rows[0]["Id"]);
                            a.Name     = dt.Rows[0]["Name"].ToString();
                            a.Userid   = Convert.ToInt32(dt.Rows[0]["Userid"]);
                            a.Password = dt.Rows[0]["Userpassword"].ToString();

                            FrmAdminHome adhm = new FrmAdminHome(a);
                            adhm.Show();
                            this.Close();
                        }
                    }
                    else
                    {
                        //user not found
                        txtusername.Clear();
                        txtpassword.Clear();
                        MessageBox.Show("Check your Login Details!");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
示例#11
0
 public FrmOfficerCadetView(Officer officer)
 {
     oofficer = officer;
     InitializeComponent();
 }