/// <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 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 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 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 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 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 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;
}
}
