public void insert(ILead newLead)
{
var lead = newLead.getLeadDto();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString))
{
string sqlQuery = @"Insert INTO Lead
(Firstname, Surname, TitleId, IdentityNo , ContactNo, EmailAddress)
Values(@FirstName, @Surname, @TitleId, @IdentityNo, @ContactNo, @EmailAddress);
SELECT CAST(SCOPE_IDENTITY() as bigint)";
var id = db.ExecuteScalar(sqlQuery,
new
{
FirstName = lead.firstName,
Surname = lead.surname,
TitleId = lead.title,
IdentityNo = lead.identityNo,
EmailAddress = lead.emailAddress,
ContactNo = lead.contactNo
});
lead.id = long.Parse(id.ToString());
//save lead comsmethod opt-ins
insertLeadComs(lead.id, lead);
}
}
