public FormCompany(AccessDataBase.Model.CompanyInfo companyInfo, OpenMode openMode)
{
InitializeComponent();
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = GetResourcesFile.getSystemIco();
this.modelCompanyInfo = companyInfo;
this.openMode = openMode;
if (openMode == OpenMode.Add)
{
kryptonTextBoxCompanyID.Text = companyInfo.CompanyID.ToString();
}
else if (openMode == OpenMode.Update)
{
kryptonTextBoxCompanyID.Text = companyInfo.CompanyID.ToString();
kryptonTextBoxCompanyName.Text = companyInfo.CompanyName.ToString();
kryptonTextBoxCompanyDes.Text = companyInfo.CompanyDes.ToString();
kryptonTextBoxCompanyAddr.Text = companyInfo.CompanyAddress.ToString();
kryptonTextBoxTelPhone1.Text = companyInfo.CompanyTel1.ToString();
kryptonTextBoxTelPhone2.Text = companyInfo.CompanyTel2.ToString();
}
}
private DataSet GetUsersFromDB()
{
AccessDataBase reader = new AccessDataBase();
string selectquery = "SELECT * FROM Registration";
return(reader.readDB(selectquery));
}
public FormDepartment(AccessDataBase.Model.DepartmentInfo modelDepartmentInfo, OpenMode openMode)
{
InitializeComponent();
InitComboBoxCompany();
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = GetResourcesFile.getSystemIco();
this.modelDepartmentInfo = modelDepartmentInfo;
this.openMode = openMode;
if (openMode == OpenMode.Add)
{
kryptonTextBoxDepartmentID.Text = modelDepartmentInfo.DepartmentID.ToString();
}
else if (openMode == OpenMode.Update)
{
string companyName = modelDepartmentInfo.CompanyName;//.CompanyID.HasValue?modelDepartmentInfo.CompanyID.Value:0;
modelCompanyInfo = bllCompanyInfo.GetModelList("CompanyName = '" + companyName + "'")[0];
kryptonTextBoxDepartmentID.Text = modelDepartmentInfo.DepartmentID.ToString();
kryptonComboBoxCompany.Text = modelCompanyInfo.CompanyName.ToString() ;
kryptonTextBoxDepartmentName.Text = modelDepartmentInfo.DepartmentName.ToString();
kryptonTextBoxDepartmentTel1.Text = modelDepartmentInfo.DepartmentTel1.ToString();
kryptonTextBoxDepartmentTel2.Text = modelDepartmentInfo.DepartmentTel2.ToString();
kryptonTextBoxDepartmentDes.Text = modelDepartmentInfo.DepartmentDes.ToString();
}
}
/// <summary>
/// Check if the last day absence selected falls before the next absence already set
/// </summary>
/// <param name="employee">Employee (object) selected</param>
/// <param name="firstDaySelected">First day selected in the DateTimePicker</param>
/// <param name="lastDaySelected">Last day selected in the DateTimePicker</param>
/// <returns>boolean (true if last day absence selected falls before the next absence already set, false if not)</returns>
public bool LastDayIsBeforeNextAbsence(Employee employee,
DateTime firstDaySelected,
DateTime lastDaySelected)
{
DateTime firstDayNextAbsence = AccessDataBase.LastDayIsBeforeNextAbsence(employee, firstDaySelected);
return(lastDaySelected < firstDayNextAbsence);
}
/// <summary>
/// Check if the first day selected falls after the previous absence already set
/// </summary>
/// <param name="employee">Employee (object) selected</param>
/// <param name="firstDaySelected">First day selected in the DateTimePicker</param>
/// <returns>boolean (true if first day absence selected falls after the previous absence already set, false if not)</returns>
public bool FirstDayIsAfterPreviousAbsence(Employee employee,
DateTime firstDaySelected
)
{
DateTime lastDayPreviousAbsence = AccessDataBase.FirstDayIsAfterPreviousAbsence(employee, firstDaySelected);
return(lastDayPreviousAbsence < firstDaySelected);
}
public FormController(AccessDataBase.Model.ControllerInfo ModelControllerInfo, OpenMode openMode)
{
InitializeComponent();
doorUnit1.KryptonButtonReaderAdd1.Click += KryptonButtonReaderAddClick1;
doorUnit1.KryptonButtonReaderAdd2.Click += KryptonButtonReaderAddClick1;
doorUnit1.KryptonButtonReaderUpdate1.Click += KryptonButtonReaderUpdateClick1;
doorUnit1.KryptonButtonReaderUpdate2.Click += KryptonButtonReaderUpdateClick1;
doorUnit1.KryptonCheckBoxReader1.CheckedChanged += KryptonCheckBoxReaderCheckedChanged1;
doorUnit1.KryptonCheckBoxReader2.CheckedChanged += KryptonCheckBoxReaderCheckedChanged1;
doorUnit2.KryptonButtonReaderAdd1.Click += KryptonButtonReaderAddClick1;
doorUnit2.KryptonButtonReaderAdd2.Click += KryptonButtonReaderAddClick1;
doorUnit2.KryptonButtonReaderUpdate1.Click += KryptonButtonReaderUpdateClick2;
doorUnit2.KryptonButtonReaderUpdate2.Click += KryptonButtonReaderUpdateClick2;
doorUnit2.KryptonCheckBoxReader1.CheckedChanged += KryptonCheckBoxReaderCheckedChanged2;
doorUnit2.KryptonCheckBoxReader2.CheckedChanged += KryptonCheckBoxReaderCheckedChanged2;
doorUnit3.KryptonButtonReaderAdd1.Click += KryptonButtonReaderAddClick1;
doorUnit3.KryptonButtonReaderAdd2.Click += KryptonButtonReaderAddClick1;
doorUnit3.KryptonButtonReaderUpdate1.Click += KryptonButtonReaderUpdateClick3;
doorUnit3.KryptonButtonReaderUpdate2.Click += KryptonButtonReaderUpdateClick3;
doorUnit3.KryptonCheckBoxReader1.CheckedChanged += KryptonCheckBoxReaderCheckedChanged3;
doorUnit3.KryptonCheckBoxReader2.CheckedChanged += KryptonCheckBoxReaderCheckedChanged3;
doorUnit4.KryptonButtonReaderAdd1.Click += KryptonButtonReaderAddClick4;
doorUnit4.KryptonButtonReaderAdd2.Click += KryptonButtonReaderAddClick4;
doorUnit4.KryptonButtonReaderUpdate1.Click += KryptonButtonReaderUpdateClick4;
doorUnit4.KryptonButtonReaderUpdate2.Click += KryptonButtonReaderUpdateClick4;
doorUnit4.KryptonCheckBoxReader1.CheckedChanged += KryptonCheckBoxReaderCheckedChanged4;
doorUnit4.KryptonCheckBoxReader2.CheckedChanged += KryptonCheckBoxReaderCheckedChanged4;
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = GetResourcesFile.getSystemIco();
this.modelControllerInfo = ModelControllerInfo;
this.openMode = openMode;
for (int i = 0; i < 4;i++ )
arrayDoorUnitInfo[i] = new AccessDataBase.Model.DoorUnitInfo();
if (openMode == OpenMode.Add)
{
showAddPara();
}
else if (openMode == OpenMode.Update)
{
showUpdatePara();
}
}
/// <summary>
/// Control that the input given by the manager fits with the input stored in the database
/// </summary>
/// <param name="login">user login</param>
/// <param name="password">user password</param>
/// <returns>true if the authentification is successfull</returns>
public Boolean ControlAuthentification(string login, string password)
{
if (AccessDataBase.ControlAuthentification(login, password))
{
FrmAuthentification.Hide();
(new FrmEmployee(this)).ShowDialog();
return(true);
}
else
{
return(false);
}
}
private void addReaderInfo(ref AccessDataBase.Model.ReaderInfo modelReaderInfo)
{
if (bllReaderInfo.Exists(modelReaderInfo.ReaderID))
{
MyMessageBox.MessageBoxOK("������ID�Ѿ�����");
return;
}
modelReaderTimeAccess.ReaderTimeAccessID = bllReaderTimeAccess.GetMaxId();
addReaderTimeAccess(ref modelReaderTimeAccess);
modelReaderInfo.ReadTimeAccessID = modelReaderTimeAccess.ReaderTimeAccessID;
bllReaderInfo.Add(modelReaderInfo);
}
/// <summary>
/// Method to update an employee in the database
/// </summary>
/// <param name="employee">Employee (objet) previously selected</param>
/// <param name="familyName">family name selected in its corresponding TextBox</param>
/// <param name="firstName">first name selected in its corresponding TextBox</param>
/// <param name="phone">phone selected in its corresponding TextBox</param>
/// <param name="mail">mail selected in its corresponding TextBox</param>
/// <param name="idDepartment">ID number of the selected department in the ComboBox</param>
public void UpdateEmployee(Employee employee,
string familyName,
string firstName,
string phone,
string mail,
int idDepartment)
{
employee.FamilyName = familyName;
employee.FirstName = firstName;
employee.Phone = phone;
employee.Mail = mail;
employee.IdDepartment = idDepartment;
AccessDataBase.UpdateEmployee(employee);
}
/// <summary>
/// Method to update an absence from an employee in the database
/// </summary>
/// <param name="employee">Employee (objet) previously selected</param>
/// <param name="previousDateSelected">first day selected (primary key) before the modification</param>
/// <param name="firstDay">first day selected in the DateTimePicker</param>
/// <param name="lastDay">last day selected in the DateTimePicker</param>
/// <param name="idReason">ID reason of the absence</param>
public void UpdateAbsence(Employee employee,
DateTime previousDateSelected,
DateTime firstDay,
DateTime lastDay,
int idReason
)
{
AccessDataBase.UpdateAbsence(employee,
previousDateSelected,
firstDay,
lastDay,
idReason
);
}
public FormManager(AccessDataBase.Model.Manager modelManager,OpenMode openMode)
{
InitializeComponent();
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Icon = GetResourcesFile.getSystemIco();
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.modelManager = modelManager;
this.openMode = openMode;
if (openMode == OpenMode.Update)
{
kryptonTextBoxName.Text = modelManager.ManagerName;
kryptonTextBoxName.Enabled = false;
}
}
/// <summary>
/// Method to add an employee in the database
/// </summary>
/// <param name="idEmployee">id number of the employee</param>
/// <param name="familyName">family name</param>
/// <param name="firstName">first name</param>
/// <param name="phone">phone number</param>
/// <param name="mail">mail</param>
/// <param name="idDepartment">id number of the department</param>
/// <param name="departmentName">name of the department</param>
public void AddEmployee(int idEmployee,
string familyName,
string firstName,
string phone,
string mail,
int idDepartment,
string departmentName
)
{
Employee employee = new Employee(idEmployee,
familyName,
firstName,
phone,
mail,
idDepartment,
departmentName);
AccessDataBase.AddEmployee(employee);
}
public FormCard(AccessDataBase.Model.CardInfo cardInfo, OpenMode openMode)
{
InitializeComponent();
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Icon = GetResourcesFile.getSystemIco();
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.modelCardInfo = cardInfo;
this.openMode = openMode;
if (openMode == OpenMode.Add)
{
showAddPara();
}
else if (openMode == OpenMode.Update)
{
showUpdatePara();
}
}
public FormReaderHoliday(OpenMode openMode, AccessDataBase.Model.ReaderInfo modelReaderInfo, AccessDataBase.Model.ReaderHoliday modelHoliay)
{
InitializeComponent();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = GetResourcesFile.getSystemIco();
this.CenterToScreen();
this.openMode = openMode;
this.modelReaderInfo = modelReaderInfo;
this.modelHoliay = modelHoliay;
if (openMode == OpenMode.Update)
{
kryptonDateTimePickerStartDate.Value = Convert.ToDateTime(modelHoliay.ReaderHolidayStartDate);
kryptonDateTimePickerEndDate.Value = Convert.ToDateTime(modelHoliay.ReaderHolidayEndDate);
}
else if(openMode == OpenMode.Add)
{ }
}
public FormMain(AccessDataBase.Model.Manager model)
{
InitializeComponent();
this.model = model;
this.CenterToScreen();
this.WindowState = FormWindowState.Maximized;
this.Icon = GetResourcesFile.getSystemIco();
this.notifyIcon1.Icon = GetResourcesFile.getSystemIco();
this.notifyIcon1.Text = this.Text;
this.toolStripStatusLabel2.Text = "";
this.toolStripStatusLabel3.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
this.timer1.Interval = 1000;
this.timer1.Start();
initUserInterface();
//WidgetThread.WidgetThread.displayFormOnPanel(this.splitContainer1.Panel2.Controls, webServer);
//webServer.BringToFrontAndRefresh();
toolStripMenuItemController_Click(null, null);
}
public FormReaderInfo(AccessDataBase.Model.ReaderInfo modelReaderInfo, OpenMode openMode)
{
InitializeComponent();
this.CenterToScreen();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = GetResourcesFile.getSystemIco();
this.modelReaderInfo = modelReaderInfo;
this.openMode = openMode;
for (int i = 0; i < 7; i++)
arrarymodelReaderTimeZone[i] = new AccessDataBase.Model.ReaderTimeZone();
if (openMode == OpenMode.Add)
{
showAddPara();
}
else if (openMode == OpenMode.Update)
{
this.modelReaderInfo = bllReaderInfo.GetModel(modelReaderInfo.ReaderID);
showUpdatePara();
}
}
private void getReaderInfo(ref AccessDataBase.Model.ReaderInfo modelReaderInfo)
{
modelReaderInfo.CommunicateType = kryptonComboBoxCommunicateType.SelectedIndex;
#region TCPͨ�Ų���
modelReaderInfo.ReaderIP = textBoxDeviceIP.Text.ToString();
modelReaderInfo.ReaderSubnet = textBoxMask.Text.ToString();
modelReaderInfo.ReaderGateway = textBoxGateway.Text.ToString();
modelReaderInfo.ReaderDNS = textBoxDNS.Text.ToString();
modelReaderInfo.ReaderBuDNS = kryptonTextBoxBackUpDNS.Text.ToString();
#endregion
#region 485ͨ�Ų���
modelReaderInfo.ReaderAddr483 = int.Parse(kryptonTextBoxControllerAddr485.Text.ToString());
modelReaderInfo.ReaderBaudrate = int.Parse(kryptonTextBoxControllerBaudrate.Text.ToString());
modelReaderInfo.ReaderDataBits = int.Parse(kryptonTextBoxControllerDataBits.Text.ToString());
modelReaderInfo.ReaderStopBits = int.Parse(kryptonTextBoxControllerStopBits.Text.ToString());
modelReaderInfo.ReaderParityCheck = kryptonComboBoxControllerParityCheck.Text.ToString();
modelReaderInfo.ReaderFlowControl = kryptonTextBoxControllerFlowControl.Text.ToString();
#endregion
}
/// <summary>
/// Check if the absence selected falls at the end of the absence list
/// </summary>
/// <param name="employee">Employee (object) selected</param>
/// <param name="firstDay">first day selected in the DateTimePicker</param>
/// <returns>boolean (true if the absence falls at the end of all previous absence, false if not)</returns>
public bool AbsenceAtTheEndOfTheCalendar(Employee employee, DateTime firstDay)
{
DateTime maxDay = AccessDataBase.AbsenceAtTheEndOfTheCalendar(employee);
return(firstDay > maxDay);
}
/// <summary>
/// Remove an absence for an employee
/// </summary>
/// <param name="absence">Absence (object)</param>
/// <param name="_employee">Employee (object)</param>
public void RemoveAbsenceFromEmployee(Absence absence, Employee _employee)
{
AccessDataBase.RemoveAbsenceFromEmployee(absence, _employee);
}
private void getReaderTimeZone( AccessDataBase.Model.ReaderTimeAccess modelReaderTimeAccess)
{
if (modelReaderTimeAccess.Mon.HasValue)
{
arrarymodelReaderTimeZone[0] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Mon.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime1, arrarymodelReaderTimeZone[0]);
}
if (modelReaderTimeAccess.Tue.HasValue)
{
arrarymodelReaderTimeZone[1] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Thu.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime2, arrarymodelReaderTimeZone[1]);
}
if (modelReaderTimeAccess.Tue.HasValue)
{
arrarymodelReaderTimeZone[2] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Tue.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime3, arrarymodelReaderTimeZone[2]);
}
if (modelReaderTimeAccess.Wed.HasValue)
{
arrarymodelReaderTimeZone[3] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Wed.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime4, arrarymodelReaderTimeZone[3]);
}
if (modelReaderTimeAccess.Fri.HasValue)
{
arrarymodelReaderTimeZone[4] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Fri.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime5, arrarymodelReaderTimeZone[4]);
}
if (modelReaderTimeAccess.Sat.HasValue)
{
arrarymodelReaderTimeZone[5] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Sat.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime6, arrarymodelReaderTimeZone[5]);
}
if (modelReaderTimeAccess.Sun.HasValue)
{
arrarymodelReaderTimeZone[6] = bllReaderTimeZone.GetModel(modelReaderTimeAccess.Sun.Value);
showDateTimePickerFormReaderTimeZone(ref timeModeAccessTime7, arrarymodelReaderTimeZone[6]);
}
}
/// <summary>
/// Method to add an absence from an employee to the database
/// </summary>
/// <param name="employee">Employee (objet) previously selected</param>
/// <param name="firstDay">first day of the absence selected in the DateTimePicker</param>
/// <param name="lastDay">last day of the absence selected in the DateTimePicker</param>
/// <param name="idReason">ID reason of the absence</param>
public void AddAbsence(Employee employee, DateTime firstDay, DateTime lastDay, int idReason)
{
AccessDataBase.AddAbsence(employee, firstDay, lastDay, idReason);
}
private void updateReaderInfo(ref AccessDataBase.Model.ReaderInfo modelReaderInfo)
{
modelReaderTimeAccess.ReaderTimeAccessID = bllReaderInfo.GetModel(modelReaderInfo.ReaderID).ReadTimeAccessID.HasValue ?
bllReaderInfo.GetModel(modelReaderInfo.ReaderID).ReadTimeAccessID.Value : bllReaderTimeAccess.GetMaxId();
modelReaderTimeAccess.ReaderTimeAccessName = "";
updateReaderTimeAccess(ref modelReaderTimeAccess);
modelReaderInfo.ReadTimeAccessID = modelReaderTimeAccess.ReaderTimeAccessID;
bllReaderInfo.Update(modelReaderInfo);
}
private void showDateTimePickerFormReaderTimeZone(ref MyComponents.TimeMode ModeAccessTime , AccessDataBase.Model.ReaderTimeZone modelReaderTimeZone)
{
if (modelReaderTimeZone == null)
return;
ModeAccessTime.KryptonDateTimePickerAccessTime1.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone1);
ModeAccessTime.KryptonDateTimePickerAccessTime2.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone2);
ModeAccessTime.KryptonDateTimePickerAccessTime3.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone3);
ModeAccessTime.KryptonDateTimePickerAccessTime4.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone4);
ModeAccessTime.KryptonDateTimePickerAccessTime5.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone5);
ModeAccessTime.KryptonDateTimePickerAccessTime6.Value = Convert.ToDateTime(modelReaderTimeZone.TimeZone6);
}
/// <summary>
/// Get and return the data from the employee coming from the database
/// </summary>
/// <returns>list of employees</returns>
public List <Employee> GetTheEmployees()
{
return(AccessDataBase.GetTheEmployees());
}
private Time1 getTimeFormReaderTimeZone(AccessDataBase.Model.ReaderTimeZone modelReaderTimeZone)
{
Time1 time = new Time1(0,0,0);
int.TryParse(modelReaderTimeZone.TimeZone1.Substring(0, 2), out time.hour);
int.TryParse(modelReaderTimeZone.TimeZone1.Substring(2, 2), out time.minute);
return time;
}
private void Button1_Click(object sender, EventArgs e)
{
AccessDataBase db = new AccessDataBase();
db.createConn();
string gioiTinh, maphongBan, maloaiHopDong, machucVu, maNhanVien, maLuong, maTrinhDo;
//Mã nhân viên
maNhanVien = "BA" + txbCMND.Text;
//phòng ban
if (comboBoxPhongBan.Text.Equals("Phòng Kỹ Thuật") == true)
{
maphongBan = "PB02";
}
else
{
maphongBan = "PB03";
}
//chức vụ
if (comboBoxChuVu.Text.Equals("Ban Giám Đốc") == true)
{
machucVu = "GD";
}
else if (comboBoxChuVu.Text.Equals("Trưởng phòng") == true)
{
machucVu = "TP";
}
else
{
machucVu = "NV";
}
//Loại hợp đồng
if (comboBoxLoaiHD.Text.Equals("Hợp đồng CTV") == true)
{
maloaiHopDong = "CTV";
}
else
{
maloaiHopDong = "HDLD";
}
//giới tính
if (radioButtonNam.Checked == true)
{
gioiTinh = "Nam";
}
else
{
gioiTinh = "Nữ";
}
//trình độ
if (comboBoxTrinhDo.Text.Equals("Manager") == true)
{
maTrinhDo = "1";
}
else if (comboBoxTrinhDo.Text.Equals("Development") == true)
{
maTrinhDo = "2";
}
else
{
maTrinhDo = "3";
}
if (txbhoTen.Text.Trim().Equals("") == true || txbLuong.Text.Trim().Equals("") == true || txbSDT.Text.Trim().Equals("") == true ||
txbDiaChi.Text.Trim().Equals("") == true || txbDanToc.Text.Trim().Equals("") == true || txbCMND.Text.Trim().Equals("") == true ||
comboBoxChuVu.Text.Trim().Equals("") == true || comboBoxLoaiHD.Text.Trim().Equals("") == true || comboBoxPhongBan.Text.Trim().Equals("") == true ||
comboBoxTrinhDo.Text.Trim().Equals("") == true || gioiTinh.Equals("") == true)
{
XtraMessageBox.Show("Mời nhập đầy đủ thông tin!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int dem = 0;
SqlCommand query_name = new SqlCommand("SELECT CMTND FROM NhanVien WHERE CMTND LIKE '" + txbCMND.Text + "'", AccessDataBase.connection);
using (SqlDataReader reader = query_name.ExecuteReader())
{
if (reader.HasRows)
{
// Đọc kết quả
while (reader.Read())
{
Console.WriteLine("{0}", reader[0].ToString());
if (reader[0].ToString().Equals(txbCMND.Text))
{
dem = 1;
}
}
}
}
if (dem == 1)
{
XtraMessageBox.Show("Nhân viên đã tồn tại!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//lương
if (IsNumber(txbLuong.Text) == true && IsNumber(txbCMND.Text) == true && IsNumber(txbSDT.Text) == true
)
{
int luong = Convert.ToInt32(txbLuong.Text);
if (luong <= 1000000)
{
maLuong = "LuongCTV" + txbCMND.Text;
}
else
{
maLuong = "LuongHDLD" + txbCMND.Text;
}
//chạy lệnh update Lương
SqlCommand query0 = new SqlCommand("INSERT Luong values ('" + maLuong + "','1','" + txbLuong.Text + "')");
nhanvien.executeQuery(query0);
//chạy lệnh update nhân viên
SqlCommand query = new SqlCommand("INSERT NhanVien values('" + maNhanVien + "','" + StandardString(txbhoTen.Text) + "', '" + ngaySinh.Value.ToString() + "'," +
" '" + gioiTinh + "', '" + StandardString(txbDanToc.Text) + "', '" + txbCMND.Text + "','" + txbSDT.Text + "', '"
+ txbDiaChi.Text + "', '" + maphongBan + "', '" + machucVu + "', '" + maloaiHopDong + "', '" + maTrinhDo + "', '" + maLuong + "')");
nhanvien.executeQuery(query);
XtraMessageBox.Show("Thêm mới nhân viên thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("Thông tin nhập vào không đúng định dạng!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
/// <summary>
/// ����ͼ�ؼ��л�ȡ�ŵ�Ԫ��Ϣ
/// </summary>
/// <param name="doorUnit"></param>
/// <returns>�ŵ�Ԫ��Ϣ</returns>
private void getModelDoorUnitInfo(ref AccessDataBase.Model.DoorUnitInfo modelDoorUnitInfo, MyComponents.DoorUnit doorUnit)
{
#region ������Ϣ
modelDoorUnitInfo.DoorUnitID = bllDoorUnitInfo.GetMaxId();
modelDoorUnitInfo.OutPutLockID = int.Parse(doorUnit.KryptonTextBoxOutPoint.Text.ToString());
//modelDoorUnitInfo.OutPutTimeLeng;
//modelDoorUnitInfo.OpenDoorOverTimeLen;
//modelDoorUnitInfo.AccessCapacityEnable;
//modelDoorUnitInfo.AccessCapacityMax;
//modelDoorUnitInfo.AccessCapacityMin;
#endregion
#region ��������Ϣ
modelDoorUnitInfo.ReadID1 = int.Parse(doorUnit.KryptonTextBoxReader1.Text.ToString());
modelDoorUnitInfo.ReadIDEnable1 = doorUnit.KryptonCheckBoxReader1.Checked;
modelDoorUnitInfo.ReadID2 = int.Parse(doorUnit.KryptonTextBoxReader2.Text.ToString());
modelDoorUnitInfo.ReadIDEnable2 = doorUnit.KryptonCheckBoxReader2.Checked;
#endregion
#region �������Ϣ
modelDoorUnitInfo.InputStateType = doorUnit.KryptonComboBoxInputStateType.SelectedIndex;
modelDoorUnitInfo.ExitButtonID = int.Parse(doorUnit.KryptonTextBoxExitButton.Text.ToString());
//modelDoorUnitInfo.ExitButtonMode;
//modelDoorUnitInfo.ExtiButtonEnable;
modelDoorUnitInfo.DoorContactID = int.Parse(doorUnit.KryptonTextBoxDoorContact.Text.ToString());
//modelDoorUnitInfo.DoorContactMode;
//modelDoorUnitInfo.DoorPositionEnable;
modelDoorUnitInfo.DoorPositionID = int.Parse(doorUnit.KryptonTextBoxDoorPosition.Text.ToString());
//modelDoorUnitInfo.DoorPositionMode;
//modelDoorUnitInfo.DoorPositionEnable;
modelDoorUnitInfo.BreakGlassID = int.Parse(doorUnit.KryptonTextBoxBreakGlass.Text.ToString());
//modelDoorUnitInfo.BreakGlassMode;
//modelDoorUnitInfo.BreakGlassEnable;
#endregion
#region ���ӵ�ͼ
//modelDoorUnitInfo.ElectronicMapID;
//modelDoorUnitInfo.PositionX;
//modelDoorUnitInfo.PositionY;
//modelDoorUnitInfo.StateImageOpen;
//modelDoorUnitInfo.StateImageClose;
//modelDoorUnitInfo.StateImageAlarmOpen;
//modelDoorUnitInfo.StateImageAlarmClose;
#endregion
}
private void getModelReaderTimeZone(ref AccessDataBase.Model.ReaderTimeZone modelReaderTimeZone,ref MyComponents.TimeMode timeModeAccessTime)
{
modelReaderTimeZone.TimeZone1 = timeModeAccessTime.KryptonDateTimePickerAccessTime1.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode1 = timeModeAccessTime.KryptonComboBoxAccessTime1.SelectedIndex;
modelReaderTimeZone.TimeZone2 = timeModeAccessTime.KryptonDateTimePickerAccessTime2.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode2 = timeModeAccessTime.KryptonComboBoxAccessTime2.SelectedIndex;
modelReaderTimeZone.TimeZone3 = timeModeAccessTime.KryptonDateTimePickerAccessTime3.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode3 = timeModeAccessTime.KryptonComboBoxAccessTime3.SelectedIndex;
modelReaderTimeZone.TimeZone4 = timeModeAccessTime.KryptonDateTimePickerAccessTime4.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode4 = timeModeAccessTime.KryptonComboBoxAccessTime4.SelectedIndex;
modelReaderTimeZone.TimeZone5 = timeModeAccessTime.KryptonDateTimePickerAccessTime5.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode5 = timeModeAccessTime.KryptonComboBoxAccessTime5.SelectedIndex;
modelReaderTimeZone.TimeZone6 = timeModeAccessTime.KryptonDateTimePickerAccessTime6.Value.ToShortTimeString();
modelReaderTimeZone.OperateMode6 = timeModeAccessTime.KryptonComboBoxAccessTime6.SelectedIndex;
}
/// <summary>
/// Get the maximum ID for the employee table
/// </summary>
/// <returns>integer (ID) corresponding to the last employee</returns>
public static int GetMaxEmployeeID()
{
return(AccessDataBase.GetMaxEmployeeID());
}
/// <summary>
/// Method to remove an employee in the database for the table ABSENCE
/// </summary>
/// <param name="employee">Employee (objet) previously selected</param>
public void RemoveEmployeeFromAbsence(Employee employee)
{
AccessDataBase.RemoveEmployeeFromAbsence(employee);
}
private void addReaderTimeAccess(ref AccessDataBase.Model.ReaderTimeAccess modelReaderTimeAccess)
{
modelReaderTimeAccess.ReaderTimeAccessName = "�ܹ���ģʽ" + modelReaderTimeAccess.ReaderTimeAccessID;
getModelReaderTimeZoneGroup();
foreach (AccessDataBase.Model.ReaderTimeZone readerTimeZone in arrarymodelReaderTimeZone)
{
readerTimeZone.ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(readerTimeZone);
}
modelReaderTimeAccess.Mon = arrarymodelReaderTimeZone[0].ReaderTimeZoneID;
modelReaderTimeAccess.Tue = arrarymodelReaderTimeZone[1].ReaderTimeZoneID;
modelReaderTimeAccess.Wed = arrarymodelReaderTimeZone[2].ReaderTimeZoneID;
modelReaderTimeAccess.Thu = arrarymodelReaderTimeZone[3].ReaderTimeZoneID;
modelReaderTimeAccess.Fri = arrarymodelReaderTimeZone[4].ReaderTimeZoneID;
modelReaderTimeAccess.Sat = arrarymodelReaderTimeZone[5].ReaderTimeZoneID;
modelReaderTimeAccess.Sun = arrarymodelReaderTimeZone[6].ReaderTimeZoneID;
}
/// <summary>
/// Get and return the list of departments stored in the database
/// </summary>
/// <returns>list of department</returns>
public List <Department> GetTheDepartments()
{
return(AccessDataBase.GetTheDepartments());
}
/// <summary>
/// Get the list of absences corresponding to a specific employee
/// </summary>
/// <param name="employee">Employee (objet) previously selected</param>
/// <returns>List of the absences</returns>
public List <Absence> GetTheAbsences(Employee employee)
{
return(AccessDataBase.GetTheAbsences(employee));
}
/// <summary>
/// Get the list of absence reasons for the ComboBox
/// </summary>
/// <returns>List of the reasons of the absence</returns>
public List <Reason> GetTheReasons()
{
return(AccessDataBase.GetTheReasons());
}
private void updateReaderTimeAccess(ref AccessDataBase.Model.ReaderTimeAccess modelReaderTimeAccess)
{
if (bllReaderTimeAccess.Exists(modelReaderTimeAccess.ReaderTimeAccessID))
{
modelReaderTimeAccess = bllReaderTimeAccess.GetModel(modelReaderTimeAccess.ReaderTimeAccessID);
}
else
{
bllReaderTimeAccess.Add(modelReaderTimeAccess);
}
getModelReaderTimeZoneGroup();
if (modelReaderTimeAccess.Mon.HasValue)
{
arrarymodelReaderTimeZone[0].ReaderTimeZoneID = modelReaderTimeAccess.Mon.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[0]);
}
else
{
modelReaderTimeAccess.Mon = arrarymodelReaderTimeZone[0].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[0]);
}
if (modelReaderTimeAccess.Thu.HasValue)
{
arrarymodelReaderTimeZone[1].ReaderTimeZoneID = modelReaderTimeAccess.Thu.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[1]);
}
else
{
modelReaderTimeAccess.Thu = arrarymodelReaderTimeZone[1].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[1]);
}
if (modelReaderTimeAccess.Tue.HasValue)
{
arrarymodelReaderTimeZone[2].ReaderTimeZoneID = modelReaderTimeAccess.Tue.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[2]);
}
else
{
modelReaderTimeAccess.Tue = arrarymodelReaderTimeZone[2].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[2]);
}
if (modelReaderTimeAccess.Wed.HasValue)
{
arrarymodelReaderTimeZone[3].ReaderTimeZoneID = modelReaderTimeAccess.Wed.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[3]);
}
else
{
modelReaderTimeAccess.Wed = arrarymodelReaderTimeZone[3].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[3]);
}
if (modelReaderTimeAccess.Fri.HasValue)
{
arrarymodelReaderTimeZone[4].ReaderTimeZoneID = modelReaderTimeAccess.Fri.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[4]);
}
else
{
modelReaderTimeAccess.Fri = arrarymodelReaderTimeZone[4].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[4]);
}
if (modelReaderTimeAccess.Sat.HasValue)
{
arrarymodelReaderTimeZone[5].ReaderTimeZoneID = modelReaderTimeAccess.Sat.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[5]);
}
else
{
modelReaderTimeAccess.Sat = arrarymodelReaderTimeZone[5].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[5]);
}
if (modelReaderTimeAccess.Sun.HasValue)
{
arrarymodelReaderTimeZone[6].ReaderTimeZoneID = modelReaderTimeAccess.Sun.Value;
bllReaderTimeZone.Update(arrarymodelReaderTimeZone[6]);
}
else
{
modelReaderTimeAccess.Sun = arrarymodelReaderTimeZone[6].ReaderTimeZoneID = bllReaderTimeZone.GetMaxId();
bllReaderTimeZone.Add(arrarymodelReaderTimeZone[6]);
}
bllReaderTimeAccess.Update(modelReaderTimeAccess);
}
