private void Manager_Load(object sender, EventArgs e) { WorkShift ws = new WorkShift(); ws.UpdateWorkShift(); this.ReloadData(); }
private void RemoveSchedule_btn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WorkShift s = new WorkShift(); s.DeleteData(); s.InsertShift(); GridControl_DisplayShift.DataSource = s.ShowShift(); }
private void Schedule_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'hotel_ManagementDataSet11.Schedule' table. You can move, or remove it, as needed. //this.scheduleTableAdapter.Fill(this.hotel_ManagementDataSet11.Schedule); this.ShiftWork(); WorkShift s = new WorkShift(); //this.GetNumber(); }
public void GetNumber() { EmployeeHotel user = new EmployeeHotel(); WorkShift w = new WorkShift(); double manager = Convert.ToDouble(user.GetNumberOfManager()); Getnum.Text = "Manager: " + manager.ToString(); }
public void RoleLogin() { try { if (Radio_Customer.Checked == true) { this.LoginWithCustomer(); } else { string role = ""; EmployeeHotel user = new EmployeeHotel(); user.ID = Convert.ToInt32(Username_tb.Text); user.Password = Password_tb.Text; Database data = new Database(); SqlCommand command = new SqlCommand("SELECT Id, password, fname, lname, CMND, bdate, address, phone, email, " + "salary, role, daywork, work, picture, gender, shift FROM Employee WHERE Id = @id AND password = @pass", data.GetConnection); command.Parameters.Add("@id", SqlDbType.Int).Value = Username_tb.Text; command.Parameters.Add("@pass", SqlDbType.NVarChar).Value = Password_tb.Text; data.OpenConnection(); DataTable table = user.GetUsers(command); if (table.Rows.Count > 0) { SqlDataAdapter SDA = new SqlDataAdapter(); SDA.SelectCommand = command; DataSet set = new DataSet(); SDA.Fill(set, "Employee"); data.CloseConnection(); role = table.Rows[0]["role"].ToString().Trim(); int UserId = Convert.ToInt32(table.Rows[0]["id"].ToString()); byte[] pic = (byte[])table.Rows[0]["picture"]; MemoryStream picture = new MemoryStream(pic); GetID(UserId); WorkShift w = new WorkShift(); if (user.GetLogin() && role == "Manager" && Manager_rbt.Checked == true) { Menu manager = new Menu(); manager.Label_ShowId.Text = UserId.ToString(); manager.Label_wcome.Text = "Wellcome back " + table.Rows[0]["fname"].ToString().Trim(); manager.PictureUser.Image = Image.FromStream(picture); //w.InsertId(Convert.ToInt32(UserId)); manager.ShowDialog(); } else if (user.GetLogin() && role == "Receptionist" && Receptionist_rbt.Checked == true) { } else if (user.GetLogin() && role == "Janitor" && Janitor_rbt.Checked == true) { } else { XtraMessageBox.Show("Invalid Username of wrong Password, Try again or Create new account", "Login", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } catch { XtraMessageBox.Show("Invalid Username of wrong Password, Try again or Create new account", "Login", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void Setshift_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WorkShift w = new WorkShift(); GridControl_DisplayShift.DataSource = w.ShowReloadShift(); }
public void ShiftWork() { WorkShift w = new WorkShift(); GridControl_DisplayShift.DataSource = w.ShowShift(); }