public void LoadDt(object sender, RoutedEventArgs e)
{
SelectFrmDb slct = new SelectFrmDb();
datatable.DataContext = null;
datatable.DataContext = slct.AttendenceRecords();
}
private static IEnumerable <EmpListForCreateCard> GetAvailableEmps()
{
SelectFrmDb sfd = new SelectFrmDb();
DataTable dt = sfd.FindEmpWithNoCard();
List <EmpListForCreateCard> emp_list = new List <EmpListForCreateCard>();
foreach (DataRow row in dt.Rows)
{
string full_name = row["first_name"].ToString().Trim() + " " + row["last_name"].ToString().Trim();
emp_list.Add(new EmpListForCreateCard((int)row["id"], full_name));
}
return(emp_list);
}
public static ObservableCollection <Attendence> AttendenceData()
{
SelectFrmDb sfd = new SelectFrmDb();
DataTable dt = sfd.AttendenceRecords();
attendences = new ObservableCollection <Attendence>();
int sn = 1;
foreach (DataRow row in dt.Rows)
{
string full_name = row["first_name"].ToString().Trim() + " " + row["last_name"].ToString().Trim();
attendences.Add(new Attendence(sn, full_name, (DateTime)row["attnd_date"]));
sn++;
}
return(attendences);
}
void BlockCard(object sender, RoutedEventArgs e)
{
Employee obj = ((FrameworkElement)sender).DataContext as Employee;
if (obj.Status != "card blocked")
{
SelectFrmDb sdb = new SelectFrmDb();
CardAccess ca = new CardAccess();
if (sdb.BlockCard(obj.Id))
{
MessageBox.Show("Card Blocked");
}
}
else
{
MessageBox.Show("Card Already Blocked");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(FirstName.Text) || string.IsNullOrWhiteSpace(LastName.Text) || string.IsNullOrWhiteSpace(DateBirth.Text) || string.IsNullOrWhiteSpace(Address.Text))
{
MessageBox.Show("Fill up All Fields");
}
else
{
SelectFrmDb sdb = new SelectFrmDb();
int add_emp = sdb.AddEmp(FirstName.Text, LastName.Text, DateBirth.Text, Address.Text);
if (add_emp == 1)
{
FirstName.Text = "";
LastName.Text = "";
DateBirth.Text = "";
Address.Text = "";
MessageBox.Show("Add Success!!!");
}
}
}
public static ObservableCollection <Employee> EmployeeData()
{
SelectFrmDb sfd = new SelectFrmDb();
DataTable dt = sfd.EmpRecords();
employees = new ObservableCollection <Employee>();
int sn = 1;
foreach (DataRow row in dt.Rows)
{
string full_name = row["first_name"].ToString().Trim() + " " + row["last_name"].ToString().Trim();
string status = "";
if ((int)row["card_status"] == 0)
{
status = "no card";
}
else if ((int)row["card_status"] == 1)
{
status = "has card";
}
else if ((int)row["card_status"] == 2)
{
status = "card blocked";
}
else if ((int)row["card_status"] == 3)
{
status = "card expired";
}
else
{
status = "";
}
employees.Add(new Employee((int)row["id"], sn, full_name, (DateTime)row["date_of_birth"], (string)row["address"], status));
sn++;
}
return(employees);
}
