//------------------------------ < /region Buttons > ------------------------------
#endregion
#region DataGridView
//------------------------------ < region DataGridView > ------------------------------
private void dgvEmpDetails_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
DataGridViewRow row = dgvEmpDetails.Rows[e.RowIndex];
//the ? new .Value would assign null to the Text property of the textboxes in case the cell value is null
EmployeeId = row.Cells[0].Value?.ToString(); //The Employee ID is determined here (the variable EmployeeId will be assigned a new value that is in this dgv cell)
txtEmpName.Text = row.Cells[1].Value?.ToString();
txtEmpCity.Text = row.Cells[2].Value?.ToString();
txtEmpDept.Text = row.Cells[3].Value?.ToString();
cboEmpGender.Text = row.Cells[4].Value?.ToString();
txtEmpHealthInsuranceProvider.Text = row.Cells[5].Value?.ToString();
txtEmpInsurancePlanName.Text = row.Cells[6].Value?.ToString();
txtEmpInsuranceMonthlyFee.Text = Convert.ToDecimal(row.Cells[7].Value).ToString("#,##0.00");
//Displaying the date in dateTimePicker
var cellValue = dgvEmpDetails.Rows[e.RowIndex].Cells[8].Value;
if (cellValue == null || cellValue == DBNull.Value || string.IsNullOrWhiteSpace(cellValue.ToString()))
{
dtpInsuranceStartDate.Value = DateTime.Now;
}
else
{
dtpInsuranceStartDate.Value = DateTime.Parse(row.Cells[8].Value?.ToString());
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
//Display Employee Image
DisplayEmployee displayEmployee = new DisplayEmployee(ConnectionString.config);
displayEmployee.Image(EmployeeId, pictureBox1, lblFileExtension);
}
}
catch (InvalidCastException)
{
pictureBox1.Image = null;
}
catch (Exception ex)
{
MessageBox.Show($"Something is wrong with the selected record! \nError: { ex.GetType().FullName }");
}
}
private void btnSortEmployees_Click(object sender, EventArgs e)
{
if (btnSortEmployees.Text == "Employees Without Healh Insurance")
{
DisplayEmployee withoutHealthInsurance = new DisplayEmployee(ConnectionString.config);
withoutHealthInsurance.AllRecords("DisplayEmployeesWithoutHealthInsuranceRecords", dgvEmpDetails);
btnSortEmployees.Text = "Employees With Healh Insurance";
btnSortEmployees.Values.Image = Properties.Resources.emotion_happy_fill;
return;
}
DisplayEmployee withHealthInsurance = new DisplayEmployee(ConnectionString.config);
withHealthInsurance.AllRecords("DisplayEmployeesWithHealthInsuranceRecords", dgvEmpDetails);
btnSortEmployees.Text = "Employees Without Healh Insurance";
btnSortEmployees.Values.Image = Properties.Resources.emotion_unhappy_fill;
}
public List <DisplayEmployee> ShowEmployeeHours()
{
var hours = Db.GetTimeSheets();
var empHours = hours.Where(x => x.EmployeeId == Emp.EmployeeId)
.Where(x => x.ClockIn.Month == DateTimeOffset.Now.Month);
var dispEmps = new List <DisplayEmployee>();
foreach (var entry in empHours)
{
var temp = new DisplayEmployee
{
Name = entry.EmployeeName, ClockIn = entry.ClockIn.ToString("f"),
ClockOut = entry.ClockOut?.ToString("f"), Hours = entry.Hours
};
dispEmps.Add(temp);
}
return(dispEmps);
}
public List <DisplayEmployee> ShowHours(Store store)
{
var timesheets = Db.GetTimeSheets();
var hours = timesheets.Where(x => x.Employee.StoreId == store.StoreId);
var dispEmps = new List <DisplayEmployee>();
foreach (var entry in hours)
{
var temp = new DisplayEmployee
{
Name = entry.EmployeeName,
ClockIn = entry.ClockIn.ToString("f"),
ClockOut = entry.ClockOut?.ToString("f"),
Hours = entry.Hours
};
dispEmps.Add(temp);
}
return(dispEmps);
}
//------------------------------ </ region Form1 > ------------------------------
#endregion
#region Methods
//------------------------------ < region Methods > ------------------------------
private void RefreshData()
{
txtEmpHealthInsuranceProvider.Text = "";
txtEmpInsurancePlanName.Text = "";
txtEmpInsuranceMonthlyFee.Text = "0.00";
dtpInsuranceStartDate.Value = DateTime.Now;
btnSave.Text = "Save";
EmployeeId = "";
txtEmpName.Text = "";
txtEmpCity.Text = "";
txtEmpDept.Text = "";
cboEmpGender.SelectedIndex = -1;
cboEmpGender.Text = "";
btnDelete.Enabled = false;
pictureBox1.Image = null;
lblFileExtension.Text = "";
txtEmpName.Focus();
DisplayEmployee displayEmployee = new DisplayEmployee(ConnectionString.config);
displayEmployee.AllRecords("DisplayAllEmployees", dgvEmpDetails);
}
public List <DisplayEmployee> displayEmployeeList()
{
List <DisplayEmployee> empdisplay = new List <DisplayEmployee>();
try
{
conOpen.Open();
SqlCommand cmd = new SqlCommand("select Emp_EmployeeID,Emp_EmployeeName,Emp_UnitHeadID,Emp_ProjectID,Emp_IsHR,Emp_DOJ,Emp_gender,Emp_CTC,Emp_Designation,Emp_IsNew from E_Data_Employee ", conOpen);
var dr = cmd.ExecuteReader();
while (dr.Read())
{
DisplayEmployee de = new DisplayEmployee();
de.Emp_id = Convert.ToInt32(dr.GetInt32(0));
de.Emp_Name = dr.GetString(1);
if (dr.IsDBNull(2))
{
de.Emp_UnitHeadID = 0;
}
else
{
de.Emp_UnitHeadID = Convert.ToInt32(dr.GetInt32(2));
}
de.Emp_ProjectID = Convert.ToInt32(dr.GetInt32(3));
de.isHR = Convert.ToBoolean(dr.GetBoolean(4));
de.Emp_DOJ = Convert.ToDateTime(dr.GetDateTime(5));
if (dr.IsDBNull(6))
{
de.gender = null;
}
else
{
de.gender = Convert.ToString(dr.GetString(6));
}
de.Emp_CTC = Convert.ToInt64(dr.GetDecimal(7));
if (dr.IsDBNull(8))
{
de.designation = null;
}
else
{
de.designation = dr.GetString(8);
}
if (dr.IsDBNull(9))
{
de.isNew = Convert.ToBoolean(0);
}
else
{
de.isNew = Convert.ToBoolean(dr.GetBoolean(9));
}
empdisplay.Add(de);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(empdisplay);
}
private void Form1_Load(object sender, EventArgs e)
{
DisplayEmployee displayEmployee = new DisplayEmployee(ConnectionString.config);
displayEmployee.AllRecords("DisplayAllEmployees", dgvEmpDetails);
}
public JsonResult GetEmployeeDetails(int i, string j)
{
IDisplayEmployee ds = new DisplayEmployee();
return(Json(this._displayemployee.ShowEmployeeDetails(), JsonRequestBehavior.AllowGet));
}
