public async Task <ErrorHandlers> ImportManpowerRequest(string filename, string Userid, string urlam1, string urlam2) { var dt = ExcelConnection.Datasource("select * from sheet ", filename); ErrorHandlers errorHandlers = new ErrorHandlers(); return(await Import(Userid, dt, urlam1, urlam2)); }
public static List <sp_applicant_listResult> ImportApplicantList(string filename) { DatabaseModelDataContext db = new DatabaseModelDataContext(); DataTable dt = ExcelConnection.Datasource("select * from sheet ", filename); List <sp_applicant_listResult> list = new List <sp_applicant_listResult>(); SmsBlaster sms = new SmsBlaster(); foreach (DataRow dr in dt.Rows) { try { if (dr[0].ToString() == null || dr[0].ToString() == "") { break; } if (db.fn_check_applicant_duplicate(dr[9].ToString(), dr[12].ToString(), dr[11].ToString(), dr[10].ToString(), dr[13].ToString(), dr[1].ToString(), dr[2].ToString(), dr[0].ToString()) == 0) { list.Add(new sp_applicant_listResult() { surname = dr[0].ToString(), firstname = dr[1].ToString(), middleinitial = dr[2].ToString(), address = dr[3].ToString(), location = dr[4].ToString(), requiredposition = dr[5].ToString(), birthday = Tools.ToDateTime(dr[6]), age = DateTime.Now.Year - Tools.ToDateTime(dr[6]).Year, gender = dr[7].ToString(), religion = dr[8].ToString(), sssnumber = dr[9].ToString(), philhealth = dr[10].ToString(), pagibignumber = dr[11].ToString(), tinnumber = dr[12].ToString(), contactnumber = dr[13].ToString(), emailaddress = dr[14].ToString(), educationattainment = dr[15].ToString(), schoolname = dr[16].ToString(), course = dr[17].ToString(), certification = dr[18].ToString(), skills = dr[19].ToString(), jobfair = dr[20].ToString(), howdidyouknowtopserve = dr[26].ToString(), referrals = dr[27].ToString(), relativesworkingintopserve = dr[28].ToString(), relativeworkingindirectcompetitionoftopserve = dr[29].ToString(), invited = dr[30].ToString(), dateinvited = dr[31].ToString(), oncall = Tools.ToBoolean(dr[32]), reliever = Tools.ToBoolean(dr[33]) }); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } System.IO.File.Delete(filename); return(list); }
public static void ImportConfirmedInvitedApplicant(string filename, string userid) { DatabaseModelDataContext db = new DatabaseModelDataContext(); 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_confirm_applicant(dr[0].ToString(), dr[1].ToString()); } } System.IO.File.Delete(filename); }
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); }
public static void ImportPassOnApplicant(string filename, string Mrfid, string userid) { DatabaseModelDataContext db = new DatabaseModelDataContext(); DataTable dt = ExcelConnection.Datasource("select * from sheet", filename); List <sp_applicant_listResult> list = new List <sp_applicant_listResult>(); foreach (DataRow dr in dt.Rows.Cast <DataRow>()) { if (dr[0].ToString() == "") { break; } list.Add(new sp_applicant_listResult() { surname = dr[0].ToString(), firstname = dr[1].ToString(), middleinitial = dr[2].ToString(), address = dr[3].ToString(), location = dr[4].ToString(), requiredposition = dr[5].ToString(), birthday = Tools.ToDateTime(dr[6]), age = DateTime.Now.Year - Tools.ToDateTime(dr[6]).Year, gender = dr[7].ToString(), religion = dr[8].ToString(), sssnumber = dr[9].ToString(), philhealth = dr[10].ToString(), pagibignumber = dr[11].ToString(), tinnumber = dr[12].ToString(), contactnumber = "63" + dr[13].ToString(), emailaddress = dr[14].ToString(), educationattainment = dr[15].ToString(), schoolname = dr[16].ToString(), course = dr[17].ToString(), certification = dr[18].ToString(), skills = dr[19].ToString(), jobfair = dr[20].ToString(), howdidyouknowtopserve = dr[26].ToString(), referrals = dr[27].ToString(), relativesworkingintopserve = dr[28].ToString(), relativeworkingindirectcompetitionoftopserve = dr[29].ToString(), invited = dr[30].ToString(), dateinvited = dr[31].ToString(), oncall = Tools.ToBoolean(dr[32]), reliever = Tools.ToBoolean(dr[33]) }); } if (list.Count > 0) { foreach (var i in list) { // db.sp_import_applicant_list(i.surname, i.firstname, i.middleinitial, i.address, i.requiredposition, i.location, i.birthday, i.age, i.gender, i.religion, i.sssnumber, i.philhealth, i.pagibignumber, i.tinnumber, i.contactnumber, i.emailaddress, i.educationattainment, i.schoolname, i.course, i.certification, i.skills, i.jobfair, i.howdidyouknowtopserve, i.referrals, i.relativesworkingintopserve, i.relativeworkingindirectcompetitionoftopserve, i.invited, Tools.ToDateTime(i.dateinvited), i.oncall, i.reliever); // db.sp_import_for_requirement_applicant(Mrfid, i.applicant_id); if (db.fn_check_applicant_duplicate(i.sssnumber, i.tinnumber, i.pagibignumber, i.philhealth, i.contactnumber, i.firstname, i.middleinitial, i.surname) <= 0) { db.sp_import_passon_applicant(Mrfid, i.surname, i.firstname, i.middleinitial, i.address, i.requiredposition, i.location, i.birthday, i.age, i.gender, i.religion, i.sssnumber, i.philhealth, i.pagibignumber, i.tinnumber, i.contactnumber, i.emailaddress, i.educationattainment, i.schoolname, i.course, i.certification, i.skills, i.jobfair, i.howdidyouknowtopserve, i.referrals, i.relativesworkingintopserve, i.relativeworkingindirectcompetitionoftopserve, i.invited, Tools.ToDateTime(i.dateinvited), i.oncall, i.reliever); } } } System.IO.File.Delete(filename); }