public static decimal GetSalaryByWork(int workerId)
{
decimal salary = 0;
List <Work> workList = new WorksEntities().Works.ToList()
.Where(x => x.worker_id == workerId && x.is_paid == 0).ToList();
foreach (var item in workList)
{
salary = salary + item.surface_work * item.unit_price_worker ?? 0;
}
salary += WorkersGroupDetail.GetWorksGroupSum(workerId);
return(salary);
}
public static Classes.Worker.WorkerPaymentModel GetWorkerPaymentModel(WorksEntities dbWorks,
WorkerPaymentsEntities dbWorkerPayment)
{
var model = new Classes.Worker.WorkerPaymentModel
{
WorkId = MySession.Current.WorkId,
CurrentDate = DateTime.Today,
Amount = GetSalary(MySession.Current.WorkerId),
WorkerWorkList = dbWorks.Works.AsQueryable().Where(x => x.worker_id == MySession.Current.WorkerId).ToList(),
PaymentTypeList = GetPaymentTypeList(),
WorkerPayments = dbWorkerPayment.WorkerPayments.ToList()
.Where(x => x.worker_id == MySession.Current.WorkerId).ToList()
};
return(model);
}
public static WorkerWorksModel GetWorkerWorksModel()
{
List <int> workerGroupsIds = WorkersGroupDetail.GetWorkerGroupIds(MySession.Current.WorkerId);
var works = new WorksEntities().Works.ToList().Where(x => x.worker_id == MySession.Current.WorkerId).ToList();
foreach (int id in workerGroupsIds)
{
works.AddRange(new WorksEntities().Works.AsQueryable().Where(x => x.workers_group_id == id).ToList());
}
return(new WorkerWorksModel
{
ObjectList = Object.Object.GetObjectModel().ObjectList,
UnitList = Home.Unit.GetUnitModel().UnitList,
WorksList = works
});
}
