public static void AddResource(List <TaskResource> resList, string prjId, int version)
{
using (pm2Entities entities = new pm2Entities())
{
DelRes(entities, prjId, version);
using (List <TaskResource> .Enumerator enumerator = resList.GetEnumerator())
{
TaskResource taskResource;
while (enumerator.MoveNext())
{
taskResource = enumerator.Current;
Bud_TaskResource resource = new Bud_TaskResource {
TaskResourceId = Guid.NewGuid().ToString(),
Bud_Task = null,
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == taskResource.Resource.Id
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = new decimal?(taskResource.Quantity),
ResourcePrice = new decimal?(taskResource.Price),
InputUser = taskResource.InputUser,
InputDate = taskResource.InputDate.Value,
PrjGuid = prjId,
Versions = new int?(version),
LossCoefficient = taskResource.LossCoefficient
};
entities.AddToBud_TaskResource(resource);
}
}
entities.SaveChanges();
}
}
public static void AddResource(TaskResource taskResource)
{
using (pm2Entities entities = new pm2Entities())
{
int?nullable = (from m in entities.Bud_Task
where m.PrjId == taskResource.PrjGuid
select m.Version).Max <int?>();
if (!nullable.HasValue)
{
nullable = 1;
}
Bud_TaskResource resource = new Bud_TaskResource {
TaskResourceId = taskResource.TaskReourceId,
Bud_Task = null,
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == taskResource.Resource.Id
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = new decimal?(taskResource.Quantity),
ResourcePrice = new decimal?(taskResource.Price),
InputUser = taskResource.InputUser,
InputDate = taskResource.InputDate.Value,
PrjGuid = taskResource.PrjGuid,
Versions = nullable,
LossCoefficient = taskResource.LossCoefficient
};
entities.AddToBud_TaskResource(resource);
entities.SaveChanges();
}
}
public static void Delete(ResourceTemp resTemp, string InputUser, string isWBSRelevance)
{
using (pm2Entities entities = new pm2Entities())
{
if (isWBSRelevance == "1")
{
Bud_TaskResource resource = (from tr in entities.Bud_TaskResource
where (tr.Res_Resource.ResourceId == resTemp.ResourceId) && (tr.Bud_Task.TaskId == resTemp.BudTask.Id)
select tr).FirstOrDefault <Bud_TaskResource>();
if (resource == null)
{
Bud_TaskResource resource2 = new Bud_TaskResource {
TaskResourceId = Guid.NewGuid().ToString(),
Bud_Task = (from t in entities.Bud_Task
where t.TaskId == resTemp.BudTask.Id
select t).FirstOrDefault <Bud_Task>(),
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resTemp.ResourceId
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = resTemp.Quantity,
ResourcePrice = resTemp.UnitPrice,
InputUser = InputUser,
InputDate = DateTime.Now,
PrjGuid = resTemp.PrjId,
Versions = 1,
LossCoefficient = 1
};
entities.AddToBud_TaskResource(resource2);
}
else
{
resource.ResourceQuantity += resTemp.Quantity;
}
}
else
{
Bud_TaskResource resource3 = (from tr in entities.Bud_TaskResource
where (tr.Res_Resource.ResourceId == resTemp.ResourceId) && (tr.PrjGuid == resTemp.PrjId)
select tr).FirstOrDefault <Bud_TaskResource>();
if (resource3 == null)
{
int?nullable = (from m in entities.Bud_Task
where m.PrjId == resTemp.PrjId
select m.Version).Max <int?>();
if (!nullable.HasValue)
{
nullable = 1;
}
Bud_TaskResource resource4 = new Bud_TaskResource {
TaskResourceId = Guid.NewGuid().ToString(),
Bud_Task = null,
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resTemp.ResourceId
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = resTemp.Quantity,
ResourcePrice = resTemp.UnitPrice,
InputUser = InputUser,
InputDate = DateTime.Now,
PrjGuid = resTemp.PrjId,
Versions = nullable
};
entities.AddToBud_TaskResource(resource4);
}
else
{
resource3.ResourceQuantity += resTemp.Quantity;
}
}
Res_ResourceTemp entity = (from rt in entities.Res_ResourceTemp
where rt.Id == resTemp.Id
select rt).FirstOrDefault <Res_ResourceTemp>();
entities.DeleteObject(entity);
entities.SaveChanges();
}
}
