/// <summary>
/// Used to get the list of all the SubCategory Data
/// </summary>
/// <param name="subCategoryDataId"></param>
public static List <SubCategoryDataTableModel> GetSubCategoryDataList(int subCategoryDataId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.SubCategoryDataMasters.Where(m => m.IsActive && (subCategoryDataId == 0 || m.SubCategoryId == subCategoryDataId))
.Select(m => new SubCategoryDataTableModel()
{
CategoryName = m.SubCategoryMaster.CategoryMaster.CategoryName,
IsCategoryActive = m.SubCategoryMaster.CategoryMaster.IsActive,
IsCategoryVisible = m.SubCategoryMaster.CategoryMaster.IsVisible,
IsVisible = m.IsVisible,
IsSubCategoryActive = m.SubCategoryMaster.IsActive,
IsSubCategoryVisible = m.SubCategoryMaster.IsVisible,
SubCategoryName = m.SubCategoryMaster.SubCategoryName,
SubCategoryDataId = m.ID,
SubCategoryDataTitle = m.Title,
SubCategoryDataShowing = (m.IsVisible && m.SubCategoryMaster.IsActive && m.SubCategoryMaster.IsVisible && m.SubCategoryMaster.CategoryMaster.IsVisible && m.SubCategoryMaster.CategoryMaster.IsActive)
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <SubCategoryDataTableModel>());
}
}
/// <summary>
/// used to save the category info in the database
/// </summary>
/// <param name="categoryId"></param>
/// <param name="categoryName"></param>
/// <param name="isVisible"></param>
/// <returns></returns>
public static bool SaveCategoryInfo(int categoryId, string categoryName, bool isVisible)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var categoryMaster = nie.CategoryMasters.FirstOrDefault(m => m.ID == categoryId);
if (categoryMaster != null)
{
categoryMaster.CategoryName = categoryName;
categoryMaster.IsVisible = isVisible;
}
else
{
categoryMaster = new CategoryMaster()
{
CategoryName = categoryName,
IsVisible = isVisible,
IsActive = true
};
nie.CategoryMasters.Add(categoryMaster);
}
nie.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to activate the user account
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public static UserActivationModel ActivateUser(string uid)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var guidInfo = nie.AuthenticationLinks.FirstOrDefault(m => m.UnqiueLink == uid && !m.IsUsed);
if (guidInfo != null && guidInfo.VerificationTypeId == 1)
{
var userInfo = nie.UserMasters.FirstOrDefault(m => m.Id == guidInfo.UserId);
if (userInfo != null)
{
userInfo.IsEnabled = true;
guidInfo.IsUsed = true;
nie.SaveChanges();
return(new UserActivationModel()
{
UserId = userInfo.Id,
UserName = userInfo.FirstName + (userInfo.MiddleName == null ? ("") : " " + userInfo.MiddleName) + " " + userInfo.LastName
});
}
}
return(new UserActivationModel());
}
}
catch (Exception ex)
{
return(new UserActivationModel());
}
}
/// <summary>
/// Used to get List of the subCategory
/// </summary>
/// <returns></returns>
public static List <SubCategoryModel> GetSubCategoryListView(int subCategory = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.SubCategoryDataMasters.Where(m => m.SubCategoryId == subCategory && m.IsVisible && m.IsActive).Select(
m => new SubCategoryModel()
{
Title = m.Title,
Description = m.Description,
SubCategoryDataId = m.ID,
Attachments = m.SubCategoryDataAttachments.Where(c => c.SubCategoryDataID == m.ID).Select(
c => new SubCategoryAttachment()
{
FileName = c.FileName,
FileType = (AttachmentType)c.AttachmentID,
SubCategoryAttachmentId = c.ID
}).ToList()
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <SubCategoryModel>());
}
}
/// <summary>
/// Used to save the subCategory Information
/// </summary>
/// <param name="subCategoryId"></param>
/// <param name="subCategoryName"></param>
/// <param name="isVisible"></param>
/// <param name="categoryId"></param>
/// <returns></returns>
public static bool SaveSubCategoryInfo(int subCategoryId, string subCategoryName, bool isVisible, int categoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var subCategoryMaster = nie.SubCategoryMasters.FirstOrDefault(m => m.ID == subCategoryId);
if (subCategoryMaster != null)
{
subCategoryMaster.SubCategoryName = subCategoryName;
subCategoryMaster.IsVisible = isVisible;
subCategoryMaster.CategoryID = categoryId;
}
else
{
subCategoryMaster = new SubCategoryMaster()
{
SubCategoryName = subCategoryName,
IsVisible = isVisible,
IsActive = true,
CategoryID = categoryId
};
nie.SubCategoryMasters.Add(subCategoryMaster);
}
nie.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to get the list of all the SubCategories
/// </summary>
/// <param name="categoryId"></param>
public static List <SubCategoryTableModel> GetSubCategoryList(int categoryId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.SubCategoryMasters.Where(m => m.IsActive && (categoryId == 0 || m.CategoryID == categoryId))
.Select(m => new SubCategoryTableModel()
{
SubCategoryName = m.SubCategoryName,
IsVisible = m.IsVisible,
SubCategoryId = m.ID,
CategoryName = m.CategoryMaster.IsActive?m.CategoryMaster.CategoryName:"-",
SubCategoryShowing = (m.IsVisible && m.CategoryMaster.IsVisible && m.CategoryMaster.IsActive),
IsCategoryVisible = m.CategoryMaster.IsVisible,
IsCategoryActive = m.CategoryMaster.IsActive
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <SubCategoryTableModel>());
}
}
/// <summary>
/// Used to get the lastest 10 news to display in the breaking news
/// </summary>
/// <returns></returns>
public static List <SubCategoryModel> GetLatestNews()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.SubCategoryDataMasters.Where(m => m.IsVisible).OrderByDescending(m => m.SubmittedDate).Take(10).Select(
m => new SubCategoryModel()
{
Title = m.Title,
Description = m.Description,
SubCategoryDataId = m.ID,
Attachments = m.SubCategoryDataAttachments.Where(c => c.SubCategoryDataID == m.ID).Select(
c => new SubCategoryAttachment()
{
FileName = c.FileName,
FileType = (AttachmentType)c.AttachmentID,
SubCategoryAttachmentId = c.ID
}).ToList()
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <SubCategoryModel>());
}
}
/// <summary>
/// Used to get users information for grid
/// </summary>
/// <returns></returns>
public static List <UserModelGrid> GetUsersForMasterGrid()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var adminRoleId = nie.UserRoles.FirstOrDefault(m => m.Name == "admin") ?? new UserRole()
{
Id = 0
};
return(nie.UserMasters.Where(m => m.IsActive).Select(m => new UserModelGrid()
{
EmailId = m.Email,
FirstName = m.FirstName,
LastName = m.LastName,
IsAdmin = m.RoleId == adminRoleId.Id,
MiddleName = m.MiddleName,
PhoneNumber = m.PhoneNumber,
RoleId = m.RoleId,
UserId = m.Id
}).ToList());
}
}
catch (Exception ex)
{
return(new List <UserModelGrid>());
}
}
/// <summary>
/// Used to get the sub category data information
/// </summary>
/// <param name="subCategoryId"></param>
/// <returns></returns>
public static SubCategoryDataInfoModel GetSubCategoryDataInformation(int subCategoryId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var info = nie.SubCategoryDataMasters.FirstOrDefault(m => m.ID == subCategoryId);
var subCategoryData = new SubCategoryDataInfoModel()
{
Description = info.Description,
SubCategoryDataId = info.ID,
Title = info.Title,
IsVisible = info.IsVisible,
SubCategoryId = info.SubCategoryId,
TimeStamp = info.SavedTimeStamp,
CategoryId = info.SubCategoryMaster.CategoryID,
Files = info.SubCategoryDataAttachments.Where(m => m.IsActive).Select(c => c.FileName).ToList()
//Attachments =
// UploadedFileNames =
};
foreach (var attachment in info.SubCategoryDataAttachments.Where(m => m.IsActive))
{
subCategoryData.UploadedFileNames += attachment.FileName.Split('\\')[1] + ",";
}
return(subCategoryData);
}
}
catch (Exception ex)
{
return(new SubCategoryDataInfoModel());
}
}
/// <summary>
/// Used to get the active categories
/// </summary>
/// <returns></returns>
public static List <UserMaster> GetActiveUsers()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.UserMasters.Where(m => m.IsActive).ToList());
}
}
catch (Exception ex)
{
return(new List <UserMaster>());
}
}
/// <summary>
/// Used to check if the email address exist in database
/// </summary>
/// <param name="emailId"></param>
/// <returns></returns>
public static bool IsEmailExist(string emailId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.UserMasters.Any(m => m.Email == emailId & m.IsActive));
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to get the Information about the side banner
/// </summary>
/// <returns></returns>
public static List <SideBannerMaster> GetSideBanner()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.SideBannerMasters.Where(m => m.IsActive && m.IsVisible).ToList());
}
}
catch (Exception ex)
{
return(new List <SideBannerMaster>());
}
}
public static SubCategoryModel GetSubCategoryData(int subCategoryDataId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
//var subCategoryData = nie.SubCategoryDataMasters.FirstOrDefault(m => m.ID == subCategoryDataId && m.IsVisible);
//var categoryDataModel = new SubCategoryModel()
//{
// Title = subCategoryData.Title,
// Description = subCategoryData.Description,
// SubCategoryDataId = subCategoryData.ID,
// Attachments = new List<SubCategoryAttachment>()
//};
//foreach (var attachment in nie.SubCategoryDataAttachments.Where(m => m.SubCategoryDataID == subCategoryData.ID))
//{
// var attachmentInfo= new SubCategoryAttachment()
// {
// FileName = attachment.FileName,
// FileType = (AttachmentType)attachment.AttachmentID,
// SubCategoryAttachmentId = attachment.ID
// };
// categoryDataModel.Attachments.Add(attachmentInfo);
//}
//return categoryDataModel;
var subcategoryInfo =
nie.SubCategoryDataMasters.FirstOrDefault(m => m.ID == subCategoryDataId && m.IsVisible);
return(new SubCategoryModel()
{
Description = subcategoryInfo.Description,
SubCategoryDataId = subcategoryInfo.ID,
Title = subcategoryInfo.Title,
Attachments = subcategoryInfo.SubCategoryDataAttachments.Select(m => new SubCategoryAttachment()
{
FileName = m.FileName,
FileType = (AttachmentType)m.AttachmentID,
SubCategoryAttachmentId = m.ID
}).ToList()
});
}
}
catch (Exception ex)
{
return(new SubCategoryModel());
}
}
/// <summary>
/// Used to get Information about SubCategory
/// </summary>
/// <param name="subCategoryId"></param>
/// <returns></returns>
public static string GetSubCategoryInformation(int subCategoryId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.SubCategoryMasters.FirstOrDefault(m => m.ID == subCategoryId).SubCategoryName);
}
}
catch (Exception ex)
{
return("");
}
}
/// <summary>
/// Used to check if the category Name is Already present
/// </summary>
/// <param name="categoryName"></param>
/// <param name="categoryId"></param>
/// <returns></returns>
public static bool CheckCategoryName(string categoryName, int categoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.CategoryMasters.Any(m => m.IsActive && m.CategoryName == categoryName && m.ID != categoryId));
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to get the information of the Category
/// </summary>
/// <returns></returns>
public static CategoryMaster GetCategoryInfo(int categoryId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.CategoryMasters.FirstOrDefault(m => m.IsActive && m.ID == categoryId));
}
}
catch (Exception ex)
{
return(new CategoryMaster());
}
}
/// <summary>
/// Used to check if the Subcategory Already exist
/// </summary>
/// <param name="subCategoryName"></param>
/// <param name="subCategoryId"></param>
/// <param name="categoryId"></param>
/// <returns></returns>
public static bool CheckSubCategoryName(string subCategoryName, int subCategoryId, int categoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.SubCategoryMasters.Any(
m =>
m.SubCategoryName == subCategoryName && (subCategoryId == 0 || m.ID != subCategoryId) &&
m.CategoryMaster.ID == categoryId && m.IsActive));
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to get List of the subCategory
/// </summary>
/// <returns></returns>
public static UserMaster GetLoginInfo(LoginInfo loginInfo)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var userInfo =
nie.UserMasters.FirstOrDefault(
m => m.Email == loginInfo.UserName && m.Password == loginInfo.Password && m.IsActive);
return(userInfo);
}
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Used to get the information of the SubCategory
/// </summary>
/// <returns></returns>
public static SubCategoryMaster GetSubCategoryInfo(int subCategoryId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var subCategoryInfo = nie.SubCategoryMasters.FirstOrDefault(m => m.ID == subCategoryId && m.IsActive);
if (subCategoryInfo != null && !subCategoryInfo.CategoryMaster.IsActive)
{
subCategoryInfo.CategoryID = 0;
}
return(subCategoryInfo);
}
}
catch (Exception ex)
{
return(new SubCategoryMaster());
}
}
/// <summary>
/// Used to Get all the roles available except super admin
/// </summary>
/// <returns></returns>
public static List <RoleInformation> GetRoles()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.UserRoles.Where(m => m.Id != 1 && m.IsActive)
.Select(m => new RoleInformation()
{
RoleId = m.Id, RoleName = m.Name
}).ToList());
}
}
catch (Exception ex)
{
return(new List <RoleInformation>());
}
}
public static List <StateMaster> GetStateList()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.States.Where(m => m.IsActive).Select(
m => new StateMaster()
{
StateId = m.StateId,
StateName = m.StateName,
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <StateMaster>());
}
}
/// <summary>
/// Used to get state information based on country id
/// </summary>
/// <returns></returns>
public static List <StateInformation> GetStateByCountry(int countryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.States.Where(m => m.IsActive && m.CountryId == countryId).Select(
m => new StateInformation()
{
StateId = m.StateId,
StateName = m.StateName,
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <StateInformation>());
}
}
public static List <CountryMaster> GetCountryList()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.Countries.Where(m => m.IsActive).Select(
m => new CountryMaster()
{
CountryId = m.CountryId,
CountryName = m.CountryName,
}
).ToList());
}
}
catch (Exception ex)
{
return(new List <CountryMaster>());
}
}
List <ActiveCategory> GetActiveCategories()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.CategoryMasters.Where(m => m.IsActive)
.Select(m => new ActiveCategory()
{
CategoryName = m.CategoryName, CategoryId = m.ID
})
.ToList());
}
}
catch (Exception ex)
{
return(new List <ActiveCategory>());
}
}
/// <summary>
/// Used to get the list of all the subCatgories present under the category
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public static List <SubCategoryInformation> GetSubCategories(int categoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return
(nie.SubCategoryMasters.Where(m => m.CategoryID == categoryId && m.IsActive)
.Select(m => new SubCategoryInformation()
{
SubCategoryId = m.ID,
SubCategoryName = m.SubCategoryName
}).ToList());
}
}
catch (Exception ex)
{
return(new List <SubCategoryInformation>());
}
}
/// <summary>
/// Used to remove the SubCategory
/// </summary>
/// <param name="subCategoryId"></param>
/// <returns></returns>
public static bool RemoveSubCategory(int subCategoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var subCategoryInfo = nie.SubCategoryMasters.FirstOrDefault(m => m.ID == subCategoryId);
if (subCategoryInfo != null)
{
subCategoryInfo.IsActive = false;
}
nie.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to get user by id
/// </summary>
/// <returns></returns>
public static UserViewModel GetUserById(int userId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var um = nie.UserMasters.FirstOrDefault(m => m.Id == userId && m.IsActive);
return(new UserViewModel()
{
UserId = um.Id,
FirstName = um.FirstName,
LastName = um.LastName,
MiddleName = um.MiddleName,
Gender = um.Gender,
EmailId = um.Email,
//Password = um.Password,
MobileNumber = um.PhoneNumber,
Address = um.Address,
City = um.City,
// StateName = um.State,
//CountryName = um.Country,
State = um.StateID,
Country = um.CountryID,
PinCode = um.Pincode,
IsActive = um.IsActive,
CreatedBy = um.CreatedBy,
CreatedOn = um.CreatedOn,
ModifiedBy = um.ModifiedBy,
ModifiedOn = um.ModifiedOn,
DateOfBirth = Convert.ToDateTime(um.DateOfBirth),
IsEnabled = Convert.ToBoolean(um.IsEnabled),
SelectedRoleId = um.RoleId
});
}
}
catch (Exception ex)
{
return(new UserViewModel());
}
}
/// <summary>
/// used to create authentication link for the authentication
/// </summary>
/// <param name="uid"></param>
/// <param name="authenticationTypeId"></param>
/// <returns></returns>
public static bool CreateAuthenticationLink(string uid, int authenticationTypeId, int userId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
nie.AuthenticationLinks.Add(new AuthenticationLink()
{
IsUsed = false,
UnqiueLink = uid,
UserId = userId,
VerificationTypeId = authenticationTypeId
});
nie.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Used to Remove user
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static bool RemoveUser(int userId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var user = nie.UserMasters.FirstOrDefault(m => m.Id == userId);
if (user != null)
{
user.IsActive = false;
}
nie.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
;
}
}
/// <summary>
/// Used to get menu for layout
/// </summary>
/// <returns></returns>
public static List <Category> GetMenuList()
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
return(nie.CategoryMasters.Where(m => m.IsActive && m.IsVisible).Select(menu => new Category()
{
CategoryName = menu.CategoryName,
CategoryId = menu.ID,
SubCategory =
menu.SubCategoryMasters.Where(m => m.CategoryID == menu.ID && m.IsActive && m.IsVisible).Select(n => new SubCategory()
{
SubCategoryId = n.ID,
SubCategoryName = n.SubCategoryName
}).ToList()
}).ToList());
}
}
catch (Exception ex)
{
return(new List <Category>());
}
}
