public ValueDataResponse <LookUp> AddLookUpData(LookUp lookup)
{
ValueDataResponse <LookUp> response = new ValueDataResponse <LookUp>();
try
{
var result = _appContext.LookUps.Add(lookup);
_appContext.SaveChanges();
if (result != null)
{
response.Result = lookup;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "LookUp Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "LookUp Added Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public async Task <ValueDataResponse <ApplicationUser> > DeleteUser(ApplicationUser user)
{
ValueDataResponse <ApplicationUser> response = new ValueDataResponse <ApplicationUser>();
try
{
var result = _context.Users.Where(x => x.Id == user.Id).FirstOrDefault();
if (result != null)
{
result.IsEnabled = false;
result.UpdatedDate = DateTime.UtcNow;
//_context.Users.Remove(result);
await _context.SaveChangesAsync();
response.Result = result;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "User Deleted Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "User Not Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <AssetGroup> InsertAssetGroup(AssetGroup asset)
{
ValueDataResponse <AssetGroup> response = new ValueDataResponse <AssetGroup>();
try
{
var result = _appContext.AssetGroups.Add(asset);
_appContext.SaveChanges();
if (result != null)
{
response.Result = asset;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "AssetGroup Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "AssetGroup Added Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <JobPlan> DeleteJobPlan(int JobPlanId)
{
ValueDataResponse <JobPlan> response = new ValueDataResponse <JobPlan>();
try
{
var JobPlanData = _appContext.JobPlans.Where(x => x.Id == JobPlanId).FirstOrDefault();
if (JobPlanData != null)
{
var jobTasks = _appContext.JobTasks.Where(x => x.JobPlanId == JobPlanId).ToList();
var pmPro = _appContext.PreventiveMaintenances.Where(x => x.JobPlanId == JobPlanId).ToList();
var res = _appContext.PMAssetXrefs.Where(x => pmPro.Select(p => p.Id).Contains(x.PreventiveMaintenanceId)).ToList();
var stspm = _appContext.PMStatusHistories.Where(x => pmPro.Select(p => p.Id).Contains(x.PreventiveMaintenanceId)).ToList();
var work = _appContext.WorkOrders.Where(x => pmPro.Select(p => p.Id).Contains(x.PMProcedureId.Value)).ToList();
var statusData = _appContext.WorkOrderStatusHistories.Where(x => work.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var ast = _appContext.WorkOrderItemXrefs.Where(x => work.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
_appContext.WorkOrderStatusHistories.RemoveRange(statusData);
_appContext.WorkOrderItemXrefs.RemoveRange(ast);
_appContext.WorkOrders.RemoveRange(work);
_appContext.PMStatusHistories.RemoveRange(stspm);
_appContext.PMAssetXrefs.RemoveRange(res);
_appContext.PreventiveMaintenances.RemoveRange(pmPro);
_appContext.JobTasks.RemoveRange(jobTasks);
_appContext.JobPlans.Remove(JobPlanData);
_appContext.SaveChanges();
}
if (JobPlanData != null)
{
response.Result = JobPlanData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Job Plan Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Job Plan Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <WorkOrder> InsertWorkOrder(UpsertWorkOrder workorders)
{
ValueDataResponse <WorkOrder> response = new ValueDataResponse <WorkOrder>();
try
{
var orderExists = _appContext.WorkOrders.Where(x => x.Reference1 == workorders.Reference1).FirstOrDefault();
if (orderExists == null)
{
WorkOrder Wro = _mapper.Map <WorkOrder>(workorders);
var result = _appContext.WorkOrders.Add(Wro);
_appContext.SaveChanges();
if (workorders.WorkOrderItems != null)
{
foreach (var it in workorders.WorkOrderItems)
{
_appContext.WorkOrderItemXrefs.Add(new WorkOrderItemXref
{
ItemId = it.ItemId,
WorkOrderId = Wro.Id,
Quantity = it.Quantity,
});
}
_appContext.SaveChanges();
}
if (Wro != null)
{
response.Result = Wro;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Work Order Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Work Order Added Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Work Order Reference is Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Location> UpdateLocation(Location location)
{
ValueDataResponse <Location> response = new ValueDataResponse <Location>();
try
{
var locationExists = _appContext.Locations.Where(x => x.Id != location.Id && x.LocationReference == location.LocationReference).FirstOrDefault();
if (locationExists == null)
{
//var result = _appContext.Locations.Add(location);
var result = _appContext.Locations.Where(x => x.Id == location.Id).FirstOrDefault();
if (result != null)
{
//result.SiteId = location.SiteId;
result.ProjectId = location.ProjectId;
result.LocationReference = location.LocationReference;
result.Name1 = location.Name1;
result.Name2 = location.Name2;
result.IsActive = location.IsActive;
result.CreatedBy = location.CreatedBy;
result.CreatedDate = location.CreatedDate;
result.UpdatedBy = location.UpdatedBy;
result.UpdatedDate = location.UpdatedDate;
_appContext.SaveChanges();
response.Result = location;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Location Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Location Updated Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Location Reference Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Item> UpdateItem(Item items)
{
ValueDataResponse <Item> response = new ValueDataResponse <Item>();
try
{
var itemExists = _appContext.Items.Where(x => x.Id != items.Id && x.ItemReference == items.ItemReference).FirstOrDefault();
if (itemExists == null)
{
var result = _appContext.Items.Where(x => x.Id == items.Id).FirstOrDefault();
if (result != null)
{
result.ItemReference = items.ItemReference;
result.ItemCategory = items.ItemCategory;
result.ItemType = items.ItemType;
result.Name1 = items.Name1;
result.Name2 = items.Name2;
result.Description = items.Description;
result.AverageCost = items.AverageCost;
result.UOMId = items.UOMId;
result.IsActive = items.IsActive;
result.CreatedBy = items.CreatedBy;
result.CreatedDate = items.CreatedDate;
result.UpdatedBy = items.UpdatedBy;
result.UpdatedDate = items.UpdatedDate;
_appContext.SaveChanges();
response.Result = result;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Item Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Item Updation Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Item Reference Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <PreventiveMaintenance> DeletePreventiveMaintenance(int PmId)
{
ValueDataResponse <PreventiveMaintenance> response = new ValueDataResponse <PreventiveMaintenance>();
try
{
var pmData = _appContext.PreventiveMaintenances.Where(x => x.Id == PmId).FirstOrDefault();
var ast = _appContext.PMAssetXrefs.Where(x => x.PreventiveMaintenanceId == PmId).ToList();
if (ast != null)
{
var assetRepo = _appContext.PMStatusHistories.Where(x => ast.Select(ar => ar.Id).Contains(x.PreventiveMaintenanceId)).ToList();
var work = _appContext.WorkOrders.Where(x => x.PMProcedureId == PmId).ToList();
var statusData = _appContext.WorkOrderStatusHistories.Where(x => work.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var asts = _appContext.WorkOrderItemXrefs.Where(x => work.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
_appContext.WorkOrderStatusHistories.RemoveRange(statusData);
_appContext.WorkOrderItemXrefs.RemoveRange(asts);
_appContext.WorkOrders.RemoveRange(work);
_appContext.PMAssetXrefs.RemoveRange(ast);
_appContext.PMStatusHistories.RemoveRange(assetRepo);
_appContext.PreventiveMaintenances.Remove(pmData);
_appContext.SaveChanges();
}
_appContext.SaveChanges();
if (pmData != null)
{
response.Result = pmData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Preventive Maintenance Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Preventive Maintenance Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <AssetLocation> DeleteAssetLocation(int assetId)
{
ValueDataResponse <AssetLocation> response = new ValueDataResponse <AssetLocation>();
try
{
var assetData = _appContext.AssetLocations.Where(x => x.Id == assetId).FirstOrDefault();
var workOrders = _appContext.WorkOrders.Where(x => x.AssetId == assetId).ToList();
if (assetData != null)
{
//assetData.IsActive = false;
//assetData.UpdatedDate = DateTime.Now;
var assetFiles = _appContext.AssetFileRepositories.Where(x => x.AssetId == assetId).ToList();
var resss = _appContext.WorkOrderItemXrefs.Where(x => workOrders.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var sts = _appContext.WorkOrderStatusHistories.Where(x => workOrders.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var stc = _appContext.PMAssetXrefs.Where(x => x.AssetId == assetId).ToList();
_appContext.PMAssetXrefs.RemoveRange(stc);
_appContext.AssetFileRepositories.RemoveRange(assetFiles);
_appContext.WorkOrderStatusHistories.RemoveRange(sts);
_appContext.WorkOrderItemXrefs.RemoveRange(resss);
_appContext.WorkOrders.RemoveRange(workOrders);
_appContext.AssetLocations.Remove(assetData);
_appContext.SaveChanges();
}
if (assetData != null)
{
response.Result = assetData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "AssetLocation Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No AssetLocation Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Location> DeleteLocation(int LocationId)
{
ValueDataResponse <Location> response = new ValueDataResponse <Location>();
try
{
var LocationData = _appContext.Locations.Where(x => x.Id == LocationId).FirstOrDefault();
var ast = _appContext.AssetLocations.Where(x => x.LocationId == LocationId).ToList();
if (ast != null)
{
var assetRepo = _appContext.AssetFileRepositories.Where(x => ast.Select(ar => ar.Id).Contains(x.AssetId)).ToList();
var workOrders = _appContext.WorkOrders.Where(x => ast.Select(p => p.Id).Contains(x.AssetId)).ToList();
var resss = _appContext.WorkOrderItemXrefs.Where(x => workOrders.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var sts = _appContext.WorkOrderStatusHistories.Where(x => workOrders.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var pmast = _appContext.PMAssetXrefs.Where(x => ast.Select(ar => ar.Id).Contains(x.AssetId)).ToList();
_appContext.AssetFileRepositories.RemoveRange(assetRepo);
_appContext.WorkOrderItemXrefs.RemoveRange(resss);
_appContext.WorkOrderStatusHistories.RemoveRange(sts);
_appContext.WorkOrders.RemoveRange(workOrders);
_appContext.PMAssetXrefs.RemoveRange(pmast);
_appContext.AssetLocations.RemoveRange(ast);
_appContext.Locations.RemoveRange(LocationData);
_appContext.SaveChanges();
}
_appContext.SaveChanges();
if (LocationData != null)
{
response.Result = LocationData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Location Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Location Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Item> DeleteItem(int ItemId)
{
ValueDataResponse <Item> response = new ValueDataResponse <Item>();
try
{
var ItemData = _appContext.Items.Where(x => x.Id == ItemId).FirstOrDefault();
var purchase = _appContext.PurchageItemXrefs.Where(x => x.ItemId == ItemId).ToList();
if (purchase != null)
{
var workOrder = _appContext.WorkOrderItemXrefs.Where(x => x.ItemId == ItemId).ToList();
var res = _appContext.PurchageOrders.Where(x => purchase.Select(p => p.Id).Contains(x.Id)).ToList();
var res1 = _appContext.WorkOrders.Where(x => workOrder.Select(p => p.Id).Contains(x.Id)).ToList();
var inv = _appContext.Inventories.Where(x => x.ItemId == ItemId).ToList();
_appContext.Inventories.RemoveRange(inv);
_appContext.PurchageOrders.RemoveRange(res);
_appContext.PurchageItemXrefs.RemoveRange(purchase);
_appContext.WorkOrders.RemoveRange(res1);
_appContext.WorkOrderItemXrefs.RemoveRange(workOrder);
_appContext.Remove(ItemData);
_appContext.SaveChanges();
}
if (ItemData != null)
{
response.Result = ItemData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Item Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Item Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <WorkOrder> CloseWorkOrder(int WorkOrderId, int StatusTypeId, string Comments)
{
ValueDataResponse <WorkOrder> response = new ValueDataResponse <WorkOrder>();
try
{
var orderData = _appContext.WorkOrders.Where(x => x.Id == WorkOrderId).FirstOrDefault();
if (orderData != null)
{
orderData.StatusTypeId = StatusTypeId;
WorkOrderStatusHistory request = new WorkOrderStatusHistory()
{
WorkOrderId = orderData.Id,
StatusTypeId = StatusTypeId,
Comments = Comments,
CreatedBy = orderData.CreatedBy,
UpdatedBy = orderData.UpdatedBy,
CreatedDate = orderData.CreatedDate,
UpdatedDate = DateTime.Now,
};
_appContext.WorkOrderStatusHistories.Add(request);
_appContext.SaveChanges();
response.Result = orderData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Work Order Accepted Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Work Order Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <AssetGroup> UpdateAssetGroup(AssetGroup asset)
{
ValueDataResponse <AssetGroup> response = new ValueDataResponse <AssetGroup>();
try
{
var result = _appContext.AssetGroups.Where(x => x.Id == asset.Id).FirstOrDefault();
if (result != null)
{
result.AssetRef1 = asset.AssetRef1;
result.AssetRef2 = asset.AssetRef2;
result.Name1 = asset.Name1;
result.Name2 = asset.Name2;
result.AssetMake = asset.AssetMake;
result.AssetModel = asset.AssetModel;
result.AssetCapacity = asset.AssetCapacity;
result.AssetType = asset.AssetType;
result.IsActive = asset.IsActive;
result.CreatedBy = asset.CreatedBy;
result.CreatedDate = asset.CreatedDate;
result.UpdatedBy = asset.UpdatedBy;
result.UpdatedDate = asset.UpdatedDate;
_appContext.SaveChanges();
response.Result = asset;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "AssetGroup Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "AssetGroup Updated Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Location> InsertLocation(Location location)
{
ValueDataResponse <Location> response = new ValueDataResponse <Location>();
try
{
var locationExists = _appContext.Locations.Where(x => x.LocationReference == location.LocationReference).FirstOrDefault();
if (locationExists == null)
{
var result = _appContext.Locations.Add(location);
_appContext.SaveChanges();
if (result != null)
{
response.Result = location;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Location Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Location Added Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Location Reference Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Supplier> DeleteSupplierByID(int SupplierId)
{
ValueDataResponse <Supplier> response = new ValueDataResponse <Supplier>();
try
{
var SupplierData = _appContext.Suppliers.Where(x => x.Id == SupplierId).FirstOrDefault();
var purchase = _appContext.PurchageOrders.Where(x => x.SupplierId == SupplierId).ToList();
if (purchase != null)
{
var res = _appContext.PurchageItemXrefs.Where(x => purchase.Select(p => p.Id).Contains(x.PurchageId)).ToList();
var inv = _appContext.Inventories.Where(x => purchase.Select(p => p.Id).Contains(x.PurchaseOrderId)).ToList();
_appContext.PurchageItemXrefs.RemoveRange(res);
_appContext.Inventories.RemoveRange(inv);
_appContext.PurchageOrders.RemoveRange(purchase);
_appContext.Suppliers.Remove(SupplierData);
_appContext.SaveChanges();
}
if (SupplierData != null)
{
response.Result = SupplierData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Supplier Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Supplier Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <AssetGroup> DeleteAssetGroup(int assetId)
{
ValueDataResponse <AssetGroup> response = new ValueDataResponse <AssetGroup>();
try
{
var assetData = _appContext.AssetGroups.Where(x => x.Id == assetId).FirstOrDefault();
var assetloc = _appContext.AssetLocations.Where(x => x.AstGroupId == assetId).ToList();
if (assetloc != null)
{
//assetData.IsActive = false;
//assetData.UpdatedDate = DateTime.Now;
var alocs = _appContext.AssetFileRepositories.Where(x => assetloc.Select(al => al.Id).Contains(x.AssetId)).ToList();
_appContext.AssetFileRepositories.RemoveRange(alocs);
_appContext.AssetLocations.RemoveRange(assetloc);
_appContext.AssetGroups.RemoveRange(assetData);
_appContext.SaveChanges();
}
if (assetData != null)
{
response.Result = assetData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "AssetGroup Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No AssetGroup Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <PurchageOrder> DeletePurchaseOrder(int PurchaseId)
{
ValueDataResponse <PurchageOrder> response = new ValueDataResponse <PurchageOrder>();
try
{
var purchaseData = _appContext.PurchageOrders.Where(x => x.Id == PurchaseId).FirstOrDefault();
var ast = _appContext.PurchageItemXrefs.Where(x => x.PurchageId == PurchaseId).ToList();
if (ast != null)
{
_appContext.PurchageItemXrefs.RemoveRange(ast);
var inventoryItems = _appContext.Inventories.Where(x => x.PurchaseOrderId == PurchaseId).ToList();
_appContext.Inventories.RemoveRange(inventoryItems);
_appContext.PurchageOrders.Remove(purchaseData);
_appContext.SaveChanges();
}
if (purchaseData != null)
{
response.Result = purchaseData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Purchase Order Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Purchase Order Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Item> AddItemDetials(Item items)
{
ValueDataResponse <Item> response = new ValueDataResponse <Item>();
try
{
var itemExists = _appContext.Items.Where(x => x.ItemReference == items.ItemReference).FirstOrDefault();
if (itemExists == null)
{
var result = _appContext.Items.Add(items);
_appContext.SaveChanges();
if (result != null)
{
response.Result = items;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Item Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Item Added Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Item Reference Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <LookUp> UpdateLookUpData(LookUp lookup)
{
ValueDataResponse <LookUp> response = new ValueDataResponse <LookUp>();
try
{
var result = _appContext.LookUps.Where(x => x.Id == lookup.Id).FirstOrDefault();
if (result != null)
{
result.Id = lookup.Id;
result.LookUpTypeId = lookup.LookUpTypeId;
result.Name1 = lookup.Name1;
result.Name2 = lookup.Name2;
result.Remarks = lookup.Remarks;
result.IsActive = lookup.IsActive;
result.CreatedBy = lookup.CreatedBy;
result.CreatedDate = lookup.CreatedDate;
result.UpdatedBy = lookup.UpdatedBy;
result.UpdatedDate = lookup.UpdatedDate;
_appContext.SaveChanges();
response.Result = result;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "LookUp Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "LookUp Updation Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <List <Inventory> > UpdateInventory(List <Inventory> inventory)
{
ValueDataResponse <List <Inventory> > response = new ValueDataResponse <List <Inventory> >();
try
{
foreach (var it in inventory)
{
_appContext.Inventories.Add(new Inventory
{
PurchaseOrderId = it.PurchaseOrderId,
ItemId = it.ItemId,
Quantity = it.Quantity,
ReceivedCost = it.ReceivedCost
});
_appContext.SaveChanges();
}
if (inventory != null)
{
response.Result = inventory;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Inventory Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Inventory Updatiton Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <WorkOrder> DeleteWorkOrder(int WorkOrderId)
{
ValueDataResponse <WorkOrder> response = new ValueDataResponse <WorkOrder>();
try
{
var orderData = _appContext.WorkOrders.Where(x => x.Id == WorkOrderId).FirstOrDefault();
var ast = _appContext.WorkOrderItemXrefs.Where(x => x.WorkOrderId == WorkOrderId).ToList();
if (ast != null)
{
var statusData = _appContext.WorkOrderStatusHistories.Where(x => x.WorkOrderId == WorkOrderId).ToList();
_appContext.WorkOrderStatusHistories.RemoveRange(statusData);
_appContext.WorkOrderItemXrefs.RemoveRange(ast);
_appContext.WorkOrders.Remove(orderData);
_appContext.SaveChanges();
}
if (orderData != null)
{
response.Result = orderData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Work Order Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Work Order Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <JobPlan> AddJobPlan(UpsertJobPlan jobPlans)
{
ValueDataResponse <JobPlan> response = new ValueDataResponse <JobPlan>();
try
{
JobPlan job = _mapper.Map <JobPlan>(jobPlans);
var result = _appContext.JobPlans.Add(job);
_appContext.SaveChanges();
foreach (var jtask in jobPlans.JobPlanTasks)
{
_appContext.JobTasks.Add(new JobTask {
Id = jtask.Id, JobPlanId = job.Id, Name = jtask.Name, Duration = jtask.Duration, AstTradeId = jtask.AstTradeId
});
}
_appContext.SaveChanges();
if (job != null)
{
response.Result = job;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Job Plan Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Job Plan Added Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <PreventiveMaintenance> InsertPreventiveMaintenance(UpsertPreventiveMaintenance PmOrders)
{
ValueDataResponse <PreventiveMaintenance> response = new ValueDataResponse <PreventiveMaintenance>();
try
{
PreventiveMaintenance PM = _mapper.Map <PreventiveMaintenance>(PmOrders);
var result = _appContext.PreventiveMaintenances.Add(PM);
_appContext.SaveChanges();
foreach (var sId in PmOrders.pmAssets)
{
_appContext.PMAssetXrefs.Add(new PMAssetXref {
AssetId = sId.AssetId, PreventiveMaintenanceId = PM.Id, DaysApplicable = sId.DaysApplicable, AstFixedDate = sId.AstFixedDate
});
}
_appContext.SaveChanges();
if (PmOrders != null)
{
response.Result = PM;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Preventive Maintenance Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Preventive Maintenance Added Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <Project> Deleteproject(int ProjectId)
{
ValueDataResponse <Project> response = new ValueDataResponse <Project>();
try
{
var Projectdetials = _appContext.Projects.Where(x => x.Id == ProjectId).FirstOrDefault();
if (Projectdetials != null)
{
Projectdetials.IsActive = false;
Projectdetials.UpdatedDate = DateTime.Now;
_appContext.SaveChanges();
}
if (Projectdetials != null)
{
response.Result = Projectdetials;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Project Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No ProjectId Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <LookUp> DeleteLooKUp(int LookUpId)
{
ValueDataResponse <LookUp> response = new ValueDataResponse <LookUp>();
try
{
var Lookupdetials = _appContext.LookUps.Where(x => x.Id == LookUpId).FirstOrDefault();
if (Lookupdetials != null)
{
Lookupdetials.IsActive = false;
Lookupdetials.UpdatedDate = DateTime.Now;
_appContext.SaveChanges();
}
if (Lookupdetials != null)
{
response.Result = Lookupdetials;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "LookUp Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No LookUp Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <PurchageOrder> RejectOrder(int PurchaseId)
{
ValueDataResponse <PurchageOrder> response = new ValueDataResponse <PurchageOrder>();
try
{
var purchaseData = _appContext.PurchageOrders.Where(x => x.Id == PurchaseId).FirstOrDefault();
if (purchaseData != null)
{
purchaseData.StatusTypeId = 16;
_appContext.SaveChanges();
}
if (purchaseData != null)
{
response.Result = purchaseData;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Purchase Order Rejected Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No Purchase Order Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <ProjectRepository> DeleteFileRepository(int RepositoryId)
{
ValueDataResponse <ProjectRepository> response = new ValueDataResponse <ProjectRepository>();
try
{
var projectRepository = _appContext.ProjectRepositories.Where(x => x.ProjectRepositoryId == RepositoryId).FirstOrDefault();
if (projectRepository != null)
{
_appContext.ProjectRepositories.Remove(projectRepository);
_appContext.SaveChanges();
}
if (projectRepository != null)
{
response.Result = projectRepository;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "File Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No File Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <SiteInfo> InsertSite(SiteInfo sites)
{
ValueDataResponse <SiteInfo> response = new ValueDataResponse <SiteInfo>();
try
{
var siteExists = _appContext.SiteInfos.Where(x => x.SiteReference == sites.SiteReference).FirstOrDefault();
if (siteExists == null)
{
// if (sites.Address != null)
// {
// coordinates LatLong = GetLatLngByAddress(sites.Address.ToString());
// if (LatLong != null)
// {
// sites.Latitude = (float)(LatLong.Latitude);
// sites.Longitude = (float)LatLong.Longitude;
// }
// }
var result = _appContext.SiteInfos.Add(sites);
if (sites.FileName != null)
{
string ModuleName = "Site";
var now = DateTime.Now;
var yearName = now.ToString("yyyy");
var monthName = now.Month.ToString("d2");
var dayName = now.ToString("dd");
FileUploadService repo = new FileUploadService();
//string FolderLocation = _config.Value.FileRepositoryFolder;
string FolderLocation = "FileRepository";
string ServerRootPath = _config.Value.ServerRootPath;
string Location = ServerRootPath + @"\" + FolderLocation + @"\" + yearName + @"\" + monthName + @"\" + dayName + @"\" + ModuleName;
// string Location = Path.Combine(ServerRootPath, FolderLocation, yearName, monthName, dayName, ModuleName);
byte[] FileBytes = Convert.FromBase64String(sites.FileName);
sites.FileName = repo.UploadFile(FileBytes, sites.FileExtention, Location);
sites.FileLocation = Path.Combine(yearName, monthName, dayName, ModuleName);
}
_appContext.SaveChanges();
if (result != null)
{
response.Result = sites;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Site Added Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Site Added Failed";
}
}
else
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = "Site Reference Already Exists";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <SiteInfo> DeleteSiteInfo(int SiteId)
{
ValueDataResponse <SiteInfo> response = new ValueDataResponse <SiteInfo>();
try
{
var result = _appContext.SiteInfos.Where(x => x.Id == SiteId).FirstOrDefault();
var projects = _appContext.Projects.Where(p => p.SiteId == SiteId).ToList();
if (projects != null)
{
var res = _appContext.ProjectRepositories.Where(x => projects.Select(p => p.Id).Contains(x.ProjectId)).ToList();
_appContext.ProjectRepositories.RemoveRange(res);
var userress = _appContext.UserProjectXrefs.Where(x => projects.Select(p => p.Id).Contains(x.ProjectId)).ToList();
_appContext.UserProjectXrefs.RemoveRange(userress);
var ress = _appContext.LookUpProjectXrefs.Where(x => projects.Select(p => p.Id).Contains(x.ProjectId)).ToList();
_appContext.LookUpProjectXrefs.RemoveRange(ress);
var resss = _appContext.Locations.Where(x => projects.Select(p => p.Id).Contains(x.ProjectId)).ToList();
var alocs = _appContext.AssetLocations.Where(x => resss.Select(al => al.Id).Contains(x.LocationId)).ToList();
var assetRepo = _appContext.AssetFileRepositories.Where(x => alocs.Select(ar => ar.Id).Contains(x.AssetId)).ToList();
var workOrders = _appContext.WorkOrders.Where(x => alocs.Select(ar => ar.Id).Contains(x.AssetId)).ToList();
var workItems = _appContext.WorkOrderItemXrefs.Where(x => workOrders.Select(ar => ar.Id).Contains(x.WorkOrderId)).ToList();
var workstatus = _appContext.WorkOrderStatusHistories.Where(x => workOrders.Select(ar => ar.Id).Contains(x.WorkOrderId)).ToList();
var orderProjects = _appContext.PurchageOrders.Where(x => projects.Select(p => p.Id).Contains(x.ProjectId)).ToList();
var orderItems = _appContext.PurchageItemXrefs.Where(x => orderProjects.Select(al => al.Id).Contains(x.PurchageId)).ToList();
var inventoryItems = _appContext.Inventories.Where(x => orderProjects.Select(al => al.Id).Contains(x.PurchaseOrderId)).ToList();
var pmAssets = _appContext.PMAssetXrefs.Where(x => alocs.Select(al => al.Id).Contains(x.AssetId)).ToList();
var jobs = _appContext.JobPlans.Where(x => projects.Select(al => al.Id).Contains(x.ProjectId.Value)).ToList();
var jobTasks = _appContext.JobTasks.Where(x => jobs.Select(p => p.Id).Contains(x.JobPlanId)).ToList();
var pmPro = _appContext.PreventiveMaintenances.Where(x => jobs.Select(p => p.Id).Contains(x.JobPlanId.Value)).ToList();
var pmres = _appContext.PMAssetXrefs.Where(x => pmPro.Select(p => p.Id).Contains(x.PreventiveMaintenanceId)).ToList();
var stspm = _appContext.PMStatusHistories.Where(x => pmPro.Select(p => p.Id).Contains(x.PreventiveMaintenanceId)).ToList();
var work1 = _appContext.WorkOrders.Where(x => pmPro.Select(p => p.Id).Contains(x.PMProcedureId.Value)).ToList();
var statusData1 = _appContext.WorkOrderStatusHistories.Where(x => work1.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
var ast1 = _appContext.WorkOrderItemXrefs.Where(x => work1.Select(p => p.Id).Contains(x.WorkOrderId)).ToList();
_appContext.PurchageItemXrefs.RemoveRange(orderItems);
_appContext.Inventories.RemoveRange(inventoryItems);
_appContext.PurchageOrders.RemoveRange(orderProjects);
_appContext.WorkOrderStatusHistories.RemoveRange(workstatus);
_appContext.WorkOrderItemXrefs.RemoveRange(workItems);
_appContext.WorkOrders.RemoveRange(workOrders);
_appContext.PMStatusHistories.RemoveRange(stspm);
_appContext.PMAssetXrefs.RemoveRange(pmres);
_appContext.PreventiveMaintenances.RemoveRange(pmPro);
_appContext.WorkOrderStatusHistories.RemoveRange(statusData1);
_appContext.WorkOrderItemXrefs.RemoveRange(ast1);
_appContext.WorkOrders.RemoveRange(work1);
_appContext.JobTasks.RemoveRange(jobTasks);
_appContext.JobPlans.RemoveRange(jobs);
_appContext.PMAssetXrefs.RemoveRange(pmAssets);
_appContext.AssetFileRepositories.RemoveRange(assetRepo);
_appContext.AssetLocations.RemoveRange(alocs);
_appContext.Locations.RemoveRange(resss);
}
_appContext.Projects.RemoveRange(projects);
_appContext.SiteInfos.Remove(result);
_appContext.SaveChanges();
if (result != null)
{
response.Result = result;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "SiteInfo Deleted Successfull";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "No SiteInfo Found";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
public ValueDataResponse <PreventiveMaintenance> UpdatePreventiveMaintenance(UpsertPreventiveMaintenance PmOrder)
{
ValueDataResponse <PreventiveMaintenance> response = new ValueDataResponse <PreventiveMaintenance>();
try
{
PreventiveMaintenance PM = _mapper.Map <PreventiveMaintenance>(PmOrder);
var result = _appContext.PreventiveMaintenances.Where(x => x.Id == PmOrder.Id).FirstOrDefault();
var List = _appContext.PMAssetXrefs.Where(x => x.PreventiveMaintenanceId == result.Id).ToList();
_appContext.PMAssetXrefs.RemoveRange(List);
_appContext.SaveChanges();
foreach (var sId in PmOrder.pmAssets)
{
_appContext.PMAssetXrefs.Add(new PMAssetXref {
AssetId = sId.AssetId, PreventiveMaintenanceId = PM.Id, DaysApplicable = sId.DaysApplicable, AstFixedDate = sId.AstFixedDate
});
}
_appContext.SaveChanges();
if (result != null)
{
result.PreventiveRefId = PmOrder.PreventiveRefId;
result.StartDate = PmOrder.StartDate;
result.JobPlanId = PmOrder.JobPlanId;
result.Priority = PmOrder.Priority;
result.DurationinHours = PmOrder.DurationInHours;
result.StatusTypeId = PmOrder.StatusTypeId;
result.WorkTechnicianId = PmOrder.WorkTechnicianId;
result.TypeOfMaintenance = PmOrder.TypeOfMaintenance;
result.Details = PmOrder.Details;
result.CreatedBy = PmOrder.CreatedBy;
result.CreatedDate = PmOrder.CreatedDate;
result.UpdatedBy = PmOrder.UpdatedBy;
result.UpdatedDate = PmOrder.UpdatedDate;
result.IsActive = PmOrder.IsActive;
}
_appContext.SaveChanges();
if (PM != null)
{
response.Result = PM;
response.IsSuccess = true;
response.AffectedRecords = 1;
response.EndUserMessage = "Preventive Maintenance Updated Successfully";
}
else
{
response.IsSuccess = true;
response.AffectedRecords = 0;
response.EndUserMessage = "Preventive Maintenance Updation Failed";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.AffectedRecords = 0;
response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
response.Exception = ex;
}
return(response);
}
