Friday, 28 February 2014

c# list multiple data types

 public class New_Library
        {

            public string File_Name { get; private set; }
            public string File_Full_Path { get; private set; }
            public string checksum { get; private set; }


            public New_Library(string File_Name1, string File_Full_Path1, string checksum1)
            {
                File_Name = File_Name1;
                File_Full_Path = File_Full_Path1;
                checksum = checksum1;
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            List<New_Library> list_New_Library = new List<New_Library>();
            list_New_Library.Add(new New_Library("sometext", "Vishal", "123456")); // store text
            list_New_Library.Add(new New_Library("sometext1", "Vishal1", "1234561")); // store text

            // read values from List
            foreach (New_Library slot in list_New_Library)
            {
                string File_Name = Convert.ToString(slot.File_Name);
                string File_Full_Path = Convert.ToString(slot.File_Full_Path);
                string checksum = Convert.ToString(slot.checksum);
            }
        }

Tuesday, 17 September 2013

AJAX AUTOCOMPLETED

Code for AJAX AUTOCOMPLETED

----------------.aspx--------------

<asp:TextBox ID="txt_Narration" runat="server" Width="200px" OnTextChanged="txt_Narration_TextChanged"
AutoPostBack="true">
</asp:TextBox>&nbsp;
<div id="div_NARRATION">
</div>
<cc1:AutoCompleteExtender runat="server" ID="AutoComplete_NARRATION" BehaviorID="autoCompleteNARRATION"
TargetControlID="txt_Narration" ServicePath="~/webservices/CommonWebService.asmx"
ServiceMethod="Get_Narration" MinimumPrefixLength="1" CompletionInterval="10"
EnableCaching="true" CompletionSetCount="12" CompletionListCssClass="AutoExtender"
CompletionListItemCssClass="AutoExtenderList" CompletionListHighlightedItemCssClass="AutoExtenderHighlight"
CompletionListElementID="div_NARRATION">
</cc1:AutoCompleteExtender>

.CSS

.AutoCompleteExtender_CompletionList
{
font-size: small;   
visibility:hidden;
padding : 1px;
Height:230px;
width:250px;
z-index:5000;
cursor:default;
margin:0px!important;
border:buttonshadow;
list-style-type:none;
overflow:auto;
text-align:left;
border-width:1px;
border-style:solid;
border-color:Maroon;
}

.AutoExtender
{

font-family: Verdana, Helvetica, sans-serif;
font-size: .8em;
font-weight: normal;
border: solid 1px #006699;
line-height: 20px;
padding: 10px;
background-color: White;
margin-left:0px;
z-index:5000;
}
.AutoExtenderList
{
border-bottom: dotted 1px #006699;
cursor: pointer;
color: Maroon;
z-index:5000;
}
.AutoExtenderHighlight
{
color: White;
background-color: #006699;
cursor: pointer;
z-index:5000;
}
#divwidth
{
z-index:500;
width: 200px !important;  
text-align:Left; 
}
#divwidth div
{
z-index:500;
text-align:Left;
width: 200px !important;  

}


.webservices

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Configuration;
using System.Diagnostics;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Web.Script.Services;
using System.Xml;
using System.Collections.Generic;
/// <summary>
/// Summary description for CommonWebService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]

ConnectionStringSettings css = ConfigurationManager.ConnectionStrings["cnnGPTERP_IBM"];
SqlConnection sqlcnGPTERP;
SqlDataAdapter da;
DataTable dt;








[WebMethod]
public string[] Get_Narration(string prefixText)
{
//int count = 10;
sqlcnGPTERP = new SqlConnection(css.ConnectionString);
string sql = "select  narr_code, narrat_name from narration  where  (narrat_name like @prefixText or narr_code like @prefixText) order by  narrat_name";
SqlDataAdapter da = new SqlDataAdapter(sql, sqlcnGPTERP);
da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["narrat_name"].ToString() + " { " + dr["narr_code"].ToString() + " }", i);
i++;
}
return items;
    }

JAVASCRIPT AUTO REFRESH PAGE

Response.Expires = 0;
Response.Buffer = true;
Response.Clear();
Response.AddHeader("Refresh", "3");

JAVASCRIPT ALERT ON CLASS PAGE



----------------.aspx--------------
JAVASCRIPT FUNCTION
function alertClick(Details)
{
alert(Details)
return false;
}
.CS    
string alert = "Enter Atleast One Debit Type and One Credit Type Ledger";
RegisterClientScriptBlock("gridcount", "<script Language='javascript'>window.onload = function(){return alertClick('" + alert + "');}</script>");
return;

 ---------------- OR

protected void Page_Load(object sender, EventArgs e)

{

  string message = "Hello! Mudassar.";

  System.Text.StringBuilder sb = new System.Text.StringBuilder();

  sb.Append("<script type = 'text/javascript'>");

  sb.Append("window.onload=function(){");

  sb.Append("alert('");

  sb.Append(message);

  sb.Append("')};");

  sb.Append("</script>");

  ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString());

}
 

Code for AJAX TEXTCHANGE WEBSERVICE CALL



----------------.aspx--------------

   <script language="javascript" type="text/javascript">
       
    function CallParametersPageMethod()
    {
       Branch_Abrv = document.getElementById('txt_search').value;
       CommonWebService.Mai_Login_Branch(Branch_Abrv,onSucceeded,onFailed);
// CommonWebService ? WEBSERVICE NAME
// Mai_Login_Branch ? METHOD NAME FROM WEBSERVICE
    }

    function onSucceeded(result,userContext,methodName)
    {
        if(result!="")
        {
          document.getElementById('txt_search').value= result;
        }   
    }
    function onFailed(error,userContext,methodName)
    {
      alert("An error occurred");
    }

    </script>


.ASPX

<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference InlineScript="true" Path="~/webservices/CommonWebService.asmx" />
</Services>
</asp:ScriptManager>


<asp:TextBox ID="txt_search" runat="server" Style="z-index: 112; left: 145px; position: absolute;
top: 135px;" TabIndex="4" ToolTip="Type Branch Name" AutoCompleteType="Disabled"
Width="143px"></asp:TextBox>


.CS CODE

txt_search.Attributes.Add("onblur", "javascript:return CallParametersPageMethod()");

.WEBSERVICES

[WebMethod]
public string Mai_Login_Branch(string prefixText)
{
if (prefixText.Contains("{") || prefixText.Contains("}"))
{
string[] branch_name = prefixText.Split('{');
prefixText = Convert.ToString(branch_name[1]).Trim();
prefixText = prefixText.Replace("{", "");
prefixText = prefixText.Replace("}", "");
}
sqlcnGPTERP = new SqlConnection(css.ConnectionString);
string sql = "select branch,branch_abrv,pk_branch_key from Branch Where branch_abrv ='" + prefixText.Trim() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, sqlcnGPTERP);
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
string Primary_Key = "";
foreach (DataRow dr in dt.Rows)
{
Primary_Key = dr["branch_abrv"].ToString() + "{" + dr["Branch"].ToString() + "}";
i++;
}
return Primary_Key;
}

AJAX TAB CONTROL




<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>

<cc1:tabcontainer id="TabContainer1" runat="server" activetabindex="0" style="z-index: 18;
left: 0px; top: 0px" width="100%" cssclass="ajax__myTab" backcolor="#FFFBD6">
<%--ledger details--%>
<cc1:TabPanel ID="Tab_Ledger_Details" runat="server" HeaderText="Voucher Details"
Width="100%" Style="text-align: left" BackColor="#FFFBD6">
<ContentTemplate>
</ContentTemplate>
</cc1:TabPanel>
<%--vourcher details complet--%>
<%--Bill and cost tab start--%>
<cc1:TabPanel ID="Tab_Bill_Cost" runat="server" HeaderText="Bill and Cost Details"
Width="100%" BackColor="#FFFBD6">
<ContentTemplate>

</ContentTemplate>
</cc1:TabPanel>
<%--Bill and cost tab complete--%>
<%--document ref tab start--%>
<cc1:TabPanel ID="Tab_Doc_Ref" runat="server" HeaderText="Document Reference Details"
Width="100%" BackColor="#FFFBD6">
<ContentTemplate>

</ContentTemplate>
</cc1:TabPanel>
<%--document ref tab complete--%>
</cc1:tabcontainer>

JAVASCRIPT CLEARE HISTORY

<script type="text/javascript" language="javascript">
javascript:window.history.forward(1);
</script>


Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.Cache.SetAllowResponseInBrowserHistory(False)