Пример #1
0
 public static bool SendMail(string ToMail, string FromMail, string FromPW, string Content, string Subject, System.Net.Mail.Attachment FileAttach)
 {
     try
     {
         MailMessage msg = new MailMessage();
         msg.From = new MailAddress(FromMail);
         msg.To.Add(ToMail);
         msg.Subject = Subject;
         msg.Body    = Content;
         if (FileAttach != null)
         {
             FileAttach = new System.Net.Mail.Attachment("File Đính Kèm");
             msg.Attachments.Add(FileAttach);
         }
         msg.IsBodyHtml = false;
         SmtpClient smtp = new SmtpClient();
         smtp.Host = "smtp.gmail.com";
         smtp.UseDefaultCredentials = false;
         NetworkCredential NetworkCred = new NetworkCredential(FromMail, FromPW);
         smtp.Credentials = NetworkCred;
         smtp.EnableSsl   = true;
         smtp.Port        = 587;
         smtp.Send(msg);
         return(true);
     }
     catch (Exception ex)
     {
         Ultis.WriteLog(ex.ToString());
     }
     return(false);
 }
Пример #2
0
        /// <summary>
        ///  Hàm lấy dữ liệu trả về kiểu đối tượng với 1 đối tượng nên câu lệnh truyền vào được phép lấy 1 đối tượng - theo thủ tục procedure
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public object SQLEXEC0A(string sql)
        {
            object msg = new object();

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = ConnectDataBase.Cnn;
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.StoredProcedure;
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    msg = dr[0];
                }
                dr.Close();
                Ultis.WriteLog(sql);
            }
            catch (Exception ex)
            {
                Ultis.WriteLog(ex.ToString());
                return(null);
            }
            return(msg);
        }
Пример #3
0
        public DataTable SelectSQL(string sql)
        {
            SqlCommand cmd = new SqlCommand();
            DataTable  dt  = new DataTable();

            da = new SqlDataAdapter();
            dt = null;
            DataSet ds = new DataSet();

            try
            {
                cmd.Connection  = ConnectDataBase.Cnn;
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
                da.SelectCommand = cmd;
                da.Fill(ds);
                dt = ds.Tables[0];
                Ultis.WriteLog(sql);
            }
            catch (SqlException ex)
            {
                Ultis.WriteLog(ex.ToString());
                return(null);
            }
            finally
            {
            }
            return(dt);
        }
Пример #4
0
        public bool UpdateExRate(bool IsUpate)
        {
            //-------- Kiểm tra ngày đó tỷ giá được cập nhật hay chưa
            try
            {
                if (IsUpate)
                {
                    MessageBox.Show("1");
                    string sqlcmd = @"select count(*) from _Currency where DateTime ='" + DateTime.Now.ToString("MM/dd/yyyy") + "'";
                    Ultis.WriteLog(sqlcmd);
                    string isUpdate = SQLEXEC(sqlcmd).ToString();
                    if (Int32.Parse(isUpdate) > 0)
                    {
                        return(false);
                    }
                    else
                    {
                        System.Xml.XmlDocument xml = new System.Xml.XmlDocument();
                        xml.Load("http://www.vietcombank.com.vn/exchangerates/ExrateXML.aspx");
                        System.Xml.XmlNodeList noXml;
                        noXml = xml.SelectNodes("/ExrateList/Exrate");
                        int       i  = 0;
                        DataTable dt = new DataTable();
                        dt = SelectSQL("select top(0) * from _Currency");
                        for (i = 0; i <= noXml.Count - 1; i++)
                        {
                            DataRow dr = dt.NewRow();
                            //ListViewItem CurrencyCode = new ListViewItem(noXml.Item(i).Attributes["CurrencyCode"].InnerText);
                            //ListViewItem CurrencyCode = new ListViewItem(noXml.Item(i).Attributes["CurrencyCode"].InnerText);
                            //// item.SubItems.Add(noXml.Item(i).Attributes["ListViewItem"].InnerText);
                            ////item.SubItems.Add(noXml.Item(i).Attributes["Buy"].InnerText);
                            ////item.SubItems.Add(noXml.Item(i).Attributes["Transfer"].InnerText);
                            //// item.SubItems.Add(noXml.Item(i).Attributes["Sell"].InnerText);
                            ////MessageBox.Show(noXml.Item(i).Attributes["Sell"].InnerText);

                            //ListViewItem item2 = new ListViewItem(noXml.Item(i).Attributes["Sell"].InnerText);
                            //ListViewItem item3 = new ListViewItem(noXml.Item(i).Attributes["Transfer"].InnerText);
                            // item2.SubItems.Add(noXml.Item(i).Attributes["Sell"].InnerText);
                            dr["CurrencyCode"] = noXml.Item(i).Attributes["CurrencyCode"].InnerText;
                            dr["Buy"]          = noXml.Item(i).Attributes["Buy"].InnerText;
                            dr["Transfer"]     = noXml.Item(i).Attributes["Transfer"].InnerText;
                            dr["Sell"]         = noXml.Item(i).Attributes["Sell"].InnerText;
                            dr["DateTime"]     = System.DateTime.Now.ToString("MM/dd/yyyy");
                            dt.Rows.Add(dr);
                        }
                        dt.TableName = "_Currency";
                        InsertDBToSQL(dt);
                        return(true);
                    }
                }
            }
            catch (Exception ex)
            {
                Ultis.WriteLog(ex.ToString());
            }

            //----------------------------------------------------
            return(false);
        }
Пример #5
0
        public static string GetLocalIPAddress()
        {
            string IP = "";

            try
            {
                var host = Dns.GetHostEntry(Dns.GetHostName());
                foreach (var ip in host.AddressList)
                {
                    if (ip.AddressFamily == AddressFamily.InterNetwork)
                    {
                        IP = ip.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                Ultis.WriteLog(ex.ToString());
            }
            return(IP);
        }
Пример #6
0
 public bool SQLEXEC1A(string sql)
 {
     try
     {
         SqlCommand cmd = new SqlCommand();
         cmd.Connection  = ConnectDataBase.Cnn;
         cmd.CommandText = sql;
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.ExecuteNonQuery();
         Ultis.WriteLog(sql);
     }
     catch (SqlException ex)
     {
         Ultis.WriteLog(ex.ToString());
         return(false);
     }
     finally
     {
     }
     return(true);
 }
Пример #7
0
        public bool InsertDBToSQL(DataTable dt)
        {
            try
            {
                StringBuilder sb = new StringBuilder();
                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("INSERT INTO " + dt.TableName + "(");

                        for (int checkcol = 0; checkcol < dt.Columns.Count; checkcol++)
                        {
                            if (dt.Columns[checkcol].ColumnName.StartsWith("f_identity"))
                            {
                                MessageBox.Show("1");
                                sb.Append(dt.Columns[checkcol - 1].ColumnName).Append(",");
                            }
                            else
                            {
                                sb.Append(dt.Columns[checkcol].ColumnName).Append(",");
                            }
                        }
                        //for (int col = 0; col < dt.Columns.Count - 1; col++)
                        //{
                        //    sb.Append(dt.Columns[col].ColumnName).Append(",");
                        //}

                        sb.Remove(sb.Length - 1, 1);
                        sb.Append(") VALUES (");
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            if (dt.Columns[j].ColumnName.StartsWith("f_identity"))
                            {
                                System.Type ColType = dt.Rows[i][j - 1].GetType();
                                if (ColType == typeof(int) || ColType == typeof(decimal))
                                {
                                    sb.Append(dt.Rows[i][j - 1].ToString()).Append(",");
                                }
                                else
                                {
                                    sb.Append("'").Append(dt.Rows[i][j - 1].ToString()).Append("'").Append(",");
                                }
                            }
                            else
                            {
                                System.Type ColType = dt.Rows[i][j].GetType();
                                if (ColType == typeof(int) || ColType == typeof(decimal))
                                {
                                    sb.Append(dt.Rows[i][j].ToString()).Append(",");
                                }
                                else
                                {
                                    sb.Append("'").Append(dt.Rows[i][j].ToString()).Append("'").Append(",");
                                }
                            }
                        }
                        //for (int j = 0; j < dt.Columns.Count - 1; j++)
                        //{
                        //    System.Type ColType = dt.Rows[i][j].GetType();
                        //    if (ColType == typeof(int) || ColType == typeof(decimal))
                        //    {

                        //        sb.Append(dt.Rows[i][j].ToString()).Append(",");
                        //    }
                        //    else
                        //    {
                        //        sb.Append("'").Append(dt.Rows[i][j].ToString()).Append("'").Append(",");
                        //    }
                        //}
                        // }

                        sb.Remove(sb.Length - 1, 1);
                        sb.Append(")");
                    }
                    //MessageBox.Show(sb.ToString());
                    Ultis.WriteLog(sb.ToString());
                }
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = ConnectDataBase.Cnn;
                cmd.CommandText = sb.ToString();
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                Ultis.WriteLog(ex.ToString());
                return(false);
            }

            return(true);
        }