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