// To validate rows, columns in uploaded file on Qualification Template public string validateQualificationsDataTable(DataTable dt, int userid) { string validationMsg = ""; for (int row = 1, col = 0; row < dt.Rows.Count; row++) { if (String.IsNullOrEmpty((dt.Rows[row][col]).ToString())) { validationMsg = "Empty field in Column: " + col + ", Row: " + (row + 1); return(validationMsg); } } try { var url = string.Format("api/Qualifications/Insert/Upload"); string res = new WebApiHelper().PostExecuteNonQueryResFromWebApi(url, userid, dt); validationMsg = res; } catch (Exception ex) { CommonLogger.Info(ex.ToString()); } return(validationMsg); }
public void SendEmail(string name, string email, string password, Constants.EmailTypes emailType) { //Fetching Settings from WEB.CONFIG file. string emailSender = ConfigurationManager.AppSettings["UserName"].ToString(); string emailSenderPassword = ConfigurationManager.AppSettings["Password"].ToString(); string emailSenderHost = ConfigurationManager.AppSettings["Host"].ToString(); int emailSenderPort = Convert.ToInt16(ConfigurationManager.AppSettings["Port"]); Boolean emailIsSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableSsl"]); //Fetching Email Body Text from EmailTemplate File. string MailText = ""; string subject = ""; // Fetching email contents w.r.t predefined email types if (emailType == Constants.EmailTypes.NewUser) { string FilePath = HttpContext.Current.Server.MapPath(Constants.emailTemplates) + "NewUser.html"; StreamReader str = new StreamReader(FilePath); MailText = str.ReadToEnd(); str.Close(); //Replacing the html for [newusername] and [newpassword] with actual values. MailText = MailText.Replace("[name]", name); MailText = MailText.Replace("[newusername]", email); MailText = MailText.Replace("[newpassword]", password); subject = "Welcome to InsyncTalentBox"; } //Base class for sending email MailMessage _mailmsg = new MailMessage(); //Make TRUE because our body text is html _mailmsg.IsBodyHtml = true; //Set From Email ID _mailmsg.From = new MailAddress(emailSender); //Set To Email ID _mailmsg.To.Add(email); //Set Subject _mailmsg.Subject = subject; //Set Body Text of Email _mailmsg.Body = MailText; //Now set your SMTP SmtpClient _smtp = new SmtpClient(); //Object state = _mailmsg; //Set HOST server SMTP detail _smtp.Host = emailSenderHost; //Set PORT number of SMTP _smtp.Port = emailSenderPort; //Set SSL --> True / False _smtp.EnableSsl = emailIsSSL; //Set Sender UserEmailID, Password NetworkCredential _network = new NetworkCredential(emailSender, emailSenderPassword); _smtp.Credentials = _network; //Send Method will send your MailMessage create above. //_smtp.Send(_mailmsg); //_smtp.SendCompleted += new SendCompletedEventHandler(smtpClient_SendCompleted); try { _smtp.Send(_mailmsg); } catch (Exception ex) { CommonLogger.Info(ex.ToString() + " while sending mail to " + email + " at " + DateTime.Now); } }