Creating New Outlook mail Item Using C#

using Microsoft.Office.Interop.Outlook;
using OutlookApp = Microsoft.Office.Interop.Outlook.Application;

-----------------------------------------------------------------------------


               OutlookApp outlookApp1 = new OutlookApp();
                MailItem _mi =(MailItem) outlookApp1.CreateItem(OlItemType.olMailItem);
                _mi.Subject = "This is the subject";
                _mi.To = "someone@example.com";
                _mi.Body = "This is the message.";
                _mi.Attachments.Add(@"C:/Users/Manjunath.le/Downloads/Annexure.pdf");
                _mi.Display(false);


// This will open New Outlook mail Create Window.

Preventing user to select date greater than today in Ajax calender extender.

<script type="text/javascript">

function checkDate(sender, args) {
            if (sender._selectedDate > new Date()) {
                alert("You cannot select a day Greater than today!");
                sender._selectedDate = new Date();
                // set the date back to the current date
                sender._textbox.set_Value(sender._selectedDate.format(sender._format))
            }

</script>


Design:


  <asp:TextBox ID="txt_FDate" runat="server" Width="100px"></asp:TextBox>
                <img id="calendar_Img1" src="Images/calendar.gif" alt="Calendar" />
                <cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txt_FDate"
                    CssClass="cal_Theme1" Format="yyyy-MM-dd" PopupButtonID="calendar_Img1" OnClientDateSelectionChanged="checkDate">
                </cc1:CalendarExtender>

Getting Data table from the Excel Sheet Using C#

        string connectionString = "";

        bool flag = true;

        object value;

        try

        {

            string fileName = Path.GetFileName(fb_master.PostedFile.FileName);

            string fileExtension = Path.GetExtension(fb_master.PostedFile.FileName);

            string folder = ConfigurationManager.AppSettings["TargetFiles"];

            string fileLocation = ConfigurationManager.AppSettings["TargetFiles"]+System.DateTime.Today.ToString("dd-MMyyyy")+"_"+ fileName;

            DirectoryInfo dir = new DirectoryInfo(folder);

            if (!dir.Exists)

                dir.Create();

            fb_master.SaveAs(fileLocation);

            if (fb_master.HasFile)

            {

                //Check whether file extension is xls or xslx

                if (fileExtension == ".xls")

                {

                    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";

                }

                else if (fileExtension == ".xlsx")

                {

                    //connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

                    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";

                }

                //Create OleDB Connection and OleDb Command

                OleDbConnection con = new OleDbConnection(connectionString);

                OleDbCommand cmd = new OleDbCommand();

                cmd.CommandType = System.Data.CommandType.Text;

                cmd.Connection = con;

                OleDbDataAdapter dAdapter = new OleDbDataAdapter(cmd);

                DataTable dtExcelRecords = new DataTable();

                con.Open();

                DataTable dtExcelSheetName = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

                string getExcelSheetName = dtExcelSheetName.Rows[0]["Table_Name"].ToString();

                cmd.CommandText = "SELECT * FROM [" + getExcelSheetName + "] where Finyear is not null ";

                dAdapter.SelectCommand = cmd;

                dAdapter.Fill(dtExcelRecords);

                con.Close();

          }

        }

        catch (Exception ex)

        {

            UserMessage.ShowUserMessage("Excel file cannot be uploaded.please check the data in Excel file.It may contains Null values.");

            _gb.ErrorLog(ex.Message);

        }

Avoiding special characters in C# using javascript

 function isNumber(evt)
       {
                   evt = (evt) ? evt : window.event;
                   var charCode = (evt.which) ? evt.which : evt.keyCode;
                   if (charCode > 59 && charCode < 64)     // here m checking for < > ? characters only
                  {
                      return false;
                   }
                   return true;
        }


// Call this javascript function onkeypress event of the text box like -   onkeypress="return isNumber(event)"

If any design issues in internet explorer because of version level , add the below code in Web.config

      <system.webServer>
    <httpProtocol>
      <customHeaders>
        <clear/>
   <!--This setting will make document mode to highest mode available we need have mode 8 and above-->
       <add name="X-UA-Compatible" value="IE=Edge"/>
      </customHeaders>
    </httpProtocol>
  </system.webServer>


Simple things effects a lot ... happy coding.........

Example for delegate in C# - here i will show how to call the child page button click on clicking the button which is inside user control of the parent page

In User Control lets name like horizantalmenu.ascx, i will define the event handler and i will use it in the particular button click event



 public event EventHandler ButtonClickDemo;   // define it globally

protected void Page_Load(object sender, EventArgs e)
 {
   
 }


protected void Button_Click(object sender, ImageClickEventArgs e)
    {
        ButtonClickDemo(sender, e);    // m using the event here
    }


--------------------------------------------------------------------------------------------------

In all the successive pages where you are calling  horizantalmenu.ascx in your page ,

trigger that event in the page load of your page

protected void Page_Load(object sender, EventArgs e)
    {
        HorizontalMenu.ButtonClickDemo += new EventHandler(GetMainQueryOnNotepad);
                                                                             // assigning with one function to call on button click
    }


 protected void GetMainQueryOnNotepad(object sender, EventArgs e)
    {
           /// you can do what ever you want to do in this function.
    }

Creating simple error log in Asp.net / C#

 public void ErrorLog(string sMessage)
    {
     
        string LogPath = ConfigurationManager.AppSettings["ErrorlagPath"].ToString();
        string filename = "ErrorLog_" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt";
        string filepath = LogPath + filename;

        if (!Directory.Exists(LogPath))
            Directory.CreateDirectory(LogPath);
        string sFilePath = filepath;

        StreamWriter objSw = new StreamWriter(sFilePath, true);
        objSw.WriteLine("-------------------START-------------" + DateTime.Now + " -----------------");
        objSw.WriteLine(sMessage);
        objSw.WriteLine("-------------------END-------------" + DateTime.Now + " -----------------");
        objSw.Close();
    }