/// <summary>
/// Not in use
/// </summary>
/// <param name="error"></param>
public void LogError(ErrorLog error)
{
var _context = new DeluxeOrderManagementEntities();
_context.ErrorLogs.Add(error);
_context.SaveChanges();
}
/// <summary>
/// Populate dropdown values on create order page
/// </summary>
/// <returns></returns>
public TerritoryLanguage GetDropDownValue()
{
var _context = new DeluxeOrderManagementEntities();
TerritoryLanguage territoryLanguage = new TerritoryLanguage();
var orderCategory = (from og in _context.OrderGrids
where !string.IsNullOrEmpty(og.Category)
select og.Category.ToString()
).Distinct().ToList();
var territory = _context.Territories.Select(x => new DeluxeOM.Models.Territory()
{
TerritoryID = x.Id,
TerritoryName = x.WBTerritory
}).Distinct().OrderBy(x => x.TerritoryName).ToList();
var language = _context.Languages.Select(x => new DeluxeOM.Models.Language()
{
LanguageID = x.Id,
LanguageName = x.Name
}).Distinct().OrderBy(x => x.LanguageName).ToList();
var title = _context.VIDs.Select(x => new DeluxeOM.Models.Title()
{
VideoVersion = x.VideoVersion,
Name = x.TitleName
}).GroupBy(x => x.VideoVersion).Select(g => g.FirstOrDefault()).OrderBy(x => x.Name).ToList();
var orderTypes = _context.OrderGrids.Where(x => x.FileType != null).Select(x => x.FileType.ToString()).Distinct().ToList();
territoryLanguage.Territory = territory;
territoryLanguage.Language = language;
territoryLanguage.Title = title;
territoryLanguage.orderCategory = orderCategory;
territoryLanguage.OrderTypes = orderTypes;
return(territoryLanguage);
}
public bool IsFileExists(string fileName)
{
using (var _context = new DeluxeOrderManagementEntities())
{
return(_context.JOBS.Any(x => x.FileName == fileName && (x.Status.HasValue && x.Status.Value)));
}
}
public TerritoryLanguage GetDropDownValue()
{
var _context = new DeluxeOrderManagementEntities();
TerritoryLanguage territoryLanguage = new TerritoryLanguage();
var orderCategory = (from og in _context.OrderGrids
where !string.IsNullOrEmpty(og.Category)
select og.Category.ToString()
).Distinct().ToList();
var territory = _context.Territories.Select(x => new DeluxeOM.Models.Territory()
{
TerritoryID = x.Id,
TerritoryName = x.WBTerritory
}).Distinct().OrderBy(x => x.TerritoryName).ToList();
var language = _context.Languages.Select(x => new DeluxeOM.Models.Language()
{
LanguageID = x.Id,
LanguageName = x.Name
}).Distinct().OrderBy(x => x.LanguageName).ToList();
var title = _context.AnnouncementGrids.Select(x => new DeluxeOM.Models.Title()
{
//TitleID = x.Id,
Name = x.Title
}).Distinct().OrderBy(x => x.Name).ToList();
territoryLanguage.Territory = territory;
territoryLanguage.Language = language;
territoryLanguage.Title = title;
territoryLanguage.orderCategory = orderCategory;
return(territoryLanguage);
}
/// <summary>
/// Import VID list into system
/// </summary>
/// <param name="filePath">downloaded file path</param>
/// <param name="userId">current userId</param>
/// <returns>Validation result from BulkUpdate_Validations table</returns>
public List <ImportValidationResult> Import(string filePath, int userId)
{
var _context = new DeluxeOrderManagementEntities();
var fileParam = new SqlParameter
{
ParameterName = "filePath",
Value = filePath
};
var userParam = new SqlParameter
{
ParameterName = "userId",
Value = userId
};
return(_context.Database.SqlQuery <BulkUpdate_Validations>("exec usp_IMPORT_VID @filePath, @userId", fileParam, userParam)
.Select(x =>
new ImportValidationResult
{
Id = x.KeyId,
ColumnName = x.ColumnName,
ColumnValue = x.ColumnValue,
ValidationLevel = x.ValidationLevel,
ValidationMessage = x.ValidationMessage
}).ToList <ImportValidationResult>());
}
/// <summary>
/// Unlock order
/// </summary>
/// <param name="orderId">Order to unlock</param>
/// <param name="userId">Current userId</param>
/// <remark>This method unlock order for other user on click of save or cancel order</remark>
public void UnlockOrder(int?orderId, int userId)
{
var _context = new DeluxeOrderManagementEntities();
if (orderId != null)
{
var order = _context.OrderGrids.Where(x => x.Id == orderId && x.LockedBy == userId).FirstOrDefault();
if (order != null)
{
order.IsLocked = false;
order.LockedBy = null;
order.LockedOn = null;
}
}
else
{
var order = _context.OrderGrids.Where(x => x.LockedBy == userId).ToList();
foreach (var o in order)
{
o.IsLocked = false;
o.LockedBy = null;
o.LockedOn = null;
}
}
_context.SaveChanges();
}
public List <TitleList> SearchTitles(string whrSQLquery)
{
var _context = new DeluxeOrderManagementEntities();
var titles = _context.usp_Search_Title(whrSQLquery).Select(x =>
new TitleList
{
TitleName = x.TitleName,
vendorID = x.VendorId,
VIDType = x.VIDStatus,
Territory = x.AppleTerritory,
ApplePOESTStartDate = x.POESTStartDate,
AppleESTStartDate = x.ESTStartDate,
AppleESTEndDate = x.ESTEndDate,
ESTHDLiveStatus = x.LiveESTHD,
ESTSDLiveStatus = x.LiveESTSD,
AppleVODStartDate = x.VODStartDate,
AppleVODEndDate = x.VODEndDate,
VODHDLiveStatus = x.LiveVODHD,
VODSDLiveStatus = x.LiveVODSD,
AnnouncementPOESTStartDate = x.AnnPOESTStartDate,
AnnouncementESTStartDate = x.AnnESTStartDate,
AnnouncementESTEndDate = x.AnnESTEndDate,
AnnouncementVODStartDate = x.AnnVODStartDate,
AnnouncementVODEndDate = x.AnnVODEndDate,
ComponentType = x.ComponentType,
ComponentQuality = x.ComponentQuality,
Language = x.LanguageName,
LanguageType = x.LanguageType,
LanguageStatus = x.LanguageStatus
}).Distinct().ToList();
return(titles);
}
public UserModel VerifyPasswordReset(string token)
{
UserModel userEty = null;
DateTime utctime = DateTime.UtcNow;
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var prety = _acoubntContext.PasswordResetModels
.Include("User")
.Include("User.UserPasswords")
.Include("User.UserRoles")
.Include("User.UserRoles.Role")
.Include("User.UserRoles.Role.RolePrivs")
.Include("User.UserRoles.Role.RolePrivs.Privilege")
.FirstOrDefault(x => x.Token == token && x.ExpireDateTime >= utctime && (x.User != null && x.User.Active == true));
userEty = prety != null ? prety.User : null;
//var user = (from pr in _acoubntContext.PasswordResetEntities
// join u in _acoubntContext.UserEntities on pr.UserId equals u.UserId
// where pr.Token == token && pr.ExpireDateTime >= utctime && u.Active
// select u);
}
return(userEty);
}
public Order SearchEditOrder(string whrSQLquery)
{
var _context = new DeluxeOrderManagementEntities();
var order = _context.usp_Get_Orders(whrSQLquery, string.Empty).Select(x =>
new Order
{
AnnouncemntId = x.AnnouncementId,
OrderId = x.OrderID,
//VId = x.VId,
Title = x.Title,
OrderStatus = x.OrderStatus,
OrderCategory = x.Category,
Region = x.Region,
Territory = x.Territory,
Language = x.Language,
RequestNumber = x.RequestNumber,
MPO = x.MPO,
HALID = x.HALID,
VendorId = x.VendorId,
FirstAnnouncementDate = x.FirstAnnouncedDate != null ? x.FirstAnnouncedDate.Value.ToString("MM/dd/yyyy") : null,
DueDate = x.DeliveryDueDate != null ? x.DeliveryDueDate.Value.ToString("MM/dd/yyyy") : null,
GreenlightSent = x.GreenlightSenttoPackaging != null ? x.GreenlightSenttoPackaging.Value.ToString("MM/dd/yyyy") : null,
GreenlightReceived = x.GreenlightValidatedbyDMDM != null ? x.GreenlightValidatedbyDMDM.Value.ToString("MM/dd/yyyy") : null,
DeliveryDate = x.ActualDeliveryDate != null ? x.ActualDeliveryDate.Value.ToString("MM/dd/yyyy") : null,
AssetRequired = x.LanguageType,
ESTUPC = x.ESTUPC,
VODUPC = x.IVODUPC,
LockedBy = x.LockedBy,
LockedOn = x.LockedOn,
IsLocked = x.IsLocked
//OrderType=x.OrderType
}).FirstOrDefault();
return(order);
}
public NotificationEntity GetNotificationMessage(JobNotificationType notificationType)
{
string type = string.Empty;
switch (notificationType)
{
case JobNotificationType.LoadAnnouncementNotification:
type = "LoadAnnounceemnt";
break;
case JobNotificationType.LoadPriceReportNotification:
type = "LoadPriceReport";
break;
case JobNotificationType.LoadQCReportNotification:
type = "LoadQCReport";
break;
case JobNotificationType.LoadPipelineOrderNotification:
type = "LoadPipelineOrder";
break;
case JobNotificationType.NewTitlesNotification:
type = "NewTitles";
break;
}
using (var _context = new DeluxeOrderManagementEntities())
{
var nfnEty = _context.NotificationEntities
.FirstOrDefault(x => x.Type == type);
return(nfnEty);
}
}
/// <summary>
/// Populate all dropdown value on VID page and render view
/// </summary>
/// <returns>VID Search</returns>
public VIDSearch GetSearchValue()
{
var _context = new DeluxeOrderManagementEntities();
var titleName = (from vid in _context.VIDs
where !string.IsNullOrEmpty(vid.TitleName)
select vid.TitleName
).Distinct().OrderBy(x => x).ToList();
var vendorId = (from vid in _context.VIDs
where !string.IsNullOrEmpty(vid.VendorId)
select vid.VendorId
).Distinct().OrderBy(x => x).ToList();
var videoVersion = (from vid in _context.VIDs
where !string.IsNullOrEmpty(vid.VideoVersion)
select vid.VideoVersion
).Distinct().OrderBy(x => x).ToList();
var vidSatus = (from vid in _context.VIDs
where !string.IsNullOrEmpty(vid.VIDStatus)
select vid.VIDStatus
).Distinct().OrderBy(x => x).ToList();
VIDSearch vidSeach = new VIDSearch();
vidSeach.TitleList = titleName.Select(x => new KeyValue {
Text = x, Value = x
}).ToList();
vidSeach.VendorIdList = vendorId.Select(x => new KeyValue {
Text = x, Value = x
}).ToList();
vidSeach.VideoVersionList = videoVersion.Select(x => new KeyValue {
Text = x, Value = x
}).ToList();
vidSeach.ListVidStatus = vidSatus.Select(x => new KeyValue {
Text = x, Value = x
}).ToList();
return(vidSeach);
}
/// <summary>
/// Check whether announcemnet is already processed or not
/// </summary>
/// <param name="fileName">Announcement file name</param>
/// <returns>True if announcement is already processed else Fasle</returns>
public bool IsAnnouncementProcessed(string fileName)
{
using (var _context = new DeluxeOrderManagementEntities())
{
return(_context.JOBS.Any(x => x.FileName == fileName && x.JobType == "Announcement" && (x.Status.HasValue && x.Status.Value)));
}
}
public bool ForgotPassword(PasswordResetModel prEntity)
{
bool bresult = false;
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var ety = _acoubntContext.UserModels.FirstOrDefault(e => e.Email == prEntity.Email && e.Active == true);
if (ety != null)
{
//Max
ety.LoginAttempts = 99;
_acoubntContext.Entry(ety).State = System.Data.Entity.EntityState.Modified;
prEntity.UserId = ety.UserId;
_acoubntContext.PasswordResetModels.Add(prEntity);
_acoubntContext.Entry(prEntity).State = System.Data.Entity.EntityState.Added;
_acoubntContext.SaveChanges();
prEntity.UserId = ety.UserId;
prEntity.Email = ety.Email;
bresult = true;
}
}
return(bresult);
}
/// <summary>
/// Log corresponding task of job into Jobs_Item table
/// </summary>
/// <param name="jobItem"></param>
public void JobItemLog(Jobs_Items jobItem)
{
var _jobContext = new DeluxeOrderManagementEntities();
_jobContext.Jobs_Items.Add(jobItem);
_jobContext.SaveChanges();
}
/// <summary>
/// Log current job into JOB table
/// </summary>
/// <param name="job"></param>
/// <returns>jonID</returns>
public int JobLog(JOB job)
{
var _jobContext = new DeluxeOrderManagementEntities();
_jobContext.JOBS.Add(job);
_jobContext.SaveChanges();
return(job.Id);
}
/// <summary>
/// Add Title in VID
/// </summary>
/// <param name="vid">This consists of all the required information need to form VID object which is further inserted into the database</param>
/// <returns>Save Result</returns>
public SaveResult Save(VID vid)
{
var _context = new DeluxeOrderManagementEntities();
_context.VIDs.Add(vid);
_context.SaveChanges();
return(new SaveResult());
}
/// <summary>
/// Get all job executed from database
/// </summary>
/// <returns>List of Job</returns>
public List <JOB> GetAll()
{
using (var _context = new DeluxeOrderManagementEntities())
{
var jobEty = _context.JOBS.OrderByDescending(x => x.Id)
.ToList();
return(jobEty);
}
}
public void Save(UserModel user)
{
using (var _context = new DeluxeOrderManagementEntities())
{
_context.UserModels.Add(user);
_context.Entry(user).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
}
/// <summary>
/// Not in use
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JOB GetById(int id)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var jobety = _context.JOBS
.FirstOrDefault(x => x.Id == id);
return(jobety);
}
}
public List <RoleModel> GetRoles()
{
using (var _context = new DeluxeOrderManagementEntities())
{
var roleety = _context.RoleModels
.Where(x => x.RoleName.ToLower() != "root" && x.Active)
.ToList();
return(roleety);
}
}
/// <summary>
/// Search VID by Video version
/// </summary>
/// <param name="videoVersion"></param>
/// <returns>List of VID</returns>
public List <VID> GetVIDByVideoVersion(string videoVersion)
{
var _context = new DeluxeOrderManagementEntities();
var vid = (from v in _context.VIDs
where v.VideoVersion == videoVersion
select v
).Distinct().ToList();
return(vid);
}
/// <summary>
/// Update current Job
/// </summary>
/// <param name="job"></param>
public void UpdateJobLog(JOB job)
{
var _jobContext = new DeluxeOrderManagementEntities();
var jobUpdate = _jobContext.JOBS.Where(x => x.Id == job.Id).FirstOrDefault();
jobUpdate.Status = job.Status;
jobUpdate.Description = job.Description;
jobUpdate.FileName = job.FileName;
_jobContext.SaveChanges();
}
/// <summary>
/// Lock order
/// </summary>
/// <param name="orderId">Order to lock</param>
/// <param name="userId">Current userId</param>
/// <remark>This method lock order for other user</remark>
public void LockOrder(int orderId, int userId)
{
var _context = new DeluxeOrderManagementEntities();
var order = _context.OrderGrids.Where(x => x.Id == orderId).FirstOrDefault();
order.IsLocked = true;
order.LockedBy = userId;
order.LockedOn = DateTime.UtcNow;
_context.SaveChanges();
}
/// <summary>
/// Search vid based on videoVersion and vedorID
/// </summary>
/// <param name="videoVersion"></param>
/// <param name="vendorId"></param>
/// <returns>VID</returns>
public VID GetVidByVVID(string videoVersion, string vendorId)
{
var _context = new DeluxeOrderManagementEntities();
var vid = (from v in _context.VIDs
where v.VideoVersion == videoVersion && v.VendorId == vendorId
select v
).FirstOrDefault();
return(vid);
}
public List <Customer> GetCustomers()
{
using (var _context = new DeluxeOrderManagementEntities())
{
var lstCustomers = from c in _context.Customers
where c.Type == (int)Customers.ContentProvider
select c;
return(lstCustomers.ToList());
}
}
/// <summary>
/// Search details of selected job
/// </summary>
/// <param name="jobId">Id of selected job</param>
/// <returns>Job details</returns>
public List <Jobs_Items> GetJobsItems(int jobId)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var jobety = _context.Jobs_Items
.Where(x => x.JobId == jobId)
.ToList();
return(jobety);
}
}
/// <summary>
/// Search pieline order
/// </summary>
/// <param name="requestNumber">CableLabsAssetID</param>
/// <remark>Search pipeline order to auto populate HAL Id and PO</remark>
/// <returns>PipelineOrder</returns>
public PipelineOrder GetPipeLineOrder(string requestNumber)
{
var _context = new DeluxeOrderManagementEntities();
var pipeLineOrder = (from po in _context.PipelineOrders
where po.CableLabsAssetID == requestNumber
select po
).FirstOrDefault();
return(pipeLineOrder);
}
public UserModel GetByEmail(string email)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var userety = _context.UserModels
.Include("UserPasswords")
.Include("UserRoles")
.Include("UserRoles.Role.RolePrivs.Privilege")
.FirstOrDefault(x => x.Email == email && x.Active);
return(userety);
}
}
public UserModel GetById(int id)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var userety = _context.UserModels
.Include("UserPasswords")
.Include("UserRoles")
.Include("UserRoles.Role.RolePrivs.Privilege")
.FirstOrDefault(x => x.UserId == id);
return(userety);
}
}
public UserModel GetUserByUserName(string email)
{
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var userety = _acoubntContext.UserModels
.Include("UserPasswords")
.Include("UserRoles")
.Include("UserRoles.Role.RolePrivs.Privilege")
.FirstOrDefault(e => e.Email == email && e.Active);
return(userety);
}
}
