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);
}
