Wednesday 28 November 2018

Download DataList checkbox checked file in zip using Ionic.zip dll in asp.net

//////////////////// HTML

 using Ionic.Zip; namespace


<asp:DataList ID="DL_FileManagement" runat="server" DataKeyField="FileNames" RepeatDirection="Horizontal" RepeatLayout="Flow" CssClass="row col-lg-12"
CellPadding="2" CellSpacing="5">
   <ItemStyle ForeColor="Black" />
         <ItemTemplate>
           <div class="col-lg-2 p-0">
               <asp:CheckBox runat="server" ID="Chk_TabtoDownload" Style="float: left; margin-top: 6px; margin-right: -8px;" CssClass="pull-right" Text="&nbsp;" />

                  </div>
                       </ItemTemplate>
    </asp:DataList>


button

<asp:LinkButton runat="server" ID="lbtn_FMDataBulk" OnClick="lbtn_FMDataBulk_OnClick">
                                                     <i class="glyphicon glyphicon-download btn-success" style="font-size:15px; padding:5px;"></i>
                                                                </asp:LinkButton>




//////////////////////////////.cs



protected void Download_Files_Zip(List<string> filenames, string FolderName)
    {
        try
        {
            string fullPath = ResolveUrl("~/" + FolderName + "/");
            string chkFile = Server.MapPath("~/" + FolderName + "/");

            using (ZipFile zip = new ZipFile())
            {
                zip.AlternateEncodingUsage = ZipOption.AsNecessary;
                zip.AddDirectoryByName("Files");
                for (int i = 0; i < filenames.Count; i++)
                {
                    string Fpaths = chkFile + Convert.ToString(filenames[i]);
                    FileInfo fi = new FileInfo(Fpaths);
                    if (fi.Exists)
                    {
                        string filePath = fullPath + Convert.ToString(filenames[i]);
                        zip.AddFile(filePath, "Files");
                    }
                }
                Response.Clear();
                Response.BufferOutput = false;
                string zipName = String.Format("Zip_{0}.zip", DateTime.Now.ToString("yyyyMMMddHHmmss"));
                Response.ContentType = "application/zip";
                Response.AddHeader("content-disposition", "attachment; filename=" + zipName);
                zip.Save(Response.OutputStream);
                Response.End();
            }
        }
        catch (Exception)
        {
        }
    }

    protected void lbtn_FMDataBulk_OnClick(object sender, EventArgs e)
    {
        try
        {
            int i = 0;
            string[] files = new string[] { };
            List<string> filesNames = new List<string>();
            foreach (DataListItem item in DL_FileManagement.Items)
            {
                if ((item.FindControl("Chk_TabtoDownload") as CheckBox).Checked)
                {
                    filesNames.Add((item.FindControl("lbl_FilesNames") as Label).Text);
                    i++;
                }
            }
            Download_Files_Zip(filesNames, "Document");
        }
        catch (Exception)
        {
        }
    }


Redirect web service error to the custom error page in asp.net using Globle.asax and web.config file

////////////////////////   web.config file

  <!--<customErrors mode="On" defaultRedirect="~/Error-page"> </customErrors>-->

--------------------------------------------------
<system.web>
    <webServices>
      <protocols>
        <remove name="Documentation"/>
      </protocols>
    </webServices>
   </system.web>
--------------------------------------------------
  <system.webServer>
<httpErrors errorMode="Custom" defaultResponseMode="Redirect">
      <remove statusCode="404" subStatusCode="-1" />
      <error statusCode="404" prefixLanguageFilePath="" path="~/Path/Error-page"
       responseMode="Redirect" />
      <remove statusCode="403" subStatusCode="-1" />
      <error statusCode="403" prefixLanguageFilePath="" path="~/Path/Error-page"
       responseMode="Redirect" />
      <remove statusCode="405" subStatusCode="-1" />
      <error statusCode="405" prefixLanguageFilePath="" path="~/Path/Error-page"
       responseMode="Redirect" />
    </httpErrors>
</system.webServer>



////////////////////////   web.config file


protected void Application_Error(object sender, EventArgs e)
    {
        Exception exception = Server.GetLastError();
        Response.Clear();

        HttpException httpException = exception as HttpException;

        if (httpException != null)
        {
            string action;

            switch (httpException.GetHttpCode())
            {
                case 404:
                    // page not found
                    action = "~/Error-page";
                    break;
                case 500:
                    // server error
                    action = "~/Error-page";
                    break;
                default:
                    action = "~/Error-page";
                    break;
            }

            // clear error on server
            Server.ClearError();
            Response.Redirect("~/Error-page");
        }
    }

Install windows service using command prompt

//////////////// Steps---------------


Step 1.  C:\Windows\system32>cd /

Step 2. C:\> cd \Windows\Microsoft.NET\Framework>cd v4.0.30319 (press Enter Key)

Step 3. C:\Windows\Microsoft.NET\Framework\v4.0.30319>

for uninstall

Step 4.  C:\Windows\Microsoft.NET\Framework\v4.0.30319>installutil.exe -u D:\FolderPath\WindowsService.exe

for install

Step 5.  C:\Windows\Microsoft.NET\Framework\v4.0.30319>installutil.exe -i D:\FolderPath\WindowsService.exe

                       

Friday 16 November 2018

Increase font-size click on button using jquery

/////////// HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
    <title>increase or decrease font size of website in asp.net</title>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js">
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            var divtxt = $('#ChDfontdiv');
            // Increase Font Size
            $('#incrsfont').click(function () {
                GetAllSize("p");
            });
            // Decrease Font Size
            $('#decrsfont').click(function () {
                GetAllSize("m");
            })
            function GetAllSize(siz) {
                $('#ChDfontdiv div, #ChDfontdiv span, #ChDfontdiv label, #ChDfontdiv .heading').each(function () {
                    if (siz == "p") {
                        debugger;
                        var curSize = $(this).css('fontSize');
                        var newSize = parseInt(curSize.replace("px", "")) + 1;
                        $(this).css("fontSize", newSize + "px");
                        if (newSize > 12) {
                            $('#decrsfont').removeAttr("disabled");
                        }
                        if (newSize >= 25) {
                            $('#incrsfont').attr("disabled", "disabled");
                        }
                    }
                    else if (siz == "m") {
                        var curSize = $(this).css('fontSize');
                        var newSize = parseInt(curSize.replace("px", "")) - 1;
                        $(this).css("fontSize", newSize + "px");
                        if (newSize <= 12) {
                            $('#decrsfont').attr("disabled", "disabled");
                        }
                        if (newSize < 25) {
                            $('#incrsfont').removeAttr("disabled");
                        }
                    }
                });
            }
        });
    </script>
    <style>
        body{ font-size:12px;}
    .heading{ font-size:18px; font-weight:bold;}
    </style>
</head>
<body>
  
    <div id="ChDfontdiv">
    <div class="heading">
    heading heading heading
    </div>
      <div>div div div div div</div>
        <span>span span span span span</span>
        <label>label label label label label</label>
    </div>
    <br />
    <input type="button" id="incrsfont" value=" + " />
    <input type="button" id="decrsfont" value=" - " />
  
</body>
</html>







Friday 2 November 2018

Add / Insert Identity column to DataTable in asp.net C#

////////////////////


DataTable dt = new DataTable();

        //Add columns to DataTable.
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Country") });

        //Set AutoIncrement True for the First Column.
        dt.Columns["Id"].AutoIncrement = true;

        //Set the Starting or Seed value.
        dt.Columns["Id"].AutoIncrementSeed = 1;

        //Set the Increment value.
        dt.Columns["Id"].AutoIncrementStep = 1;

        //Add rows to DataTable.
        dt.Rows.Add(null, "Raja", "India");
        dt.Rows.Add(null, "Ram", "US");
        dt.Rows.Add(null, "Mohan", "UK");
        dt.Rows.Add(null, "Ray", "Russia");
        dt.Rows.Add(null, "Jai", "China");



Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...