public PCommissionCouncilAllModel PrintCouncilAll(string searcvalue, SearchType searchtype)
{
try
{
Int64 number = (searchtype == SearchType.FileNumber || searchtype == SearchType.StudentNumber)
? Convert.ToInt64(searcvalue) : 0;
var queryrequest =
_requestRepository.Where(
s => (s.RequestType == RequestType.Council) &&
(searchtype == SearchType.StudentNumber)
? s.Person.Student.StudentNumber == number
: (searchtype == SearchType.StudentNameFamili)
? (s.Person.Profile.Name + " " + s.Person.Profile.Family).Contains(searcvalue)
: (searchtype == SearchType.FileNumber) && s.Council.CouncilNumber == number);
var firstOrDefault = queryrequest.Include(d => d.MemberMaster.MemberDetails).FirstOrDefault();
if (firstOrDefault != null)
{
PCommissionCouncilAllModel query = new PCommissionCouncilAllModel
{
PRequestAllDataModels = _requestRepository.Where(
s => (s.RequestType == RequestType.Council) && (
(searchtype == SearchType.StudentNumber)
? s.Person.Student.StudentNumber == number
: (searchtype == SearchType.StudentNameFamili)
? (s.Person.Profile.Name + " " + s.Person.Profile.Family).Contains(searcvalue)
: (searchtype == SearchType.FileNumber) && s.Council.CouncilNumber == number))
.Select(item => new PRequestAllDataModel
{
Date = item.Council.Date,
StudentNumber = item.Person.Student.StudentNumber,
VoteText = item.Vote == null ? " " : item.Vote.VoteText,
CommissionCouncilNumber = item.Council.CouncilNumber,
NameFamili = item.Person.Profile.Name + " " + item.Person.Profile.Family,
RequestId = item.Id,
Description = item.Council.ProblemText
}).ToList(),
PMemberDetailsModel = firstOrDefault
.MemberMaster.MemberDetails.Select(i => new PMemberDetailsModel
{
PostName = i.PostName,
FullName = i.PersonName,
RowNumber = i.RowNumber
}
).ToList()
};
return(query);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
public PCommissionCouncilAllModel PrintCommissionAll(string searcvalue, SearchType searchtype)
{
try
{
Int64 number = (searchtype == SearchType.FileNumber || searchtype == SearchType.StudentNumber)
? Convert.ToInt64(searcvalue) : 0;
var queryrequest =
_requestRepository.Where(
s => (s.RequestType == RequestType.Comision) &&
(searchtype == SearchType.StudentNumber)
? s.Person.Student.StudentNumber == number
: (searchtype == SearchType.StudentNameFamili)
? (s.Person.Profile.Name + " " + s.Person.Profile.Family).Contains(searcvalue)
: (searchtype == SearchType.FileNumber) && s.Commission.CommissionNumber == number);
var firstOrDefault = queryrequest.Include(d => d.MemberMaster.MemberDetails).FirstOrDefault();
if (firstOrDefault != null)
{
PCommissionCouncilAllModel query = new PCommissionCouncilAllModel
{
PRequestAllDataModels = _requestRepository.Where(
s => (s.RequestType == RequestType.Comision) &&
(searchtype == SearchType.StudentNumber)
? s.Person.Student.StudentNumber == number
: (searchtype == SearchType.StudentNameFamili)
? (s.Person.Profile.Name + " " + s.Person.Profile.Family).Contains(searcvalue)
: (searchtype == SearchType.FileNumber) && s.Commission.CommissionNumber == number)
.Select(item => new PRequestAllDataModel
{
Date = item.Commission.Date,
StudentNumber = item.Person.Student.StudentNumber,
VoteText = item.Vote == null ? " " : item.Vote.VoteText,
CommissionCouncilNumber = item.Commission.CommissionNumber,
NameFamili = item.Person.Profile.Name + " " + item.Person.Profile.Family,
RequestId = item.Id,
PSpecialEducationModel = item.Commission.CommissionSpecialEducations.Select(i =>
new PSpecialEducationModel
{
Name = i.SpecialEducation.Name,
State = true,
Id = i.SpecialEducationId
}).ToList()
}).ToList(),
PMemberDetailsModel = firstOrDefault
.MemberMaster.MemberDetails.Select(i => new PMemberDetailsModel
{
PostName = i.PostName,
FullName = i.PersonName,
RowNumber = i.RowNumber
}
).ToList()
};
if (query.PRequestAllDataModels != null)
{
foreach (PRequestAllDataModel item in query.PRequestAllDataModels)
{
item.Description =
string.Join("\r\n",
item.PSpecialEducationModel.Select(d => d.Name).ToArray());
}
}
return(query);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}