public InsulationTypeDTO Update(InsulationTypeDTO obj) { using (var transaction = _context.Database.BeginTransaction()) { try { InsulationType tempObj = (from r in _unitOfWork.InsulationType.GenerateEntityAsIQueryable() where r.Name == obj.Name && r.ID != obj.ID select r).FirstOrDefault(); if (tempObj == null) { var response = _unitOfWork.InsulationType.FindById(obj.ID); if (response != null) { response.Name = obj.Name; response.AdjustmentFactor = obj.AdjustmentFactor; response.Active = obj.Active; response.CreatedBy = obj.CreatedBy; response.CreatedDate = obj.CreatedDate; response.ModifiedBy = obj.ModifiedBy; response.ModifiedDate = DateTime.Now; } _unitOfWork.InsulationType.Update(response); _unitOfWork.SaveChanges(); transaction.Commit(); return(new InsulationTypeDTO { ID = obj.ID, Status = true, StatusMessage = "Successfully updated", StatusCode = 200 }); } else { return(new InsulationTypeDTO { ID = tempObj.ID, Status = false, StatusMessage = "Error - Duplicate Insulation Type.", StatusCode = 200 }); } } catch (Exception ex) { transaction.Rollback(); return(new InsulationTypeDTO() { ID = 0, Status = false, StatusMessage = ex.Message, StatusCode = 200 }); } } }
public InsulationTypeDTO Create(InsulationTypeDTO obj) { using (var transaction = _context.Database.BeginTransaction()) { try { InsulationType tempObj = (from i in _unitOfWork.InsulationType.GenerateEntityAsIQueryable() where i.Name == obj.Name select i).FirstOrDefault(); if (tempObj == null) { var insulationType = new InsulationType() { Name = obj.Name, AdjustmentFactor = obj.AdjustmentFactor, Active = true, CreatedBy = obj.CreatedBy, CreatedDate = DateTime.Now }; _unitOfWork.InsulationType.Create(insulationType); _unitOfWork.SaveChanges(); transaction.Commit(); return(new InsulationTypeDTO { ID = insulationType.ID, Status = true, StatusMessage = "Successfully created", StatusCode = 200 }); } else { return(new InsulationTypeDTO { ID = tempObj.ID, Status = false, StatusMessage = "Error - Duplicate Insulation Type - " + tempObj.Name, StatusCode = 200 }); } } catch (Exception ex) { transaction.Rollback(); return(new InsulationTypeDTO() { ID = 0, Status = false, StatusMessage = ex.Message, StatusCode = 200 }); } } }
private void Stream( ArrayList data, InsulationType insType ) { data.Add( new Snoop.Data.ClassSeparator( typeof( InsulationType ) ) ); data.Add( new Snoop.Data.Bool( "Is in use", insType.IsInUse ) ); }