1)First Query for getting the N largest salary (where N=2)
SELECT max(CURRENT_NEWS_ID)
FROM (SELECT TOP N CURRENT_NEWS_ID FROM CURRENT_NEWS order by CURRENT_NEWS_ID ASC)a
//WHERE N=3
2)Second query for second largest salary
SELECT TOP 1 CURRENT_NEWS_ID FROM
(
SELECT TOP 2 CURRENT_NEWS_ID FROM (SELECT CURRENT_NEWS_ID FROM CURRENT_NEWS )A ORDER BY CURRENT_NEWS_ID DESC
)T ORDER BY CURRENT_NEWS_ID ASC
Tuesday, September 29, 2009
Wednesday, September 23, 2009
How to Create dyanic button and TextBox
Hello friends,
today we will learn here how to create the dynamic Button as well as Textbox ,how to handle the event of dynamic Button and how to retrieve the values of Textboxs
//Put a Place Holder or panel control on your aspx page like this
//2) go to the code behind and done the following operaions
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Administrator.DataAccess;
using Administrator.BussinessObject;
public partial class UserControl_Navigration : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CreateButton();//Function to create the dynamic button
CreatedTextBox(); //Function to Create the Dyanmic Textbox
}
else
{
CreateButton();
CreatedTextBox();
}
}
//function to Create the dynamic button
public void CreateButton()
{
for (int i = 0; i <= 10; i++)
{
Button btn = new Button();
btn.ID = "btn" + i.ToString();
btn.Text = "Button"+i.ToString();
btn.CssClass = "current";
btn.ForeColor = System.Drawing.Color.White;
btn.BackColor = System.Drawing.Color.Gray;
btn.Attributes.Add("style", "cursor:pointer;");
btn.Command +=new CommandEventHandler(Redirect);//Handling the Event of button
place.Controls.Add(btn);//Adding the button to Place holder control here
}
}
//this function Redirect will be fire when any user will click on button
protected void Redirect(object sender, CommandEventArgs e)
{
Button btn=(Button)sender;
Response.Write("My Name is:" + btn.ID.ToString());
btn.Text = "My name is praveen";
//using for loop we are geting the text of dynamic text box
for (int i = 0; i <= 5; i++)
{
TextBox txt =(TextBox) this.form1.FindControl("txt" + i);
Response.Write(txt.Text);
txt.Text = "Jai Shree Ram";
}
}
//Here We are creating the dynamic textboxs
public void CreatedTextBox()
{
for(int i=0; i<=5; i++)
{
TextBox txt = new TextBox();
txt.ID = "txt" + i;
this.form1.Controls.Add(txt);
}
}
}
}
}
today we will learn here how to create the dynamic Button as well as Textbox ,how to handle the event of dynamic Button and how to retrieve the values of Textboxs
//Put a Place Holder or panel control on your aspx page like this
//2) go to the code behind and done the following operaions
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Administrator.DataAccess;
using Administrator.BussinessObject;
public partial class UserControl_Navigration : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CreateButton();//Function to create the dynamic button
CreatedTextBox(); //Function to Create the Dyanmic Textbox
}
else
{
CreateButton();
CreatedTextBox();
}
}
//function to Create the dynamic button
public void CreateButton()
{
for (int i = 0; i <= 10; i++)
{
Button btn = new Button();
btn.ID = "btn" + i.ToString();
btn.Text = "Button"+i.ToString();
btn.CssClass = "current";
btn.ForeColor = System.Drawing.Color.White;
btn.BackColor = System.Drawing.Color.Gray;
btn.Attributes.Add("style", "cursor:pointer;");
btn.Command +=new CommandEventHandler(Redirect);//Handling the Event of button
place.Controls.Add(btn);//Adding the button to Place holder control here
}
}
//this function Redirect will be fire when any user will click on button
protected void Redirect(object sender, CommandEventArgs e)
{
Button btn=(Button)sender;
Response.Write("My Name is:" + btn.ID.ToString());
btn.Text = "My name is praveen";
//using for loop we are geting the text of dynamic text box
for (int i = 0; i <= 5; i++)
{
TextBox txt =(TextBox) this.form1.FindControl("txt" + i);
Response.Write(txt.Text);
txt.Text = "Jai Shree Ram";
}
}
//Here We are creating the dynamic textboxs
public void CreatedTextBox()
{
for(int i=0; i<=5; i++)
{
TextBox txt = new TextBox();
txt.ID = "txt" + i;
this.form1.Controls.Add(txt);
}
}
}
}
}
Thursday, September 17, 2009
Code for Sending Mail In asp.net
//This code is use to send mail on Godday Hosting server
using System;
using System.Data;
using System.Configuration;
using System.Web;
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.Web.Mail;
public class EmailManager
{
public void mailfrom(string FAddress, string TOAddress, string MailSubject, string MailMessageBody)
{
try
{
const string SERVER = "relay-hosting.secureserver.net";
MailMessage oMail = new System.Web.Mail.MailMessage();
oMail.From = FAddress;
oMail.To = TOAddress;
oMail.Subject = MailSubject;
oMail.BodyFormat = MailFormat.Html; // enumeration
oMail.Priority = MailPriority.High; // enumeration
oMail.Body = MailMessageBody;
SmtpMail.SmtpServer = SERVER;
SmtpMail.Send(oMail);
}
catch (Exception ex)
{
//HttpContext.Current.Response.Write("Can not send the mail sorry");
}
}
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
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.Web.Mail;
public class EmailManager
{
public void mailfrom(string FAddress, string TOAddress, string MailSubject, string MailMessageBody)
{
try
{
const string SERVER = "relay-hosting.secureserver.net";
MailMessage oMail = new System.Web.Mail.MailMessage();
oMail.From = FAddress;
oMail.To = TOAddress;
oMail.Subject = MailSubject;
oMail.BodyFormat = MailFormat.Html; // enumeration
oMail.Priority = MailPriority.High; // enumeration
oMail.Body = MailMessageBody;
SmtpMail.SmtpServer = SERVER;
SmtpMail.Send(oMail);
}
catch (Exception ex)
{
//HttpContext.Current.Response.Write("Can not send the mail sorry");
}
}
}
Wednesday, September 16, 2009
Use of Generic in C#
Steps of using the Generics Instead of Dataset
1)Create a property class have all the property what ever fields you want to add the generic class
suppose we have Created a class Name userInfo
2)Create a another class for Generic list suppose we are creating a class GenricList
3)Import the above two Name space in your class
using System.Collections.Generic;
using System.Data.SqlClient;
4)Create the object of IList Generic class in class GenericList
Like this:
IList UserInfos = new List();
5)Create a function in class GenericList for Add the value in Generic have IList Return type
Like:
public System.Collections.Generic.IList FillList()
{
//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
// = new IList();
string Qstring = "select * from UserRegistration";
using( SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = Qstring;
cn.Open();
SqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
UserInfo ObjUserInfo = new UserInfo(red[4].ToString(),red[5].ToString());
UserInfos.Add(ObjUserInfo);
}
red.Close();
return UserInfos;
}
}
//Explanation of function FillList() setp by step
A)Declare a string and Assign SQL statement or procedure name to it
B)Declare and Create the Connection string using SqlConnection
C)Fetch the Data from database using SqlDataReader
D)If you reader gets any row from database than apply for reading the values form SqlDataReader
D)Crate the object of property class like our property class name is userInfo
E)Assign the value of dataReader to the corresponding property define in userInfo class
F)Add this Created Object into Generic List class object
G) And At last return this Generic list class object
//Operation for aspx page
6)Add the GridView on your aspx page
7)Create a function of GenricList Class
8)Create a object of Generic IList
9)Call the FillList() Function and assign the its return value to Generic IList Object
10)Assign the Generic Ilist Object to GridView as DataSource and Bind The Grid
//How to fech the Value form Ilist
for (int i = 0; i<=User.Count - 1; i++)
{
Response.Write("UserName: "+Convert.ToString(User[i].UserName) + " ," +"Password:"+ Convert.ToString(User[i].Password)+"
");
}
Note:- We cannot convert the Genrice List object to Dataset or DataTable its better alternet of DataSet or DataTable Its Incress the performance of System
//All code of Generic List
//.cs class file code
using System;
using System.Data;
using System.Configuration;
using System.Web;
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.Collections.Generic;
using System.Data.SqlClient;
///
/// Summary description for Col
///
public class UserInfo
{
private string _UserName = string.Empty;
private string _Password = string.Empty;
public UserInfo(string UserName,string Password)
{
this._UserName = UserName;
this._Password = Password;
//
// TODO: Add constructor logic here
//
}
public string UserName
{
get { return _UserName; }
}
public string Password
{
get { return _Password; }
}
}
///
///This Class is for Genric
///
///
public class GenricList
{
IList UserInfos = new List();
public GenricList()
{
}
public System.Collections.Generic.IList FillList()
{
//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
// = new IList();
string Qstring = "select * from UserRegistration";
using( SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = Qstring;
cn.Open();
SqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
UserInfo ObjUserInfo = new UserInfo(red[4].ToString(),red[5].ToString());
UserInfos.Add(ObjUserInfo);
}
red.Close();
return UserInfos;
}
}
}
//put above code on your aspx.cs page
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
GenricList ObjGenricList = new GenricList();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
public void BindGrid()
{
System.Collections.Generic.IList User = new System.Collections.Generic.List();
User = ObjGenricList.FillList();
grd.DataSource = User;//Assign the DataSource to GridView
grd.DataBind();
for (int i = 0; i<=User.Count - 1; i++)
{
//Reading the Row by row Data For List
Response.Write("UserName: "+Convert.ToString(User[i].UserName) + " ," +"Password:"+ Convert.ToString(User[i].Password)+"
");
}
}
}
1)Create a property class have all the property what ever fields you want to add the generic class
suppose we have Created a class Name userInfo
2)Create a another class for Generic list suppose we are creating a class GenricList
3)Import the above two Name space in your class
using System.Collections.Generic;
using System.Data.SqlClient;
4)Create the object of IList Generic class in class GenericList
Like this:
IList
5)Create a function in class GenericList for Add the value in Generic have IList
Like:
public System.Collections.Generic.IList
{
//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
// = new IList
string Qstring = "select * from UserRegistration";
using( SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = Qstring;
cn.Open();
SqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
UserInfo ObjUserInfo = new UserInfo(red[4].ToString(),red[5].ToString());
UserInfos.Add(ObjUserInfo);
}
red.Close();
return UserInfos;
}
}
//Explanation of function FillList() setp by step
A)Declare a string and Assign SQL statement or procedure name to it
B)Declare and Create the Connection string using SqlConnection
C)Fetch the Data from database using SqlDataReader
D)If you reader gets any row from database than apply for reading the values form SqlDataReader
D)Crate the object of property class like our property class name is userInfo
E)Assign the value of dataReader to the corresponding property define in userInfo class
F)Add this Created Object into Generic List class object
G) And At last return this Generic list class object
//Operation for aspx page
6)Add the GridView on your aspx page
7)Create a function of GenricList Class
8)Create a object of Generic IList
9)Call the FillList() Function and assign the its return value to Generic IList Object
10)Assign the Generic Ilist Object to GridView as DataSource and Bind The Grid
//How to fech the Value form Ilist
for (int i = 0; i<=User.Count - 1; i++)
{
Response.Write("UserName: "+Convert.ToString(User[i].UserName) + " ," +"Password:"+ Convert.ToString(User[i].Password)+"
");
}
Note:- We cannot convert the Genrice List object to Dataset or DataTable its better alternet of DataSet or DataTable Its Incress the performance of System
//All code of Generic List
//.cs class file code
using System;
using System.Data;
using System.Configuration;
using System.Web;
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.Collections.Generic;
using System.Data.SqlClient;
///
/// Summary description for Col
///
public class UserInfo
{
private string _UserName = string.Empty;
private string _Password = string.Empty;
public UserInfo(string UserName,string Password)
{
this._UserName = UserName;
this._Password = Password;
//
// TODO: Add constructor logic here
//
}
public string UserName
{
get { return _UserName; }
}
public string Password
{
get { return _Password; }
}
}
///
///This Class is for Genric
///
///
public class GenricList
{
IList
public GenricList()
{
}
public System.Collections.Generic.IList
{
//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
// = new IList
string Qstring = "select * from UserRegistration";
using( SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = Qstring;
cn.Open();
SqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
UserInfo ObjUserInfo = new UserInfo(red[4].ToString(),red[5].ToString());
UserInfos.Add(ObjUserInfo);
}
red.Close();
return UserInfos;
}
}
}
//put above code on your aspx.cs page
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
GenricList ObjGenricList = new GenricList();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
public void BindGrid()
{
System.Collections.Generic.IList
User = ObjGenricList.FillList();
grd.DataSource = User;//Assign the DataSource to GridView
grd.DataBind();
for (int i = 0; i<=User.Count - 1; i++)
{
//Reading the Row by row Data For List
Response.Write("UserName: "+Convert.ToString(User[i].UserName) + " ," +"Password:"+ Convert.ToString(User[i].Password)+"
");
}
}
}
Code for Drawing the PIe char in C#
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
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.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Drawing2D;
public partial class MyOptimizePieChartForPorject : System.Web.UI.Page
{
//This programe is use to Create a pie chart and Dispaly the completed process in the ratio of //20%,30% and 50% completed in diffreent colore
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "image/jpeg";
Graphics Instatnce;
const int width = 450, height = 400;//Height and widht of rectangel Image in which we //draw the pie chart
Bitmap ObjBitmap = new Bitmap(width, height, PixelFormat.Format32bppRgb);
Graphics ObjGraphics = Graphics.FromImage(ObjBitmap);
ObjGraphics.FillRectangle(new SolidBrush(Color.Violet), 0, 0, width, height);
Draw3DPieChart(ref ObjGraphics);
ObjBitmap.Save(Response.OutputStream, ImageFormat.Jpeg);
ObjGraphics.Dispose();
ObjBitmap.Dispose();
}
protected void Draw3DPieChart(ref Graphics objGraphics)
{
int iLoop, iLoop2;
// Create location and size of ellipse.
// int x = 50;
//int y = 20;
int x = 10;//X-axis
int y = 10;//y axis
int width = 250;//Width of Pie chart
int height = 250;//height of pie chart
// Create start and sweep angles.
int startAngle = 0;//starting point to filling the chart
int sweepAngle = 60;//defining how much we draw the angle to fill the pie chart
SolidBrush objBrush = new SolidBrush(Color.Aqua);
Random rand = new Random();
objGraphics.SmoothingMode = SmoothingMode.AntiAlias;
objBrush.Color = Color.Red;
DrowPie(objGraphics,objBrush, 10, 10, 250, 250, 0, 20);//this fuction is user to draw and //fill the pic chart
DrowIndecatedRectangle(objGraphics,objBrush, 0);//drawing the rectangle to Indicateing wich color is showing which section
//DrawString is use to wirite any incation or words
objGraphics.DrawString("Completed 20%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Red, 330, 25 + (0 * 50) + 10);
objBrush.Color = Color.Gray;
DrowPie(objGraphics,objBrush, 10, 10, 250, 250, 20, 30);
DrowIndecatedRectangle(objGraphics, objBrush, 1);
objGraphics.DrawString(" Completed 30%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Gray, 330, 25 + (1 * 50) + 10);
objBrush.Color = Color.Yellow;
DrowPie(objGraphics, objBrush, 10, 10, 250, 250, 50, 50);
DrowIndecatedRectangle(objGraphics, objBrush, 2);
objGraphics.DrawString(" Completed 50%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Yellow, 330, 25 + (2 * 50) + 10);
}
//This function is user to drow the pie chart
protected void DrowPie(Graphics objGraphics, SolidBrush objBrush, int x, int y, int width, int height, int startAngle, int sweepAngle)
{
//meaning of paramenters variable
//int x-- is use to declare the x-axis of pie chart
//int y -- is use to declare the y-axis
//int width use to declare the width of pie chart
//int heigh use to declare the height of pie chart
startAngle = PercentageAngle(startAngle);
sweepAngle = PercentageAngle(sweepAngle);
objGraphics.FillPie(objBrush, x, y, width, height, startAngle, sweepAngle);
}
//This function is use the Draw the rectangle to indicate the color and its use
protected void DrowIndecatedRectangle(Graphics ObjGraphics,SolidBrush objBrush,int i)
{
//int i --is use to maintain thepositnion of rectangle
ObjGraphics.FillRectangle(objBrush, 290, 25 + (i * 50), 25, 25);
}
//This function is use to change the completed percent in degree of circle like //360 degrdd==100%
protected int PercentageAngle(int input)
{
int totalAngle = (360* input / 100) ;
return totalAngle;
}
}
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
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.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Drawing2D;
public partial class MyOptimizePieChartForPorject : System.Web.UI.Page
{
//This programe is use to Create a pie chart and Dispaly the completed process in the ratio of //20%,30% and 50% completed in diffreent colore
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "image/jpeg";
Graphics Instatnce;
const int width = 450, height = 400;//Height and widht of rectangel Image in which we //draw the pie chart
Bitmap ObjBitmap = new Bitmap(width, height, PixelFormat.Format32bppRgb);
Graphics ObjGraphics = Graphics.FromImage(ObjBitmap);
ObjGraphics.FillRectangle(new SolidBrush(Color.Violet), 0, 0, width, height);
Draw3DPieChart(ref ObjGraphics);
ObjBitmap.Save(Response.OutputStream, ImageFormat.Jpeg);
ObjGraphics.Dispose();
ObjBitmap.Dispose();
}
protected void Draw3DPieChart(ref Graphics objGraphics)
{
int iLoop, iLoop2;
// Create location and size of ellipse.
// int x = 50;
//int y = 20;
int x = 10;//X-axis
int y = 10;//y axis
int width = 250;//Width of Pie chart
int height = 250;//height of pie chart
// Create start and sweep angles.
int startAngle = 0;//starting point to filling the chart
int sweepAngle = 60;//defining how much we draw the angle to fill the pie chart
SolidBrush objBrush = new SolidBrush(Color.Aqua);
Random rand = new Random();
objGraphics.SmoothingMode = SmoothingMode.AntiAlias;
objBrush.Color = Color.Red;
DrowPie(objGraphics,objBrush, 10, 10, 250, 250, 0, 20);//this fuction is user to draw and //fill the pic chart
DrowIndecatedRectangle(objGraphics,objBrush, 0);//drawing the rectangle to Indicateing wich color is showing which section
//DrawString is use to wirite any incation or words
objGraphics.DrawString("Completed 20%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Red, 330, 25 + (0 * 50) + 10);
objBrush.Color = Color.Gray;
DrowPie(objGraphics,objBrush, 10, 10, 250, 250, 20, 30);
DrowIndecatedRectangle(objGraphics, objBrush, 1);
objGraphics.DrawString(" Completed 30%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Gray, 330, 25 + (1 * 50) + 10);
objBrush.Color = Color.Yellow;
DrowPie(objGraphics, objBrush, 10, 10, 250, 250, 50, 50);
DrowIndecatedRectangle(objGraphics, objBrush, 2);
objGraphics.DrawString(" Completed 50%", new Font("Verdana", 8, FontStyle.Bold), Brushes.Yellow, 330, 25 + (2 * 50) + 10);
}
//This function is user to drow the pie chart
protected void DrowPie(Graphics objGraphics, SolidBrush objBrush, int x, int y, int width, int height, int startAngle, int sweepAngle)
{
//meaning of paramenters variable
//int x-- is use to declare the x-axis of pie chart
//int y -- is use to declare the y-axis
//int width use to declare the width of pie chart
//int heigh use to declare the height of pie chart
startAngle = PercentageAngle(startAngle);
sweepAngle = PercentageAngle(sweepAngle);
objGraphics.FillPie(objBrush, x, y, width, height, startAngle, sweepAngle);
}
//This function is use the Draw the rectangle to indicate the color and its use
protected void DrowIndecatedRectangle(Graphics ObjGraphics,SolidBrush objBrush,int i)
{
//int i --is use to maintain thepositnion of rectangle
ObjGraphics.FillRectangle(objBrush, 290, 25 + (i * 50), 25, 25);
}
//This function is use to change the completed percent in degree of circle like //360 degrdd==100%
protected int PercentageAngle(int input)
{
int totalAngle = (360* input / 100) ;
return totalAngle;
}
}
Thursday, September 10, 2009
Paypal Integration
/*Paypal Integration Using Code behind HTML(Redirect on Paypal((DoDirectPayment))) */
string amount = Convert.ToString(Session["TotalPayment"]);
string redirect = "https://www.paypal.com/xclick/business=julie@reframecollective.com";
redirect += "&item_name=videos_Payment";
// redirect += "&item_number=1";
redirect += "&amount=" + String.Format("{0:0.00}", amount);
redirect += "¤cy_code=USD";
//redirect += "&no_shipping=1";
// redirect += "&no_note=1";
redirect += "&return=http://reframeawards.com/SuccessPaypalPayment.aspx";//?status=success&orderid=" + orderId;
redirect += "&cancel_return=http://reframeawards.com/Categories.aspx/fail";//?status=failed&orderid=" + orderId;
Response.Redirect(redirect);
====================================================================
/*Paypal Integration using API(DoDirectPayment)*/
====================================================================
using System;
using System.Data;
using System.Configuration;
using System.Web;
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 com.paypal.sdk.services;
using com.paypal.soap.api;
using com.paypal.sdk.profiles;
using com.paypal.sdk.exceptions;
///
/// Summary description for DoDirectPayment
///
namespace GenerateCodeSOAP
{
public class DoDirectPayment
{
public DoDirectPayment()
{
//
// TODO: Add constructor logic here
//
}
public string DoDirectPaymentCode(string paymentAmount, string buyerLastName, string buyerFirstName, string buyerAddress1, string buyerAddress2, string buyerCity, string buyerState, string buyerZipCode, string creditCardType, string creditCardNumber, string CVV2, int expMonth, int expYear, PaymentActionCodeType paymentAction)
{
CallerServices caller = new CallerServices();
IAPIProfile profile = ProfileFactory.createSignatureAPIProfile();
/*
WARNING: Do not embed plaintext credentials in your application code.
Doing so is insecure and against best practices.
Your API credentials must be handled securely. Please consider
encrypting them for use in any production environment, and ensure
that only authorized individuals may view or modify them.
*/
// Set up your API credentials, PayPal end point, and API version.
profile.APIUsername = "julie_api1.reframecollective.com";//"julie@reframecollective.com";//
profile.APIPassword = "V3GB2HR76FEU92XB";//"togglereframe";//
profile.APISignature = "ADlg1IZhxkPA1k9zzvwCX-FsoRV9AfW9ubc4HF7B.C1.Dl5PkYq1FIvg";
profile.Environment = "Live";
caller.APIProfile = profile;
// Create the request object.
DoDirectPaymentRequestType pp_Request = new DoDirectPaymentRequestType();
pp_Request.Version = "51.0";
// Add request-specific fields to the request.
// Create the request details object.
pp_Request.DoDirectPaymentRequestDetails = new DoDirectPaymentRequestDetailsType();
pp_Request.DoDirectPaymentRequestDetails.IPAddress = "10.244.43.106";
pp_Request.DoDirectPaymentRequestDetails.MerchantSessionId = "1X911810264059026";
pp_Request.DoDirectPaymentRequestDetails.PaymentAction = paymentAction;
pp_Request.DoDirectPaymentRequestDetails.CreditCard = new CreditCardDetailsType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardNumber = creditCardNumber;
switch (creditCardType)
{
case "Visa":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Visa;
break;
case "MasterCard":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.MasterCard;
break;
case "Discover":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Discover;
break;
case "Amex":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Amex;
break;
}
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CVV2 = CVV2;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.ExpMonth = expMonth;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.ExpYear = expYear;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner = new PayerInfoType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Payer = "";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerID = "";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerStatus = PayPalUserStatusCodeType.unverified;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerCountry = CountryCodeType.US;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address = new AddressType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Street1 = buyerAddress1;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Street2 = buyerAddress2;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CityName = buyerCity;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.StateOrProvince = buyerState;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.PostalCode = buyerZipCode;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CountryName = "USA";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Country = CountryCodeType.US;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CountrySpecified = true;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName = new PersonNameType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName.FirstName = buyerFirstName;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName.LastName = buyerLastName;
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails = new PaymentDetailsType();
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal = new BasicAmountType();
// NOTE: The only currency supported by the Direct Payment API at this time is US dollars (USD).
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal.currencyID = CurrencyCodeType.USD;
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal.Value = paymentAmount;
// Execute the API operation and obtain the response.
DoDirectPaymentResponseType pp_response = new DoDirectPaymentResponseType();
pp_response = (DoDirectPaymentResponseType)caller.Call("DoDirectPayment", pp_Request);
if (pp_response.Ack.ToString().Equals("Success"))
{
HttpContext.Current.Session["STransactionID"] = pp_response.TransactionID.ToString();
}
return pp_response.Ack.ToString();
}
}
}
How to Call This Function on page
1)Create a object of this class file like
DoDirectPayment objMakePay = new DoDirectPayment();
2)And Finally call this method like this
string msg = objMakePay.DoDirectPaymentCode(paymentAmount, buyerLastName, buyerFirstName, buyerAddress1, buyerAddress2, buyerCity, buyerState, buyerZipCode, creditCardType, creditCardNumber, CVV2, expMonth, expYear, PaymentActionCodeType.Sale);
string amount = Convert.ToString(Session["TotalPayment"]);
string redirect = "https://www.paypal.com/xclick/business=julie@reframecollective.com";
redirect += "&item_name=videos_Payment";
// redirect += "&item_number=1";
redirect += "&amount=" + String.Format("{0:0.00}", amount);
redirect += "¤cy_code=USD";
//redirect += "&no_shipping=1";
// redirect += "&no_note=1";
redirect += "&return=http://reframeawards.com/SuccessPaypalPayment.aspx";//?status=success&orderid=" + orderId;
redirect += "&cancel_return=http://reframeawards.com/Categories.aspx/fail";//?status=failed&orderid=" + orderId;
Response.Redirect(redirect);
====================================================================
/*Paypal Integration using API(DoDirectPayment)*/
====================================================================
using System;
using System.Data;
using System.Configuration;
using System.Web;
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 com.paypal.sdk.services;
using com.paypal.soap.api;
using com.paypal.sdk.profiles;
using com.paypal.sdk.exceptions;
///
/// Summary description for DoDirectPayment
///
namespace GenerateCodeSOAP
{
public class DoDirectPayment
{
public DoDirectPayment()
{
//
// TODO: Add constructor logic here
//
}
public string DoDirectPaymentCode(string paymentAmount, string buyerLastName, string buyerFirstName, string buyerAddress1, string buyerAddress2, string buyerCity, string buyerState, string buyerZipCode, string creditCardType, string creditCardNumber, string CVV2, int expMonth, int expYear, PaymentActionCodeType paymentAction)
{
CallerServices caller = new CallerServices();
IAPIProfile profile = ProfileFactory.createSignatureAPIProfile();
/*
WARNING: Do not embed plaintext credentials in your application code.
Doing so is insecure and against best practices.
Your API credentials must be handled securely. Please consider
encrypting them for use in any production environment, and ensure
that only authorized individuals may view or modify them.
*/
// Set up your API credentials, PayPal end point, and API version.
profile.APIUsername = "julie_api1.reframecollective.com";//"julie@reframecollective.com";//
profile.APIPassword = "V3GB2HR76FEU92XB";//"togglereframe";//
profile.APISignature = "ADlg1IZhxkPA1k9zzvwCX-FsoRV9AfW9ubc4HF7B.C1.Dl5PkYq1FIvg";
profile.Environment = "Live";
caller.APIProfile = profile;
// Create the request object.
DoDirectPaymentRequestType pp_Request = new DoDirectPaymentRequestType();
pp_Request.Version = "51.0";
// Add request-specific fields to the request.
// Create the request details object.
pp_Request.DoDirectPaymentRequestDetails = new DoDirectPaymentRequestDetailsType();
pp_Request.DoDirectPaymentRequestDetails.IPAddress = "10.244.43.106";
pp_Request.DoDirectPaymentRequestDetails.MerchantSessionId = "1X911810264059026";
pp_Request.DoDirectPaymentRequestDetails.PaymentAction = paymentAction;
pp_Request.DoDirectPaymentRequestDetails.CreditCard = new CreditCardDetailsType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardNumber = creditCardNumber;
switch (creditCardType)
{
case "Visa":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Visa;
break;
case "MasterCard":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.MasterCard;
break;
case "Discover":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Discover;
break;
case "Amex":
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CreditCardType = CreditCardTypeType.Amex;
break;
}
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CVV2 = CVV2;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.ExpMonth = expMonth;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.ExpYear = expYear;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner = new PayerInfoType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Payer = "";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerID = "";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerStatus = PayPalUserStatusCodeType.unverified;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerCountry = CountryCodeType.US;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address = new AddressType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Street1 = buyerAddress1;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Street2 = buyerAddress2;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CityName = buyerCity;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.StateOrProvince = buyerState;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.PostalCode = buyerZipCode;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CountryName = "USA";
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.Country = CountryCodeType.US;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.Address.CountrySpecified = true;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName = new PersonNameType();
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName.FirstName = buyerFirstName;
pp_Request.DoDirectPaymentRequestDetails.CreditCard.CardOwner.PayerName.LastName = buyerLastName;
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails = new PaymentDetailsType();
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal = new BasicAmountType();
// NOTE: The only currency supported by the Direct Payment API at this time is US dollars (USD).
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal.currencyID = CurrencyCodeType.USD;
pp_Request.DoDirectPaymentRequestDetails.PaymentDetails.OrderTotal.Value = paymentAmount;
// Execute the API operation and obtain the response.
DoDirectPaymentResponseType pp_response = new DoDirectPaymentResponseType();
pp_response = (DoDirectPaymentResponseType)caller.Call("DoDirectPayment", pp_Request);
if (pp_response.Ack.ToString().Equals("Success"))
{
HttpContext.Current.Session["STransactionID"] = pp_response.TransactionID.ToString();
}
return pp_response.Ack.ToString();
}
}
}
How to Call This Function on page
1)Create a object of this class file like
DoDirectPayment objMakePay = new DoDirectPayment();
2)And Finally call this method like this
string msg = objMakePay.DoDirectPaymentCode(paymentAmount, buyerLastName, buyerFirstName, buyerAddress1, buyerAddress2, buyerCity, buyerState, buyerZipCode, creditCardType, creditCardNumber, CVV2, expMonth, expYear, PaymentActionCodeType.Sale);
Monday, September 7, 2009
Download any file from server
using System;
using System.Data;
using System.Configuration;
using System.Web;
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.IO;
public class Utility:System.Web.UI.Page
{
string filepath = string.Empty;
public Utility()
{
//
// TODO: Add constructor logic here
//
}
public void DownloadFile(string FileName)
{
///get the file
///
try
{
if (HttpContext.Current.Request.RawUrl.Contains("Admin"))
{
filepath = Server.MapPath("~/UploadFiles/" + FileName);
}
else
{
filepath = Server.MapPath("UploadFiles/" + FileName);
}
string[] extension = FileName.Split('.');
///get the file stream to get the file length
System.IO.FileStream fs = new System.IO.FileStream(filepath, System.IO.FileMode.Open);
///set the content type
HttpContext.Current.Response.ContentType = "application/" + extension[1];
///set Content-Disposition
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName);
///get the file size
long filesize = fs.Length;
fs.Close();
///set the content length to the size of the file
///this will chop off the extra junk that may be sent by the ASP.NET runtime along with your file
HttpContext.Current.Response.AddHeader("Content-Length", filesize.ToString());
///write the file to the browser
HttpContext.Current.Response.WriteFile(filepath);
///flush it
HttpContext.Current.Response.Flush();
}
catch (Exception ex)
{
}
}
}
using System.Data;
using System.Configuration;
using System.Web;
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.IO;
public class Utility:System.Web.UI.Page
{
string filepath = string.Empty;
public Utility()
{
//
// TODO: Add constructor logic here
//
}
public void DownloadFile(string FileName)
{
///get the file
///
try
{
if (HttpContext.Current.Request.RawUrl.Contains("Admin"))
{
filepath = Server.MapPath("~/UploadFiles/" + FileName);
}
else
{
filepath = Server.MapPath("UploadFiles/" + FileName);
}
string[] extension = FileName.Split('.');
///get the file stream to get the file length
System.IO.FileStream fs = new System.IO.FileStream(filepath, System.IO.FileMode.Open);
///set the content type
HttpContext.Current.Response.ContentType = "application/" + extension[1];
///set Content-Disposition
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName);
///get the file size
long filesize = fs.Length;
fs.Close();
///set the content length to the size of the file
///this will chop off the extra junk that may be sent by the ASP.NET runtime along with your file
HttpContext.Current.Response.AddHeader("Content-Length", filesize.ToString());
///write the file to the browser
HttpContext.Current.Response.WriteFile(filepath);
///flush it
HttpContext.Current.Response.Flush();
}
catch (Exception ex)
{
}
}
}
JavaScript function to Reload Parent when child pop up closed
function ReloadParent()
{
window.opener.document.location.reload();
window.open('','_self','');window.close();
return true;
}
{
window.opener.document.location.reload();
window.open('','_self','');window.close();
return true;
}
Friday, September 4, 2009
Genrating an ExcelSheet using Dataset
protected void Button3_Click(object sender, EventArgs e)
{
DataTable dt = GetData();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
}
{
DataTable dt = GetData();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
}
ExportToExcel
private void ExportGridView()
{
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
{
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
Subscribe to:
Posts (Atom)