public IEnumerable <ScienceResearchDTO> GetListByPlanDetail(Guid Id)
{
var result = new List <ScienceResearchDTO>();
SessionManager.DoWork(session =>
{
List <ScienceResearch> list = session.Query <ScienceResearch>().Where(d => d.PlanKPIDetail.Id == Id).ToList();
foreach (ScienceResearch kpi in list)
{
ScienceResearchDTO k = new ScienceResearchDTO();
k.Id = kpi.Id;
k.Name = kpi.CriterionDictionary != null ? kpi.CriterionDictionary.Name : kpi.Name;
k.PlanKPIDetailId = kpi.PlanKPIDetail != null ? kpi.PlanKPIDetail.Id : Guid.Empty;
k.CriterionDictionary = kpi.CriterionDictionary != null ? new CriterionDictionaryDTO()
{
Id = kpi.CriterionDictionary.Id, Name = kpi.CriterionDictionary.Name
} : null;
k.CriterionDictionaryId = kpi.CriterionDictionary != null ? kpi.CriterionDictionary.Id : Guid.Empty;
k.NumberOfResearch = kpi.NumberOfResearch;
k.OrderNumber = kpi.OrderNumber;
k.IsRating = kpi.IsRating;
result.Add(k);
}
result = result.OrderBy(p => p.OrderNumber).ToList();
});
return(result);
}
public ScienceResearchDTO GetObj(Guid id)
{
var result = new ScienceResearchDTO();
SessionManager.DoWork(session =>
{
ScienceResearch sr = session.Query <ScienceResearch>().SingleOrDefault(a => a.Id == id);
if (sr != null)
{
result.Id = sr.Id;
result.Name = sr.Name;
result.PlanKPIDetailId = sr.PlanKPIDetail != null ? sr.PlanKPIDetail.Id : Guid.Empty;
result.CriterionDictionaryId = sr.CriterionDictionary != null ? sr.CriterionDictionary.Id : Guid.Empty;
result.NumberOfResearch = sr.NumberOfResearch;
result.OrderNumber = sr.OrderNumber;
result.IsRating = sr.IsRating;
}
});
return(result);
}
public int Put(ScienceResearchDTO obj)
{
int result = 0;
//try
//{
SessionManager.DoWork(session =>
{
if (obj.CriterionDictionaryId == Guid.Empty)
{
if (obj.Id == Guid.Empty)
{
ScienceResearch pa = new ScienceResearch();
pa.Id = Guid.NewGuid();
pa.Name = obj.Name;
pa.NumberOfResearch = obj.NumberOfResearch;
pa.OrderNumber = obj.OrderNumber;
pa.IsRating = obj.IsRating;
pa.PlanKPIDetail = new PlanKPIDetail()
{
Id = obj.PlanKPIDetailId
};
pa.CriterionDictionary = null;
session.Save(pa);
}
else
{
ScienceResearch pa = new ScienceResearch();
pa.Id = obj.Id;
pa.Name = obj.Name;
pa.NumberOfResearch = obj.NumberOfResearch;
pa.OrderNumber = obj.OrderNumber;
pa.IsRating = obj.IsRating;
pa.PlanKPIDetail = new PlanKPIDetail()
{
Id = obj.PlanKPIDetailId
};
pa.CriterionDictionary = null;
session.Update(pa);
}
}
else
{
ScienceResearch pa = new ScienceResearch();
pa.Id = obj.Id;
pa.Name = obj.Name;
pa.NumberOfResearch = obj.NumberOfResearch;
pa.IsRating = obj.IsRating;
pa.PlanKPIDetail = new PlanKPIDetail()
{
Id = obj.PlanKPIDetailId
};
pa.CriterionDictionary = new CriterionDictionary()
{
Id = obj.CriterionDictionaryId
};
session.Update(pa);
}
result = 1;
});
//}
//catch (Exception e)
//{
// result = 0;
//}
return(result);
}
