public bool Insert(TimesheetModel parameter) { bool result = false; try { TB_TIMESHEET data = new TB_TIMESHEET(); using (DB_TIMESHEETEntities db = new DB_TIMESHEETEntities()) { data.TIMESHEET_DATE = parameter.DATE_OF; data.EMPLOYEE_ID = parameter.EMPLOYEE_ID; data.JOBCODE_ID = parameter.JOB_CODE_ID; data.TICKET_ID = parameter.TICKET_ID; data.TIMESHEET_REMARK = parameter.DESCRIPTION; data.WORK_HOUR = decimal.Parse(parameter.WORK_HOUR); data.WORK_LOCATION = parameter.WORK_LOCATION; db.TB_TIMESHEET.Add(data); db.SaveChanges(); result = true; } } catch (Exception ex) { } return(result); }
public bool Delete(int timesheet_id) { bool result; try { using (DB_TIMESHEETEntities db = new DB_TIMESHEETEntities()) { TB_TIMESHEET data = db.TB_TIMESHEET.FirstOrDefault(i => i.TIMESHEET_ID.Equals(timesheet_id)); db.TB_TIMESHEET.Remove(data); db.SaveChanges(); result = true; } } catch (Exception ex) { result = false; } return(result); }