public List <ts.Employee> GetList()
{
ts.TimesheetDBContext db = DBContext;
var lst = db.Employee.OrderBy(x => x.Name).ToList();
return(lst);
}
public void ImportTimesheetBulk(HttpPostedFileBase fb)
{
DataTable dt = GetDataTableFromSpreadsheet(fb.InputStream, false);
ts.TimesheetDBContext db = DBContext;
foreach (DataRow dr in dt.Rows)
{
int EmployeeNumber = int.Parse(dr[0].ToString());
int Month = int.Parse(dr[1].ToString());
float WorkingHours = float.Parse(dr[2].ToString());
if (db.Employee.Any(x => x.EmployeeNumber == EmployeeNumber))
{
var sheet = db.Timesheet.Where(x => x.EmployeeNumber == EmployeeNumber && x.Month == Month).FirstOrDefault();
if (sheet != null && sheet.EmployeeNumber > 0)
{
sheet.WorkingHours = WorkingHours;
}
else
{
db.Timesheet.Add(new ts.Timesheet()
{
EmployeeNumber = EmployeeNumber, Month = Month, WorkingHours = WorkingHours
});
}
}
}
db.SaveChanges();
}
public void AddTempTimesheet()
{
ts.TimesheetDBContext db = DBContext;
if (!db.Timesheet.Any(x => x.EmployeeNumber == 1 && x.Month == 1))
{
db.Timesheet.Add(new ts.Timesheet()
{
EmployeeNumber = 1, Month = 1, WorkingHours = 7
});
}
if (!db.Timesheet.Any(x => x.EmployeeNumber == 2 && x.Month == 1))
{
db.Timesheet.Add(new ts.Timesheet()
{
EmployeeNumber = 2, Month = 1, WorkingHours = 8
});
}
if (!db.Timesheet.Any(x => x.EmployeeNumber == 3 && x.Month == 1))
{
db.Timesheet.Add(new ts.Timesheet()
{
EmployeeNumber = 3, Month = 1, WorkingHours = 9
});
}
db.SaveChanges();
}
public void AddTempEmployees()
{
ts.TimesheetDBContext db = DBContext;
if (!db.Employee.Any(x => x.EmployeeNumber == 1))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 1, Name = "Ahmed Mohamed"
});
}
if (!db.Employee.Any(x => x.EmployeeNumber == 2))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 2, Name = "Mostafa Salah"
});
}
if (!db.Employee.Any(x => x.EmployeeNumber == 3))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 3, Name = "Samy Reda"
});
}
if (!db.Employee.Any(x => x.EmployeeNumber == 4))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 4, Name = "Said Fahmy"
});
}
if (!db.Employee.Any(x => x.EmployeeNumber == 5))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 5, Name = "Ramy Nagy"
});
}
if (!db.Employee.Any(x => x.EmployeeNumber == 6))
{
db.Employee.Add(new ts.Employee()
{
EmployeeNumber = 6, Name = "Hady Shawky"
});
}
db.SaveChanges();
}
public List <ts.TimesheetListItem> GetList()
{
ts.TimesheetDBContext db = DBContext;
List <ts.TimesheetListItem> data = new List <ts.TimesheetListItem>();
var lst = from t in db.Timesheet join e in db.Employee on t.EmployeeNumber equals e.EmployeeNumber
select new { t.EmployeeNumber, t.Month, t.WorkingHours, e.Name };
foreach (var item in lst)
{
data.Add(new ts.TimesheetListItem()
{
EmployeeNumber = item.EmployeeNumber,
Name = item.Name,
Month = item.Month,
WorkingHours = item.WorkingHours
});
}
return(data);
}
public void AddUpdate(AddTimesheetViewModel vm)
{
if (vm != null && vm.EmployeeNumber > 0 && vm.SelectedMonth > 0 && vm.WorkingHours > 0)
{
ts.TimesheetDBContext db = DBContext;
var ts = db.Timesheet.Where(x => x.EmployeeNumber == vm.EmployeeNumber && x.Month == vm.SelectedMonth).FirstOrDefault();
if (ts != null && ts.EmployeeNumber > 0)
{
ts.WorkingHours = vm.WorkingHours;
}
else
{
db.Timesheet.Add(new Data.Entities.Timesheet()
{
EmployeeNumber = vm.EmployeeNumber, Month = vm.SelectedMonth, WorkingHours = vm.WorkingHours
});
}
db.SaveChanges();
}
}