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