public void MoveToTimesheet(Int32 ExpenseEntryID, Int32 NewBillingPeriodAccountID, Int32 OldTimesheetID)
{
TimesheetController timesheetcontroller = new TimesheetController();
Timesheet oldtimesheet = timesheetcontroller.FetchByID(OldTimesheetID)[0];
String username = oldtimesheet.Username;
if (!timesheetcontroller.TimesheetExists(username, NewBillingPeriodAccountID))
{
timesheetcontroller.Insert(username, NewBillingPeriodAccountID, oldtimesheet.Rategroupid);
}
TimesheetCollection col = new BillingPeriodAccountController().FetchByID(NewBillingPeriodAccountID)[0].Timesheets();
foreach (Timesheet timesheet in col)
{
if (timesheet.Username.Equals(username))
{
ExpenseEntry item = this.FetchByID(ExpenseEntryID)[0];
this.Update(item.Id, timesheet.Id, item.Expensedate, item.Cost, item.Expensedesc);
return;
}
}
return;
}
public void Update(int Id, int Timesheetid, DateTime Expensedate, double Cost, string Expensedesc)
{
ExpenseEntry item = new ExpenseEntry();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.Timesheetid = Timesheetid;
item.Expensedate = Expensedate;
item.Cost = Cost;
item.Expensedesc = Expensedesc;
item.IsDeleted = false;
item.CreatedOn = null;
item.CreatedBy = null;
item.ModifiedOn = null;
item.ModifiedBy = null;
item.Save(UserName);
}
public void Insert(int Timesheetid, DateTime Expensedate, double Cost, string Expensedesc, bool IsDeleted, DateTime?CreatedOn, string CreatedBy, DateTime?ModifiedOn, string ModifiedBy)
{
ExpenseEntry item = new ExpenseEntry();
item.Timesheetid = Timesheetid;
item.Expensedate = Expensedate;
item.Cost = Cost;
item.Expensedesc = Expensedesc;
item.IsDeleted = IsDeleted;
item.CreatedOn = CreatedOn;
item.CreatedBy = CreatedBy;
item.ModifiedOn = ModifiedOn;
item.ModifiedBy = ModifiedBy;
item.Save(UserName);
}
public void DeleteTimesheet(int TimesheetID)
{
//first delete expense entries
ExpenseEntry.Delete(ExpenseEntry.Columns.Timesheetid, TimesheetID, this.UserName);
//second delete time entries
TimeEntry.Delete(TimeEntry.Columns.Timesheetid, TimesheetID, this.UserName);
//finally delete the time sheet
this.Delete(TimesheetID);
}
public bool Destroy(object Id)
{
return(ExpenseEntry.Destroy(Id) == 1);
}
public bool Delete(object Id)
{
return(ExpenseEntry.Delete(Id) == 1);
}
