How to Persist data on a Domain Component?

StatusIDPriorityType
Closed25126TrivialQuestion
ProfileReply
doorscomputersClient

I have a viewcontroller code below and it computes basic payroll computation, owever it is only displayed on a window. How do I persist the results to a table in sql server? Hope you can help me on this. Thanks!
namespace Piask.Module.BusinessObjects.PayrollCalculation
{
using System;
using System.Collections.Generic;
using System.ComponentModel;

using DevExpress.ExpressApp;
using DevExpress.ExpressApp.DC;
using DevExpress.Persistent.Base;

[DomainComponent] public class PayrollResultView : INotifyPropertyChanged
{
public PayrollResultView(DateTime startDate, DateTime endDate, List employees)
{
this.StartDate = startDate;
this.EndDate = endDate;
this.Employees = employees;
this.CalculateResults();
}

[Browsable(false)] public int Id;

private DateTime _StartDate;

private DateTime _EndDate;

[ImmediatePostData] public DateTime StartDate
{
get
{
return _StartDate;
}
set
{
_StartDate = value;

CalculateResults();
OnPropertyChanged("StartDate");
}
}

[ImmediatePostData] public DateTime EndDate
{
get
{
return _EndDate;
}
set
{
_EndDate = value;

CalculateResults();
OnPropertyChanged("EndDate");
}
}

[Browsable(false)] public List Employees { get; set; }

private IList _Results;
public IList Results
{
get
{
return this._Results ?? (this._Results = new BindingList());
}
}

private void CalculateResults()
{
if (StartDate >= EndDate)
return;

this.Results.Clear();
if (this.StartDate != DateTime.MinValue && this.EndDate != DateTime.MinValue && this.EndDate > this.StartDate
&& this.Employees != null)
foreach (var employee in this.Employees)
this.Results.Add(new PayrollResult(this.StartDate.Date, this.EndDate.Date, employee));

OnPropertyChanged("Results");
}

public event PropertyChangedEventHandler PropertyChanged;

private void OnPropertyChanged(string propertyName)
{
if (PropertyChanged == null) return;
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}

and the Payresult controller
// --------------------------------------------------------------------------------------------------------------------
//
//
//
// --------------------------------------------------------------------------------------------------------------------

namespace Piask.Module.BusinessObjects.PayrollCalculation
{
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;

using DevExpress.ExpressApp.DC;
using DevExpress.ExpressApp.Model;

///

/// The payroll result.
///

[DomainComponent] public class PayrollResult
{
///

/// Initializes a new instance of the class.
///

///
/// The start date.
///
///
/// The end date.
///
///
/// The employee.
///
public PayrollResult(DateTime startDate, DateTime endDate, Employee employee)
{
this.DatesRange = new DatesRange(startDate, endDate);
this.Employee = employee;
}

///

/// The id.
///

[Browsable(false)] public int Id;

///

/// Gets or sets the employee.
///

[ModelDefault("AllowEdit", "False")] public Employee Employee { get; set; }

///

/// Gets or sets the dates range.
///

[ModelDefault("AllowEdit", "False")] public DatesRange DatesRange { get; set; }

///

/// The base hours details.
///

private List baseHoursDetails;

///

/// Gets the base hours details.
///

public List BaseHoursDetails
{
get
{
if (baseHoursDetails == null)
{
baseHoursDetails = new List();
foreach (var schedule in this.Employee.Schedules)
{
// Get or create hours detail
var classTypeHours = baseHoursDetails.FirstOrDefault(x => x.ClassType == schedule.ClassType);
if (classTypeHours == null)
{
classTypeHours = new ClassTypeHours(schedule, schedule.ClassType);
baseHoursDetails.Add(classTypeHours);
}

classTypeHours.Hours += schedule.GetHours(this.DatesRange);
}
}

return baseHoursDetails;
}
}

///

/// The absent hours details.
///

private List absentHoursDetails;

///

/// Gets the absent hours details.
///

public List AbsentHoursDetails
{
get
{
if (absentHoursDetails == null)
absentHoursDetails = Employee.GetAbsentHours(DatesRange);

return absentHoursDetails;
}
}

///

/// The over time hours details.
///

private List overTimeHoursDetails;

///

/// Gets the over time hours details.
///

public List OverTimeHoursDetails
{
get
{
if (overTimeHoursDetails == null)
{
overTimeHoursDetails = new List();
foreach (var overtime in
Employee.Overtimes.Where(x => x.StartDate >= this.DatesRange.StartDate && x.EndDate <= this.DatesRange.EndDate))
{
overTimeHoursDetails.Add(
new ClassTypeHours(overtime, overtime.ClassType)
{
Hours = overtime.EndDate.Subtract(overtime.StartDate).TotalHours
});
}
}

return overTimeHoursDetails;
}
}

///

/// Gets the work hours.
///

public double WorkHours
{
get
{
double workHours = 0;
foreach (var hoursDetail in BaseHoursDetails)
workHours += hoursDetail.Hours;

return workHours;
}
}

///

/// Gets the absent hours.
///

public double AbsentHours
{
get
{
double absentHours = 0;
foreach (var absent in AbsentHoursDetails)
absentHours += absent.Hours;

return absentHours;
}

}

///

/// Gets the overtime hours.
///

public double OvertimeHours
{
get
{
double result = 0;
foreach (var overtime in OverTimeHoursDetails)
result += overtime.Hours;

return result;
}

}

///

/// Gets the total hours.
///

public double TotalHours
{
get
{
return this.WorkHours + this.OvertimeHours - this.AbsentHours;
}
}

///

/// Gets the total basic.
///

public decimal TotalBasic
{
get
{
decimal totalBasic = 0;
foreach (var baseHoursDetail in this.BaseHoursDetails)
{
// Add base hours
totalBasic += baseHoursDetail.TotalBasic;

// Subtract absent hours by schedule
foreach (var absent in AbsentHoursDetails.Where(x => x.Payable == baseHoursDetail.Payable))
totalBasic -= absent.TotalBasic;
}

return totalBasic;
}
}

///

/// Gets the total allowance.
///

public decimal TotalAllowance
{
get
{
decimal totalAllowance = 0;
foreach (var baseHoursDetail in this.BaseHoursDetails)
{
// Add base hours
totalAllowance += baseHoursDetail.TotalAllowance;

// Subtract absent hours by schedule
foreach (var absent in AbsentHoursDetails.Where(x => x.Payable == baseHoursDetail.Payable))
totalAllowance -= absent.TotalAllowance;
}

return totalAllowance;
}
}

///

/// Gets the total amount.
///

public decimal TotalAmount
{
get
{
return this.TotalBasic + this.TotalAllowance;
}
}

public decimal TotalOvertime
{
get
{
decimal result = 0;
foreach (var overtime in OverTimeHoursDetails)
result += overtime.TotalBasic + overtime.TotalAllowance;

return result;
}
}

public decimal TotalEarnings
{
get
{
decimal result = 0;
foreach (var earning in Employee.GetEarnings(this.DatesRange))
result += earning.Total;

return result;
}
}

public decimal TotalDeductions
{
get
{
decimal result = 0;
foreach (var earning in Employee.GetDeductions(this.DatesRange))
result += earning.Total;

return result;
}
}

public decimal NetPay
{
get
{
return TotalAmount + TotalOvertime + TotalEarnings - TotalDeductions;
}
}
}
}

Replies

UserDescriptionPosted On
Sasha (Xafari Support)Agent

Hello,

Thank you for the additional information.
We will try to advise you in the near future.

Best regargs,
Sasha.

doorscomputers

Thanks for the very quick reply. May I clarify that I want to persist the computations made by the code above to the database. currently it is just showing on a view window

Sasha (Xafari Support)Agent

Hello,

To solve this issue you can use next variants:
1) make class which you want save in database as XPO class
example:

[DomainComponent]
public class PayrollResult
{
...
}

->

public class PayrollResult: BaseObject
{
public PayrollResult(Session session) : base(session) { }
...
}

2) create XPO object and inherit the object from your DC class
3) use strategy with interfaces: How to: Get Started with Domain Components, Using Domain Components (DC) in XAF (DevExpress): Part I: The Basics.

If you need any further assistance on this subject, feel free to contact us.
Regards, Sasha.

doorscomputers

Thanks very much!

Sasha (Xafari Support)Agent

You're welcome!

× This ticket is closed.

Write US