public static TimeSheetMaster CreateTimeSheetMasterTemplate(DateTime forCalendarMonth, Staff staff)
{
TimeSheetMaster master = new TimeSheetMaster();
master.PersonId = staff.PersonId;
master.Person = staff;
master.Company = staff.Supervisor.Company;
master.Supervisor = staff.Supervisor;
master.AgencyId = staff.AgentId;
master.Month = forCalendarMonth.Month;
master.Year = forCalendarMonth.Year;
List <TimeSheetDetail> listDetails = new List <TimeSheetDetail>();
for (int i = 1; i <= DateTime.DaysInMonth(forCalendarMonth.Year, forCalendarMonth.Month); i++)
{
TimeSheetDetail detail = new TimeSheetDetail();
detail.StartTime = new DateTime(forCalendarMonth.Year, forCalendarMonth.Month, i);
detail.EndTime = new DateTime(forCalendarMonth.Year, forCalendarMonth.Month, i);
listDetails.Add(detail);
}
master.TimeSheetDetail = listDetails;
return(master);
}
//
// GET: /TimeSheet/Delete/5
public ActionResult Delete(int id = 0)
{
TimeSheetDetail detail = TimesheetRepository.GetTimeSheetDetailById(id);
if (detail == null)
{
return(HttpNotFound());
}
return(View(detail));
}
public async Task <IActionResult> Update([FromBody] TimeSheetDetail timeSheetDetail)
{
try
{
_context.Entry(timeSheetDetail).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(Ok(timeSheetDetail));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public async Task <IActionResult> Create([FromBody] TimeSheetDetail timeSheetDetail)
{
try
{
_context.TimeSheetDetails.Add(timeSheetDetail);
_context.SaveChanges();
return(Ok(timeSheetDetail));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public bool InsertTimeSheetDetail(int TimeSheetID, int Bonus, int Penalty, string Currency, string Desc)
{
try
{
TimeSheetDetail tsDetail = new TimeSheetDetail();
tsDetail.TimeSheetID = TimeSheetID;
tsDetail.Bonus = Bonus;
tsDetail.Penalty = Penalty;
tsDetail.Desc = Desc;
tsDetail.Currency = Currency;
context.TimeSheetDetails.InsertOnSubmit(tsDetail);
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error Insert TimeSheetDetail: " + e.Message);
}
}
public ActionResult DeleteConfirmed(int id)
{
TimeSheetDetail.Delete(id);
return(RedirectToAction("Index"));
}
public IActionResult CreateTimeSheetDetail(IFormCollection inFormData)
{
string customMessage = "";
object result = null;
string email = _userManager.GetUserName(User);
int userInfoId = Database.UserInfo.Single(input => input.Email == email).UserInfoId;
string fullname = Database.UserInfo.Single(input => input.Email == email).FullName;
//int userInfold = Database.UserInfo.Single(input => input.LoginUserName == userLoginName).UserInfoId;
//string userLoginName = Database.UserInfo.Where(input => input.LoginUserName == userLoginName);
// DateTime lessonDate = "";
//DateTime date = DateTime.ParseExact(inFormData["dateOfLesson"], ");
// Declare a DateTime Variable and get the informData's dateOfLesson into it
string time = inFormData["officialTimeIn"];
//string lessonDate = inFormData["dateOfLesson"];
DateTime LessonDate = DateTime.ParseExact(inFormData["dateOfLesson"], "d/M/yyyy", CultureInfo.InvariantCulture);
// Concate the 1 with the month and year in date of lesson
string GetMonthAndYear = string.Format("1/{0}/{1}", LessonDate.Month, LessonDate.Year);
//
DateTime MonthYear = DateTime.ParseExact(GetMonthAndYear, "d/M/yyyy", CultureInfo.InvariantCulture);
int timeSheetId = Database.TimeSheets.Single(input => input.CreatedById == userInfoId && input.MonthAndYear == MonthYear).TimeSheetId;
TimeSheetDetail oneNewTimeSheetDetail = new TimeSheetDetail();
var accountNameSelected = inFormData["accountName"];
var currentDateTime = DateTime.Now;
var ar = Database.AccountRates
.Where(input => input.EffectiveStartDate <= currentDateTime)
.ToList();
//var ratePerHourFromAccountName = Database.AccountRates
// .Include(input => input.CustomerAccount)
// .Where(input => input.CustomerAccount.AccountName == accountNameSelected)
// && ();
//var rateWithAccountName = Database.CustomerAccounts
// .Include(input=>input.AccountRates)
// .Where(input=>input.AccountName==accountNameSelected)
var ss = inFormData["sessionSynopsisNames"];
var test = "";
try
{
oneNewTimeSheetDetail.TimeSheetId = timeSheetId;//oneNewTimeSheetDetail .TimeSheet.TimeSheetId
//oneNewTimeSheetDetail.TimeSheetId = 12;
oneNewTimeSheetDetail.AccountName = inFormData["accountName"];
oneNewTimeSheetDetail.OfficialTimeInMinutes = ConvertHHMMToMinutes(inFormData["officialTimeIn"]);
oneNewTimeSheetDetail.OfficialTimeOutMinutes = ConvertHHMMToMinutes(inFormData["officialTimeOut"]);
oneNewTimeSheetDetail.WageRatePerHour = 0;
//Decimal.Parse(inFormData["wageRate"]);
oneNewTimeSheetDetail.RatePerHour = 0;
//Decimal.Parse(inFormData["ratePerHour"]);
oneNewTimeSheetDetail.DateOfLesson = DateTime.ParseExact(inFormData["dateOfLesson"], "d/M/yyyy", CultureInfo.InvariantCulture);
//oneNewTimeSheetDetail.TimeInInMinutes = ConvertHHMMToMinutes(inFormData["timeIn"]);
//oneNewTimeSheetDetail.TimeOutInMinutes = ConvertHHMMToMinutes(inFormData["timeOut"]);
//oneNewTimeSheetDetail.Comments = inFormData["comments"];
oneNewTimeSheetDetail.SessionSynopsisNames = inFormData["sessionSynopsisNames"];
oneNewTimeSheetDetail.IsReplacementInstructor = bool.Parse(inFormData["isReplacementInstructor"]);
test = ss;
//oneNewTimeSheetDetail.CreatedAt = DateTime.Now;
//oneNewTimeSheetDetail.UpdatedAt = DateTime.Now;
oneNewTimeSheetDetail.CreatedByName = fullname;
oneNewTimeSheetDetail.UpdatedByName = fullname;
Database.TimeSheetDetails.Add(oneNewTimeSheetDetail);
Database.SaveChanges();
}
catch (Exception ex)
{
//String innerMessage = (ex.InnerException != null)
// ? ex.InnerException.Message
// : "";
if (ex.InnerException.Message != null)
{
String innerMessage = ex.InnerException.Message;
object httpFailRequestResultMessage = new { message = innerMessage };
//Return a bad http request message to the client
return(BadRequest(httpFailRequestResultMessage));
//customMessage += "Unable to save Timesheet detail Record.";
//object httpFailRequestResultMessage = new { message = customMessage};
////Return a bad http request message to the client
//return BadRequest(httpFailRequestResultMessage);
}
}
//Message member variable (property)
var successRequestResultMessage = new
{
message = "Saved timesheet detail record"
};
OkObjectResult httpOkResult =
new OkObjectResult(successRequestResultMessage);
return(httpOkResult);
}
public static IEnumerable <TimeSheetDetail> GetAllTimeSheetDetails()
{
return(TimeSheetDetail.GetAll());
}
//----------------------------------------------------------------------------------
public static TimeSheetDetail GetTimeSheetDetailById(int TimeSheetDetailId)
{
return(TimeSheetDetail.GetById(TimeSheetDetailId));
}