Thursday, September 15, 2011

ASP.NET



AllAccount.aspx









AllAccount.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AllAccount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void ListGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName=="delAcc"){
var ID = Convert.ToInt32(e.CommandArgument);

string query1 = "DELETE FROM AccData WHERE Id='"+ID+"'";
string query2="DELETE FROM Accounts WHERE Acc_Number='"+ID+"'";

Connect con = new Connect();
con.deleteAcc(query1, query2);
Response.Redirect("~/AllAccount.aspx",true);
}
}
}



Connect.cs



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
///
/// Summary description for Connect
///

public class Connect
{
SqlConnection sqlcon=null;
SqlDataAdapter Adptr = null;
public Connect()
{

}

public void connection()
{
string constr = "Data Source=SARANGA-PC;Initial Catalog=Accounts;User ID=sa;Password=saranga";
sqlcon = new SqlConnection(constr);
sqlcon.Open();
}

public void Insert(string sp,SqlParameter[] para)
{
connection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sp;
cmd.Connection = sqlcon;
for (int i=0; i {
cmd.Parameters.Add(para[i]);
}
cmd.ExecuteNonQuery();
sqlcon.Close();

}

public void update(string sp, SqlParameter[] para)
{
connection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sp;
cmd.Connection = sqlcon;
for (int i = 0; i < para.Length; i++)
{
cmd.Parameters.Add(para[i]);
}
cmd.ExecuteNonQuery();
sqlcon.Close();
}

public DataTable display(string query )
{
connection();

Adptr = new SqlDataAdapter(query, sqlcon);
DataSet ds = new DataSet();
DataTable dt = new DataTable();

Adptr.Fill(dt);
sqlcon.Close();

return dt;
}

public void deleteAcc(string q1,string q2)
{
connection();
SqlCommand cmd1 = new SqlCommand();
cmd1.CommandText = q1;
cmd1.Connection = sqlcon;
cmd1.ExecuteNonQuery();

SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = q1;
cmd2.Connection = sqlcon;
cmd2.ExecuteNonQuery();

sqlcon.Close();
}
}



NewAccount.aspx















NewAccount.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class NewAccount : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnApply_Click(object sender, EventArgs e)
{
int num=int.Parse(txtNum.Text);
string name=txtName.Text;
decimal depo= Convert.ToDecimal(txtDep.Text);
decimal withd = Convert.ToDecimal(txtwithdrowal.Text);
decimal Balance = Convert.ToDecimal(txtbalance.Text);
string type = DropType.SelectedValue ;

NewAcnt NewAc = new NewAcnt();
NewAc.CreateNew(num,name,depo,withd,Balance,type);
lblApplyStatus.Text = "Account Successfully Created";
}
}




NewAcnt.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
///
/// Summary description for NewAccount
///

public class NewAcnt
{


public NewAcnt()
{

}

public void CreateNew(int num, string name, decimal depo,decimal withd,decimal balance, string type)
{

SqlParameter[] para = {new SqlParameter("@num",SqlDbType.Int),
new SqlParameter("@name",SqlDbType.VarChar,50),
new SqlParameter("@depo",SqlDbType.Decimal),
new SqlParameter("@withd",SqlDbType.Decimal),
new SqlParameter("@balance",SqlDbType.Decimal),
new SqlParameter("@type",SqlDbType.VarChar,50)};

para[0].Value = num;
para[1].Value = name;
para[2].Value = depo;
para[3].Value = withd;
para[4].Value = balance;
para[5].Value = type;

string sp= "SP_NewAcc";

Connect cont = new Connect();
cont.Insert(sp,para);
}
}




TransAccount.aspx













TransAccount.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class TransAccount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//$ConnectionStrings:AccountsConnectionString;
if(!IsPostBack){
dropNumber.ConnectionString = "Data Source=SARANGA-PC;Initial Catalog=Accounts;User ID=sa;Password=saranga";
dropNumber.SelectCommand = "SELECT [Acc_Number] FROM [Accounts]";
}
bind();
}
protected void btnbalance_Click(object sender, EventArgs e)
{
decimal withd = Convert.ToDecimal(txtupwithd.Text);
decimal depo = Convert.ToDecimal(txtupdepo.Text);
decimal baln = Convert.ToDecimal(txtupbalance.Text);

decimal finalbalance=baln+(depo-withd);
txtupbalance.Text = finalbalance.ToString();

}
protected void btnupdate_Click(object sender, EventArgs e)
{
int num = int.Parse(DropDownNumber.SelectedValue);
string name = txtupname.Text;
string type = txtuptype.Text;
decimal withd = Convert.ToDecimal(txtupwithd.Text);
decimal depo = Convert.ToDecimal(txtupdepo.Text);
decimal baln = Convert.ToDecimal(txtupbalance.Text);

Upadate up = new Upadate();
up.updateAcc(num, name, depo, withd, baln, type);
lblupstatus.Text = "Account Successfully Updated";

}
protected void btnsubmit_Click(object sender, EventArgs e)
{
Upadate up = new Upadate();
int ID =int.Parse(DropDownNumber.SelectedValue);
DataTable dt= up.drop(ID);

txtupname.Text = dt.Rows[0].ItemArray.GetValue(0).ToString();
txtuptype.Text = dt.Rows[0].ItemArray.GetValue(4).ToString();
txtupdepo.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
txtupwithd.Text=dt.Rows[0].ItemArray.GetValue(2).ToString();;
txtupbalance.Text = dt.Rows[0].ItemArray.GetValue(3).ToString(); ;
}

public void bind()
{

}
}





Upadate.cs




using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

///
/// Summary description for Upadate
///

public class Upadate
{
public Upadate()
{
//
// TODO: Add constructor logic here
//
}

public DataTable drop(int ID)
{

string query = "SELECT dbo.Accounts.Acc_Name, dbo.Accounts.Acc_Deposit, dbo.AccData.Withdrowal, dbo.AccData.Balance,dbo.Accounts.Acc_Type FROM dbo.AccData INNER JOIN dbo.Accounts ON dbo.AccData.Id = dbo.Accounts.Acc_Number WHERE AccData.Id='"+ID+"'";
Connect cont = new Connect();

DataTable dt = new DataTable();
dt = cont.display(query);
return dt;
}

public void updateAcc(int num, string name, decimal depo, decimal withd, decimal balance, string type)
{
SqlParameter[] para = {new SqlParameter("@num",SqlDbType.Int),
new SqlParameter("@name",SqlDbType.VarChar,50),
new SqlParameter("@depo",SqlDbType.Decimal),
new SqlParameter("@withd",SqlDbType.Decimal),
new SqlParameter("@balance",SqlDbType.Decimal),
new SqlParameter("@type",SqlDbType.VarChar,50)};

para[0].Value = num;
para[1].Value = name;
para[2].Value = depo;
para[3].Value = withd;
para[4].Value = balance;
para[5].Value = type;

string sp = "SP_Update";

Connect cont = new Connect();
cont.update(sp, para);
}
}

5 comments:

  1. public string GetClientList()
    {
    DataService.DataServiceAgent db = new DataService.DataServiceAgent();
    List lst = new List();
    lst = db.ReadAllClients();
    var jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
    jsonSerialiser.MaxJsonLength = int.MaxValue;
    return jsonSerialiser.Serialize(lst);
    }

    ReplyDelete
  2. public class WebServiceController : Controller
    {
    //
    // GET: /WebService/

    public ActionResult Index()
    {
    List client = new List();
    ServiceReference1.ClientServiceClient ddd= new ServiceReference1.ClientServiceClient();
    string outreslt= ddd.GetClientList();
    var jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
    var resultout = client;
    resultout = jsonSerialiser.Deserialize>(outreslt);
    return View(resultout);
    }

    }

    ReplyDelete
  3. public class ClientDataTranslator
    {
    public static Client ConvertToModel(SqlDataReader dataReader)
    {
    int resultInt = 0;
    Client client = new Client();
    for (int i=0; i < dataReader.FieldCount; i++)
    {
    switch(dataReader.GetName(i)){
    case "ID":
    {
    int.TryParse(dataReader["ID"].ToString(),out resultInt);
    client.ID = resultInt;
    }
    break;
    case "Code":
    {
    if(dataReader["Code"]!=DBNull.Value)
    client.Code = dataReader["Code"].ToString();
    }
    break;
    }
    }
    }
    }

    ReplyDelete


  4. @Html.PagedListPager(Model, page => Url.Action("Index",new { page}), PagedListRenderOptions.MinimalWithItemCountText)

    ReplyDelete
  5. public ActionResult Index(string sortOrder, string currentFilter, string searchString,int page = 1)
    {
    List lst =new List();
    var Model = lst.ToPagedList(page,10);
    ViewBag.NameSortParm = sortOrder == "ClientName" ? "ClientName desc" : "ClientName";
    ViewBag.EmailSortParm = sortOrder == "Email" ? "Email desc" : "Email";
    if (Request.HttpMethod == "GET")
    {
    searchString = currentFilter;
    }
    ViewBag.CurrentFilter = searchString;

    switch (sortOrder)
    {
    case "ClientName":
    {
    Model = cd.ReadAllClients().OrderBy(x => x.ClientName).ToPagedList(page, 10);
    }
    break;
    case "ClientName desc":
    {
    Model = cd.ReadAllClients().OrderByDescending(x => x.ClientName).ToPagedList(page, 10);
    }
    break;
    case "Email":
    {
    Model = cd.ReadAllClients().OrderBy(x => x.Email).ToPagedList(page, 10);
    }
    break;
    case "Email desc":
    {
    Model = cd.ReadAllClients().OrderByDescending(x => x.Email).ToPagedList(page, 10);
    }
    break;
    default:
    Model = cd.ReadAllClients().OrderBy(x => x.ClientName).ToPagedList(page, 10);
    break;
    }

    return View(Model);
    }

    ReplyDelete