public static DataTable getAll()
{
var lst = DAL_HISTORY.GetAll();
var dt = new DataTable();
dt = BLL_ExtendList.ToDataTable(lst);
DataColumn STT = new DataColumn();
STT.ColumnName = "STT";
dt.Columns.Add(STT);
DataColumn NV = new DataColumn();
NV.ColumnName = "NV";
dt.Columns.Add(NV);
DataColumn NGAY = new DataColumn();
NGAY.ColumnName = "NGAY";
dt.Columns.Add(NGAY);
DataColumn TG = new DataColumn();
TG.ColumnName = "TG";
dt.Columns.Add(TG);
DataColumn STATUS = new DataColumn();
STATUS.ColumnName = "STATUS";
dt.Columns.Add(STATUS);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = i + 1;
//PERSONAL per = DAL_PERSON.getPerByID(int.Parse(dt.Rows[i]["ID_PER"].ToString()));
//if (per.TYPE_PS == 1)
{
dt.Rows[i]["NV"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_PER"].ToString()));
}
//else
//{
// dt.Rows[i]["NV"] = "Khách";
//}
DateTime time = (DateTime)dt.Rows[i]["TIME_UPDATE"];
dt.Rows[i]["NGAY"] = time.ToShortDateString();
dt.Rows[i]["TG"] = time.ToShortTimeString();
if (dt.Rows[i]["IN_OUT"] == "False")
{
dt.Rows[i]["STATUS"] = "Ra";
}
else
{
dt.Rows[i]["STATUS"] = "Ra";
}
}
dt.Columns.Remove("TIME_UPDATE");
dt.Columns.Remove("IN_OUT");
return(dt);
}
public static DataTable getAll()
{
try
{
var db = new DBEntities();
var lst = db.PERSONALs.ToList();
DataTable dt = BLL_ExtendList.ToDataTable(lst);
return(dt);
}
catch (Exception exx)
{
return(null);
}
}
public static DataTable SearchEmp(string key)
{
var lst = DAL_EMPLOYEE.SearchEmp(key);
var dt = new DataTable();
dt = BLL_ExtendList.ToDataTable(lst);
DataColumn STT = new DataColumn();
STT.ColumnName = "STT";
dt.Columns.Add(STT);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = i + 1;
}
dt.Columns.Remove("ATTENDANCEs");
dt.Columns.Remove("PERSONAL");
dt.Columns.Remove("ISDELETE");
return(dt);
}
public static DataTable filterPage(DateTime s, DateTime e, int num)
{
var lst = DAL_HISTORY.filterPage(s, e, num);
var dt = new DataTable();
dt = BLL_ExtendList.ToDataTable(lst);
DataColumn STT = new DataColumn();
STT.ColumnName = "STT";
dt.Columns.Add(STT);
DataColumn NV = new DataColumn();
NV.ColumnName = "NV";
dt.Columns.Add(NV);
DataColumn NGAY = new DataColumn();
NGAY.ColumnName = "NGAY";
dt.Columns.Add(NGAY);
DataColumn TG = new DataColumn();
TG.ColumnName = "TG";
dt.Columns.Add(TG);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = (num - 1) * 5 + i + 1;
//PERSONAL per = DAL_PERSON.getPerByID(int.Parse(dt.Rows[i]["ID_PER"].ToString()));
//if (per.TYPE_PS == 1)
{
dt.Rows[i]["NV"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_PER"].ToString()));
}
DateTime time = (DateTime)dt.Rows[i]["TIME_UPDATE"];
dt.Rows[i]["NGAY"] = time.ToShortDateString();
dt.Rows[i]["TG"] = time.ToShortTimeString();
}
dt.Columns.Remove("TIME_UPDATE");
dt.Columns.Remove("IN_OUT");
return(dt);
}
public static DataTable getHisMonth(int id, int month, int year)
{
//EMPLOYEE emp = DAL_EMPLOYEE.SearchEmpByName(name);
var lst = new List <ATTENDANCE>();
var dt = new DataTable();
//if (emp!=null)
//{
//int id = emp.ID;
lst = DAL_ATTENDANCE.getByMonthEmp(month, year, id);
if (lst.Count > 0)
{
dt = BLL_ExtendList.ToDataTable(lst);
DataColumn STT = new DataColumn();
STT.ColumnName = "STT";
dt.Columns.Add(STT);
DataColumn NAME = new DataColumn();
NAME.ColumnName = "NAME";
dt.Columns.Add(NAME);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = i + 1;
dt.Rows[i]["NAME"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_EMP"].ToString()));
var IN = (TimeSpan)dt.Rows[i]["TIME_IN"];
//string OUT = dt.Rows[i]["TIME_OUT"];
dt.Rows[i]["TIME_IN"] = IN.Hours + ":" + IN.Minutes + ":" + IN.Seconds;
try
{
var OUT = (TimeSpan)dt.Rows[i]["TIME_OUT"];
dt.Rows[i]["TIME_OUT"] = OUT.Hours + ":" + OUT.Minutes + ":" + OUT.Seconds;
}
catch (Exception ex) { }
//}
}
dt.Columns.Remove("EMPLOYEE");
}
return(dt);
}
public static DataTable getAll()
{
var lst = DAL_ATTENDANCE.getAll();
return(BLL_ExtendList.ToDataTable(lst));
}
