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