public static void CaptureLead(LeadItem item) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { try { JazMax.DataAccess.LeadRawData raw = new DataAccess.LeadRawData() { FullName = item.FullName, ContactNumber = item.ContactNumber, Email = item.Email, Comments = item.Comments, SourceName = item.Source, PropertyListingId = item.PropertyListingID, DateCreated = DateTime.Now, ServiceCompleted = false, ServiceCompletedDate = null, CoreUserId = item.CoreUserId ?? -999, IsManualCapture = item.IsManual, }; db.LeadRawDatas.Add(raw); db.SaveChanges(); } catch (Exception e) { JazMax.BusinessLogic.AuditLog.ErrorLog.LogError(e, 0); } } }
static void Main(string[] args) { DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext(); int?JobId = WebJobService.GetWebJobId("JazMaxMesseneger"); JazMax.Web.ViewModel.WebJob.JobModel m = new Web.ViewModel.WebJob.JobModel() { JobId = (int)JobId, StartDate = DateTime.Now }; List <DataAccess.MessengerCoreLog> ListToSent = db.MessengerCoreLogs.Where(x => x.IsSent == false).ToList(); int numberOfMailsSent = 0; foreach (var a in ListToSent) { MessengerService.SendGmail(a.MessageTo, a.MessageSubject, a.IsHtml, a.MessageBody); MessengerService.UpdateMessengerToSent(a.MessengerCoreLogId); numberOfMailsSent++; } m.RecordsAffected = Convert.ToString(numberOfMailsSent); m.EndDate = DateTime.Now; WebJobService.LogWebJob(m); }
public static List <LeadActivityByBranch> LeadByBranch(LeadActivityByBranchFilter filter) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var query = db.VwGetLeadsByActivities.Select(x => new LeadActivityByBranch { BranchName = x.BranchName, NumberOfActivities = (int)x.NumberOfActivities, CoreBranchId = x.CoreBranchId, DateCreated = x.DateCreated, LeadID = x.LeadId, LeadStatusId = x.LeadStatusId, StatusName = x.StatusName }).ToList().AsQueryable(); var mine = query; if (filter.CoreBranchId > 0) { mine = mine.Where(x => x.CoreBranchId == filter.CoreBranchId); } if (filter.LeadStatusId > 0) { mine = mine.Where(x => x.LeadStatusId == filter.LeadStatusId); } filter.TotalResults = mine.Count(); return(mine.ToList()); } }
public IQueryable <NewListingView> GetPrimaryListingOK() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { List <NewListingView> view = new List <NewListingView>(); #region Joins Query var query = (from a in db.PropertyListings join b in db.PropertyListingDetails on a.PropertyListingId equals b.PropertyListingId select new { a.PropertyListingId, a.FriendlyName, b.RatesAndTaxes, b.NumberOfBathRooms, b.NumberOfBedrooms, b.NumberOfGarages, b.NumberOfSquareMeters, }).ToList().AsQueryable(); #endregion foreach (var item in query) { #region Property Listing View PropertyListingView list = new PropertyListingView() { PropertyListingId = item.PropertyListingId, FriendlyName = item.FriendlyName, }; #endregion #region Details View PropertyListingDetailView details = new PropertyListingDetailView() { RatesAndTaxes = item.RatesAndTaxes, NumberOfBathRooms = item.NumberOfBathRooms, NumberOfBedrooms = item.NumberOfBedrooms, NumberOfGarages = item.NumberOfGarages, NumberOfSquareMeters = item.NumberOfSquareMeters, }; #endregion #region NewList NewListingView lists = new NewListingView() { PropertyListingView = list, PropertyListingDetailView = details, }; #endregion view.Add(lists); } return(view.AsQueryable()); } }
public static void CaptureLeadReminder(LeadReminder reminder) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { JazMax.DataAccess.LeadReminder act = new DataAccess.LeadReminder() { CoreUserId = reminder.CoreUserId, DateCreated = DateTime.Now, Description = reminder.Description, LeadId = reminder.LeadId, ReminderDate = reminder.ReminderDate, WebJobCompleted = false, WebJobCompletedDate = null }; db.LeadReminders.Add(act); db.SaveChanges(); JazMax.Core.Leads.Activity.ActivityCreation.CaptureLeadActivity(new Core.Leads.Activity.LeadActivity { CoreUserId = reminder.CoreUserId, LeadActivityId = 5, LeadId = reminder.LeadId, IsSystem = false, Description = "Reminder added for " + reminder.ReminderDate.ToShortDateString() }); } }
public static void CreateTrigger(SendMessage model) { using (JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { MessengerTrigger t = new MessengerTrigger() { BranchId = model.BranchId, CoreUserId = model.CoreUserId, CreatedDate = DateTime.Now, HasBeenProcessed = false, IsCancelled = 0, MessengerComTypeId = 1, CoreProvinceId = model.ProvinceId, CoreUserTypeId = model.CoreUserTypeId, MessageBody = model.MessageBody, MessengerTemplateId = 1, NumberOfContacts = null, ProcessedDateTime = null, SendingDate = model.SendDate, SendingTo = model.SendTo, TriggerSetup = model.TriggerText, MessageSubject = model.MessageSubject }; db.MessengerTriggers.Add(t); db.SaveChanges(); } }
public IQueryable <LeadIndex> GetLeadIndex(int BranchId = 0, int AgentId = 0) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { IQueryable <LeadIndex> query = (from a in db.Leads join b in db.LeadTypes on a.LeadTypeId equals b.LeadTypeId join c in db.LeadSources on a.LeadSourceId equals c.LeadSourceId join d in db.LeadStatus on a.LeadStatusId equals d.LeadStatusId join e in db.PropertyListings on a.PropertyListingId equals e.PropertyListingId join f in db.CoreBranches on a.CoreBranchId equals f.BranchId join g in db.LeadProspects on a.LeadId equals g.LeadId select new LeadIndex { DateCreated = a.DateCreated, LeadId = a.LeadId, LeadSource = c.SourceName, LeadStatus = d.StatusName, LeadType = b.TypeName, PropertyListingFriendlyName = e.FriendlyName, BranchName = f.BranchName, ProspectName = g.FullName, BranchId = f.BranchId }).ToList().AsQueryable(); foreach (var ash in query) { JazMax.Core.Leads.Activity.ActivityLogic o = new Activity.ActivityLogic(ash.LeadId); ash.LastActivity = JazMax.Core.Leads.Activity.ActivityLogic.GetLastLeadActivity()?.ActivityTypeName; } foreach (var bob in query) { LeadId = bob.LeadId; bob.LeadAgents = GetAgentsForLead(); } var mine = query.AsQueryable(); if (BranchId > 0) { mine = mine.Where(x => x.BranchId == BranchId); } if (AgentId > 0) { mine = mine.Where(x => x.LeadAgents.Where(y => y.AgentId == AgentId).Any()); } //List<LeadIndex> lol = new List<LeadIndex>(); //lol = mine.ToList(); //return lol; return(mine); } }
public IQueryable <DataAccess.CoreLeadAttachment> GetLeadAttachment() { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var documents = db.CoreLeadAttachments.ToList(); return(documents.AsQueryable()); } }
public IQueryable <DataAccess.CoreFileType> GetFileType() { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var filetype = db.CoreFileTypes.ToList(); return(filetype.AsQueryable()); } }
public IQueryable <DataAccess.CoreDocumentType> GetTypes() { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var types = db.CoreDocumentTypes.ToList(); return(types.AsQueryable()); } }
public IQueryable <DataAccess.CoreFileUpload> GetDocument() { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var documents = db.CoreFileUploads.ToList(); return(documents.AsQueryable()); } }
private List <int> GetLeads() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var leads = db.Leads.Where(x => x.ServiceCompleted == false).Select(x => x.LeadId).ToList(); return(leads); } }
public int LeadProspectsCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var LeadProspectsCount = (from leads in db.LeadProspects select leads).ToList(); return(LeadProspectsCount.Count()); } }
public static List <LeadActivityByAgent> LeadByAgentNew(LeadActivityByAgentFilter filter) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var sqlParams = new SqlParameter[] { new SqlParameter { ParameterName = "@CoreUserId", Value = filter.CoreUserId } }; return(db.Database.SqlQuery <LeadActivityByAgent>($"SPLeadActivityByAgent @CoreUserId", sqlParams).ToList()); } }
public void Update(int LeadReminderId) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { JazMax.DataAccess.LeadReminder o = db.LeadReminders.Where(x => x.LeadReminderId == LeadReminderId).FirstOrDefault(); o.WebJobCompleted = true; o.WebJobCompletedDate = DateTime.Now; db.SaveChanges(); } }
public int ManualCaptureCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var ManualCount = (from leads in db.LeadRawDatas where leads.IsManualCapture == true select leads).ToList(); return(ManualCount.Count()); } }
public int ProcessedLeadCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var leadCount = (from leads in db.Leads where leads.ServiceCompleted == true select leads).ToList(); return(leadCount.Count()); } }
public int LeadsClosedCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var LeadsClosedCount = (from leads in db.Leads where leads.LeadStatusId == 3 select leads).ToList(); return(LeadsClosedCount.Count()); } }
public int WorkInProgressCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var WorkInProgressCount = (from leads in db.Leads where leads.LeadStatusId == 2 select leads).ToList(); return(WorkInProgressCount.Count()); } }
public int RawLeadCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var RawCount = (from rawleads in db.LeadRawDatas where rawleads.ServiceCompleted == false select rawleads).ToList(); return(RawCount.Count()); } }
public int LastMonth() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var date = DateTime.Now; var LastMonth = (from leads in db.Leads select leads).ToList(); var count = LastMonth.Where(x => x.DateCreated >= date.AddMonths(-1)); return(count.Count()); } }
public static void DoWork() { Debug.WriteLine("JazMax Messenger Service V2.0 has started"); DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext(); List <DataAccess.MessengerCoreLog> ListToSent = db.MessengerCoreLogs.Where(x => x.IsSent == false).ToList(); foreach (var a in ListToSent) { MessengerService.SendGmail(a.MessageTo, a.MessageSubject, a.IsHtml, a.MessageBody); MessengerService.UpdateMessengerToSent(a.MessengerCoreLogId); } }
public int SystemProcessedCount() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var SystemCount = (from leads in db.LeadRawDatas where leads.IsManualCapture == false && leads.CoreUserId == -999 select leads).ToList(); return(SystemCount.Count()); } }
private int GetCoreUserType(int CoreUserId) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var t = db.CoreUserInTypes.Where(x => x.CoreUserId == CoreUserId)?.Select(x => x.CoreUserTypeId)?.FirstOrDefault(); if (t > 0) { return((int)t); } return(-1); } }
public int Upload(UploadView coreFileUpload) { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var context = HttpContext.Current; for (int i = 0; i < context.Request.Files.Count; i++) { var file = context.Request.Files[i]; #region Content Length if (file != null && file.ContentLength > 0) { #region CoreFIleUpload DataAccess.CoreFileUpload fileUpload = new DataAccess.CoreFileUpload() { FileUploadId = coreFileUpload.FileUploadId, FileNames = System.IO.Path.GetFileName(file.FileName), CoreUserId = JazMaxIdentityHelper.GetCoreUserId(), CoreUserTypeId = JazMaxIdentityHelper.GetCoreUserId(), DateCreated = DateTime.Now, DeletedBy = "None", DeletedDate = DateTime.Now, BranchId = (int)JazMaxIdentityHelper.GetUserInformationNew().BranchId, ProvinceId = (int)JazMaxIdentityHelper.GetUserInformationNew().ProvinceId, CoreFileTypeId = coreFileUpload.CoreFileTypeId, FileDescription = coreFileUpload.FileDescription, CoreFileCategoryId = coreFileUpload.CoreFileCategoryId, LastUpdated = DateTime.Now, IsActive = true, IsSent = true, IsRecieved = true, FileContent = coreFileUpload.FileContent, SentFrom = JazMaxIdentityHelper.UserName, SentTo = "Document Directory" }; #endregion #region Binary Reader using (var reader = new System.IO.BinaryReader(file.InputStream)) { fileUpload.FileContent = reader.ReadBytes(file.ContentLength); } #endregion db.CoreFileUploads.Add(fileUpload); } #endregion db.SaveChanges(); } return(coreFileUpload.FileUploadId); } }
public int ManualCaptureCountUserId() { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var Finduser = db.CoreUsers.FirstOrDefault(x => x.EmailAddress == HttpContext.Current.User.Identity.Name); var ManualCount = (from leads in db.LeadRawDatas where leads.IsManualCapture == true && leads.CoreUserId == Finduser.CoreUserId select leads).ToList(); return(ManualCount.Count()); } }
public int CreateFileType(CoreFileTypesView filetypes) { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { DataAccess.CoreFileType filetype = new DataAccess.CoreFileType() { CoreFileTypeId = filetypes.CoreFileTypeId, TypeName = filetypes.TypeName, IsActive = true, }; db.CoreFileTypes.Add(filetype); db.SaveChanges(); return(filetypes.CoreFileTypeId); } }
public int CreateDocument(DocumentTypesView doctype) { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { DataAccess.CoreDocumentType type = new DataAccess.CoreDocumentType() { CoreFileCategoryId = doctype.CoreFileCategoryId, CategoryName = doctype.CategoryName, IsActive = true, }; db.CoreDocumentTypes.Add(type); db.SaveChanges(); return(doctype.CoreFileCategoryId); } }
public int Attach(DocumentAttachments Attachments) { using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var context = HttpContext.Current; for (int i = 0; i < context.Request.Files.Count; i++) { var file = context.Request.Files[i]; #region Content Length if (file != null && file.ContentLength > 0) { #region AttachmentFileUpload DataAccess.CoreDocumentAttachment AttachmentUpload = new DataAccess.CoreDocumentAttachment() { FileAttachmentId = Attachments.FileAttachmentId, FileUploadId = Attachments.FileUploadId, FileNames = System.IO.Path.GetFileName(file.FileName), CoreUserId = 1, DateCreated = DateTime.Now, DeletedBy = "None", DeletedDate = DateTime.Now, BranchId = 1, ProvinceId = 1, FileAttachmentDescription = Attachments.FileAttachmentDescription, LastUpdated = DateTime.Now, IsActive = true, IsRecieved = true, FileContent = Attachments.FileContent }; #endregion #region Binary Reader using (var reader = new System.IO.BinaryReader(file.InputStream)) { AttachmentUpload.FileContent = reader.ReadBytes(file.ContentLength); } #endregion db.CoreDocumentAttachments.Add(AttachmentUpload); } #endregion db.SaveChanges(); } return(Attachments.FileAttachmentId); } }
public static void CloseLead(int LeadId, Activity.LeadActivity model) { using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { var Lead = db.Leads?.FirstOrDefault(x => x.LeadId == LeadId); if (Lead != null) { Lead.IsCompleted = true; Lead.LeadStatusId = 3; //Closed Lead } db.SaveChanges(); JazMax.Core.Leads.Activity.ActivityCreation.CaptureLeadActivity(model, false); } }