public static void UpdateResQuantity(string taskId, string resId, decimal quantity)
{
using (pm2Entities entities = new pm2Entities())
{
Bud_ContractResource resource = (from m in entities.Bud_ContractResource
where (m.Res_Resource.ResourceId == resId) && (m.Bud_ContractTask.TaskId == taskId)
select m).FirstOrDefault <Bud_ContractResource>();
if (resource != null)
{
resource.ResourceQuantity = new decimal?(quantity);
entities.SaveChanges();
}
}
}
public static void Add(BudContractResource conRes)
{
using (pm2Entities entities = new pm2Entities())
{
Bud_ContractTask task = (from m in entities.Bud_ContractTask
where m.TaskId == conRes.TaskId
select m).FirstOrDefault <Bud_ContractTask>();
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == conRes.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_ContractResource resource2 = new Bud_ContractResource {
TaskResourceId = conRes.Id,
ResourcePrice = new decimal?(conRes.ResPrice),
ResourceQuantity = new decimal?(conRes.ResQuantity),
InputDate = conRes.InputDate,
InputUser = conRes.InputUser,
Bud_ContractTask = task,
Res_Resource = resource
};
entities.AddToBud_ContractResource(resource2);
entities.SaveChanges();
}
}
