/// <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 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 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>();
}
}
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 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 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 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 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>();
}
}
/// <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 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>();
}
}
/// <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 the active categories
/// </summary>
/// <returns></returns>
public static 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 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 remove the Category
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public static bool RemoveCategory(int categoryId)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var categoryInfo = nie.CategoryMasters.FirstOrDefault(m => m.ID == categoryId);
if (categoryInfo != null)
categoryInfo.IsActive = false;
nie.SaveChanges();
}
return true;
}
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 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<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>();
}
}
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>();
}
}
/// <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 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>();
}
}
/// <summary>
/// Used to Add or Update Sub Category Data
/// </summary>
/// <param name="subCategoryDataInfoModel"></param>
/// <param name="subCategoryDataId"></param>
/// <returns></returns>
public static bool AddEditSubCategoryData(
SubCategoryDataInfoModel subCategoryDataInfoModel, int subCategoryDataId = 0)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var subCategoryData = new SubCategoryDataMaster();
if (subCategoryDataId != 0)
subCategoryData = nie.SubCategoryDataMasters.FirstOrDefault(m => m.ID == subCategoryDataId);
subCategoryData.IsActive = true;
subCategoryData.Title = subCategoryDataInfoModel.Title;
subCategoryData.Description = subCategoryDataInfoModel.Description;
subCategoryData.IsVisible = subCategoryDataInfoModel.IsVisible;
subCategoryData.SubCategoryId = subCategoryDataInfoModel.SubCategoryId;
subCategoryData.IsSuperAdminApproved = subCategoryDataInfoModel.IsVisible;
if (subCategoryDataId == 0)
{
subCategoryData.SubmittedDate = DateTime.Now;
subCategoryData.SavedTimeStamp = subCategoryDataInfoModel.TimeStamp;
nie.SubCategoryDataMasters.Add(subCategoryData);
}
nie.SaveChanges();
if (subCategoryDataInfoModel.UploadedFileNames != null)
{
var uploadedFiles = new List<SubCategoryDataAttachment>();
if (subCategoryDataId != 0)
{
uploadedFiles =
nie.SubCategoryDataAttachments.Where(m => m.SubCategoryDataID == subCategoryDataId && m.IsActive).ToList();
foreach (var uploadedFile in uploadedFiles)
{
uploadedFile.IsActive = false;
nie.SaveChanges();
}
}
if(subCategoryDataInfoModel.UploadedFileNames!="")
foreach (var fileInfo in subCategoryDataInfoModel.UploadedFileNames.Split(','))
{
// var fileType=
var fileInformation = uploadedFiles.FirstOrDefault(m => m.FileName == fileInfo);
if (fileInformation != null)
fileInformation.IsActive = true;
else
{
nie.SubCategoryDataAttachments.Add(new SubCategoryDataAttachment()
{
FileName = fileInfo,
SubCategoryDataID = subCategoryData.ID,
AttachmentID = Convert.ToInt32(GetAttachmentType(fileInfo)),
IsActive = true,
});
}
nie.SaveChanges();
}
}
return true;
}
}
catch (Exception ex)
{
return false;
}
}
/// <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 save the User Information
/// </summary>
/// <returns></returns>
public static int SaveUserInformation(UserViewModel um, bool requestForPasswordChange, bool isAdminSave,
int? loggedInUser = null)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
if (um.UserId != 0)
{
var userInfo = nie.UserMasters.FirstOrDefault(m => m.Id == um.UserId & m.IsActive);
if (userInfo != null)
{
userInfo.FirstName = um.FirstName;
userInfo.LastName = um.LastName;
userInfo.MiddleName = um.MiddleName;
userInfo.Gender = um.Gender;
// userInfo.Email = um.EmailId;
userInfo.PhoneNumber = um.MobileNumber;
userInfo.DateOfBirth = um.DateOfBirth;
if (requestForPasswordChange)
userInfo.Password = um.Password;
userInfo.Address = um.Address;
userInfo.City = um.City;
userInfo.StateID = um.State;
userInfo.CountryID = um.Country;
userInfo.Pincode = um.PinCode;
userInfo.ModifiedBy = loggedInUser;
userInfo.ModifiedOn = DateTime.Now;
if (isAdminSave)
{
userInfo.RoleId = um.SelectedRoleId;
userInfo.IsEnabled = um.IsEnabled;
}
nie.SaveChanges();
return userInfo.Id;
}
return 0;
}
else
{
var userData = new UserMaster()
{
FirstName = um.FirstName,
LastName = um.LastName,
MiddleName = um.MiddleName,
Gender = um.Gender,
Email = um.EmailId,
Password = um.Password,
PhoneNumber = um.MobileNumber,
Address = um.Address,
City = um.City,
StateID = um.State,
CountryID = um.Country,
Pincode = um.PinCode,
IsActive = true,
CreatedBy = loggedInUser,
CreatedOn = DateTime.Now,
ModifiedBy = loggedInUser,
ModifiedOn = DateTime.Now,
DateOfBirth = um.DateOfBirth
};
if (isAdminSave)
{
userData.RoleId = um.SelectedRoleId;
userData.IsEnabled = um.IsEnabled;
}
else
{
userData.RoleId = 3;
userData.IsEnabled = false;
}
nie.UserMasters.Add(userData);
nie.SaveChanges();
return userData.Id;
}
}
}
catch (Exception ex)
{
return 0;
}
}
/// <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 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 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 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 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>();
}
}
