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); }