public ManageResourcesResponse AddResources(ManageResourcesRequest request)
{
ManageResourcesResponse response = new ManageResourcesResponse();
int? compId = AdapterHelper.GetCompanyId(request.CompanyName);
if (compId == null)
{
throw new Exception("No company found. Try again!");
}
using (var context = new Company_dbEntities())
{
var resp = (from a in context.Resources_table where a.CompanyID == compId.Value && request.Serial == a.Serial select a).FirstOrDefault<Resources_table>();
if (resp == null)
{
resp = new Resources_table();
resp.NameOfDevice = request.NameOfDevice;
resp.Type = request.Type;
resp.IssuedFrom = request.IssuedFrom.ToShortDateString();
resp.Serial = request.Serial;
resp.CompanyID = compId.Value;
resp.EmployeeID = null;
resp.Deleted = false;
context.Resources_table.Add(resp);
var comp = (from a in context.Company_table where a.CompanyID == compId.Value select a).FirstOrDefault<Company_table>();
if (comp != null)
comp.ResourceCount++;
context.SaveChanges();
response.IsResourcesCreated = true;
}
else
{
response.IsResourcesCreated = false;
}
}
return response;
}
public ManageResourcesResponse CompanyDeleted(ManageResourcesRequest request)
{
ManageResourcesResponse response = new ManageResourcesResponse();
Resources_table resource = new Resources_table();
using (var context = new Company_dbEntities())
{
resource = (from a in context.Resources_table select a).FirstOrDefault<Resources_table>();
if (resource != null)
{
context.Resources_table.Remove(resource);
context.SaveChanges();
CompanyDeleted(request);
}
response.DeletedCompany = true;
}
return response;
}