public void AddEmployee(Dictionary <string, string> txtBoxes, Dictionary <string, int> cmbBoxes, Dictionary <string, bool> chkBoxes) { using (IDbConnection connection = new SqlConnection(Helper.GetConnectionString("UserSupportDB"))) { string sql = "INSERT INTO EMPLOYEE(PositionId, DepartmentId, RoleId, UserName, Password, FirstName, " + "LastName, SurName, RoomNumber, Address, Email, PhoneNumber, WorkingState) VALUES " + "(@PositionId, @DepartmentId, @RoleId, @UserName, @Password, @FirstName, @LastName, " + "@SurName, @RoomNumber, @Address, @Email, @PhoneNumber, @WorkingState)"; var exception = false; try { connection.Execute(sql, new { PositionId = cmbBoxes["positionsCmbBox"], DepartmentId = cmbBoxes["departmentsCmbBox"], RoleId = cmbBoxes["rolesCmbBox"], UserName = txtBoxes["userNameTxtBox"], Password = txtBoxes["passwordTxtBox"], FirstName = txtBoxes["firstNameTxtBox"], LastName = txtBoxes["lastNameTxtBox"], SurName = txtBoxes["surNameTxtBox"], RoomNumber = txtBoxes["roomNumberTxtBox"], Address = txtBoxes["addressTxtBox"], Email = txtBoxes["emailTxtBox"], PhoneNumber = txtBoxes["phoneNumberTxtBox"], WorkingState = chkBoxes["workingStateChkBox"] }); } catch (SqlException ex) { exception = true; if (ex.Message.Contains("UserName")) { UserNameExistException?.Invoke(this, null); } else if (ex.Message.Contains("Email")) { EmailExistException?.Invoke(this, null); } else { DBConnectionException?.Invoke(this, null); } } if (!exception) { SuccessRecordInsert?.Invoke(this, null); } } }
public void UpdateEmployee(Dictionary <string, string> txtBoxes, Dictionary <string, int> cmbBoxes, Dictionary <string, bool> chkBoxes, int employeeId) { using (IDbConnection connection = new SqlConnection(Helper.GetConnectionString("UserSupportDB"))) { string sql = "UPDATE EMPLOYEE " + "SET PositionId = @PositionId, " + "DepartmentId = @DepartmentId, " + "RoleId = @RoleId, " + "UserName = @UserName, " + "Password = @Password, " + "FirstName = @FirstName, " + "LastName = @LastName, " + "SurName = @SurName, " + "RoomNumber = @RoomNumber, " + "Address = @Address, " + "Email = @Email, " + "PhoneNumber = @PhoneNumber, " + "WorkingState = @WorkingState " + "WHERE Id = @Id"; var exception = false; try { connection.Execute(sql, new { PositionId = cmbBoxes["positionsCmbBox"], DepartmentId = cmbBoxes["departmentsCmbBox"], RoleId = cmbBoxes["rolesCmbBox"], UserName = txtBoxes["userNameTxtBox"], Password = txtBoxes["passwordTxtBox"], FirstName = txtBoxes["firstNameTxtBox"], LastName = txtBoxes["lastNameTxtBox"], SurName = txtBoxes["surNameTxtBox"], RoomNumber = txtBoxes["roomNumberTxtBox"], Address = txtBoxes["addressTxtBox"], Email = txtBoxes["emailTxtBox"], PhoneNumber = txtBoxes["phoneNumberTxtBox"], WorkingState = chkBoxes["workingStateChkBox"], Id = employeeId }); } catch (SqlException ex) { exception = true; if (ex.Message.Contains("UserName")) { UserNameExistException?.Invoke(this, null); } else if (ex.Message.Contains("Email")) { EmailExistException?.Invoke(this, null); } } if (!exception) { SuccessRecordUpdate?.Invoke(this, null); } } }