Pramod Raising

Friday, 28 April 2017

Remove the newline and enter data \n and select SQL Query

REPLACE(REPLACE(cast(BRANCHNAME as nvarchar(max)), CHAR(13), ''), CHAR(10), '')

Wednesday, 8 March 2017

XML Convert into SQL table

DECLARE @XMLData XML

SET @XMLData ='

<STUDENTS>

  <STUDENT>

    <StudentID>1</StudentID>

    <Name>John Smith</Name>

    <Marks>200</Marks>

  </STUDENT>

  <STUDENT>

    <StudentID>2</StudentID>

    <Name>Mark Johnson</Name>

    <Marks>300</Marks>

  </STUDENT>

<STUDENT>

    <StudentID>3</StudentID>

    <Name>Nitin Tyagi</Name>

    <Marks>400</Marks>

  </STUDENT>

</STUDENTS>'

SELECT StudentID = Node.Data.value('(StudentID)[1]', 'INT')

        , [Name] = Node.Data.value('(Name)[1]', 'VARCHAR(MAX)')

        , [Marks] = Node.Data.value('(Marks)[1]', 'INT')

FROM    @XMLData.nodes('/STUDENTS/STUDENT') Node(Data)

Tuesday, 29 November 2016

Arry Data DataTable Data Xml data insert into Database

DataTable _dt = new DataTable();
DataColumn col1 = new DataColumn("fkEmployeeid");
col1.DataType = System.Type.GetType("System.String");
_dt.Columns.Add(col1);

if (sel_list.Items.Count > 0)
{
for (int i = 1; i < sel_list.Items.Count; i++)
{
_dt.Rows.Add(sel_list.Items[i].Value);

}
}

public static string GetXMLOfDataTable(DataTable dtToProcess)
{
string strOutput = "";
try
{
dtToProcess.TableName = "Table";
StringWriter sw = new StringWriter();
dtToProcess.WriteXml(sw);
strOutput = sw.ToString();
}
catch (Exception ex)
{
}
return strOutput;
}
ED.strxmlData1 = GetXMLOfDataTable(_dt);

@xmlLanguage2 xml,

IF (@xmlLanguage2 IS NOT NULL)
begin
SELECT ISNULL(cast(Colx.query('data(fkEmployeeid)') as varchar(max)),'0') as fkEmployeeid
INTO #TMPLanguage1 FROM @xmlLanguage2.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_tab_OthereEmployeeInvoled(
Employeeid,
EmployeeReportId
)
select fkEmployeeid,@RID from #TMPLanguage1
end

Monday, 17 October 2016

DDL Drropdown DDLDay DDLMonth DDlYear

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testc.aspx.cs" Inherits="testc" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script type="text/javascript">
function ValidateDate(sender, args) {
var dateString = document.getElementById("ddlday").value + "/" + document.getElementById("ddlmonth").value +
"/" + document.getElementById("ddlyear").value ;
alert(dateString)
var regex = /(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$/;
if (regex.test(dateString)) {
var parts = dateString.split("/");
var dt = new Date(parts[1] + "/" + parts[0] + "/" + parts[2]);
args.IsValid = (dt.getDate() == parts[0] && dt.getMonth() + 1 == parts[1] && dt.getFullYear() == parts[2]);
} else {
args.IsValid = false;
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div class="selectWrapper">
<label>Date of registration</label>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText" id="selectday" runat="server" >Day</div>
<asp:DropDownList ID="ddlday" runat="server">
<asp:ListItem>Day</asp:ListItem>
</asp:DropDownList>

</div>
</div>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText">Month</div>
<asp:DropDownList ID="ddlmonth" runat="server">
<asp:ListItem>Month</asp:ListItem>
</asp:DropDownList>
</div>
</div>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText">Year</div>
<asp:DropDownList ID="ddlyear" runat="server">
<asp:ListItem>Year</asp:ListItem>
</asp:DropDownList>
</div>
</div>
</div>
<asp:CustomValidator runat="server" ClientValidationFunction="ValidateDate"
ErrorMessage="Invalid Date." OnServerValidate="ValidateDate" ValidationGroup="Group2" />
<asp:Button ID="Button1" runat="server" Text="Button" ValidationGroup="Group2" />
</form>
</body>
</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Text.RegularExpressions;

using System.Globalization;

public partial class testc : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindddlDayMonthYear();

}

protected void ValidateDate(object sender, ServerValidateEventArgs e)

{

string txtDate3 = ddlday.SelectedValue + "/" + ddlmonth.SelectedValue + "/" + ddlyear;

if (Regex.IsMatch(txtDate3, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$"))

{

DateTime dt;

e.IsValid = DateTime.TryParseExact(e.Value, "dd/MM/yyyy", new CultureInfo("en-GB"), DateTimeStyles.None, out dt);

if (e.IsValid)

{

ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Valid Date.');", true);

}

else

{

e.IsValid = false;

}

protected void bindddlDayMonthYear()

{

ddlday.Items.Clear();

for (int i = 1; i <= 31; i++)

{

if (i < 10)

{ ddlday.Items.Add(new ListItem("0" + i.ToString())); }

else

{ ddlday.Items.Add(new ListItem(i.ToString())); }

}

ddlday.Items.Insert(0, "Day");

ddlmonth.Items.Clear();

for (int i = 1; i <= 12; i++)

{

if (i < 10)

{ ddlmonth.Items.Add(new ListItem("0" + i.ToString())); }

else

{

ddlmonth.Items.Add(new ListItem(i.ToString()));

}

ddlmonth.Items.Insert(0, "Month");

ddlyear.Items.Clear();

for (int i = 1980; i <= DateTime.Now.Year; i++)

{

ddlyear.Items.Add(new ListItem(i.ToString()));

}

ddlyear.Items.Insert(0, "Year");

}

Wednesday, 13 July 2016

Client site validation in MVC and Umbraco

Monday, 20 June 2016

one field text box and multiple validator

Monday, 13 June 2016

post request

using (WebClient client = new WebClient())
{

byte[] response =
client.UploadValues("http://dork.com/service", new NameValueCollection()
{
{ "home", "Cosby" },
{ "favorite+flavor", "flies" }
});

string result = System.Text.Encoding.UTF8.GetString(response);
string addResult = "{\"d\":" + result + "}";

XmlDocument xml = (XmlDocument)JsonConvert.DeserializeXmlNode(addResult);
XmlNodeList xnList = xml.SelectNodes("/d/transaction_details");
string statusr = "";
string transactionId = "", PG_TYPE = "", Bank_Ref_Num = "", BankCode = "", CardNum = "", Card_Type = "" ;
foreach (XmlNode anode in xnList)
{
if (anode != null)
{
foreach (XmlNode a in anode.FirstChild)
{
if (a != null)
{
if (a.Name == "status")
{
statusr = a.InnerText.ToLower().Trim();

}
else
if (a.Name == "txnid")
{
transactionId = a.InnerText.ToLower().Trim();

} else
if (a.Name == "PG_TYPE")
{
PG_TYPE = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "bank_ref_num")
{
Bank_Ref_Num = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "bankcode")
{
BankCode = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "card_no")
{
CardNum = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "card_type")
{
Card_Type = a.InnerText.ToLower().Trim();
}
}
}
}

}