public List <LeadEntity> GetAllLeads()
{
List <LeadEntity> Leads = new List <LeadEntity>();
SqlConnection connection = new SqlConnection("Data Source=DESKTOP-OTH8BE1;Initial Catalog=CampusMind;Integrated Security=True");
connection.Open();
string sqlQuery = string.Format("select * from Leads");
SqlCommand command = new SqlCommand(sqlQuery, connection);
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
dataAdapter.Fill(table);
connection.Close();
foreach (DataRow item in table.Rows)
{
LeadEntity lead = new LeadEntity();
lead.LeadId = Convert.ToInt32(item["LeadId"]);
lead.TechnologyId = Convert.ToInt32(item["TechnologyId"]);
lead.LeadName = Convert.ToString(item["LeadName"]);
Leads.Add(lead);
}
return(Leads);
}
public int Post([FromBody] LeadEntity leadEntity)
{
var userIpAddress = HttpContext.Current.Request.UserHostAddress;
leadEntity.EnderecoIpv4 = userIpAddress;
return(_leadServices.Add(leadEntity));
}
public ActionResult AddLead(LeadModel newLeadModel)
{
LeadEntity newLeadEntity = manage.ConvertLeadModelToEntity(newLeadModel);
accessBusinessLayer.AddLead(newLeadEntity);
return(View("Index"));
}
public LeadEntity ConvertLeadModelToEntity(LeadModel newLeadModel)
{
LeadEntity newLeadEntity = new LeadEntity();
newLeadEntity.LeadId = newLeadModel.LeadId;
newLeadEntity.LeadName = newLeadModel.LeadName;
newLeadEntity.TechnologyId = newLeadModel.TechnologyId;
return(newLeadEntity);
}
public void OptionSetMapper_Should_Be_Able_To_Map_OptionSetValues_Enums()
{
OptionSetMapper.AddOptionSetMapping(_jsonResponseForTest);
var lead = new LeadEntity
{
SyncState = SyncStates.Error
};
lead.CommitChanges();
lead.Attributes["test_sync_state"].Should().Be(3);
}
public async Task <TypedResult <LeadOutDto> > CreateLead(NewLeadDtoIn newLeadDtoIn)
{
try
{
var dateTimeNow = DateTimeOffset.UtcNow;
var newLeadEntity = new LeadEntity
{
RecordId = Guid.NewGuid(),
CreatedTime = dateTimeNow,
CreatedByUserId = newLeadDtoIn.ModifiedBy,
ModifiedBy = newLeadDtoIn.ModifiedBy,
LastModifiedTime = dateTimeNow,
AnnualSalary = newLeadDtoIn.AnnualSalary,
LeadSource = newLeadDtoIn.LeadSource,
Tags = newLeadDtoIn.Tags.Select(x => x),
Converted = false,
Address = new AddressEntity
{
StreetLineOne = newLeadDtoIn.Address.StreetLineOne,
StreetLineTwo = newLeadDtoIn.Address.StreetLineTwo,
AptSuite = newLeadDtoIn.Address.AptSuite,
City = newLeadDtoIn.Address.City,
State = newLeadDtoIn.Address.State,
County = newLeadDtoIn.Address.County,
Zip = newLeadDtoIn.Address.Zip
},
Name = new NameEntity
{
FirstName = newLeadDtoIn.Name.FirstName,
LastName = newLeadDtoIn.Name.LastName,
MiddleName = newLeadDtoIn.Name.MiddleName,
Salutation = newLeadDtoIn.Name.Salutation,
PreferredFirstName = newLeadDtoIn.Name.PreferredFirstName
},
ContactInfo = new ContactInfoEntity
{
Mobile = newLeadDtoIn.ContactInfo.Mobile,
Fax = newLeadDtoIn.ContactInfo.Fax,
Email = newLeadDtoIn.ContactInfo.Email,
Home = newLeadDtoIn.ContactInfo.Home,
PreferredContactMethod = newLeadDtoIn.ContactInfo.PreferredContactMethod
}
};
await LeadCollection.InsertOneAsync(newLeadEntity);
return(new SuccessfulTypedResult <LeadOutDto>(LeadOutDto.EntityToOutDto(newLeadEntity)));
}
catch (Exception e)
{
return(new FailedTypedResult <LeadOutDto>(e));
}
}
public int LeadAction(LeadEntity leadEntity)
{
Hashtable hashtable = new Hashtable();
hashtable.Add("@AssignedTo", leadEntity.AssignedTo);
hashtable.Add("@AssignedBy", leadEntity.AssignedBy);
hashtable.Add("@LeadStatus", leadEntity.LeadStatus);
hashtable.Add("@lsId", leadEntity.LeadID);
int result = dataUtilities.ExecuteNonQuery("usp_LeadActions", hashtable);
return(result);
}
public int AddLead(LeadEntity newLead)
{
string strConString = "Data Source=DESKTOP-OTH8BE1;Initial Catalog=CampusMind;Integrated Security=True";
using (SqlConnection con = new SqlConnection(strConString))
{
con.Open();
string query = "Insert into Leads(LeadName,TechnologyId) values(@Name, @TechId)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Name", newLead.LeadName);
cmd.Parameters.AddWithValue("@TechId", newLead.TechnologyId);
cmd.ExecuteNonQuery();
}
return(0);
}
public async Task <RegisterLeadOutput> RegisterLead(RegisterLeadInput request)
{
var status = await _leadRepository.AddStatus(request.StatusDescription);
//var allStatusLead = await _leadRepository.ListAllStatusLead();
//if (!allStatusLead.Any())
//throw new DefaultException((int)HttpStatusCode.InternalServerError, "Nenhum status lead encontrado.");
LeadEntity input = new LeadEntity()
{
CustomerName = request.CustomerName,
CustomerEmail = request.CustomerEmail,
CustomerPhone = request.CustomerPhone,
StatusId = status.Id
};
var lead = await _leadRepository.AddLead(input);
foreach (var item in request.Opportunities)
{
var opportunity = new OpportunityEntity()
{
LeadId = lead.Id,
Description = item
};
await _leadRepository.AddOpportunities(opportunity);
}
var opportunitiesOfLead = await _leadRepository.ListOpportunitiesByLeadId(lead.Id);
var leadDto = lead.CreateDto();
leadDto.Opportunities = new List <OpportunityDto>();
opportunitiesOfLead.ToList().ForEach(item => leadDto.Opportunities.Add(item.CreateDto()));
return(new RegisterLeadOutput()
{
Method = "RegisterLead",
Result = lead != default ? "SUCCESS" : "ERROR",
Payload = leadDto
});
public static BasicLeadDto CreateBasicLeadDto(this LeadEntity input)
{
if (input == default)
{
return(default);
public int CUDLead(LeadEntity leadEntity, char Operation)
{
Hashtable hashtable = new Hashtable();
if (Operation == 'I')
{
hashtable.Add("@lsId", 0);
hashtable.Add("@lsCreatedBy", leadEntity.CreatedBy);
hashtable.Add("@lsUpdatedBy", leadEntity.UpdatedBy);
hashtable.Add("@WebsiteConsultantNotes", leadEntity.WebsiteConsultantNotes);
}
else
{
hashtable.Add("@lsId", leadEntity.LeadID);
hashtable.Add("@lsCreatedBy", 0);
hashtable.Add("@lsUpdatedBy", leadEntity.UpdatedBy);
hashtable.Add("@WebsiteConsultantNotes", DBNull.Value);
}
if (leadEntity.FollowupDate != "")
{
hashtable.Add("@FollowupDate", DateTime.ParseExact(leadEntity.FollowupDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@FollowupDate", DBNull.Value);
}
hashtable.Add("@FollowupDesc", leadEntity.FollowupDesc);
hashtable.Add("@lsAssignedTo", leadEntity.AssignedTo);
hashtable.Add("@lsAssignedBy", leadEntity.AssignedBy);
hashtable.Add("@lsOthersInfo", leadEntity.Others);
hashtable.Add("@lsSource", leadEntity.SourceID);
hashtable.Add("@lsSourceRef", leadEntity.SourceRef);
hashtable.Add("@lsFirstName", leadEntity.FirstName);
hashtable.Add("@lsLastName", leadEntity.LastName);
hashtable.Add("@lsMobile", leadEntity.Mobile);
hashtable.Add("@lsEmailID", leadEntity.Email);
hashtable.Add("@lsProdType", leadEntity.ProductType);
hashtable.Add("@lsOriginName", leadEntity.OriginName);
hashtable.Add("@lsDestinationName", leadEntity.DestinationName);
hashtable.Add("@lsLeadDesc", leadEntity.LeadDescription);
if (leadEntity.DepartureDate != "")
{
hashtable.Add("@lsDepartureDate", DateTime.ParseExact(leadEntity.DepartureDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@lsDepartureDate", DBNull.Value);
}
if (leadEntity.ReturnDate != "")
{
hashtable.Add("@lsReturnDate", DateTime.ParseExact(leadEntity.ReturnDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@lsReturnDate", DBNull.Value);
}
hashtable.Add("@lsLeadStatus", leadEntity.LeadStatus);
hashtable.Add("@lsAdults", leadEntity.Adult);
hashtable.Add("@lsChildren", leadEntity.Child);
hashtable.Add("@lsInfants", leadEntity.Infant);
hashtable.Add("@lsBudget", leadEntity.Budget);
hashtable.Add("@lsNotes", leadEntity.Notes);
hashtable.Add("@lsQuotedPrice", leadEntity.QuotedPrice);
hashtable.Add("@lsFinalPrice", leadEntity.FinalPrice);
hashtable.Add("@Operation", Operation);
hashtable.Add("@lsPackageId", leadEntity.PackageId);
hashtable.Add("@lsProductId", leadEntity.ProductID);
hashtable.Add("@IdentityValue", 0);
int result = dataUtilities.ExecuteNonQuery("usp_CUDLead", hashtable, "@return");
return(result);
}
public int UpdateLeadInfo(LeadEntity leadEntity, char Operation)
{
Hashtable hashtable = new Hashtable();
hashtable.Add("@lsId", leadEntity.LeadID);
hashtable.Add("@lsUpdatedBy", leadEntity.UpdatedBy);
hashtable.Add("@lsSource", leadEntity.SourceID);
hashtable.Add("@lsSourceRef", leadEntity.SourceRef);
if (leadEntity.FollowupDate != "")
{
hashtable.Add("@FollowupDate", DateTime.ParseExact(leadEntity.FollowupDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@FollowupDate", DBNull.Value);
}
hashtable.Add("@FollowupDesc", leadEntity.FollowupDesc);
hashtable.Add("@lsOthersInfo", leadEntity.Others);
hashtable.Add("@lsFirstName", leadEntity.FirstName);
hashtable.Add("@lsLastName", leadEntity.LastName);
hashtable.Add("@lsMobile", leadEntity.Mobile);
hashtable.Add("@lsEmailID", leadEntity.Email);
hashtable.Add("@lsLeadDesc", leadEntity.LeadDescription);
if (leadEntity.DepartureDate != "")
{
hashtable.Add("@lsDepartureDate", DateTime.ParseExact(leadEntity.DepartureDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@lsDepartureDate", DBNull.Value);
}
if (leadEntity.ReturnDate != "")
{
hashtable.Add("@lsReturnDate", DateTime.ParseExact(leadEntity.ReturnDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@lsReturnDate", DBNull.Value);
}
hashtable.Add("@lsLeadStatus", leadEntity.LeadStatus);
hashtable.Add("@lsNotes", leadEntity.Notes);
hashtable.Add("@Operation", Operation);
hashtable.Add("@ClientFileId", leadEntity.ClientFileId);
hashtable.Add("@lsConsultantNotes", leadEntity.ConsultantNotes);
if (!string.IsNullOrEmpty(leadEntity.Reminder))
{
hashtable.Add("@lsReminder", DateTime.ParseExact(leadEntity.Reminder, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@lsReminder", DBNull.Value);
}
hashtable.Add("@lsReminderNotes", leadEntity.ReminderNotes);
int result = dataUtilities.ExecuteNonQuery("usp_UpdtLeadInfo", hashtable);
return(result);
}
public void LeadInfoFromWebsite(List <Object> aray)
{
string leadInfo = "";
try
{
foreach (Dictionary <string, object> item in aray)
{
leadInfo = new JavaScriptSerializer().Serialize(item);
}
;
JavaScriptSerializer js = new JavaScriptSerializer();
LeadEntity leadObject = js.Deserialize <LeadEntity>(leadInfo);
LeadEntity leadEntity = new LeadEntity();
string deptdt = DateTime.ParseExact(leadObject.DepartureDate, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy");
string rettdt = DateTime.ParseExact(leadObject.DepartureDate, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy");
leadEntity.SourceID = 1;
leadEntity.SourceRef = "Website";
leadEntity.Others = "";
leadEntity.AssignedTo = 0;
leadEntity.AssignedBy = 0;
leadEntity.FirstName = leadObject.FirstName;
leadEntity.LastName = leadObject.LastName;
leadEntity.Mobile = leadObject.Mobile;
leadEntity.Email = leadObject.Email;
leadEntity.OriginName = leadObject.OriginName;
leadEntity.DestinationName = leadObject.DestinationName;
leadEntity.DepartureDate = deptdt;
leadEntity.ReturnDate = rettdt;
leadEntity.Adult = leadObject.Adult;
leadEntity.Child = leadObject.Child;
leadEntity.Infant = leadObject.Infant;
leadEntity.ProductType = leadObject.ProductType;
leadEntity.Budget = leadObject.Budget;
leadEntity.Notes = leadObject.Notes;
leadEntity.QuotedPrice = 0;
leadEntity.FinalPrice = 0;
leadEntity.UpdatedBy = 0;
leadEntity.LeadStatus = 2;
leadEntity.CreatedBy = 2;
leadEntity.FollowupDate = "";
leadEntity.FollowupDesc = "";
leadEntity.LeadDescription = "";
leadEntity.PackageId = leadObject.PackageId;
leadEntity.ProductID = leadObject.ProductID;
leadEntity.WebsiteConsultantNotes = leadObject.WebsiteConsultantNotes;
int result = leadBL.CUDLead(leadEntity, 'I');
if (result > 1)
{
string clName = leadObject.FirstName + " " + leadObject.LastName;
SendMail(clName, leadObject.Email, leadObject.Mobile, leadObject.PackageId);
}
else
{
}
}
catch (Exception ex)
{
}
}
public int AddLead(LeadEntity newLead)
{
return(accessDataAcessLayer.AddLead(newLead));
}
