public static async void ImportConfirmedApplicant(string filename, string userid)
{
DatabaseModelDataContext db = new DatabaseModelDataContext();
SmsBlaster sms = new SmsBlaster();
DataTable dt = ExcelConnection.Datasource("select * from sheet", filename);
foreach (DataRow dr in dt.Rows)
{
if (dr[9].ToString().ToLower() == "y" || dr[9].ToString().ToLower() == "yes")
{
db.sp_import_shortlist_applicant(dr[0].ToString(), dr[1].ToString());
if (dr[10].ToString().ToLower() == "y" || dr[10].ToString().ToLower() == "yes")
{
await sms.SendBlastShortlistImport(userid, dr[1].ToString(), false);
}
}
}
System.IO.File.Delete(filename);
}
public static async void ImportForRequirementApplicant(string filename, string userid)
{
DatabaseModelDataContext db = new DatabaseModelDataContext();
SmsBlaster sms = new SmsBlaster();
DataTable dt = ExcelConnection.Datasource("select * from sheet", filename);
foreach (DataRow dr in dt.Rows)
{
if (dr[19].ToString().ToLower() == "y" || dr[19].ToString().ToLower() == "yes")
{
db.sp_applicant_requirement(dr[1].ToString(), Tools.YesToBoolean(dr[3]), Tools.YesToBoolean(dr[4]), Tools.YesToBoolean(dr[5]), Tools.YesToBoolean(dr[6]), Tools.YesToBoolean(dr[7]), Tools.YesToBoolean(dr[8]), Tools.YesToBoolean(dr[9]), Tools.YesToBoolean(dr[10]), Tools.YesToBoolean(dr[11]), Tools.YesToBoolean(dr[12]), Tools.YesToBoolean(dr[13]), Tools.YesToBoolean(dr[14]), dr[15].ToString(), dr[16].ToString(), dr[17].ToString(), dr[18].ToString());
db.sp_import_accept_applicant(dr[0].ToString(), dr[1].ToString());
if (dr[20].ToString().ToLower() == "y" || dr[20].ToString().ToLower() == "yes")
{
await sms.SendBlastShortlistImport(userid, dr[1].ToString(), false);
}
}
}
System.IO.File.Delete(filename);
}