public IActionResult Save(AddTimeSheet items, [FromQuery] string save) { //Module items = itemsData.Data; //var itemsObject = await request.Content.; //AddTimeSheet items = JsonConvert.DeserializeObject<AddTimeSheet>(request); try { Timesheetv2 timeSheet = new Timesheetv2(); var existingEmployeee = db.Timesheetv2.FirstOrDefault(item => items.empId == item.EmpId); if (existingEmployeee == null) { timeSheet.EmpId = items.empId; timeSheet.EmpName = items.empName; db.Add(timeSheet); db.SaveChanges(); } foreach (TimeSheetData value in items.Data) { Timesheetitemv2 timeSheetItem = new Timesheetitemv2(); Timesheetentryv2 timeSheetEntry = new Timesheetentryv2(); timeSheetItem.Hours = value.hours; timeSheetItem.EmpId = items.empId; timeSheetItem.Status = save; timeSheetItem.Submittedto = value.submittedto; timeSheetItem.ToDate = items.toDate; timeSheetItem.FromDate = items.fromDate; timeSheetItem.Date = value.date; db.Add(timeSheetItem); db.SaveChanges(); int index = timeSheetItem.TimestampId; timeSheetEntry.Customer = value.customer; timeSheetEntry.Company = value.company; timeSheetEntry.Task = value.task; timeSheetEntry.Project = value.project; timeSheetEntry.Timestampid = index; db.Add(timeSheetEntry); db.SaveChanges(); } return(Ok(new { value = 200 })); } catch (Exception e) { Console.Write(e); var s = e; return(BadRequest(new { error = e })); } }
public IActionResult save([FromBody] AddTimeSheet items) { try { TimeSheet timeSheet = new TimeSheet(); var existingEmployeee = db.TimeSheet.FirstOrDefault(item => items.Empid == item.Empid); if (existingEmployeee == null) { timeSheet.Empid = items.Empid; timeSheet.Empname = items.Empname; db.Add(timeSheet); db.SaveChanges(); } foreach (TimeSheetData value in items.data) { TimeSheetItem timeSheetItem = new TimeSheetItem(); TimeSheetEntry timeSheetEntry = new TimeSheetEntry(); timeSheetItem.Hours = value.Hours; timeSheetItem.Empid = items.Empid; timeSheetItem.Status = "Drafted"; timeSheetItem.Submittedto = value.Submittedto; timeSheetItem.To = items.To; timeSheetItem.From = items.From; timeSheetItem.Date = value.Date; db.Add(timeSheetItem); db.SaveChanges(); int index = timeSheetItem.Timestampid; timeSheetEntry.Customer = value.Customer; timeSheetEntry.Company = value.Company; timeSheetEntry.Task = value.Task; timeSheetEntry.Project = value.Project; timeSheetEntry.Timestampid = index; db.Add(timeSheetEntry); db.SaveChanges(); } } catch (Exception e) { Console.Write(e); } return(Ok()); }