public List <ABC_ClassificationsDTO> GetClassificationBySet(Guid id) { try { List <ABC_ClassificationsDTO> result = new List <ABC_ClassificationsDTO>(); SessionManager.DoWork(session => { var list = session.Query <ABC_Classifications>().Where(q => q.ABC_ClassificationSet.Id == id).OrderBy(q => q.MinRecord).ThenByDescending(q => q.Rank); foreach (var l in list) { ABC_ClassificationsDTO item = new ABC_ClassificationsDTO() { Id = l.Id, MinRecord = l.MinRecord, MaxRecord = l.MaxRecord, Rank = l.Rank, IsEligible = l.IsEligible, ABC_ClassificationSetId = l.ABC_ClassificationSet?.Id ?? Guid.Empty }; result.Add(item); } }); return(result); } catch (Exception) { throw; } }
public int PutClassification(ABC_ClassificationsDTO obj) { try { int result = 0; SessionManager.DoWork(session => { Guid id = Guid.Empty; if (obj.Id == Guid.Empty) { ABC_Classifications newItem = new ABC_Classifications(); newItem.Id = Guid.NewGuid(); newItem.MinRecord = obj.MinRecord; newItem.MaxRecord = obj.MaxRecord; newItem.Rank = obj.Rank; newItem.IsEligible = obj.IsEligible; newItem.ABC_ClassificationSet = new ABC_ClassificationSet() { Id = obj.ABC_ClassificationSetId }; session.Save(newItem); id = newItem.Id; } else { var objDB = session.Query <ABC_Classifications>().SingleOrDefault(q => q.Id == obj.Id); objDB.MinRecord = obj.MinRecord; objDB.MaxRecord = obj.MaxRecord; objDB.Rank = obj.Rank; objDB.IsEligible = obj.IsEligible; objDB.ABC_ClassificationSet = new ABC_ClassificationSet() { Id = obj.ABC_ClassificationSetId }; session.Update(objDB); id = objDB.Id; } if (obj.IsEligible == true) { var listOther = session.Query <ABC_Classifications>().Where(q => q.ABC_ClassificationSet.Id == obj.ABC_ClassificationSetId && q.Id != id); foreach (var l in listOther) { l.IsEligible = false; session.Update(l); } } result = 1; }); return(result); } catch (Exception) { throw; } }
public int DeleteClassification(ABC_ClassificationsDTO item) { try { SessionManager.DoWork(session => { var obj = session.Query <ABC_Classifications>().SingleOrDefault(q => q.Id == item.Id); if (obj != null) { session.Delete(obj); } }); return(1); } catch (Exception) { throw; } }