Developer Scripts

Welcome

2014-12-31T15:40:00.000-06:00

Wellcome to "Developer Scripts", here you can find scripts to your sofyware development.
Do not forget add +1 when you use a script published here.

Please visit www.TyroDeveloper.com

Thanks and enjoy the site...

Create a Encrypted Private Key in C#

2014-01-24T15:57:00.002-06:00

Whe have this XML Private Key:


5ayPZaKM3flHFu2B7aiYpkI81/cByFHHNSmcgQQfP+X2bIGf7JlkuEneh5z7PRkk7Z05jOGxIMdvDd7pVLIWmgRLWaN7bI8JAVf8lUN0kcjA5KgQNjRI23LpvnvzHQjB4jyNXkhhxKXREreeWtEujduD1u99l5t2WxoDqdbYbdc=

AQAB
/27P2g48qXfQBlFRZ+pes6EBBUYzS3r7B1BL3g/O9VFJnZBPQFzclEdZPVvjh9Ve+HktvbKTaYRJ5wlVewDVRw==
5i8bXxa7g6Tue2/NkOjFK5i54RTaGPbjvPcg1N1Wq8pew0lx0lY3q7A+qH3VjiJHwSRifY7n92zkxutSqF4q8Q==
hyilhyZ9ZtblFlK1Fp1nWvlYxuesgMYkSmxsmKYYxqoqn9sadF4uwa83Q0Z6EQgQZr4IPBZf9jdvu3au6pU4RQ==
RWDDZjiq0fXfL3M2SUvvScGhnNa1GbsoTydJTP9dhS/cug2j8dqssuHPMOeke0+Xwv4ddWyiO/AlUFNTOY4QcQ==
BtvaLLe1E1whaPvvT7r72qPl8oq+E020GiHmvO7v08D1SfynETLs5NJVAn4e3ChHNSvErTshin0r1JvLLTKqRw==
31S3r52rmuEdtnbHI8EQhoLcRSikLBURP2myDGZkuK61u3ckel4CaY0y/O2yBAxiM0fyQULpCTXEkFlUzI3LmKoj/L0cSlk58xf8hB837/fn/bulnATWSajKn/p4ecXpBlPTySf9MPwoyNwXdyjjz0bQc6oo1U42VybQRNgvWGE=

And we need to convert to this format:

Here the c# code:

public string EncryptPrivateKey(string pPhrase)
{

    RSA rsa1 = RSA.Create();
    rsa1.FromXmlString(xml_private_key);//Put here your XML Privatye Key
    AsymmetricCipherKeyPair keyPair = 
        Org.BouncyCastle.Security.DotNetUtilities.GetRsaKeyPair(rsa1);
    TextWriter textWriter = new StringWriter();
    PemWriter pemWriter = new PemWriter(textWriter);
    pemWriter.WriteObject(keyPair.Private, "DES-EDE3-CBC", pPhrase.ToCharArray(), new SecureRandom());
    pemWriter.Writer.Flush();
    return (textWriter.ToString());          
}

Convert RSA to PEM

2014-01-22T13:33:00.000-06:00

Hi friends, after some days searching the way to convert a RSACrytoServiceProvider (RSA) to PEM format finally in C# i found this code:

using System;
using System.IO;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using Org.BouncyCastle.Asn1.Pkcs;
using Org.BouncyCastle.Asn1.X509;
using Org.BouncyCastle.Crypto;
using Org.BouncyCastle.Crypto.Parameters;
using Org.BouncyCastle.OpenSsl;
using Org.BouncyCastle.Pkcs;
using Org.BouncyCastle.Security;
using Org.BouncyCastle.X509;

namespace RsaKeyConverter.Converter
{
    public static class RsaKeyConverter
    {
        public static string XmlToPem(string xml)
        {
            using (RSA rsa = RSA.Create())
            {
                rsa.FromXmlString(xml);

                AsymmetricCipherKeyPair keyPair = Org.BouncyCastle.Security.DotNetUtilities.GetRsaKeyPair(rsa); // try get private and public key pair
                if (keyPair != null) // if XML RSA key contains private key
                {
                    PrivateKeyInfo privateKeyInfo = PrivateKeyInfoFactory.CreatePrivateKeyInfo(keyPair.Private);
                    return FormatPem(Convert.ToBase64String(privateKeyInfo.GetEncoded()), "PRIVATE KEY");
                   
                }

                RsaKeyParameters publicKey = Org.BouncyCastle.Security.DotNetUtilities.GetRsaPublicKey(rsa); // try get public key
                if (publicKey != null) // if XML RSA key contains public key
                {
                    SubjectPublicKeyInfo publicKeyInfo = SubjectPublicKeyInfoFactory.CreateSubjectPublicKeyInfo(publicKey);
                    return FormatPem(Convert.ToBase64String(publicKeyInfo.GetEncoded()), "PUBLIC KEY");
                }
            }

            throw new InvalidKeyException("Invalid RSA Xml Key");
        }

        public static string PublicXmlToPem(string xml)
        {
            using (RSA rsa = RSA.Create())
            {
                rsa.FromXmlString(xml);

                RsaKeyParameters publicKey = Org.BouncyCastle.Security.DotNetUtilities.GetRsaPublicKey(rsa); // try get public key
                if (publicKey != null) // if XML RSA key contains public key
                {
                    SubjectPublicKeyInfo publicKeyInfo = SubjectPublicKeyInfoFactory.CreateSubjectPublicKeyInfo(publicKey);
                    return FormatPem(Convert.ToBase64String(publicKeyInfo.GetEncoded()), "PUBLIC KEY");
                }
            }

            throw new InvalidKeyException("Invalid RSA Xml Key");
        }

        private static string FormatPem(string pem, string keyType)
        {
            var sb = new StringBuilder();
            sb.AppendFormat("-----BEGIN {0}-----\n", keyType);

            int line = 1, width = 64;

            while ((line - 1) * width < pem.Length)
            {
                int startIndex = (line - 1) * width;
                int len = line * width > pem.Length
                              ? pem.Length - startIndex
                              : width;
                sb.AppendFormat("{0}\n", pem.Substring(startIndex, len));
                line++;
            }

            sb.AppendFormat("-----END {0}-----\n", keyType);
            return sb.ToString();
        }

        public static string PemToXml(string pem)
        {
            if (pem.StartsWith("-----BEGIN RSA PRIVATE KEY-----")
                || pem.StartsWith("-----BEGIN PRIVATE KEY-----"))
            {
                return GetXmlRsaKey(pem, obj =>
                {
                    if ((obj as RsaPrivateCrtKeyParameters) != null)
                        return DotNetUtilities.ToRSA((RsaPrivateCrtKeyParameters)obj);
                    var keyPair = (AsymmetricCipherKeyPair)obj;
                    return DotNetUtilities.ToRSA((RsaPrivateCrtKeyParameters)keyPair.Private);
                }, rsa => rsa.ToXmlString(true));
            }

            if (pem.StartsWith("-----BEGIN PUBLIC KEY-----"))
            {
                return GetXmlRsaKey(pem, obj =>
                {
                    var publicKey = (RsaKeyParameters)obj;
                    return DotNetUtilities.ToRSA(publicKey);
                }, rsa => rsa.ToXmlString(false));
            }

            throw new InvalidKeyException("Unsupported PEM format...");
        }

        private static string GetXmlRsaKey(string pem, Func getRsa, Func getKey)
        {
            using (var ms = new MemoryStream())
            using (var sw = new StreamWriter(ms))
            using (var sr = new StreamReader(ms))
            {
                sw.Write(pem);
                sw.Flush();
                ms.Position = 0;
                var pr = new PemReader(sr);
                object keyPair = pr.ReadObject();
                using (RSA rsa = getRsa(keyPair))
                {
                    var xml = getKey(rsa);
                    return xml;
                }
            }
        }
    }
}

How to Use:

string private_pem = RsaKeyConverter.Converter.RsaKeyConverter.XmlToPem(rsa.ToXmlString(true));//private
string public_pem = RsaKeyConverter.Converter.RsaKeyConverter.PublicXmlToPem(rsa.ToXmlString(false));//public

Where rsa is your RSACryptoServiceProvider object.

You need C# Bouncy Castle Library - Download is 100% free

Regards

ComboBox Item Color

2012-04-23T13:03:00.000-05:00

You can add items to ComboBox control with colors. You only need to create a CustomComboBox that enable add items with the desired color:

using System;
using System.Windows.Forms;
using System.Drawing;
namespace TyroDeveloperDLL
{
    public class ComboBoxCustom : ComboBox
    {
        public ComboBoxCustom()
        {
            this.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed;
        }
        protected override void OnDrawItem(DrawItemEventArgs e)
        {
            base.OnDrawItem(e);
            if (e.Index < 0) { return; }
            e.DrawBackground();
            ComboBoxItem item = (ComboBoxItem)this.Items[e.Index];
            Brush brush = new SolidBrush(item.ForeColor);
            if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
            { brush = Brushes.Yellow; }
            e.Graphics.DrawString(item.Text, 
                this.Font, brush, e.Bounds.X, e.Bounds.Y);
        }
        object selectedValue = null;
        public new Object SelectedValue
        {
            get
            {
                object ret = null;
                if (this.SelectedIndex >= 0) { 
                    ret = ((ComboBoxItem)this.SelectedItem).Value; 
                }
                return ret;
            }
            set { selectedValue = value; }
        }
        string selectedText = "";
        public new String SelectedText
        {
            get
            {
                return ((ComboBoxItem)this.SelectedItem).Text;
            }
            set { selectedText = value; }
        }
    }
    public class ComboBoxItem
    {
        public ComboBoxItem() { }

        public ComboBoxItem(string pText, object pValue)
        {
            text = pText; val = pValue;
        }

        public ComboBoxItem(string pText, object pValue, Color pColor)
        {
            text = pText; val = pValue; foreColor = pColor;
        }

        string text = "";
        public string Text
        {
            get { return text; }
            set { text = value; }
        }

        object val;
        public object Value
        {
            get { return val; }
            set { val = value; }
        }

        Color foreColor = Color.Black;
        public Color ForeColor
        {
            get { return foreColor; }
            set { foreColor = value; }
        }

        public override string ToString()
        {
            return text;
        }
    }
}

To add items:

comboBoxCustom1.Items.Add(new ComboBoxItem("México", "0", Color.Green));
comboBoxCustom1.Items.Add(new ComboBoxItem("USA", "1", Color.Blue));
comboBoxCustom1.Items.Add(new ComboBoxItem("China", "2", Color.Red));

To get the item values:

string Msg = String.Format("Text: {0}\nValue: {1}", 
   comboBoxCustom1.SelectedText, comboBoxCustom1.SelectedValue);
MessageBox.Show(Msg);

Please visit: www.TyroDeveloper
Please Click on +1

Connect to a MySQL Database PHP

2012-03-22T13:57:00.000-06:00

Open Connection



 $con = mysql_connect("localhost","dbUserName","p@assword");
 if (!$con){die('Could not connect: ' . mysql_error());}
 
//some code

Close Connection


$con = mysql_connect("localhost","dbUserName","p@assword");
if (!$con){die('Could not connect: ' . mysql_error());}

// some code
mysql_close($con);

Microsoft Access Connection Strings

2012-03-20T13:39:00.002-06:00

Standard:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

With Data Base Password:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbP@ssword;

Data Directory:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;

Network Location:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;

You can change the provider to Access 2007-2010 Data Base:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

Please visit: www.TyroDeveloper
Please Click on +1

Read web.config C#

2012-03-20T12:04:00.001-06:00

web.config example:

CSharp (C#) Code:

public static string WebConfig(string prmKey) {
    try
    {
        string value = ConfigurationManager.AppSettings[prmKey];
        return (value);
    }
    catch {
        return ("");
    }
}

Implementation:

string GMailURL = WebConfig("DEVELOPER_URL");

Please visit: www.TyroDeveloper
Please Click on +1

Restore Data Base SQL Server

2012-03-20T11:35:00.004-06:00

RESTORE DATABASE [PointOfSale] 
FROM  DISK = N'C:\MyDataFiles\PointOfSale_Full.bak' 
WITH  FILE = 1,  
MOVE N'PointOfSale_Data' TO N'C:\MyDataFiles\PointOfSale_Data.mdf',  
MOVE N'PointOfSale_Log' TO N'C:\MYDataFiles\PointOfSale_Log.ldf',  
NOUNLOAD,  STATS = 10

Please visit: www.TyroDeveloper
Please Click on +1

Backup Data Base SQL Server

2012-03-20T11:30:00.002-06:00

BACKUP DATABASE [PointOfSale] TO  
DISK = N'C:\MyDataFiles\PointOfSale_Full.bak' 
WITH NOFORMAT, NOINIT,  NAME = N'PointOfSale-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10

Create Data Base SQL Server

2012-03-20T11:19:00.001-06:00

USE master;
GO
CREATE DATABASE PointOfSale
ON 
( NAME = PointOfSale_Data,
    FILENAME = 'C:\MyDataFiles\PointOfSale_Data.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
LOG ON
( NAME = PointOfSale_Log,
    FILENAME = 'C:\MyDataFiles\PointOfSale_Log.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB ) ;
GO

Please visit: www.TyroDeveloper

Please Click on +1

Generare ID with SQL Server

2012-03-19T14:51:00.001-06:00

CREATE FUNCTION [dbo].[fn_GenerateID]
 (@ID BIGINT, @LEN SMALLINT)
RETURNS NVARCHAR(100)
AS
/*
THIS FUNCTION GENERATE ID WITH LEFT ZEROS.
JUAN GABRIEL CASTILLO TURRUBIATES
tyrodeveloper@gmail.com
20 dic 2011
Example:
SELECT dbo.fn_GenerateID(243,5) AS RESULT
Where 243 is the number to be converted and
5 is the number of chars, the value result is:
|RESULT
00243
*/
BEGIN
 DECLARE @SRC_LEN SMALLINT, @DIFF_LEN SMALLINT, 
 @COUNT SMALLINT, @ZERO NVARCHAR(100)
 SET @ZERO=''
 SET @SRC_LEN = LEN(CAST(@ID AS NVARCHAR(100)))
 IF @LEN <= @SRC_LEN
 BEGIN
  --IF THE LENREQUESTED IS LESS OR EQUAL THAN THE ORIGINAL
  SET @ZERO = ''
 END
 ELSE
 BEGIN
  --IF THE LEN REQUESTED IS MORE THAN THE ORIGINAL
  SET @COUNT= 0
  SET @DIFF_LEN = @LEN - @SRC_LEN 
  WHILE(@COUNT < @DIFF_LEN)
  BEGIN
   SET @ZERO = @ZERO + '0'
   SET @COUNT = @COUNT + 1
  END
 END
 RETURN @ZERO + CAST(@ID AS NVARCHAR(100))
END

GO

Please visit: www.TyroDeveloper.com

Please Click on +1

Pictures on Access

2012-03-19T14:44:00.001-06:00

using System;
using System.Data.OleDb;
using System.IO;
namespace TyroDeveloper.Class
{
    public class AccessPictures
    {
        string _connStr = "";
        public string ConnStr { 
            get { return _connStr; } 
            set { _connStr = value; } 
        }
        public bool SetPicture(string tableName, string fieldId, 
            string fieldIdValue, 
            string targetFieldName, string fileName){
            OleDbConnection conn = new OleDbConnection(_connStr);
            try
            {
                System.IO.FileStream fs = 
                    new FileStream(fileName, FileMode.Open, FileAccess.Read);
                System.IO.BinaryReader br = new System.IO.BinaryReader(fs);
                byte[] picture = new byte[fs.Length];
                br.Read(picture, 0, (int)fs.Length);
                br.Close();
                fs.Close();
                string SQL = String.Format("UPDATE [{0}] "+
                    " SET [{1}]=@IMG WHERE [{2}]=@ID", 
                    tableName, targetFieldName, fieldId);
                conn.Open();
                OleDbCommand comm = new OleDbCommand(SQL, conn);
                //IMAGE
                OleDbParameter parImagen = 
                    new OleDbParameter("@IMG", OleDbType.VarBinary, 
                        picture.Length);
                parImagen.Value = picture;
                comm.Parameters.Add(parImagen);
                //ID
                OleDbParameter parId = new OleDbParameter("@ID", fieldIdValue);
                comm.Parameters.Add(parId);
                comm.ExecuteNonQuery();
                return (true);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally { conn.Close(); }
        }
        public byte[] GetPicture(string targetFieldName,string fieldIdName, 
            string tableName, string fieldIdValue){
            OleDbConnection conn = new OleDbConnection(_connStr);
            try {
                conn.Open();
                string SQL = string.Format("SELECT [{0}], [{1}] "+
                    " FROM [{2}] WHERE [{1}]=@ID AND [{0}] IS NOT NULL", 
                    targetFieldName, fieldIdName, tableName);
                OleDbCommand comm = new OleDbCommand(SQL, conn);
                OleDbParameter parId = new OleDbParameter("@ID", fieldIdValue);
                comm.Parameters.Add(parId);
                OleDbDataReader dr = null;
                dr = comm.ExecuteReader();
                byte[] aBytes = null;
                if (dr.Read())
                {
                    aBytes = (byte[])dr[targetFieldName];
                }
                dr.Close();
                return (aBytes);
            }
            catch (Exception ex) { throw (ex); }
            finally { conn.Close(); }
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Folder Browser Dialog C#

2012-03-19T11:05:00.002-06:00

FolderBrowserDialog dlg = new FolderBrowserDialog();
DialogResult res = dlg.ShowDialog();
if (res == DialogResult.OK)
{
    txtReportsFolder.Text = dlg.SelectedPath;
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Open File Dialog C#

2012-03-19T11:03:00.003-06:00

OpenFileDialog m_OpenFile = new OpenFileDialog();
m_OpenFile.Title = "Buscar Base de Datos";
m_OpenFile.Filter = "All Files(*.*)|*.*|Base de datos de Microsoft Access (*.mdb)|*.mdb";
m_OpenFile.FilterIndex = 2;
if (m_OpenFile.ShowDialog() == DialogResult.OK)
{
    txtSource.Text = m_OpenFile.FileName.ToString();
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Safe SQL Like Clause Literal C#

2012-03-19T10:46:00.003-06:00

    public static string SafeSqlLikeClauseLiteral(string prmSQLString)
    {
        string s = prmSQLString;
        s = s.Replace("'", "''");
        s = s.Replace("[", "[[]");
        s = s.Replace("%", "[%]");
        s = s.Replace("_", "[_]");
        return (s);
    }

Please visit: www.TyroDeveloper.com

Please Click on +1

ASP.Net Absolute URL C#

2012-03-19T10:43:00.000-06:00

    public static string GetUrl(string file, Page page)
    {
        string end = (page.Request.ApplicationPath.EndsWith("/")) ? "" : "/";
        string path = page.Request.ApplicationPath + end;
        return string.Format("http://{0}{1}{2}", page.Request.Url.Authority, path, file);
    }

Please visit: www.TyroDeveloper.com

Please Click on +1

Read and Write Cookies C#

2012-03-19T10:39:00.004-06:00

using System;
using System.Web.UI;

/// 
/// Cookies
/// 
public class clsCookies{

    public string GetCookie(Page page, string cookieName, string defaultValue) {
        try {
            if (page.Request.Cookies[cookieName] != null)
            {
                return (page.Request.Cookies[cookieName].Value);
            }
            else {
                return (defaultValue);
            }
        }
        catch {
            return (defaultValue);
        }
    }

    public void SetCookie(Page page, string cookieName,string cookieValue) {
        page.Response.Cookies[cookieName].Value = cookieValue;
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Send Email C#

2012-03-19T10:34:00.003-06:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net.Mail;
namespace TyroDeveloperDLL
{
    public class clsMail
    {
        string userid = "";
        public String UserId {
            get { return userid; }
            set { userid = value; }
        }
        string userpassword = "";
        public String UserPassword {
            get { return userpassword; }
            set { userpassword = value; }
        }
        string host = "";
        public String  Host {
            get { return host; }
            set { host = value; }
        }
        int port = 80;
        public Int32 Port{
            get { return port; }
            set { port = value; }
        }
        string destination_email = "";
        public String DestinationEmail {
            get { return destination_email; }
            set { destination_email = value; }
        }
        string subject = "";
        public String Subject {
            get { return subject; }
            set { subject = value; }
        }
        string message = "";
        public String Message {
            get { return message; }
            set { message = value; }
        }
        MailPriority priority = MailPriority.Normal;
        public MailPriority EmailPriority {
            get { return priority; }
            set { priority = value; }
        }
        public bool Send(string prmDestinationEMail, string prmSubject, string prmMessage)
        {
            try
            {               
                MailMessage correo = new MailMessage();
                correo.From = new MailAddress(userid);
                correo.To.Add(prmDestinationEMail);
                correo.Subject = prmSubject;
                correo.Body = prmMessage;
                correo.IsBodyHtml = true;
                correo.Priority = priority;
                SmtpClient smtp = new SmtpClient();
                smtp.Credentials = 
                    new System.Net.NetworkCredential(userid, userpassword);
                smtp.Host = host;
                smtp.Port = port;
                smtp.EnableSsl = true;
                smtp.Send(correo);
                return (true);

            }
            catch (Exception ex)
            {
                throw(ex);
            }
        }
        public bool Send()
        {
            try
            {
                MailMessage correo = new MailMessage();
                correo.From = new MailAddress(userid);
                correo.To.Add(destination_email);
                correo.Subject = subject;
                correo.Body = message;
                correo.IsBodyHtml = true;
                correo.Priority = priority;
                SmtpClient smtp = new SmtpClient();
                smtp.Credentials = 
                    new System.Net.NetworkCredential(userid, userpassword);
                smtp.Host = host;
                smtp.Port = port;
                smtp.EnableSsl = true;
                smtp.Send(correo);
                return (true);

            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Custom HTMLEditor C#

2012-03-19T10:24:00.003-06:00

using AjaxControlToolkit.HTMLEditor;
/// 
/// Summary description for MyHTMLEditor
/// 
/// namespace 
/// 
namespace TyroDeveloper.WebControls
{
    public class MyHTMLEditor : Editor
    {
        protected override void FillTopToolbar()
        {
           
            //this.TopToolbar.Buttons.Clear();
            TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Bold()); 
            TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Italic());
            TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Underline());
            TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.BulletedList());
        }
        protected override void FillBottomToolbar()
        {
            //base.FillBottomToolbar();
            BottomToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.DesignMode()); 
            BottomToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.PreviewMode());
            BottomToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.HtmlMode()); 
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Link on a GridView

2012-03-19T10:14:00.000-06:00


    
        
            Text Link
        
    
    
        Hearder Text Link

Please visit: www.TyroDeveloper.com

Please Click on +1

ListView to Excel C#

2012-03-17T23:23:00.003-06:00

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;
namespace TyroDeveloperDLL
{
    public class ListViewToExcel
    {
        /// 
        /// Export to Excel
        /// 
        /// Name of the ListView control
        /// Book name
        /// Folder to put the file. 
        /// To export a list of items
        /// C#: ExportToExcel(lvArticulos,"Items","C:\");
        public static void ExportToExcel(ListView lv, string prmBookName, string prmPath)
        {
            try
            {
                if (lv.Items.Count == 0)
                {
                    MessageBox.Show("No items to export",
                        "System Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    return;
                }

                string[] st = new string[lv.Columns.Count];
                DirectoryInfo di = new DirectoryInfo(prmPath);
                if (di.Exists == false) di.Create();
                StreamWriter sw = new StreamWriter(prmPath + prmBookName + ".xls", false);
                sw.AutoFlush = true;
                for (int col = 0; col < lv.Columns.Count; col++)
                {
                    sw.Write("\t" + lv.Columns[col].Text.ToString());
                }
                int rowIndex = 1; int row = 0;
                string st1 = "";
                for (row = 0; row < lv.Items.Count; row++)
                {
                    if (rowIndex <= lv.Items.Count)
                        rowIndex++;
                    if (row == 0) st1 = "\n";
                    else st1 = "";
                    for (int col = 0; col < lv.Columns.Count; col++)
                    {
                        st1 = st1 + "\t" + "'" + lv.Items[row].SubItems[col].Text.ToString();
                    }
                    sw.WriteLine(st1);
                }
                sw.Close();
                FileInfo fil = new FileInfo(prmPath + prmBookName + ".xls");
                if (fil.Exists == true)
                    MessageBox.Show("¡Finished!\n" +
                        "File Name: " + prmPath + prmBookName,
                        "Export to Excel",
                        MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Taskbar Notifier C#

2012-03-17T23:17:00.000-06:00

// C# TaskbarNotifier Class v1.0
// by John O'Byrne - 02 december 2002
// 01 april 2003 : Small fix in the OnMouseUp handler
// 11 january 2003 : Patrick Vanden Driessche  added a few enhancements
// Small Enhancements/Bugfix
// Small bugfix: When Content text measures larger than the corresponding ContentRectangle
// the focus rectangle was not correctly drawn. This has been solved.
// Added KeepVisibleOnMouseOver
// Added ReShowOnMouseOver
// Added If the Title or Content are too long to fit in the corresponding Rectangles,
// the text is truncateed and the ellipses are appended (StringTrimming).

using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Drawing2D;
using System.Windows.Forms;
using System.Runtime.InteropServices;

namespace GoogleReaderNotifier.WinUI
{
    /// 
    /// TaskbarNotifier allows to display MSN style/Skinned instant messaging popups
    /// 
    public class TaskbarNotifier : System.Windows.Forms.Form
    {
        #region TaskbarNotifier Protected Members
        protected Bitmap BackgroundBitmap = null;
        protected Bitmap CloseBitmap = null;
        protected Point CloseBitmapLocation;
        protected Size CloseBitmapSize;
        protected Rectangle RealTitleRectangle;
        protected Rectangle RealContentRectangle;
        protected Rectangle WorkAreaRectangle;
        protected Timer timer = new Timer();
        protected TaskbarStates taskbarState = TaskbarStates.hidden;
        protected string titleText;
        protected string contentText;
        protected Color normalTitleColor = Color.FromArgb(255, 0, 0);
        protected Color hoverTitleColor = Color.FromArgb(255, 0, 0);
        protected Color normalContentColor = Color.FromArgb(0, 0, 0);
        protected Color hoverContentColor = Color.FromArgb(0, 0, 0x66);
        protected Font normalTitleFont = new Font("Arial", 12, FontStyle.Regular, GraphicsUnit.Pixel);
        protected Font hoverTitleFont = new Font("Arial", 12, FontStyle.Bold, GraphicsUnit.Pixel);
        protected Font normalContentFont = new Font("Arial", 11, FontStyle.Regular, GraphicsUnit.Pixel);
        protected Font hoverContentFont = new Font("Arial", 11, FontStyle.Regular, GraphicsUnit.Pixel);
        protected int nShowEvents;
        protected int nHideEvents;
        protected int nVisibleEvents;
        protected int nIncrementShow;
        protected int nIncrementHide;
        protected bool bIsMouseOverPopup = false;
        protected bool bIsMouseOverClose = false;
        protected bool bIsMouseOverContent = false;
        protected bool bIsMouseOverTitle = false;
        protected bool bIsMouseDown = false;
        protected bool bKeepVisibleOnMouseOver = true;   // Added Rev 002
        protected bool bReShowOnMouseOver = false;    // Added Rev 002
        #endregion

        #region TaskbarNotifier Public Members
        public Rectangle TitleRectangle;
        public Rectangle ContentRectangle;
        public bool TitleClickable = false;
        public bool ContentClickable = true;
        public bool CloseClickable = true;
        public bool EnableSelectionRectangle = true;
        public event EventHandler CloseClick = null;
        public event EventHandler TitleClick = null;
        public event EventHandler ContentClick = null;
        #endregion

        #region TaskbarNotifier Enums
        /// 
        /// List of the different popup animation status
        /// 
        public enum TaskbarStates
        {
            hidden = 0,
            appearing = 1,
            visible = 2,
            disappearing = 3
        }
        #endregion

        #region TaskbarNotifier Constructor
        /// 
        /// The Constructor for TaskbarNotifier
        /// 
        public TaskbarNotifier()
        {
            // Window Style
            FormBorderStyle = FormBorderStyle.None;
            WindowState = FormWindowState.Minimized;
            base.Show();
            base.Hide();
            WindowState = FormWindowState.Normal;
            ShowInTaskbar = false;
            TopMost = true;
            MaximizeBox = false;
            MinimizeBox = false;
            ControlBox = false;

            timer.Enabled = true;
            timer.Tick += new EventHandler(OnTimer);
            //CloseBitmap
            CloseBitmap = global::TyroDeveloperDLL.Properties.Resources.close;
            CloseBitmapSize = new System.Drawing.Size(16, 16);
            CloseBitmapLocation = new Point(325, 8);
            //BackgroundBitmap
            BackgroundBitmap = global::TyroDeveloperDLL.Properties.Resources.bak;
            //configuration
            TitleRectangle = new Rectangle(8, 9, 300, 25);
            ContentRectangle = new Rectangle(8, 41, 300, 100);
            
        }
        #endregion

        #region TaskbarNotifier Properties
        /// 
        /// Get the current TaskbarState (hidden, showing, visible, hiding)
        /// 
        public TaskbarStates TaskbarState
        {
            get
            {
                return taskbarState;
            }
        }

        /// 
        /// Get/Set the popup Title Text
        /// 
        public string TitleText
        {
            get
            {
                return titleText;
            }
            set
            {
                titleText = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the popup Content Text
        /// 
        public string ContentText
        {
            get
            {
                return contentText;
            }
            set
            {
                contentText = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Normal Title Color
        /// 
        public Color NormalTitleColor
        {
            get
            {
                return normalTitleColor;
            }
            set
            {
                normalTitleColor = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Hover Title Color
        /// 
        public Color HoverTitleColor
        {
            get
            {
                return hoverTitleColor;
            }
            set
            {
                hoverTitleColor = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Normal Content Color
        /// 
        public Color NormalContentColor
        {
            get
            {
                return normalContentColor;
            }
            set
            {
                normalContentColor = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Hover Content Color
        /// 
        public Color HoverContentColor
        {
            get
            {
                return hoverContentColor;
            }
            set
            {
                hoverContentColor = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Normal Title Font
        /// 
        public Font NormalTitleFont
        {
            get
            {
                return normalTitleFont;
            }
            set
            {
                normalTitleFont = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Hover Title Font
        /// 
        public Font HoverTitleFont
        {
            get
            {
                return hoverTitleFont;
            }
            set
            {
                hoverTitleFont = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Normal Content Font
        /// 
        public Font NormalContentFont
        {
            get
            {
                return normalContentFont;
            }
            set
            {
                normalContentFont = value;
                Refresh();
            }
        }

        /// 
        /// Get/Set the Hover Content Font
        /// 
        public Font HoverContentFont
        {
            get
            {
                return hoverContentFont;
            }
            set
            {
                hoverContentFont = value;
                Refresh();
            }
        }

        /// 
        /// Indicates if the popup should remain visible when the mouse pointer is over it.
        /// Added Rev 002
        /// 
        public bool KeepVisibleOnMousOver
        {
            get
            {
                return bKeepVisibleOnMouseOver;
            }
            set
            {
                bKeepVisibleOnMouseOver = value;
            }
        }

        /// 
        /// Indicates if the popup should appear again when mouse moves over it while it's disappearing.
        /// Added Rev 002
        /// 
        public bool ReShowOnMouseOver
        {
            get
            {
                return bReShowOnMouseOver;
            }
            set
            {
                bReShowOnMouseOver = value;
            }
        }

        protected override bool ShowWithoutActivation
        {
            get
            {
                return true;
            }
        }

        #endregion

        #region TaskbarNotifier Public Methods
        [DllImport("user32.dll")]
        private static extern Boolean ShowWindow(IntPtr hWnd, Int32 nCmdShow);
        /// 
        /// Displays the popup for a certain amount of time
        /// 
        /// 
The string which will be shown as the title of the popup
        /// 
The string which will be shown as the content of the popup
        /// 
Duration of the showing animation (in milliseconds)
        /// 
Duration of the visible state before collapsing (in milliseconds)
        /// 
Duration of the hiding animation (in milliseconds)
        /// Nothing
        public void Show(string strTitle, string strContent, int nTimeToShow, int nTimeToStay, int nTimeToHide)
        {
            WorkAreaRectangle = Screen.GetWorkingArea(WorkAreaRectangle);
            titleText = strTitle;
            contentText = strContent;
            nVisibleEvents = nTimeToStay;
            CalculateMouseRectangles();

            // We calculate the pixel increment and the timer value for the showing animation
            int nEvents;
            if (nTimeToShow > 10)
            {
                nEvents = Math.Min((nTimeToShow / 10), BackgroundBitmap.Height);
                nShowEvents = nTimeToShow / nEvents;
                
                    nIncrementShow = BackgroundBitmap.Height / nEvents;
                
            }
            else
            {
                nShowEvents = 10;
               
                    nIncrementShow = BackgroundBitmap.Height;
                
            }

            // We calculate the pixel increment and the timer value for the hiding animation
            if (nTimeToHide > 10)
            {
                nEvents = Math.Min((nTimeToHide / 10), BackgroundBitmap.Height);
                nHideEvents = nTimeToHide / nEvents;
                nIncrementHide = BackgroundBitmap.Height / nEvents;
            }
            else
            {
                nHideEvents = 10;
                nIncrementHide = BackgroundBitmap.Height;
            }


            switch (taskbarState)
            {
                case TaskbarStates.hidden:
                    taskbarState = TaskbarStates.appearing;
                    SetBounds(WorkAreaRectangle.Right - BackgroundBitmap.Width - 17, WorkAreaRectangle.Bottom - 1, BackgroundBitmap.Width, 0);
                    timer.Interval = nShowEvents;
                    timer.Start();

                    // We Show the popup without stealing focus
                    // Although ShowWithoutActivation is overridden, using just Show() will still steal focus
                    // This focus stealing problem may be related to the fact that .TopMost is also used.
                    ShowWindow(this.Handle, 4);
                    break;

                case TaskbarStates.appearing:
                    Refresh();
                    break;

                case TaskbarStates.visible:
                    timer.Stop();
                    timer.Interval = nVisibleEvents;
                    timer.Start();
                    Refresh();
                    break;

                case TaskbarStates.disappearing:
                    timer.Stop();
                    taskbarState = TaskbarStates.visible;
                    SetBounds(WorkAreaRectangle.Right - BackgroundBitmap.Width - 17, WorkAreaRectangle.Bottom - BackgroundBitmap.Height - 1, BackgroundBitmap.Width, BackgroundBitmap.Height);
                    timer.Interval = nVisibleEvents;
                    timer.Start();
                    Refresh();
                    break;
            }
        }

        /// 
        /// Hides the popup
        /// 
        /// Nothing
        public new void Hide()
        {
            if (taskbarState != TaskbarStates.hidden)
            {
                timer.Stop();
                taskbarState = TaskbarStates.hidden;
                base.Hide();
                Visible = false;
            }
        }

        /// 
        /// Sets the background bitmap and its transparency color
        /// 
        /// 
Path of the Background Bitmap on the disk
        /// 
Color of the Bitmap which won't be visible
        /// Nothing
        public void SetBackgroundBitmap(string strFilename, Color transparencyColor)
        {
            BackgroundBitmap = new Bitmap(strFilename);
            Width = BackgroundBitmap.Width;
            Height = BackgroundBitmap.Height;
            Region = BitmapToRegion(BackgroundBitmap, transparencyColor);
        }

        /// 
        /// Sets the background bitmap and its transparency color
        /// 
        /// 
Image/Bitmap object which represents the Background Bitmap
        /// 
Color of the Bitmap which won't be visible
        /// Nothing
        public void SetBackgroundBitmap(Image image, Color transparencyColor)
        {
            BackgroundBitmap = new Bitmap(image);
            Width = BackgroundBitmap.Width;
            Height = BackgroundBitmap.Height;
            Region = BitmapToRegion(BackgroundBitmap, transparencyColor);
        }

        /// 
        /// Sets the 3-State Close Button bitmap, its transparency color and its coordinates
        /// 
        /// 
Path of the 3-state Close button Bitmap on the disk (width must a multiple of 3)
        /// 
Color of the Bitmap which won't be visible
        /// 
Location of the close button on the popup
        /// Nothing
        public void SetCloseBitmap(string strFilename, Color transparencyColor, Point position)
        {
            CloseBitmap = new Bitmap(strFilename);
            CloseBitmap.MakeTransparent(transparencyColor);
            CloseBitmapSize = new Size(CloseBitmap.Width / 3, CloseBitmap.Height);
            CloseBitmapLocation = position;
        }

        /// 
        /// Sets the 3-State Close Button bitmap, its transparency color and its coordinates
        /// 
        /// 
Image/Bitmap object which represents the 3-state Close button Bitmap (width must be a multiple of 3)
        /// 
Color of the Bitmap which won't be visible
        /// /// 
Location of the close button on the popup
        /// Nothing
        public void SetCloseBitmap(Image image, Color transparencyColor, Point position)
        {
            CloseBitmap = new Bitmap(image);
            CloseBitmap.MakeTransparent(transparencyColor);
            CloseBitmapSize = new Size(CloseBitmap.Width / 3, CloseBitmap.Height);
            CloseBitmapLocation = position;
        }
        #endregion

        #region TaskbarNotifier Protected Methods
        protected void DrawCloseButton(Graphics grfx)
        {
            if (CloseBitmap != null)
            {
                Rectangle rectDest = new Rectangle(CloseBitmapLocation, CloseBitmapSize);
                Rectangle rectSrc;

                if (bIsMouseOverClose)
                {
                    if (bIsMouseDown)
                        rectSrc = new Rectangle(new Point(CloseBitmapSize.Width * 2, 0), CloseBitmapSize);
                    else
                        rectSrc = new Rectangle(new Point(CloseBitmapSize.Width, 0), CloseBitmapSize);
                }
                else
                    rectSrc = new Rectangle(new Point(0, 0), CloseBitmapSize);


                grfx.DrawImage(CloseBitmap, rectDest, rectSrc, GraphicsUnit.Pixel);
            }
        }

        protected void DrawText(Graphics grfx)
        {
            if (titleText != null && titleText.Length != 0)
            {
                StringFormat sf = new StringFormat();
                sf.Alignment = StringAlignment.Near;
                sf.LineAlignment = StringAlignment.Center;
                sf.FormatFlags = StringFormatFlags.NoWrap;
                sf.Trimming = StringTrimming.EllipsisCharacter;    // Added Rev 002
                if (bIsMouseOverTitle)
                    grfx.DrawString(titleText, hoverTitleFont, new SolidBrush(hoverTitleColor), TitleRectangle, sf);
                else
                    grfx.DrawString(titleText, normalTitleFont, new SolidBrush(normalTitleColor), TitleRectangle, sf);
            }

            if (contentText != null && contentText.Length != 0)
            {
                StringFormat sf = new StringFormat();
                sf.Alignment = StringAlignment.Center;
                sf.LineAlignment = StringAlignment.Center;
                sf.FormatFlags = StringFormatFlags.MeasureTrailingSpaces;
                sf.Trimming = StringTrimming.Word;       // Added Rev 002

                if (bIsMouseOverContent)
                {
                    grfx.DrawString(contentText, hoverContentFont, new SolidBrush(hoverContentColor), ContentRectangle, sf);
                    if (EnableSelectionRectangle)
                        ControlPaint.DrawBorder3D(grfx, RealContentRectangle, Border3DStyle.Etched, Border3DSide.Top | Border3DSide.Bottom | Border3DSide.Left | Border3DSide.Right);

                }
                else
                    grfx.DrawString(contentText, normalContentFont, new SolidBrush(normalContentColor), ContentRectangle, sf);
            }
        }

        protected void CalculateMouseRectangles()
        {
            Graphics grfx = CreateGraphics();
            StringFormat sf = new StringFormat();
            sf.Alignment = StringAlignment.Center;
            sf.LineAlignment = StringAlignment.Center;
            sf.FormatFlags = StringFormatFlags.MeasureTrailingSpaces;
            SizeF sizefTitle = grfx.MeasureString(titleText, hoverTitleFont, TitleRectangle.Width, sf);
            SizeF sizefContent = grfx.MeasureString(contentText, hoverContentFont, ContentRectangle.Width, sf);
            grfx.Dispose();

            // Added Rev 002
            //We should check if the title size really fits inside the pre-defined title rectangle
            if (sizefTitle.Height > TitleRectangle.Height)
            {
                RealTitleRectangle = new Rectangle(TitleRectangle.Left, TitleRectangle.Top, TitleRectangle.Width, TitleRectangle.Height);
            }
            else
            {
                RealTitleRectangle = new Rectangle(TitleRectangle.Left, TitleRectangle.Top, (int)sizefTitle.Width, (int)sizefTitle.Height);
            }
            RealTitleRectangle.Inflate(0, 2);

            // Added Rev 002
            //We should check if the Content size really fits inside the pre-defined Content rectangle
            if (sizefContent.Height > ContentRectangle.Height)
            {
                RealContentRectangle = new Rectangle((ContentRectangle.Width - (int)sizefContent.Width) / 2 + ContentRectangle.Left, ContentRectangle.Top, (int)sizefContent.Width, ContentRectangle.Height);
            }
            else
            {
                RealContentRectangle = new Rectangle((ContentRectangle.Width - (int)sizefContent.Width) / 2 + ContentRectangle.Left, (ContentRectangle.Height - (int)sizefContent.Height) / 2 + ContentRectangle.Top, (int)sizefContent.Width, (int)sizefContent.Height);
            }
            RealContentRectangle.Inflate(0, 2);
        }

        protected Region BitmapToRegion(Bitmap bitmap, Color transparencyColor)
        {
            if (bitmap == null)
                throw new ArgumentNullException("Bitmap", "Bitmap cannot be null!");

            int height = bitmap.Height;
            int width = bitmap.Width;

            GraphicsPath path = new GraphicsPath();

            for (int j = 0; j < height; j++)
                for (int i = 0; i < width; i++)
                {
                    if (bitmap.GetPixel(i, j) == transparencyColor)
                        continue;

                    int x0 = i;

                    while ((i < width) && (bitmap.GetPixel(i, j) != transparencyColor))
                        i++;

                    path.AddRectangle(new Rectangle(x0, j, i - x0, 1));
                }

            Region region = new Region(path);
            path.Dispose();
            return region;
        }
        #endregion

        #region TaskbarNotifier Events Overrides
        protected void OnTimer(Object obj, EventArgs ea)
        {
            switch (taskbarState)
            {
                case TaskbarStates.appearing:
                    if (Height < BackgroundBitmap.Height)
                    {
                        SetBounds(Left, Top - nIncrementShow, Width, Height + nIncrementShow);
                        Opacity = ((Double)Height / BackgroundBitmap.Height);
                    }
                    else
                    {
                        timer.Stop();
                        Opacity = 1;
                        Height = BackgroundBitmap.Height;
                        timer.Interval = nVisibleEvents;
                        taskbarState = TaskbarStates.visible;
                        timer.Start();
                    }
                    break;

                case TaskbarStates.visible:
                    timer.Stop();
                    Opacity = 1;
                    timer.Interval = nHideEvents;
                    // Added Rev 002
                    if ((bKeepVisibleOnMouseOver && !bIsMouseOverPopup) || (!bKeepVisibleOnMouseOver))
                    {
                        taskbarState = TaskbarStates.disappearing;
                    }
                    //taskbarState = TaskbarStates.disappearing;  // Rev 002
                    timer.Start();
                    break;

                case TaskbarStates.disappearing:
                    // Added Rev 002
                    if (bReShowOnMouseOver && bIsMouseOverPopup)
                    {
                        taskbarState = TaskbarStates.appearing;
                    }
                    else
                    {
                        if (Top < WorkAreaRectangle.Bottom)
                        {
                            SetBounds(Left, Top + nIncrementHide, Width, Height - nIncrementHide);
                            Opacity = ((Double)Height / BackgroundBitmap.Height);
                        }
                        else
                        {
                            Hide();
                        }
                    }
                    break;
            }

        }

        protected override void OnMouseEnter(EventArgs ea)
        {
            base.OnMouseEnter(ea);
            bIsMouseOverPopup = true;
            Refresh();
        }

        protected override void OnMouseLeave(EventArgs ea)
        {
            base.OnMouseLeave(ea);
            bIsMouseOverPopup = false;
            bIsMouseOverClose = false;
            bIsMouseOverTitle = false;
            bIsMouseOverContent = false;
            Refresh();
        }

        protected override void OnMouseMove(MouseEventArgs mea)
        {
            base.OnMouseMove(mea);

            bool bContentModified = false;

            if ((mea.X > CloseBitmapLocation.X) && (mea.X < CloseBitmapLocation.X + CloseBitmapSize.Width) && (mea.Y > CloseBitmapLocation.Y) && (mea.Y < CloseBitmapLocation.Y + CloseBitmapSize.Height) && CloseClickable)
            {
                if (!bIsMouseOverClose)
                {
                    bIsMouseOverClose = true;
                    bIsMouseOverTitle = false;
                    bIsMouseOverContent = false;
                    Cursor = Cursors.Hand;
                    bContentModified = true;
                }
            }
            else if (RealContentRectangle.Contains(new Point(mea.X, mea.Y)) && ContentClickable)
            {
                if (!bIsMouseOverContent)
                {
                    bIsMouseOverClose = false;
                    bIsMouseOverTitle = false;
                    bIsMouseOverContent = true;
                    Cursor = Cursors.Hand;
                    bContentModified = true;
                }
            }
            else if (RealTitleRectangle.Contains(new Point(mea.X, mea.Y)) && TitleClickable)
            {
                if (!bIsMouseOverTitle)
                {
                    bIsMouseOverClose = false;
                    bIsMouseOverTitle = true;
                    bIsMouseOverContent = false;
                    Cursor = Cursors.Hand;
                    bContentModified = true;
                }
            }
            else
            {
                if (bIsMouseOverClose || bIsMouseOverTitle || bIsMouseOverContent)
                    bContentModified = true;

                bIsMouseOverClose = false;
                bIsMouseOverTitle = false;
                bIsMouseOverContent = false;
                Cursor = Cursors.Default;
            }

            if (bContentModified)
                Refresh();
        }

        protected override void OnMouseDown(MouseEventArgs mea)
        {
            base.OnMouseDown(mea);
            bIsMouseDown = true;

            if (bIsMouseOverClose)
                Refresh();
        }

        protected override void OnMouseUp(MouseEventArgs mea)
        {
            base.OnMouseUp(mea);
            bIsMouseDown = false;

            if (bIsMouseOverClose)
            {
                Hide();

                if (CloseClick != null)
                    CloseClick(this, new EventArgs());
            }
            else if (bIsMouseOverTitle)
            {
                if (TitleClick != null)
                    TitleClick(this, new EventArgs());
            }
            else if (bIsMouseOverContent)
            {
                if (ContentClick != null)
                    ContentClick(this, new EventArgs());
            }
        }

        protected override void OnPaintBackground(PaintEventArgs pea)
        {
            Graphics grfx = pea.Graphics;
            grfx.PageUnit = GraphicsUnit.Pixel;

            Graphics offScreenGraphics;
            Bitmap offscreenBitmap;

            offscreenBitmap = new Bitmap(BackgroundBitmap.Width, BackgroundBitmap.Height);
            offScreenGraphics = Graphics.FromImage(offscreenBitmap);

            if (BackgroundBitmap != null)
            {
                offScreenGraphics.DrawImage(BackgroundBitmap, 0, 0, BackgroundBitmap.Width, BackgroundBitmap.Height);
            }

            DrawCloseButton(offScreenGraphics);
            DrawText(offScreenGraphics);

            grfx.DrawImage(offscreenBitmap, 0, 0);
        }
        #endregion
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Read and Write the Windows Registry C#

2012-03-17T23:13:00.001-06:00

using System;
using Microsoft.Win32;

namespace TyroDeveloperDLL
{
    public class WindowsRegistry
    {
        RegistryKey registryAccess;
        public void WriteValue(string pKey, string pValue) {
            registryAccess = Registry.Users;
            registryAccess = registryAccess.OpenSubKey(".DEFAULT", true);

            registryAccess.SetValue(pKey, pValue, RegistryValueKind.String);

            registryAccess.Close();
        }
        public string ReadValue(string pKey, string pDefault) {
            registryAccess = Registry.Users;
            string val = "";
            registryAccess = registryAccess.OpenSubKey(".DEFAULT", true);

            val = registryAccess.GetValue(pKey, pDefault).ToString();

            registryAccess.Close();
            return (val);
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Only Numeric Text Box C#

2012-03-17T16:42:00.001-06:00

using System;
using System.Collections.Generic;
using System.Text;

namespace TyroDeveloperDLL
{
    public class TextBoxCustom{

        static int _decimales = 3;

        public int Decimales{
            get {
                return (_decimales);
            }
            set {
                _decimales = value;
            }
        }

        public static void OnlyNumeric(System.Windows.Forms.TextBox _TextBox, System.Windows.Forms.KeyPressEventArgs e){
            if (e.KeyChar == 8){
                e.Handled = false;
                return;
            }
            if (_TextBox.Text.Length == 0) { 
                if((e.KeyChar == Convert.ToChar("-"))){
                    e.Handled = false;
                    return;
                }
            }
            bool IsDec = false;
            int nroDec = 0;
            for (int i = 0; i < _TextBox.Text.Length; i++){
                if (_TextBox.Text[i] == '.')
                    IsDec = true;

                if (IsDec && nroDec++ >= _decimales){
                    e.Handled = true;
                    return;
                }
            }
            if (e.KeyChar >= 48 && e.KeyChar <= 57)
                e.Handled = false;
            else if (e.KeyChar == 46)
                e.Handled = (IsDec) ? true : false;
            else
                e.Handled = true;
        }

        public static void OnlyLetters(System.Windows.Forms.TextBox textBox, System.Windows.Forms.KeyPressEventArgs e){
            if (Char.IsLetter(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsControl(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsSeparator(e.KeyChar))
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }

        public static void OnlyLetterAndNumber(System.Windows.Forms.TextBox _TextBox, System.Windows.Forms.KeyPressEventArgs e){
            if (Char.IsLetter(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsNumber(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsControl(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsSeparator(e.KeyChar))
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }

        public static void OnlyKeys(System.Windows.Forms.TextBox textBox, System.Windows.Forms.KeyPressEventArgs e){
            if (Char.IsLetter(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsNumber(e.KeyChar))
            {
                e.Handled = false;
            }
            else if (Char.IsControl(e.KeyChar))
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }
    }
}

Please visit: www.TyroDeveloper.com

Please Click on +1

Bill PDF C#

2012-03-17T16:36:00.002-06:00

using System;
//using System.Windows.Forms;
//using System.Drawing;
//using System.Drawing.Printing;
using System.Collections;
using iTextSharp;
using iTextSharp.text;
using iTextSharp.text.pdf;
using System.IO;
namespace TyroDeveloperDLL
{
    public class BillPDF
    {
        public BillPDF()
        {
            
            myBill.AddAuthor("TyroDeveloper");
            myBill.AddCreator("JUAN GABRIEL CASTILLO TURRUBIATES");
            myBill.AddTitle("Ticket de Venta");
        }

        PdfWriter writer = null;
        PdfContentByte cb = null;

        ArrayList headerLines = new ArrayList();
        ArrayList subHeaderLines = new ArrayList();
        ArrayList items = new ArrayList();
        ArrayList totales = new ArrayList();
        ArrayList footerLines = new ArrayList();
        private string headerImage = "";
        bool _DrawItemHeaders = true;
        int startItemsOn = 20;
        string path = "";
        string file_name = "";
        //int maxChar = 100;
        int maxCharDescription = 50;

        int imageHeight = 0;

        float idProductX = 0;
        float descProductX = 0;
        float amountProductX = 0;
        float qtyProductX = 0;
        float priceProductX = 0;
        float topMargin = 5;
        
        static int fontSize = 12;
        static BaseFont bfCourier = BaseFont.CreateFont(BaseFont.COURIER, BaseFont.CP1252, false);
        static Font font = new Font(bfCourier, fontSize, Font.NORMAL, Color.BLACK);

        Document myBill = new Document(PageSize.LETTER, 0, 0, 0, 0); //Aqui se ponen todos los objetos

        string line = "";

        #region Properties
        
        public Int32 StartItemsOn { get { return startItemsOn; } set { startItemsOn = value; } }
        public float IdProductX { get { return idProductX; } set { idProductX = value; } }
        public float DescProductX { get { return descProductX; } set { descProductX = value; } }
        public float AmountProductX { get { return amountProductX; } set { amountProductX = value; } }
        public float QtyProductX { get { return qtyProductX; } set { qtyProductX = value; } }
        public float PriceProductX { get { return priceProductX; } set { priceProductX = value; } }
        public String Path
        {
            get { return path; }
            set { path = value; }
        }

        public String FileName
        {
            get { return file_name; }
            set { file_name = value; }
        }

        public String FullFileName
        {
            get { return (String.Format("{0}{1}", path, file_name)); }
        }
        public String HeaderImage
        {
            get { return headerImage; }
            set { if (headerImage != value) headerImage = value; }
        }

       

        public bool DrawItemHeaders
        {
            set { _DrawItemHeaders = value; }
        }

        public int MaxCharDescription
        {
            get { return maxCharDescription; }
            set { if (value != maxCharDescription) maxCharDescription = value; }
        }

        public int FontSize
        {
            get { return fontSize; }
            set { if (value != fontSize) fontSize = value; }
        }

        public Font FontName
        {
            get { return font; }
            set { if (value != font) font = value; }
        }
        //CustomerName
        string customerName = "";
        public String CustomerName {get { return customerName; }set { customerName = value; }}
        float customerNameX = 0;
        public float CustomerNameX { get { return customerNameX; } set { customerNameX = value; }}
        float customerNameY = 0;
        public float CustomerNameY {get { return customerNameY; }set { customerNameY = value; }}
        //BillID
        string billID = "";
        public String BillID {get { return billID; } set { billID = value; } }
        float billIDX = 0;
        public float BillIDX { get { return billIDX; } set { billIDX = value; } }
        float billIDY = 0;
        public float BillIDY { get { return billIDY; } set { billIDY = value; } }
        //BillDate
        string billDate = "";
        public String BillDate { get { return billDate; } set { billDate = value; } }
        float billDateX = 0;
        public float BillDateX { get { return billDateX; } set { billDateX = value; } }
        float billDateY = 0;
        public float BillDateY { get { return billDateY; } set { billDateY = value; } }
        //CustomerAddress
        string customerAddress = "";
        public String CustomerAddress { get { return customerAddress; } set { customerAddress = value; } }
        float customerAddressX = 0;
        public float CustomerAddressX { get { return customerAddressX; } set { customerAddressX = value; } }
        float customerAddressY = 0;
        public float CustomerAddressY { get { return customerAddressY; } set { customerAddressY = value; } }
        //CustomerCity
        string customerCity = "";
        public String CustomerCity { get { return customerCity; } set { customerCity = value; } }
        float customerCityX = 0;
        public float CustomerCityX { get { return customerCityX; } set { customerCityX = value; } }
        float customerCityY = 0;
        public float CustomerCityY { get { return customerCityY; } set { customerCityY = value; } }
        //CustomerRFC
        string customerRFC = "";
        public String CustomerRFC { get { return customerRFC; } set { customerRFC = value; } }
        float customerRFCX = 0;
        public float CustomerRFCX { get { return customerRFCX; } set { customerRFCX = value; } }
        float customerRFCY = 0;
        public float CustomerRFCY { get { return customerRFCY; } set { customerRFCY = value; } }
        //CustomerPostalCode
        string customerPostalCode = "";
        public String CustomerPostalCode { get { return customerPostalCode; } set { customerPostalCode = value; } }
        float customerPostalCodeX = 0;
        public float CustomerPostalCodeX { get { return customerPostalCodeX; } set { customerPostalCodeX = value; } }
        float customerPostalCodeY = 0;
        public float CustomerPostalCodeY { get { return customerPostalCodeY; } set { customerPostalCodeY = value; } }
        //BillTotalString
        string billTotalString = "";
        public String BillTotalString { get { return billTotalString; } set { billTotalString = value; } }
        float billTotalStringX = 0;
        public float BillTotalStringX { get { return billTotalStringX; } set { billTotalStringX = value; } }
        float billTotalStringY = 0;
        public float BillTotalStringY { get { return billTotalStringY; } set { billTotalStringY = value; } }
        //BillSubTotal
        string billSubTotal = "";
        public String BillSubTotal { get { return billSubTotal; } set { billSubTotal = value; } }
        float billSubTotalX = 0;
        public float BillSubTotalX { get { return billSubTotalX; } set { billSubTotalX = value; } }
        float billSubTotalY = 0;
        public float BillSubTotalY { get { return billSubTotalY; } set { billSubTotalY = value; } }
        //BillTax
        string billTax = "";
        public String BillTax { get { return billTax; } set { billTax = value; } }
        float billTaxX = 0;
        public float BillTaxX { get { return billTaxX; } set { billTaxX = value; } }
        float billTaxY = 0;
        public float BillTaxY { get { return billTaxY; } set { billTaxY = value; } }
        //billTotal
        string billTotal = "";
        public String BillTotal { get { return billTotal; } set { billTotal = value; } }
        float billTotalX = 0;
        public float BillTotalX { get { return billTotalX;  } set { billTotalX = value; } }
        float billTotalY = 0;
        public float BillTotalY { get { return billTotalY;  } set { billTotalY = value; } }
        #endregion

        #region HeaderBill
        public void SetBillID(string Value, float XPosition, float YPosition) {
            billID = Value;
            billIDX = XPosition;
            billIDY = YPosition;
        }
        public void SetBillDate(string Value, float XPosition, float YPosition) {
            billDate = Value;
            billDateX = XPosition;
            billDateY = YPosition;
        }
        public void SetBillSubTotal(string Value, float XPosition, float YPosition) {
            billSubTotal = Value;
            billSubTotalX = XPosition;
            billSubTotalY = YPosition;
        }
        public void SetBillTax(string Value, float XPosition, float YPosition) {
            billTax = Value;
            billTaxX = XPosition;
            billTaxY = YPosition;
        }
        public void SetBillTotal(string Value, float XPosition, float YPosition) {
            billTotal = Value;
            billTotalX = XPosition;
            billTotalY = YPosition;
        }
        public void SetBillTotalString(string Value, float XPosition, float YPosition) {
            billTotalString = Value;
            billTotalStringX = XPosition;
            billTotalStringY = YPosition;
        }
        public void SetCustomerName(string Value, float XPosition, float YPosition) {
            customerName = Value;
            customerNameY = YPosition;
            customerNameX = XPosition;
        }
        public void SetCustomerAddress(string Value, float XPosition, float YPosition) {
            customerAddress = Value;
            customerAddressX = XPosition;
            customerAddressY = YPosition;
        }
        public void SetCustomerCity(string Value, float XPosition, float YPosition) {
            customerCity = Value;
            customerCityX = XPosition;
            customerCityY = YPosition;
        }
        public void SetCustomerRFC(string Value, float XPosition, float YPosition) {
            customerRFC = Value;
            customerRFCX = XPosition;
            customerRFCY = YPosition;
        }
        public void SetCustomerPostalCode(string Value, float XPosition, float YPosition) {
            customerPostalCode = Value;
            customerPostalCodeX = XPosition;
            customerPostalCodeY = YPosition;
        }
        #endregion

       

        public void AddItem(string cantidad, string item, string price, string unitPrice)
        {
            BillOrderItem newItem = new BillOrderItem('?');
            items.Add(newItem.GenerateItem(cantidad, item, price,unitPrice));
        }

       
        private void DrawEspacio()
        {
            line = "";

            cb.SetTextMatrix(idProductX, YPosition());
            cb.SetFontAndSize(font.BaseFont, fontSize);
            cb.ShowText(line);

            startItemsOn++;
        }

        public bool Print()
        {
            try
            {
                //aqui para generar el PDF
                writer = PdfWriter.GetInstance(myBill, new FileStream(path + file_name, FileMode.Create));
                
                myBill.Open();
                cb = writer.DirectContent;
                cb.SetFontAndSize(font.BaseFont, fontSize);
                cb.BeginText();


                DrawInfo();
                DrawItems();
                

                cb.EndText();
                myBill.Close();

                return true;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
        private void DrawInfo() {
            //CustomerName
            cb.SetTextMatrix(customerNameX, myBill.PageSize.Height - customerNameY);
            cb.ShowText(customerName);
            //BillID
            cb.SetTextMatrix(billIDX, myBill.PageSize.Height - billIDY);
            cb.ShowText(billID);
            //BillDate
            cb.SetTextMatrix(billDateX, myBill.PageSize.Height - billDateY);
            cb.ShowText(billDate);
            //CustomerAddress
            cb.SetTextMatrix(customerAddressX, myBill.PageSize.Height - customerAddressY);
            cb.ShowText(customerAddress);
            //CustomerCity
            cb.SetTextMatrix(customerCityX, myBill.PageSize.Height - customerCityY);
            cb.ShowText(customerCity);
            //CustomerRFC
            cb.SetTextMatrix(customerRFCX, myBill.PageSize.Height - customerRFCY);
            cb.ShowText(customerRFC);
            //CustomerPostalCode
            cb.SetTextMatrix(customerPostalCodeX, myBill.PageSize.Height - customerPostalCodeY);
            cb.ShowText(customerPostalCode);
            //TotalString
            cb.SetTextMatrix(billTotalStringX, myBill.PageSize.Height - billTotalStringY);
            cb.ShowText(billTotalString);
            //SubTotal
            //cb.SetTextMatrix(billSubTotalX, myBill.PageSize.Height - billSubTotalY);
            //cb.ShowText(billSubTotal);
            cb.ShowTextAligned(PdfContentByte.ALIGN_RIGHT, billSubTotal, billSubTotalX, myBill.PageSize.Height - billSubTotalY, 0);
            //Tax
            //cb.SetTextMatrix(billTaxX, myBill.PageSize.Height - billTaxY);
            //cb.ShowText(billTax);
            cb.ShowTextAligned(PdfContentByte.ALIGN_RIGHT, billTax, billTaxX, myBill.PageSize.Height - billTaxY, 0);
            //Total
            //cb.SetTextMatrix(billTotalX, myBill.PageSize.Height - billTotalY);
            //cb.ShowText(billTotal);
            cb.ShowTextAligned(PdfContentByte.ALIGN_RIGHT, billTotal, billTotalX, myBill.PageSize.Height - billTotalY, 0);

        }
        private float YPosition()
        {
            return (myBill.PageSize.Height - (topMargin + (startItemsOn * font.CalculatedSize + imageHeight)));
        }

        private void DrawItems()
        {
            
            BillOrderItem ordIt = new BillOrderItem('?');

            foreach (string item in items)
            {
                //cantidad
                line = ordIt.GetItemCantidad(item);
                cb.SetTextMatrix(qtyProductX, YPosition());
                cb.ShowText(line);

                //precio(Monto)
                line = ordIt.GetItemPrice(item);
                cb.ShowTextAligned(PdfContentByte.ALIGN_RIGHT, line, amountProductX, YPosition(), 0);

                //PRECIO_VENTA
                line = ordIt.GetItemUnitPrice(item);
                cb.ShowTextAligned(PdfContentByte.ALIGN_RIGHT, line, priceProductX, YPosition(), 0);

                //Descripcion
                string name = ordIt.GetItemName(item);
                
                if (name.Length > maxCharDescription)
                {
                    int currentChar = 0;
                    int itemLenght = name.Length;

                    while (itemLenght > maxCharDescription)
                    {
                        line = ordIt.GetItemName(item);

                        cb.SetTextMatrix(descProductX, YPosition());
                        cb.ShowText(line.Substring(currentChar, maxCharDescription));

                        startItemsOn++;
                        currentChar += maxCharDescription;
                        itemLenght -= maxCharDescription;
                    }

                    line = ordIt.GetItemName(item);

                    cb.SetTextMatrix(descProductX, YPosition());
                    cb.ShowText(line.Substring(currentChar, line.Length - currentChar));

                    startItemsOn++;
                }
                else
                {
                    cb.SetTextMatrix(descProductX, YPosition());
                    cb.ShowText(ordIt.GetItemName(item));

                    startItemsOn++;
                }
            }

        }
    
    }

    public class BillOrderItem
    {
        char[] delimitador = new char[] { '?' };

        public BillOrderItem(char delimit)
        {
            delimitador = new char[] { delimit };
        }
        //CANTIDAD
        public string GetItemCantidad(string BillOrderItem)
        {
            string[] delimitado = BillOrderItem.Split(delimitador);
            return delimitado[0];
        }
        //DESCRIPCION
        public string GetItemName(string BillOrderItem)
        {
            string[] delimitado = BillOrderItem.Split(delimitador);
            return delimitado[1];
        }
        //IMPORTE
        public string GetItemPrice(string BillOrderItem)
        {
            string[] delimitado = BillOrderItem.Split(delimitador);
            return delimitado[2];
        }
        //precio unitario
        public string GetItemUnitPrice(string BillOrderItem)
        {
            string[] delimitado = BillOrderItem.Split(delimitador);
            return delimitado[3];
        }
        //GENERAR
        public string GenerateItem(string cantidad, string itemName, string price, string unitPrice)
        {
            return cantidad + delimitador[0] + itemName + delimitador[0] + price + delimitador[0] + unitPrice;
        }
    }  
}

Please visit :www.TyroDeveloper.com

Please Click on +1