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