public ObservableTimesheet(Timesheet timesheet) : this() { _isTrackingEnabled = false; OriginalTitle = timesheet.Title; OriginalTimesheetId = timesheet.TimesheetId; OriginalProjectTimeItems = new ObservableCollection <ObservableProjectTaskTimesheetItem>(timesheet.ProjectTimeItems.Select(x => new ObservableProjectTaskTimesheetItem(x)).ToList()); OriginalNonProjectActivityItems = new ObservableCollection <ObservableProjectTaskTimesheetItem>(timesheet.NonProjectActivityItems.Select(x => new ObservableProjectTaskTimesheetItem(x)).ToList()); OriginalRequiredHours = new ObservableCollection <TimeSpan>(timesheet.RequiredHours); OriginalTotalRequiredHours = timesheet.TotalRequiredHours; OriginalTotals = new ObservableCollection <ObservableHoursSummary>(timesheet.Totals.Select(x => new ObservableHoursSummary(x)).ToList()); // Set the properties to the Original property values ResetProperties(); ProjectTimeItems.CollectionChanged += ProjectTimeItems_CollectionChanged; NonProjectActivityItems.CollectionChanged += NonProjectActivityItems_CollectionChanged; RequiredHours.CollectionChanged += RequiredHours_CollectionChanged; Totals.CollectionChanged += Totals_CollectionChanged; ResetChangeTracking(); _isTrackingEnabled = true; Initialize(); }
public Model.Timesheet SelectQuery(String _Where) { try { SqlCommand cmd = new SqlCommand("Select * From [FAMIS].[dbo].[Timesheet] " + _Where, db.Db()); SqlDataReader dr = cmd.ExecuteReader(); Model.Timesheet UApp; UApp = new Model.Timesheet(); while (dr.Read()) { UApp = new Model.Timesheet(); if (!dr.IsDBNull(0)) { UApp.Timesheet_id = dr.GetInt32(0); } if (!dr.IsDBNull(1)) { UApp.Client_id = dr.GetInt32(1); } if (!dr.IsDBNull(2)) { UApp.Project_id = dr.GetInt32(2); } if (!dr.IsDBNull(3)) { UApp.User_id = dr.GetInt32(3); } if (!dr.IsDBNull(4)) { UApp.StartTime = dr.GetDateTime(4); } if (!dr.IsDBNull(5)) { UApp.EndTime = dr.GetDateTime(5); } if (!dr.IsDBNull(6)) { UApp.FullTime = dr.GetDateTime(6); } if (!dr.IsDBNull(7)) { UApp.JobTime = dr.GetDateTime(7); } if (!dr.IsDBNull(8)) { UApp.Coment = dr.GetString(8); } } return UApp; } catch (Exception ex) { throw new Exception(ex.Message); } }
public List<Model.Timesheet> Select(String pWhere) { List<Model.Timesheet> lstTimesheet = new List<Model.Timesheet>(); Model.Timesheet UApp; SqlCommand cmd = new SqlCommand("Select * From dbo.[Timesheet] " + pWhere, db.Db()); //SQLHelper.ExecuteReader("string de conexao", CommandType.StoredProcedure, "Procedure", null) using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { UApp = new Model.Timesheet(); if (!dr.IsDBNull(0)) { UApp.Timesheet_id = dr.GetInt32(0); } if (!dr.IsDBNull(1)) { UApp.Client_id = dr.GetInt32(1); } if (!dr.IsDBNull(2)) { UApp.Project_id = dr.GetInt32(2); } if (!dr.IsDBNull(3)) { UApp.User_id = dr.GetInt32(3); } if (!dr.IsDBNull(4)) { UApp.StartTime = dr.GetDateTime(4); } if (!dr.IsDBNull(5)) { UApp.EndTime = dr.GetDateTime(5); } if (!dr.IsDBNull(6)) { UApp.FullTime = dr.GetDateTime(6); } if (!dr.IsDBNull(7)) { UApp.JobTime = dr.GetDateTime(7); } if (!dr.IsDBNull(8)) { UApp.Coment = dr.GetString(8); } lstTimesheet.Add(UApp); } } return lstTimesheet; }