private void btnLogin_Click(object sender, EventArgs e)
{
try
{
string uname = tbUsername.Text.Trim();
string passwd = tbPassword.Text.Trim();
if (uname == "" || passwd == "")
{
MessageBox.Show("PLEASE INPUT USERNAME AND/OR PASSWORD", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Clear();
tbUsername.Focus();
}
else
{
Admin A = new Admin();
string[] values = A.Authentication(uname, passwd);
string dbUname = values[0];
string dbPsswd = values[1];
string dbLevel = values[2];
if (uname == dbUname && passwd == dbPsswd)
{
if (dbLevel == "Yes")
{
MessageBox.Show("WELCOME, " + uname + "", "WELCOME TO IHRIS", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormMainMenuMaster MMM = new FormMainMenuMaster(uname);
this.Hide();
MMM.Show();
}
else
{
MessageBox.Show("WELCOME, " + uname + "", "WELCOME TO IHRIS", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormUserMainMenu MM = new FormUserMainMenu(uname);
this.Hide();
MM.Show();
}
}
else
{
MessageBox.Show("INCORRECT USERNAME AND/OR PASSWORD", "INCORRECT LOGIN", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Clear();
tbUsername.Focus();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void RefreshDGV()
{
Admin Show = new Admin();
dgDivision.DataSource = Show.DivisionDGV();
dgDivision.DataMember = "Division";
dgPosition.DataSource = Show.PositionDGV();
dgPosition.DataMember = "Position";
dgSearchEmpPayroll.DataSource = Show.PayrollEmpDGV();
dgSearchEmpPayroll.DataMember = "Employee";
dgAddPayroll.DataSource = Show.PayrollEmpDGV();
dgAddPayroll.DataMember = "Employee";
}
public void RefreshDG()
{
Admin Auto = new Admin();
tbItemNumber.Text = Auto.InventoryAutoGenerateID();
Admin Show = new Admin();
dgAllItem.DataSource = Show.InventoryDGV();
dgAllItem.DataMember = "Inventory";
dgSearchItem.DataSource = Show.InventoryDGV();
dgSearchItem.DataMember = "Inventory";
dgEditItem.DataSource = Show.InventoryDGV();
dgEditItem.DataMember = "Inventory";
tbEditAddStock.Enabled = false;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("MAKE SURE YOUR PASSWORD IS EASY TO REMEMBER", "UPDATE PASSWORD?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (tbPassword.Text == "" || tbRepeat.Text == "")
{
MessageBox.Show("PLEASE INPUT PASSWORD AND/OR REPEAT THE PASSWORD", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Clear();
tbRepeat.Clear();
}
else
{
if (tbPassword.Text == tbRepeat.Text)
{
Admin A = new Admin();
A.UpdatePassword(tbRepeat.Text, lblUsername.Text);
MessageBox.Show("PASSWORD UPDATED", "UPDATED", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbPassword.Clear();
tbRepeat.Clear();
}
else
{
tbPassword.Clear();
tbRepeat.Clear();
MessageBox.Show("PASSWORD MISSMATCH", "FAILED TO UPDATE", MessageBoxButtons.OK, MessageBoxIcon.Error);
tbPassword.Focus();
}
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindCBDivision()
{
Admin A = new Admin();
ArrayList data_division = A.BindCBDivision();
if (data_division.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_division.Count; i = i + 2)
{
string DivID = (string)data_division[i];
string DivName = (string)data_division[i+1];
cbPositionDivision.Items.Add(DivID+". "+DivName);
}
}
}
public void BindPositionComboBoxEditForm()
{
Admin AP = new Admin();
ArrayList data_position = AP.BindCBPosition(cbEditEmpDivision.Text.Substring(0, 1));
if (data_position.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_position.Count; i = i + 2)
{
string PosID = (string)data_position[i];
string PosName = (string)data_position[i + 1];
cbEditEmpPosition.Items.Add(PosID + ". " + PosName);
}
}
}
public void RefreshDG()
{
Admin Show = new Admin();
dgvAllContract.DataSource = Show.ContractDGV();
dgvAllContract.DataMember = "Contracts";
dgOngoing.DataSource = Show.GetOngoingContractDGV();
dgOngoing.DataMember = "OngoingContracts";
dgCompleted.DataSource = Show.GetCompletedContractDGV();
dgCompleted.DataMember = "CompletedContracts";
dgExtended.DataSource = Show.GetExtendedContractDGV();
dgExtended.DataMember = "ExtendedContracts";
dgSearchContract.DataSource = Show.GetSearchContractDGV();
dgSearchContract.DataMember = "SearchContracts";
dgEditContract.DataSource = Show.GetEditContractDGV();
dgEditContract.DataMember = "EditContracts";
}
private void dgSearchEmp_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string str = dgSearchEmp.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
Admin Bind = new Admin();
ArrayList data_emp = Bind.BindEmpDetails(str);
if (data_emp.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_emp.Count; i = i + 8)
{
string EmpNIP = (string)data_emp[i];
string EmpName = (string)data_emp[i + 1];
string EmpGender = (string)data_emp[i + 2];
string EmpDOB = (string)data_emp[i + 3];
string EmpEmail = (string)data_emp[i + 4];
string EmpPhone = (string)data_emp[i + 5];
string DivID = (string)data_emp[i + 6];
string PosID = (string)data_emp[i + 7];
tbSearchEmpNIP.Text = EmpNIP;
tbSearchEmpName.Text = EmpName;
tbSearchEmpGender.Text = EmpGender;
tbSearchEmpDOB.Text = EmpDOB;
tbSearchEmpEmail.Text = EmpEmail;
tbSearchEmpPhone.Text = EmpPhone;
Admin BindSingleDiv = new Admin();
ArrayList data_singleDiv = BindSingleDiv.BindCBDivisionForEditAndSearchEmployeeForm(DivID);
for (int iD = 0; iD < data_singleDiv.Count; iD = iD + 2)
{
string CompletedDivID = (string)data_singleDiv[iD];
string CompletedDivName = (string)data_singleDiv[iD + 1];
tbSearchEmpDivision.Text = CompletedDivID + ". " + CompletedDivName;
}
Admin BindSinglePos = new Admin();
ArrayList data_singlePos = BindSingleDiv.BindCBPositionForEditAndSearchEmployeeForm(PosID);
for (int iP = 0; iP < data_singlePos.Count; iP = iP + 2)
{
string CompletedPosID = (string)data_singlePos[iP];
string CompletedPosName = (string)data_singlePos[iP + 1];
tbSearchEmpPosition.Text = CompletedPosID + ". " + CompletedPosName;
}
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("SAVE DATA? \nMAKE SURE ALL THE FORM FIELDS FILLED CORRECTLY", "DATA ENTRY", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (tbEmpPassword.Text != tbEmpRepeatPassword.Text)
{
MessageBox.Show("PASSWORD MISSMATCH", "INCORECT PASSWORD", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbEmpPassword.Clear();
tbEmpRepeatPassword.Clear();
tbEmpPassword.Focus();
}
else
{
if (tbEmpNIP.Text == "" || tbEmpName.Text == "" || tbEmpEmail.Text == "" || tbEmpPhone.Text == "" || tbEmpPhoto.Text == "" || dtpEmpDOB.Text == DateTime.Today.ToShortDateString() || cbEmpGender.Text == "-----SELECT GENDER-----" || cbEmpDivision.Text == "-----SELECT DIVISION-----" || cbEmpPosition.Text == "-----SELECT POSITION-----")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO SAVE DATA", "DATA ENTRY ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbEmpNIP.Focus();
}
else
{
string EmployeeNIP = tbEmpNIP.Text;
string EmployeePassword = tbEmpRepeatPassword.Text;
string EmployeeName = tbEmpName.Text;
string EmployeeGender = cbEmpGender.Text;
string EmployeeDOB = dtpEmpDOB.Text;
string EmployeeEmail = tbEmpEmail.Text;
string EmployeePhone = tbEmpPhone.Text;
string EmployeePhoto = tbEmpPhoto.Text;
string DivisionID = cbEmpDivision.Text.Substring(0, 1);
string PositionID = cbEmpPosition.Text.Substring(0, 1);
Admin A = new Admin();
A.AddEmployee(EmployeeNIP, EmployeePassword, EmployeeName, EmployeeGender, EmployeeDOB, EmployeeEmail, EmployeePhone, EmployeePhoto, DivisionID, PositionID);
tbEmpNIP.Clear();
tbEmpName.Clear();
cbEmpGender.Text = "-----SELECT GENDER-----";
dtpEmpDOB.Text = DateTime.Today.ToShortDateString();
tbEmpEmail.Clear();
tbEmpPhone.Clear();
tbEmpPhoto.Clear();
cbEmpDivision.Text = "-----SELECT DIVISION-----";
cbEmpPosition.Text = "-----SELECT POSITION-----";
tbEmpPassword.Clear();
tbEmpRepeatPassword.Clear();
MessageBox.Show("DATA SAVED", "ENTRY DATA SUCCESSFUL", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshFormEmployee();
}
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("DO YOU WANT TO EDIT THIS EMPLOYEE DATA?", "EDIT EMPLOYEE DETAILS", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (tbEditEmpNIP.Text == "" || tbEditEmpName.Text == "" || tbEditEmpEmail.Text == "" || tbEditEmpPhone.Text == "" || dtpEditEmpDOB.Text == DateTime.Today.ToShortDateString() || cbEditEmpGender.Text == "-----SELECT GENDER-----" || cbEditEmpDivision.Text == "-----SELECT DIVISION-----" || cbEditEmpPosition.Text == "-----SELECT POSITION-----")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO EDIT DATA", "DATA UPDATION ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbEditEmpEmail.Focus();
}
else
{
string EmployeeNIP = tbEditEmpNIP.Text;
string EmployeeName = tbEditEmpName.Text;
string EmployeeGender = cbEditEmpGender.Text;
string EmployeeDOB = dtpEditEmpDOB.Text;
string EmployeeEmail = tbEditEmpEmail.Text;
string EmployeePhone = tbEditEmpPhone.Text;
string DivisionID = cbEditEmpDivision.Text.Substring(0, 1);
string PositionID = cbEditEmpPosition.Text.Substring(0, 1);
Admin A = new Admin();
A.EditEmployee(EmployeeNIP, EmployeeName, EmployeeGender, EmployeeDOB, EmployeeEmail, EmployeePhone, DivisionID, PositionID);
tbEditEmpNIP.Clear();
tbEditEmpName.Clear();
cbEditEmpGender.Text = "-----SELECT GENDER-----";
dtpEditEmpDOB.Text = DateTime.Today.ToShortDateString();
tbEditEmpEmail.Clear();
tbEditEmpPhone.Clear();
cbEditEmpDivision.Text = "-----SELECT DIVISION-----";
cbEditEmpPosition.Text = "-----SELECT POSITION-----";
MessageBox.Show("DATA UPDATED", "UPDATE DATA SUCCESSFUL", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshFormEmployee();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void RefreshFormEmployee()
{
dtpEmpDOB.Text = DateTime.Today.ToShortDateString();
dtpEditEmpDOB.Text = DateTime.Today.ToShortDateString();
Admin Show = new Admin();
dgAllEmployee.DataSource = Show.EmployeeDGV();
dgAllEmployee.DataMember = "Employee";
dgEditEmp.DataSource = Show.EmployeeDGV();
dgEditEmp.DataMember = "Employee";
dgSearchEmp.DataSource = Show.EmployeeDGV();
dgSearchEmp.DataMember = "Employee";
if (tbEditEmpNIP.Text == "" || tbEditEmpName.Text == "")
{
btnEdit.Visible = false;
btnCancelEdit.Visible = false;
}
if (tbEmpNIP.Text == "" || tbEditEmpName.Text == "")
{
btnSave.Visible = false;
btnCancel.Visible = false;
}
}
private void dgSearchContract_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string str = dgSearchContract.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
Admin Bind = new Admin();
ArrayList data_contract = Bind.BindAllContractDetails(str);
if (data_contract.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_contract.Count; i = i + 8)
{
string ContractNumber = (string)data_contract[i];
string ContractName = (string)data_contract[i + 1];
string ContractDescription = (string)data_contract[i + 2];
string ContractTimePeriod = (string)data_contract[i + 3];
DateTime ContractStartDate = (DateTime)data_contract[i + 4];
DateTime ContractEndDate = (DateTime)data_contract[i + 5];
string ContractStatus = (string)data_contract[i + 6];
string ContractInfo = (string)data_contract[i + 7];
tbSearchContractNumber.Text = ContractNumber;
tbSearchContractName.Text = ContractName;
tbSearchContractDescription.Text = ContractDescription;
tbSearchContractTime.Text = ContractTimePeriod;
tbSearchContractStartDate.Text = ContractStartDate.ToShortDateString();
tbSearchContractEndDate.Text = ContractEndDate.ToShortDateString();
tbSearchContractStatus.Text = ContractStatus;
tbSearchContractInfo.Text = ContractInfo;
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgSearchEmpPayroll_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string str = dgSearchEmpPayroll.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
Admin Bind = new Admin();
ArrayList data_payroll = Bind.BindPayrollDetails(str);
if (data_payroll.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_payroll.Count; i = i + 8)
{
string EmpNIP = (string)data_payroll[i];
string PayrollBase = (string)data_payroll[i + 1];
string PayrollPositionAllowanceTotal = (string)data_payroll[i + 2];
string PayrollTransportationAllowanceTotal = (string)data_payroll[i + 3];
string PayrollHouseAllowanceTotal = (string)data_payroll[i + 4];
string PayrollAnotherAllowanceTotal = (string)data_payroll[i + 5];
string PayrollReductionTotal = (string)data_payroll[i + 6];
string PayrollTotal = (string)data_payroll[i + 7];
tbSearchPayrollEmpNIP.Text = EmpNIP;
tbSearchPayrollBase.Text = PayrollBase;
tbSearchPayrollPosition.Text = PayrollPositionAllowanceTotal;
tbSearchPayrollTransportation.Text = PayrollTransportationAllowanceTotal;
tbSearchPayrollHouse.Text = PayrollHouseAllowanceTotal;
tbSearchPayrollAnother.Text = PayrollAnotherAllowanceTotal;
tbSearchPayrollReduction.Text = PayrollReductionTotal;
tbSearchTotalPayroll.Text = PayrollReductionTotal;
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private List<string> StatusKerja()
{
Admin A = new Admin();
ArrayList data_att = A.GetAttendanceTime();
List<string> statusKerjaList = null;
for (int ar = 0; ar <= data_att.Count; ar = ar + 2)
{
string statusKerja;
DateTime AttIn = (DateTime)data_att[ar];
DateTime AttOut = (DateTime)data_att[ar + 1];
TimeSpan rawTotalHoursWorked = AttOut - AttIn;
var masuk = TimeSpan.Parse("08:00:00");
var lembur = TimeSpan.Parse("09:00:00");
if (rawTotalHoursWorked >= lembur)
{
statusKerja = "Lembur";
}
else if (rawTotalHoursWorked >= masuk && rawTotalHoursWorked < lembur)
{
statusKerja = "Masuk";
}
else
{
statusKerja = "Setengah Hari";
}
statusKerjaList.Add(statusKerja);
}
return statusKerjaList;
}
private void btnUpdateContract_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("UPDATE CONTRACT STATUS TO COMPLETED?", "UPDATE CONTRACT STATUS", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (tbEditContractNumber.Text == "" || tbEditContractName.Text == "" || tbEditContractTimePeriod.Text == "" || tbEditContractEndDate.Text == "" || tbEditContractStatus.Text == "")
{
MessageBox.Show("PLEASE SELECT CONTRACT TO COMPLETE FIRST", "ERROR UPDATING CONTRACT STATUS", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string TodayDate = DateTime.Today.ToShortDateString();
string OneDayAfter = DateTime.Today.AddDays(-1).ToShortDateString();
string TwoDayAfter = DateTime.Today.AddDays(-2).ToShortDateString();
string ThreeDayAfter = DateTime.Today.AddDays(-3).ToShortDateString();
string FourDayAfter = DateTime.Today.AddDays(-4).ToShortDateString();
string FiveDayAfter = DateTime.Today.AddDays(-5).ToShortDateString();
string SixDayAfter = DateTime.Today.AddDays(-6).ToShortDateString();
string SevenDayAfter = DateTime.Today.AddDays(-7).ToShortDateString();
if(tbEditContractEndDate.Text == TodayDate || tbEditContractEndDate.Text == OneDayAfter || tbEditContractEndDate.Text == TwoDayAfter || tbEditContractEndDate.Text == ThreeDayAfter || tbEditContractEndDate.Text == FourDayAfter || tbEditContractEndDate.Text == FiveDayAfter || tbEditContractEndDate.Text == SixDayAfter || tbEditContractEndDate.Text == SevenDayAfter)
{
string ContractNumber = tbEditContractNumber.Text;
Admin A = new Admin();
A.UpdateContractStatus(ContractNumber);
MessageBox.Show("CONTRACT STATUS UPDATED", "CONTRACT DONE", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbEditContractNumber.Clear();
tbEditContractName.Clear();
tbEditContractTimePeriod.Clear();
tbEditContractEndDate.Clear();
tbEditContractStatus.Clear();
RefreshDG();
}
else
{
MessageBox.Show("CONTRACT IS NOT DONE YET, CAN'T UPDATE CONTRACT STATUS", "CONTRACT STILL ONGOING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindDetails()
{
try
{
string str = lblUser.Text;
Admin Bind = new Admin();
ArrayList data_emp = Bind.UserBindEmpDetails(str);
if (data_emp.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_emp.Count; i = i + 9)
{
string EmpNIP = (string)data_emp[i];
string EmpName = (string)data_emp[i + 1];
string EmpGender = (string)data_emp[i + 2];
string EmpDOB = (string)data_emp[i + 3];
string EmpEmail = (string)data_emp[i + 4];
string EmpPhone = (string)data_emp[i + 5];
string EmpPhoto = (string)data_emp[i + 6];
string DivID = (string)data_emp[i + 7];
string PosID = (string)data_emp[i + 8];
lblEmpNIP.Text = EmpNIP;
lblEmpName.Text = EmpName;
lblEmpGender.Text = EmpGender;
lblEmpDOB.Text = EmpDOB;
lblEmpEmail.Text = EmpEmail;
lblEmpPhone.Text = EmpPhone;
pbEmpPhoto.Image = Image.FromFile(@"D:\Important\Clients\PT Bahtera Adhiguna\Misc\Employee Photo\"+EmpPhoto+"");
pbEmpPhoto.SizeMode = PictureBoxSizeMode.StretchImage;
pbEmpPhoto.BorderStyle = BorderStyle.Fixed3D;
Admin BindSingleDiv = new Admin();
ArrayList data_singleDiv = BindSingleDiv.BindCBDivisionForEditAndSearchEmployeeForm(DivID);
for (int iD = 0; iD < data_singleDiv.Count; iD = iD + 2)
{
string CompletedDivID = (string)data_singleDiv[iD];
string CompletedDivName = (string)data_singleDiv[iD + 1];
lblEmpDivision.Text = CompletedDivID + ". " + CompletedDivName;
}
Admin BindSinglePos = new Admin();
ArrayList data_singlePos = BindSingleDiv.BindCBPositionForEditAndSearchEmployeeForm(PosID);
for (int iP = 0; iP < data_singlePos.Count; iP = iP + 2)
{
string CompletedPosID = (string)data_singlePos[iP];
string CompletedPosName = (string)data_singlePos[iP + 1];
lblEmpPosition.Text = CompletedPosID + ". " + CompletedPosName;
}
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnChangePhoto_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("UPDATE YOUR PROFILE PHOTO?", "UPDATE PROFILE PICTURE?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (tbEmpPhoto.Text == "")
{
MessageBox.Show("PLEASE SELECT THE PHOTO FIRST", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
btnBrowse.Focus();
}
else
{
Admin A = new Admin();
A.UserUpdatePhoto(tbEmpPhoto.Text, lblUser.Text);
MessageBox.Show("PROFILE PHOTO UPDATED", "UPDATE PHOTO SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindDetails();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FormMainMenuMaster_Load(object sender, EventArgs e)
{
lblUser.Text = dataPassing;
lblDate.Text = DateTime.Now.ToShortDateString();
lblTime.Text = DateTime.Now.ToLongTimeString();
Admin CheckContract = new Admin();
ArrayList data_contract = CheckContract.CheckContractExpiration();
for (int i = 0; i < data_contract.Count; i = i + 2)
{
string ContractNumber = (string)data_contract[i];
string ContractEndDate = (string)data_contract[i + 1];
string TodayDate = DateTime.Today.ToShortDateString();
string Date1 = DateTime.Today.AddDays(-1).ToShortDateString();
string Date2 = DateTime.Today.AddDays(-2).ToShortDateString();
string Date3 = DateTime.Today.AddDays(-3).ToShortDateString();
string Date4 = DateTime.Today.AddDays(-4).ToShortDateString();
string Date5 = DateTime.Today.AddDays(-5).ToShortDateString();
string Date6 = DateTime.Today.AddDays(-6).ToShortDateString();
string Date7 = DateTime.Today.AddDays(-7).ToShortDateString();
string Date8 = DateTime.Today.AddDays(-8).ToShortDateString();
string Date9 = DateTime.Today.AddDays(-9).ToShortDateString();
string Date10 = DateTime.Today.AddDays(-10).ToShortDateString();
string Date11 = DateTime.Today.AddDays(-11).ToShortDateString();
string Date12 = DateTime.Today.AddDays(-12).ToShortDateString();
string Date13 = DateTime.Today.AddDays(-13).ToShortDateString();
string Date14 = DateTime.Today.AddDays(-14).ToShortDateString();
string Date15 = DateTime.Today.AddDays(-15).ToShortDateString();
string Date16 = DateTime.Today.AddDays(-16).ToShortDateString();
string Date17 = DateTime.Today.AddDays(-17).ToShortDateString();
string Date18 = DateTime.Today.AddDays(-18).ToShortDateString();
string Date19 = DateTime.Today.AddDays(-19).ToShortDateString();
string Date20 = DateTime.Today.AddDays(-20).ToShortDateString();
string Date21 = DateTime.Today.AddDays(-21).ToShortDateString();
string Date22 = DateTime.Today.AddDays(-22).ToShortDateString();
string Date23 = DateTime.Today.AddDays(-23).ToShortDateString();
string Date24 = DateTime.Today.AddDays(-24).ToShortDateString();
string Date25 = DateTime.Today.AddDays(-25).ToShortDateString();
string Date26 = DateTime.Today.AddDays(-26).ToShortDateString();
string Date27 = DateTime.Today.AddDays(-27).ToShortDateString();
string Date28 = DateTime.Today.AddDays(-28).ToShortDateString();
string Date29 = DateTime.Today.AddDays(-29).ToShortDateString();
string Date30 = DateTime.Today.AddDays(-30).ToShortDateString();
string Date31 = DateTime.Today.AddDays(-31).ToShortDateString();
if (ContractEndDate == TodayDate || ContractEndDate == Date1 || ContractEndDate == Date2 || ContractEndDate == Date3 || ContractEndDate == Date4 || ContractEndDate == Date5 || ContractEndDate == Date6 || ContractEndDate == Date7 || ContractEndDate == Date8 || ContractEndDate == Date9 || ContractEndDate == Date10 || ContractEndDate == Date11 || ContractEndDate == Date12 || ContractEndDate == Date13 || ContractEndDate == Date14 || ContractEndDate == Date15 || ContractEndDate == Date16 || ContractEndDate == Date17 || ContractEndDate == Date18 || ContractEndDate == Date19 || ContractEndDate == Date20 || ContractEndDate == Date21 || ContractEndDate == Date22 || ContractEndDate == Date23 || ContractEndDate == Date24 || ContractEndDate == Date25 || ContractEndDate == Date26 || ContractEndDate == Date27 || ContractEndDate == Date28 || ContractEndDate == Date29 || ContractEndDate == Date30 || ContractEndDate == Date31)
{
Console.Beep();
Console.Beep();
Console.Beep();
Console.Beep();
notifyContract.Text = "Contract Expired";
notifyContract.Visible = true;
notifyContract.BalloonTipTitle = "Contract Expired";
notifyContract.BalloonTipText = "Click Here to see details";
notifyContract.ShowBalloonTip(300000000);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("DO YOU WANT TO EDIT THIS DATA CONTRACT?", "EDIT CONTRACT DETAILS", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (tbUpdateContractNumber.Text == "" || tbUpdateContractName.Text == "" || rtbUpdateContractDescription.Text == "" || dtpUpdateContractStartDate.Text == "" || dtpUpdateContractEndDate.Text == "" || cbUpdateContractTime.SelectedIndex == -1 || tbUpdateContractStatus.Text == "" || tbUpdateContractInfo.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO EDIT DATA", "DATA UPDATE ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string ContractNumber = tbUpdateContractNumber.Text;
string ContractName = tbUpdateContractName.Text;
string ContractDescription = rtbUpdateContractDescription.Text;
string ContractStartDate = dtpUpdateContractStartDate.Text;
string ContractPeriod = lblStartDate.Text + " EXTENDED " + cbUpdateContractTime.Text;
string ContractEndDate = dtpUpdateContractEndDate.Text;
string ContractInfo = tbUpdateContractInfo.Text;
Admin A = new Admin();
A.EditContractDetails(ContractNumber, ContractName, ContractDescription, ContractPeriod, ContractStartDate, ContractEndDate, ContractInfo);
MessageBox.Show("CONTRACT DETAILS UPDATED", "CONTRACT UPDATED", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbUpdateContractNumber.Clear();
tbUpdateContractName.Clear();
rtbUpdateContractDescription.Clear();
tbUpdateContractStatus.Clear();
cbUpdateContractTime.Text = "-----SELECT TIME-----";
tbUpdateContractInfo.Clear();
dtpStartDate.Text = DateTime.Today.ToShortDateString();
dtpEndDate.Text = DateTime.Today.ToShortDateString();
dtpUpdateContractStartDate.Text = DateTime.Today.ToShortDateString();
dtpUpdateContractEndDate.Text = DateTime.Today.ToShortDateString();
RefreshDG();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FormLogin_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1)
{
MessageBox.Show("1. MASUKAN USERNAME DAN PASSWORD ANDA" +
"\n SESUAI DENGAN DATA DI DATABASE" +
"\n2. USERNAME MAKSIMAL 10 KARAKTER" +
"\n3. PASSWORD MAKSIMAL 10 KARAKTER" +
"\n4. FORM INI CASE-SENSITIVE" +
"\n5. JIKA ERROR TERJADI, HARAP LAPORKAN KE:" +
"\n [email protected] / 0811 940 90 65"
, "HELP", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
if (e.KeyCode == Keys.Enter)
{
try
{
string uname = tbUsername.Text.Trim();
string passwd = tbPassword.Text.Trim();
if (uname == "" || passwd == "")
{
MessageBox.Show("PLEASE INPUT USERNAME AND/OR PASSWORD", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Clear();
tbUsername.Focus();
}
else
{
Admin A = new Admin();
string[] values = A.Authentication(uname, passwd);
string dbUname = values[0];
string dbPsswd = values[1];
string dbLevel = values[2];
if (uname == dbUname && passwd == dbPsswd)
{
if (dbLevel == "Yes")
{
MessageBox.Show("WELCOME, " + uname + "", "WELCOME TO IHRIS", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormMainMenuMaster MMM = new FormMainMenuMaster(uname);
this.Hide();
MMM.Show();
}
else
{
MessageBox.Show("WELCOME, " + uname + "", "WELCOME TO IHRIS", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormUserMainMenu MM = new FormUserMainMenu(uname);
this.Hide();
MM.Show();
}
}
else
{
MessageBox.Show("INCORRECT USERNAME AND/OR PASSWORD", "INCORRECT LOGIN", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Clear();
tbUsername.Focus();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (e.KeyCode == Keys.Escape)
{
DialogResult dialogResult = MessageBox.Show("ARE YOU SURE WANT TO QUIT?", "QUIT", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
this.Close();
Application.Exit();
}
}
}
}
private void btnSavePosition_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("SAVE DATA? \nMAKE SURE ALL THE FORM FIELDS FILLED CORRECTLY", "DATA ENTRY", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (cbPositionDivision.Text == "-----SELECT DIVISION-----" || tbPositionName.Text == "" || tbPayrollBase.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO SAVE DATA", "DATA ENTRY ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbDivisionName.Focus();
}
else
{
string PositionName = tbPositionName.Text.Trim();
string DivisionID = cbPositionDivision.Text.Substring(0, 1).Trim(); ;
string PayrollBase = tbPayrollBase.Text.Trim();
Admin A = new Admin();
A.AddPosition(PositionName, PayrollBase, DivisionID);
tbPositionName.Clear();
cbPositionDivision.Text = "-----SELECT DIVISION-----";
tbPayrollBase.Clear();
MessageBox.Show("DATA SAVED", "ENTRY DATA SUCCESSFUL", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshDGV();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgAddPayroll_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string str = dgAddPayroll.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
Admin Bind = new Admin();
ArrayList data_payroll = Bind.BindAddPayrollDetails(str);
if (data_payroll.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_payroll.Count; i = i + 2)
{
string EmpNIP = (string)data_payroll[i];
string PayrollBase = (string)data_payroll[i + 1];
tbSaveEmpNIP.Text = EmpNIP;
tbSaveEmpPayrollBase.Text = PayrollBase;
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgSearchItem_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string str = dgSearchItem.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
Admin Bind = new Admin();
ArrayList data_contract = Bind.BindAllItemDetails(str);
if (data_contract.Count == 0)
{
MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
for (int i = 0; i < data_contract.Count; i = i + 5)
{
string ItemNumber = (string)data_contract[i];
string ItemName = (string)data_contract[i + 1];
string ItemDescription = (string)data_contract[i + 2];
string ItemCategory = (string)data_contract[i + 3];
Int64 ItemStock = (Int64)data_contract[i + 4];
tbSearchItemNumber.Text = ItemNumber;
tbSearchItemName.Text = ItemName;
tbSearchItemDescription.Text = ItemDescription;
tbSearchItemCategory.Text = ItemCategory;
tbSearchItemStock.Text = ItemStock.ToString();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("SAVE DATA? \nMAKE SURE ALL THE FORM FIELDS FILLED CORRECTLY", "DATA ENTRY", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (tbItemNumber.Text == "" || tbItemName.Text == "" || tbItemDescription.Text == "" || tbItemCategory.Text == "" || tbItemStock.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO SAVE DATA", "DATA ENTRY ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbItemName.Focus();
}
else
{
string ItemNumber = tbItemNumber.Text;
string ItemName = tbItemName.Text;
string ItemDescription = tbItemDescription.Text;
string ItemCategory = tbItemCategory.Text;
string ItemStock = tbItemStock.Text;
Admin Save = new Admin();
Save.AddInventory(ItemNumber, ItemName, ItemDescription, ItemCategory, ItemStock);
MessageBox.Show("DATA SAVED", "ENTRY DATA SUCCESSFUL", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbItemName.Clear();
tbItemDescription.Clear();
tbItemCategory.Clear();
tbItemStock.Value = 0;
RefreshDG();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("SAVE DATA? \nMAKE SURE ALL THE FORM FIELDS FILLED CORRECTLY", "DATA ENTRY", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (tbContractNumber.Text == "" || tbContractName.Text == "" || tbContractDescription.Text == "" || cbTime.SelectedIndex == -1 || tbContractInfo.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO SAVE DATA", "DATA ENTRY ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbContractNumber.Focus();
}
else
{
string ContractNumber = tbContractNumber.Text;
string ContractName = tbContractName.Text;
string ContractDescription = tbContractDescription.Text;
string ContractTimePeriod = cbTime.Text;
string ContractStartDate = dtpStartDate.Text;
string ContractEndDate = dtpEndDate.Text;
string ContractInfo = tbContractInfo.Text;
string EmployeeNIP = lblUser.Text;
Admin Save = new Admin();
Save.AddContract(ContractNumber, ContractName, ContractDescription, ContractTimePeriod, ContractStartDate, ContractEndDate, ContractInfo, EmployeeNIP);
MessageBox.Show("DATA SAVED", "ENTRY DATA SUCCESSFUL", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshDG();
tbContractNumber.Clear();
tbContractName.Clear();
tbContractDescription.Clear();
cbTime.Text = "-----SELECT TIME-----";
dtpStartDate.Text = DateTime.Today.ToShortDateString();
dtpEndDate.Text = DateTime.Today.ToShortDateString();
dtpUpdateContractStartDate.Text = DateTime.Today.ToShortDateString();
dtpUpdateContractEndDate.Text = DateTime.Today.ToShortDateString();
tbContractInfo.Clear();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("DO YOU WANT UPDATE STOCK?", "STOCK UPDATION", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (tbEditAddStock.Value == 0 || tbEditFinalStock.Text == "" || tbEditItemName.Text == "" || tbEditItemCategory.Text == "" || tbEditItemStock.Text == "" || tbEditItemDescription.Text == "" || tbEditItemNumber.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO EDIT DATA", "DATA UPDATE ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbEditAddStock.Focus();
}
else
{
string InventoryNumber = tbEditItemNumber.Text;
string InventoryName = tbEditItemName.Text;
string InventoryDescription = tbEditItemDescription.Text;
string InventoryCategory = tbEditItemCategory.Text;
string ItemStock = tbEditFinalStock.Text;
Admin Update = new Admin();
Update.UpdateStock(InventoryNumber, InventoryName, InventoryDescription, InventoryCategory, ItemStock);
MessageBox.Show("STOCK UPDATED", "ITEM STOCK UPDATED", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbEditAddStock.Value = 0;
tbEditItemNumber.Clear();
tbEditItemName.Clear();
tbEditItemDescription.Clear();
tbEditItemCategory.Clear();
tbEditFinalStock.Clear();
tbEditItemStock.Clear();
RefreshDG();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void InsertStatus()
{
//buat list baru yang akan dimasukkan status yang ada
List<string> status = StatusKerja();
for (int i = 0; i < status.Count; i++)
{
Admin A = new Admin();
A.UpdateStatusAttendance(status);
}
}
