public CResult DataReaderQueryRequest(string sSql) { oSqlConnection = new SqlConnection(); m_oCConnectionToDB = new CConnection(); oSqlConnection = m_oCConnectionToDB.GetDBConnection(); SqlCommand sqlComm = new SqlCommand(sSql, oSqlConnection); SqlDataReader oSqlDataReader = sqlComm.ExecuteReader(); oCResult.Data = oSqlDataReader; return(oCResult); }
public DataSet DataAdapterQueryRequest(string sSql) { m_oCConnectionToDB = new CConnection(); oSqlConnection = new SqlConnection(); oDataSet = new DataSet(); oSqlConnection = m_oCConnectionToDB.GetDBConnection(); SqlDataAdapter oSqlDataAdapter = new SqlDataAdapter(sSql, oSqlConnection); try { oSqlDataAdapter.Fill(oDataSet, "Common"); //oCResult.IsSuccess = true; //oCResult.Message = "Successfull"; //oCResult.Data = oDataSet; } catch (Exception ex) { //oCResult.IsSuccess = false; //oCResult.Message = ex.ToString(); } return(oDataSet); }
private void SearchExeFile(string c) { //OMSProcessMail ap = new OMSProcessMail(); DirectoryInfo dir = new DirectoryInfo(c); SqlConnection oSqlConnection = new SqlConnection(); CConnection m_oCConnectionToDB = new CConnection(); foreach (FileInfo f in dir.GetFiles()) { String Sender = ""; String pathname = "C:\\OMS\\Others\\Sender.dbz"; FileStream fsIn = new FileStream(pathname, FileMode.Open, FileAccess.Read, FileShare.Read); using (StreamReader sr = new StreamReader(fsIn, fileEncoding, true)) { Sender = sr.ReadLine(); } String Mail = ""; pathname = "C:\\OMS\\Others\\Mail.dbz"; fsIn = new FileStream(pathname, FileMode.Open, FileAccess.Read, FileShare.Read); using (StreamReader sr = new StreamReader(fsIn, fileEncoding, true)) { Mail = sr.ReadLine(); } oSqlConnection = m_oCConnectionToDB.GetDBConnection(); DataSet oDataSet = new DataSet(); //Modified : Saurav Biswas Kartik /OCT-21-2009 [Start] //Summary : To mail to all user [user aleart only] //oDataSet = m_oCSQLCommandExecutor.DataAdapterQueryRequest("SELECT * FROM SecurityUser WHERE (UsrDepartment = 'Administration') and UsrLevel= 'Administrator' and UsrActive='Y'", oSqlConnection); string strUser = ""; strUser = f.Name; strUser = strUser.Substring(0, strUser.IndexOf("_")); oDataSet = m_oCSQLCommandExecutor.DataAdapterQueryRequest("SELECT * FROM SecurityUser WHERE UsrActive='Y' And UsrUserName = '******'", oSqlConnection); //Modified : Saurav Biswas Kartik /OCT-21-2009 [End] if (oDataSet.Tables[0].Rows.Count > 0) { File.Copy(f.FullName, "C:\\OMS\\Mail_Mail\\" + f.Name.ToString(), true); File.Delete(f.FullName); for (int k = 0; k <= oDataSet.Tables[0].Rows.Count - 1; k++) { if (oDataSet.Tables[0].Rows[k]["UsrEmailAddress"].ToString() != "") { //Kartik Checking Oct-21-2009 [START] StreamWriter sw = File.AppendText("c:\\Test1.txt"); sw.WriteLine(oDataSet.Tables[0].Rows[k]["UsrEmailAddress"].ToString()); sw.Close(); //Kartik Checking Oct-21-2009 [END] pathname = "C:\\OMS\\Mail_Mail\\" + f.Name.ToString(); // @"D:\TransferPurchase\Buy03022009Purchase.txt"; string s; MailMessage mail = new MailMessage(); mail.To = oDataSet.Tables[0].Rows[k]["UsrEmailAddress"].ToString(); mail.From = Sender; mail.Subject = f.Name.ToString(); mail.Body = f.Name.ToString(); MailAttachment attachment = new MailAttachment(pathname); //create the attachment mail.Attachments.Add(attachment); //add the attachment SmtpMail.SmtpServer = Mail; //your real server goes here SmtpMail.Send(mail); } else { File.Copy(f.FullName, "C:\\OMS\\OMS_Mail_Err\\" + f.Name.ToString(), true); File.Delete(f.FullName); } } } } }