public void deleteTimeTrack(int timeTrackRowId) { pdsTidRedLiveEntities db = new pdsTidRedLiveEntities(); timeTrackRow tr = db.timeTrackRow.FirstOrDefault(x => x.timeTrackRowID == timeTrackRowId); int timeTrackHeadId = tr.timeTrackHeadID; db.timeTrackRow.Remove(tr); db.SaveChanges(); int cnt = db.timeTrackRow.Where(x => x.timeTrackHeadID == timeTrackHeadId).Count(); if (cnt == 0) { timeTrackHead th = db.timeTrackHead.FirstOrDefault(x => x.timeTrackHeadID == timeTrackHeadId); db.timeTrackHead.Remove(th); db.SaveChanges(); } }
public void addTimeTrack(CTimeTrack tt, int userId) { pdsTidRedLiveEntities db = new pdsTidRedLiveEntities(); int timeTrackHeadId = addTimeTrackHead(tt, userId); int ttRowId = db.timeTrackRow.Max(x => x.timeTrackRowID); ttRowId++; timeTrackRow ttr = new timeTrackRow(); ttr.timeTrackRowID = ttRowId; ttr.hours = tt.hours; ttr.note = tt.note; ttr.regDate = System.DateTime.Now; ttr.subProjectID = tt.subProjectID; ttr.timeTrackHeadID = timeTrackHeadId; db.timeTrackRow.Add(ttr); db.SaveChanges(); }
public void editTimeTrack(CTimeTrack tt, int userId) { int timeTrackHeadId = addTimeTrackHead(tt, userId); pdsTidRedLiveEntities db = new pdsTidRedLiveEntities(); timeTrackRow ttr = db.timeTrackRow.FirstOrDefault(x => x.timeTrackRowID == tt.timeTrackRowID); if (ttr != null) { ttr.hours = tt.hours; ttr.note = tt.note; ttr.subProjectID = tt.subProjectID; int deleteTTH = 0; if (ttr.timeTrackHeadID != timeTrackHeadId) { deleteTTH = ttr.timeTrackHeadID; ttr.timeTrackHeadID = timeTrackHeadId; } db.SaveChanges(); if (deleteTTH != 0) { deleteTimeTrackHead(deleteTTH); } } }