public Result <List <Section> > List(SectionListVM listVM)
{
var table = ConvertDataTableToList.BindList <Section>(_dataSource.List(listVM));
if (table.Count > 0 || table.Count == 0)
{
return(Result <List <Section> > .Successful(data : table));
}
return(Result <List <Section> > .Failure());
}
public List <string> GetBreadCrumbs(SectionListVM model)
{
var parent = model.MessageSections.First().Parent;
if (parent.SysName == MessageSections.Forum)
{
return(new List <string>());
}
return(GetBreadCrumbs(parent, false));
}
public IHttpActionResult List(SectionListVM listVM)
{
try
{
var result = _service.List(listVM);
return(Ok(result));
}
catch (Exception e)
{
return(NotFound());
}
}
public ActionResult Section(int?sectionID, int?pageIndex)
{
var section = MessageSectionService.GetByPK(sectionID);
if (section == null)
{
return(null);
}
if ((section.IsGraduateClubOrChildren) &&
!User.GetOrDefault(x => x.InRole(Role.GraduateClubAccess)))
{
return(BaseView(new PagePart("Доступ только для выпускников")));
}
if (section.Children.Any())
{
var model2 = new SectionListVM {
MessageSections = section.Children
.AsQueryable().IsActive().ToList(),
User = User
};
foreach (var messageSection in model2.MessageSections)
{
messageSection.MessageCount = MessageSectionService
.SectionMessageCounts().GetValueOrDefault(messageSection
.MessageSectionID);
messageSection.LastMessageDate = MessageSectionService
.SectionLastMessageDates().GetValueOrDefault(messageSection
.MessageSectionID);
}
return(View(ViewNames.SectionList, model2));
}
pageIndex = pageIndex ?? 1;
var messages = UserMessageService.GetAll()
.Where(um => um.MessageSectionID == sectionID && um.IsActive)
.OrderByDescending(um =>
um.Children.Max(um2 => (DateTime?)um2.CreateDate)
?? um.CreateDate)
.ToPagedList(pageIndex.Value - 1);
var messageIds = messages.Select(x => x.UserMessageID).ToList();
var messageCounts = UserMessageService
.GetAll(x => messageIds.Contains(x.UserMessageID))
.Select(x => new { x.UserMessageID, x.Children.Count }).ToList()
.ToDictionary(x => x.UserMessageID, x => x.Count);
var model =
new SectionMessageListVM {
Messages = messages,
MessageCounts = messageCounts,
Section = section,
};
return(View(ViewNames.MessageList, model));
}
public DataTable List(SectionListVM listVM)
{
try
{
var param = new SqlParameter[3];
param[0] = new SqlParameter("Name", SqlDbType.NVarChar);
param[0].Value = listVM.Name != null ? (object)listVM.Name : DBNull.Value;
param[1] = new SqlParameter("ProvinceType", SqlDbType.TinyInt);
param[1].Value = listVM.ProvinceType != ProvinceType.نامشخص ? (object)listVM.ProvinceType : DBNull.Value;
param[2] = new SqlParameter("CountryType", SqlDbType.TinyInt);
param[2].Value = listVM.CountryType != CountryType.نامشخص ? (object)listVM.CountryType : DBNull.Value;
return(SQLHelper.GetDataTable(CommandType.StoredProcedure, "app.spGetsSection", param));
}
catch (Exception e) { throw; }
}