public static string CreateLeadConstructQuery(string msisdn, string email, string first_name, string last_name, string country, string address, string city, string zip, string device, string carrier, string device_mf, string device_os, int actions_count, CCSubmitDirect db = null)
{
if (db == null)
{
db = CCSubmitDirect.Instance;
}
return(db.Construct("INSERT INTO [].tm_lead (msisdn, email, first_name, last_name, country, countryid, address, city, zip, device, operator, device_mf, device_os, actions_count, updated, created)",
msisdn, email, first_name, last_name, country, GetCountryID(country), address, city, zip, device, carrier, device_mf, device_os, actions_count, DirectTime.Now, DirectTime.Now));
}
public static (bool isSuccess, int numOfRows) InsertCsvData(List <string[]> csvArrayList)
{
CCSubmitDirect db = CCSubmitDirect.Instance;
string query = "";
query += db.Construct("INSERT INTO [].tm_lead (msisdn, email, first_name, last_name, country, address, city, zip, device, operator)",
csvArrayList);
var numOfRows = db.Execute(query);
return(numOfRows > 0 ? true : false, numOfRows != null ? (int)numOfRows : 0);
}