public void GetNumber() { EmployeeHotel user = new EmployeeHotel(); WorkShift w = new WorkShift(); double manager = Convert.ToDouble(user.GetNumberOfManager()); Getnum.Text = "Manager: " + manager.ToString(); }
public void ReturnRoleID() { DataTable table = this.ShowId(); EmployeeHotel employee = new EmployeeHotel(); Total = Convert.ToInt32(employee.GetNumberJanitor()) + Convert.ToInt32(employee.GetNumberOfManager()) + Convert.ToInt32(employee.GetNumberReceptionist()); for (int i = 0; i < Total; i++) { arrayRole[i] = table.Rows[i]["role"].ToString().Trim(); arrayID[i] = Convert.ToInt32(table.Rows[i]["id"].ToString().Trim()); } }
public void ReLoad() { DataTable table = this.ShowId(); EmployeeHotel employee = new EmployeeHotel(); Random random = new Random(); Total = Convert.ToInt32(employee.GetNumberJanitor()) + Convert.ToInt32(employee.GetNumberOfManager()) + Convert.ToInt32(employee.GetNumberReceptionist()); this.ReturnRoleID(); for (int i = 0; i < Total; i++) { int mon = random.Next(1, 4); int tue = random.Next(1, 4); int wed = random.Next(1, 4); int thu = random.Next(1, 4); int fri = random.Next(1, 4); this.UppdateShiftColumn1(arrayID[i], mon); this.UppdateShiftColumn2(arrayID[i], tue); this.UppdateShiftColumn3(arrayID[i], wed); this.UppdateShiftColumn4(arrayID[i], thu); this.UppdateShiftColumn5(arrayID[i], fri); } }
public void GetShift() { this.ReturnRoleID(); EmployeeHotel employee = new EmployeeHotel(); int manager = Convert.ToInt32(employee.GetNumberOfManager()); int receptionist = Convert.ToInt32(employee.GetNumberReceptionist()); int Janitor = Convert.ToInt32(employee.GetNumberJanitor()); //Monday for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Manager" && manager > 0) { Check = 0; int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn1(arrayID[i], 1); } else { this.UppdateShiftColumn1(arrayID[i], s1); } Check = 1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Receptionist" && receptionist > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn1(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Janitor" && Janitor > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn1(arrayID[i], s1); } Check = s1; } } //Tuesday for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Manager" && manager > 0) { Check = 0; int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn2(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Receptionist" && receptionist > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn2(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Janitor" && Janitor > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn2(arrayID[i], s1); } Check = s1; } } //Wednesday for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Manager" && manager > 0) { Check = 0; int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn3(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Receptionist" && receptionist > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn3(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Janitor" && Janitor > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn3(arrayID[i], s1); } Check = s1; } } //Thursday for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Manager" && manager > 0) { Check = 0; int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn4(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Receptionist" && receptionist > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn4(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Janitor" && Janitor > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn4(arrayID[i], s1); } Check = s1; } } //Friday for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Manager" && manager > 0) { Check = 0; int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn5(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Receptionist" && receptionist > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn5(arrayID[i], s1); } Check = s1; } } for (int i = 0; i < Total; i++) { if (arrayRole[i] == "Janitor" && Janitor > 0) { int s1 = random.Next(1, 4); if (Check != s1) { this.UppdateShiftColumn5(arrayID[i], s1); } Check = s1; } } //for (int i = 0; i < Total; i++) //{ // int mon = random.Next(1, 4); // int tue = random.Next(1, 4); // int wed = random.Next(1, 4); // int thu = random.Next(1, 4); // int fri = random.Next(1, 4); // int sat = random.Next(1, 4); // int sun = random.Next(1, 4); // this.UppdateShift(arrayID[i], mon, tue, wed, thu, fri, sat, sun); //} }
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); } }