public static bool EditWorkShiftRecord(WorkShiftRecord wsRecord)
{
if (wsRecord != null)
{
using (DBEntities db = new DBEntities())
{
db.WorkShiftRecords.Attach(wsRecord);
db.Entry(wsRecord).Property(x => x.WorkDate).IsModified = true;
db.SaveChanges();
}
return(true);
}
return(false);
}
public static bool DeleteWorkShiftRecord(WorkShiftRecord wsRecord)
{
if (wsRecord != null)
{
using (DBEntities db = new DBEntities())
{
WorkShiftRecord record = db.WorkShiftRecords.SingleOrDefault(x => x.WorkShiftRecordId == wsRecord.WorkShiftRecordId);
db.WorkShiftRecords.Remove(record);
db.SaveChanges();
}
return(true);
}
return(false);
}
public static WorkShiftRecord GetWorkShiftRecordById(int wsrID)
{
DBEntities db = new DBEntities();
WorkShiftRecord wsRecord = db.WorkShiftRecords.SingleOrDefault(record => record.WorkShiftRecordId == wsrID);
//var query = from member in db.Members
// where member.UserName == un
// select member;
//Member m = query.SingleOrDefault();
return(wsRecord);
}
