public ActionResult Timecard(string id)
{
using (var db = new TimeClockContext())
{
int lineNumberCounter = 1;
List <TimeCardView> timecard = new List <TimeCardView>();
PayPeriod payPeriod = PayPeriodTools.LookupPayPeriod(db, 1);
var empTC = db.Timecards.SingleOrDefault(t => t.EmployeeID == id && t.PayPeriod == payPeriod.Start);
var lines = db.Lines.Where(l => l.TimecardID == empTC.TimecardID);
lines.OrderBy(l => l.SplitStart);
foreach (Line line in lines)
{
int last = timecard.Count - 1;
if (last > 0 && timecard[last].PunchID == line.PunchID)
{
timecard[last].Out = line.SplitEnd;
if (line.PayType.Description == "Overtime")
{
timecard[last].Overtime = line.SplitEnd.Subtract(line.SplitStart).TotalHours;
}
else if (line.PayType.Description == "Regular")
{
timecard[last].Regular = line.SplitEnd.Subtract(line.SplitStart).TotalHours;
}
else
{
;
}
timecard[last].updateEntry();
}
// Otherwise we create a new line and add it to the timecard.
else
{
TimeCardView temp = new TimeCardView(lineNumberCounter, line.SplitStart.Date, line.SplitStart, line.SplitEnd, line.PunchID);
if (line.PayType.Description == "Regular")
{
temp.Regular = line.SplitStart.Subtract(line.SplitEnd).TotalHours;
}
else if (line.PayType.Description == "Overtime")
{
temp.Overtime = line.SplitStart.Subtract(line.SplitEnd).TotalHours;
}
else
{
;// What should we do if it is neither of the two?
}
timecard.Add(temp);
}
}
return(PartialView(timecard));
}
}
//Should return identical to time card lines
public HttpResponseMessage <IEnumerable <TimeCardView> > GetTimeCardDetails(string empId, int tcId)
{
//List<TimeCardView>() {}
using (var db = new TimeClockContext())
{
Timecard curTimeCard = db.Timecards.SingleOrDefault(tc => tc.TimecardID == tcId);
var timeCardData = db.Lines.Where(l => l.TimecardID == curTimeCard.TimecardID).OrderBy(l => l.SplitStart).ToList();
var lines = TimeCardView.LinesToTimeCardView(timeCardData);
return(new HttpResponseMessage <IEnumerable <TimeCardView> >(lines));
}
}
//Should return identical to time card lines
public HttpResponseMessage <PunchResponse> GetTimeCardDetails(string empId, int tcId = -1)
{
if (tcId == -1)
{
var emp = db.Employees.SingleOrDefault(e => e.EmployeeID == empId);
var payPeriod = PayPeriodTools.LookupPayPeriod(db, emp.DepartmentID);
var tcLookup = emp.Timecards.SingleOrDefault(tc => tc.PayPeriod == payPeriod.Start);
tcId = tcLookup.TimecardID;
}
Timecard curTimeCard = db.Timecards.SingleOrDefault(tc => tc.TimecardID == tcId);
var timeCardData = db.Lines.Where(l => l.TimecardID == curTimeCard.TimecardID).OrderBy(l => l.SplitStart).ToList();
var lines = TimeCardView.LinesToTimeCardView(timeCardData);
PunchResponse ret = new PunchResponse()
{
lines = lines
};
return(new HttpResponseMessage <PunchResponse>(ret));
}
public IEnumerable <TimeCardView> getTimeCardLines(TimeClockContext db, PayPeriod payPeriod)
{
int lineNumberCounter = 1;
List <TimeCardView> timecard = new List <TimeCardView>();
var empTC = db.Timecards.SingleOrDefault(t => t.EmployeeID == this.EmployeeID && t.PayPeriod == payPeriod.Start);
//Need to bail out if we don't have time cards
if (empTC == null)
{
return(timecard);
}
var lines = db.Lines.Where(l => l.TimecardID == empTC.TimecardID);
//Need to bail out if we don't have time card lines
if (lines == null)
{
return(timecard);
}
lines.OrderBy(l => l.SplitStart);
foreach (Line line in lines)
{
int last = timecard.Count - 1;
if (last > 0 && timecard[last].PunchID == line.PunchID)
{
timecard[last].Out = line.SplitEnd;
if (line.PayType.Description == "Overtime")
{
timecard[last].Overtime = line.SplitEnd.Subtract(line.SplitStart).TotalHours;
}
else if (line.PayType.Description == "Regular")
{
timecard[last].Regular = line.SplitEnd.Subtract(line.SplitStart).TotalHours;
}
//else ;
timecard[last].updateEntry();
}
// Otherwise we create a new line and add it to the timecard.
else
{
TimeCardView temp = new TimeCardView(lineNumberCounter, line.SplitStart.Date, line.SplitStart, line.SplitEnd, line.PunchID);
if (line.PayType.Description == "Regular")
{
temp.Regular = line.SplitStart.Subtract(line.SplitEnd).TotalHours;
}
else if (line.PayType.Description == "Overtime")
{
temp.Overtime = line.SplitStart.Subtract(line.SplitEnd).TotalHours;
}
//else ;// What should we do if it is neither of the two?
timecard.Add(temp);
}
}
return(timecard);
}
public HttpResponseMessage <PunchResponse> Punch(PunchRequest request)
{
Employee emp = db.Employees.FirstOrDefault(e => e.EmployeeID.Equals(request.ID));
if (!emp.Pin.Equals(request.pin)) // the pin didn't match don't do anything
{
PunchResponse response = new PunchResponse()
{
isSuccess = false,
pinError = "Pin and user did not match.",
lines = null,
generalError = null
};
return(new HttpResponseMessage <PunchResponse>(response));
}
else
{
var payPeriod = PayPeriodTools.LookupPayPeriod(db, emp.DepartmentID);
var curTimeCard = emp.Timecards.SingleOrDefault(tc => tc.PayPeriod == payPeriod.Start);
PunchResponse retVal = new PunchResponse()
{
isSuccess = true,
pinError = "",
generalError = null
};
if (request.closesPunch == -1) // Create a new punch in the DB
{
Punch temp = new Punch()
{
EmployeeID = emp.EmployeeID,
InTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, 0),
OutTime = null,
DepartmentID = emp.DepartmentID,
PunchTypeID = Constants.DEFAULT_PUNCH_TYPE // Make this equal to the Regular punch type.
};
db.Punches.Add(temp);
db.SaveChanges();
var timeCardData = TimeCardView.LinesToTimeCardView(db.Lines.Where(l => l.TimecardID == curTimeCard.TimecardID).OrderBy(l => l.SplitStart));
// We add the last line to just display the information, letting the user know that we register the punch in
timeCardData.Add(new TimeCardView()
{
DateText = DateTime.Now.ToString(@"MM\/dd\/yy"),
InText = temp.InTime.ToString(@"hh\:mm"),
OutText = "",
RegularText = "",
OvertimeText = "",
DoubletimeText = ""
});
retVal.lines = timeCardData;
}
else // We need to close the last punch and make lines -- Make it split the lines over the payperiod seed
{
// Set the ending time of the punch
Punch currentPunch = db.Punches.First(p => p.PunchID == request.closesPunch);
currentPunch.OutTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, 0);
var timeCardData = db.Lines.Where(l => l.TimecardID == curTimeCard.TimecardID).OrderBy(l => l.SplitStart).ToList();
retVal.lines = TimeCardView.LinesToTimeCardView(timeCardData);
if (currentPunch.OutTime.Value.Subtract(currentPunch.InTime).TotalMinutes < 1) // punch was shorter than a minut.
{
db.Punches.Remove(currentPunch);
retVal.lines.Add(new TimeCardView() // Make the last line show, but mark is as rapid since it won't get put in the DB
{
DateText = currentPunch.InTime.ToString(@"MM\/dd\/yy"),
InText = currentPunch.InTime.ToString(@"hh\:mm"),
OutText = currentPunch.OutTime.Value.ToString(@"hh\:mm"),
RegularText = "00:00",
OvertimeText = "00:00",
DoubletimeText = "00:00",
isRapid = true
});
}
else // Punch was longer than a minut, we add it to the DB.
{
Calculations.addLines(db, currentPunch);
}
db.SaveChanges();
}
return(new HttpResponseMessage <PunchResponse>(retVal));
}
}
public HttpResponseMessage <PunchResponse> Punch(PunchRequest request)
{
using (var db = new TimeClockContext())
{
/****************************************************************************** TODO ITEM *********************************/
//This is where we need to insert the new punch for the employee
//If it is an out punch, we should recalculate their timecard lines.
Employee emp = db.Employees.FirstOrDefault(e => e.EmployeeID.Equals(request.ID));
if (!emp.Pin.Equals(request.pin))
{
PunchResponse response = new PunchResponse()
{
isSuccess = false,
pinError = "Pin and user did not match.",
lines = null,
generalError = null
};
return(new HttpResponseMessage <PunchResponse>(response));
}
else
{
var payPeriod = PayPeriodTools.LookupPayPeriod(db, emp.DepartmentID);
var curTimeCard = emp.Timecards.SingleOrDefault(tc => tc.PayPeriod == payPeriod.Start);
PunchResponse retVal = new PunchResponse()
{
isSuccess = true,
pinError = "",
generalError = null
};
if (request.closesPunch == -1) // Create a new punch in the DB
{
Punch temp = new Punch()
{
EmployeeID = emp.EmployeeID,
InTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, 0),
OutTime = null,
DepartmentID = emp.DepartmentID,
PunchTypeID = Constants.DEFAULT_PUNCH_TYPE // Make this equal to the Regular punch type.
//OutTime = null;
};
db.Punches.Add(temp);
db.SaveChanges();
var timeCardData = new List <TimeCardView>();
timeCardData.Add(new TimeCardView()
{
DateText = DateTime.Now.ToString(@"MM\/dd\/yy"),
InText = temp.InTime.ToString(@"hh\:mm"),
OutText = "",
RegularText = "",
OvertimeText = "",
DoubletimeText = ""
});
retVal.lines = timeCardData;
}
else // We need to close the last punch and make lines -- Make it split the lines over the payperiod seed
{
// Set the ending time of the punch
Punch currentPunch = db.Punches.First(p => p.PunchID == request.closesPunch);
currentPunch.OutTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, 0);
if (currentPunch.OutTime.Value.Subtract(currentPunch.InTime).TotalMinutes < 1)
{
db.Punches.Remove(currentPunch);
}
db.SaveChanges();
Calculations.addLines(db, currentPunch);
var timeCardData = db.Lines.Where(l => l.TimecardID == curTimeCard.TimecardID).OrderBy(l => l.SplitStart).ToList();
retVal.lines = TimeCardView.LinesToTimeCardView(timeCardData);
}
/*
* PunchResponse retVal = new PunchResponse()
* {
* isSuccess = true,
* pinError = "",
* lines = TimeCardView.LinesToTimeCardView(timeCardData),
* generalError = null
* };
*/
return(new HttpResponseMessage <PunchResponse>(retVal));
}
}
}
