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);
}
}
}
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 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 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 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);
}
}
//Move Lead Status
/*
* 1 = New
* 2 = WIP
* 3 = Closed
*/
public static void ChangeLeadStatus(int LeadId)
{
using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
int CountUserActivity = (from b in db.LeadActivityForLeads
where b.IsSystem == false && b.LeadId == LeadId
select b).Count();
if (CountUserActivity > 0)
{
JazMax.DataAccess.Lead lead = db.Leads.FirstOrDefault(x => x.LeadId == LeadId);
lead.LeadStatusId = 2;
db.SaveChanges();
}
}
}
public static void CreateTemplate(MessageTemplate model)
{
using (JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
MessengerTemplate table = new MessengerTemplate()
{
CoreBranchId = model.CoreBranchId,
CoreUserId = model.CoreUserId,
CreatedDate = DateTime.Now,
IsActive = true,
MessengerTemplateTypeId = 1,
TemplateHtml = model.TemplateHtml,
TemplateName = model.TemplateName
};
db.MessengerTemplates.Add(table);
db.SaveChanges();
}
}
public int ForwardDocument(int id, UploadView coreFileUpload, FormCollection Form)
{
using (DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
string[] ids = Form["SentTo"].Split(new char[] { ',' });
//Find Document Id That i Want to forward
var FindContent = FindById(id);
//get All contents of that particular file
//Move Document to User Email Thats been Selected
#region Database Upload object
foreach (var item in ids)
{
DataAccess.CoreFileUpload upload = new DataAccess.CoreFileUpload()
{
FileUploadId = FindContent.FileUploadId,
FileNames = FindContent.FileNames,
CoreUserId = JazMaxIdentityHelper.GetCoreUserId(),
CoreUserTypeId = FindContent.CoreUserTypeId,
DateCreated = DateTime.Now,
DeletedBy = "None",
DeletedDate = DateTime.Now,
BranchId = (int)JazMaxIdentityHelper.GetUserInformationNew().BranchId,
ProvinceId = (int)JazMaxIdentityHelper.GetUserInformationNew().ProvinceId,
CoreFileTypeId = FindContent.CoreFileTypeId,
FileDescription = coreFileUpload.FileDescription,
CoreFileCategoryId = FindContent.CoreFileCategoryId,
LastUpdated = DateTime.Now,
IsActive = true,
IsSent = true,
IsRecieved = false,
FileContent = FindContent.FileContent,
SentFrom = JazMaxIdentityHelper.UserName,
SentTo = item.ToString()
};
#endregion
//SaveChanges To Database
db.CoreFileUploads.Add(upload);
db.SaveChanges();
}
return(FindContent.FileUploadId);
}
}
public void DoWork()
{
using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
var ListToMove = db.CoreUserBranchMoveRequests.Where(x => x.HasBeenApproved == true &&
x.EffectiveDate >= DateTime.Today && x.WebJobUpdateCompleted == false).ToList();
foreach (var item in ListToMove)
{
var Record = db.CoreUserBranchMoveRequests.Where(x => x.CoreUserMoveRequestId == item.CoreUserMoveRequestId)?.FirstOrDefault();
Record.WebJobUpdateCompleted = true;
db.SaveChanges();
var CoreUserTypeId = GetCoreUserType(Record.CoreUserId);
if (CoreUserTypeId > 0)
{
if (CoreUserTypeId == (int)JazMax.Common.Enum.UserType.Agent)
{
//Do Agent Move Logic
JazMax.BusinessLogic.UserAccounts.CoreUserService.MoveAgent(Record.CoreUserId, -1, Record.CoreBranchId);
}
else if (CoreUserTypeId == (int)JazMax.Common.Enum.UserType.TeamLeader)
{
//Do Teamleader Move Logic
}
else if (CoreUserTypeId == (int)JazMax.Common.Enum.UserType.PA)
{
//Not Implemented Yet
}
}
else
{
JazMax.BusinessLogic.AuditLog.ErrorLog.LogError(new JazMax.BusinessLogic.AuditLog.ErrorLog.ErrorMessage
{
CoreUserId = -1,
Message = "Invalid Core User Type",
Source = "JazMax.WebJob.MoveBranchRequest",
StackTrace = "N/A"
});
}
}
}
}
//2018-03-30 -------- Checking Azure Web Job Logging
//Catch all records and update. Does not log (See Exception Log ID : 58)
//2018-04-11 ----- This seems to be working but why?
//I am 99.9999999999% sure this works.
public static void LogWebJob(JazMax.Web.ViewModel.WebJob.JobModel model)
{
try
{
DataAccess.AzureWebJobLog log = new DataAccess.AzureWebJobLog()
{
AzureWebJobId = Convert.ToString(model.JobId),
RecordsAffected = model.RecordsAffected,
StartDateTime = model.StartDate,
EndDateTime = model.EndDate
};
db.AzureWebJobLogs.Add(log);
db.SaveChanges();
}
catch (Exception e)
{
AuditLog.ErrorLog.LogError(e, 1);
}
}
public static void CaptureLeadActivity(LeadActivity activity, bool overRide = true)
{
using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
JazMax.DataAccess.LeadActivityForLead act = new DataAccess.LeadActivityForLead()
{
CoreUserId = activity.CoreUserId,
DateCreated = DateTime.Now,
LeadActivityId = activity.LeadActivityId,
LeadId = activity.LeadId,
IsDeleted = false,
IsSystem = activity.IsSystem,
Description = activity.Description
};
db.LeadActivityForLeads.Add(act);
db.SaveChanges();
if (overRide)
{
JazMax.Core.Leads.Status.LeadStatusLogic.ChangeLeadStatus(activity.LeadId);
}
}
}
private void ProcessLeadCommunication(int LeadId)
{
using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
var lead = db.Leads?.FirstOrDefault(x => x.LeadId == LeadId);
if (lead != null)
{
var TeamLeader = (from t in db.CoreTeamLeaders
join b in db.CoreBranches
on t.CoreTeamLeaderId equals b.CoreTeamLeaderId
where b.BranchId == lead.CoreBranchId
join e in db.CoreUsers
on t.CoreUserId equals e.CoreUserId
select e)?.FirstOrDefault();
if (TeamLeader != null)
{
//Send TeamLeader An Email
JazMax.BusinessLogic.Messenger.JazMaxMail.SendMail(new Web.ViewModel.Messenger.Email
{
IsAspUserId = false,
IsBodyHtml = true,
Message = "A new lead has been created in your branch. LeadID: " + lead.LeadId,
SendTo = TeamLeader.EmailAddress,
Subject = "New Lead In Your Branch (LeadID: " + LeadId + ")"
});
}
var AgentList = (from t in db.CoreAgents
join b in db.CoreUsers
on t.CoreUserId equals b.CoreUserId
join e in db.LeadAgents
on t.CoreAgentId equals e.AgentId
where e.LeadId == lead.LeadId
select b)?.ToList();
//Send Agents An Email
if (AgentList != null)
{
foreach (var agent in AgentList)
{
JazMax.BusinessLogic.Messenger.JazMaxMail.SendMail(new Web.ViewModel.Messenger.Email
{
IsAspUserId = false,
IsBodyHtml = true,
Message = "A new lead has been created and assigned to you. LeadID: " + lead.LeadId,
SendTo = agent.EmailAddress,
Subject = "New Lead Assigned To You (LeadID: " + LeadId + ")"
});
}
}
var Customer = (from t in db.LeadProspects
where t.LeadId == lead.LeadId
select t)?.FirstOrDefault();
//Send Customer an Email
if (Customer != null)
{
JazMax.BusinessLogic.Messenger.JazMaxMail.SendMail(new Web.ViewModel.Messenger.Email
{
IsAspUserId = false,
IsBodyHtml = true,
Message = "Thank you for your enquiry an agent will be in contact with you shortly. Please use " + lead.LeadId + " as your reference number",
SendTo = Customer.Email,
Subject = "Thank you for your enquiry"
});
}
lead.ServiceCompleted = true;
db.SaveChanges();
}
}
}