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