using
System.Collections
.Generic
;using
System.Web
.UI
.WebControls
;
namespace onetierarchitecture1
{
public partial
class onetier
: System.Web
.UI
.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cs"].ToString());
internal void BINDDEPT()
{
SqlCommand cmd = new SqlCommand("select * from dept", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "dept new");
dddeptname.DataSource = ds.Tables["deptnew"];
dddeptname.DataTextField = "deptid ";
dddeptname.DataTextField = "deptname";
dddeptname.DataBind();
dddeptname.Items.Insert(0, "_select_");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BINDDEPT();
}
}
internal int autoempid()
{
SqlCommand cmd = new SqlCommand("select IsNull(max(id),0) from employee", conn);
conn.Open();
int empid = (int)cmd.ExecuteScalar();
conn.Close();
empid++;
return empid;
}
protected void btninsert_Click(object sender, EventArgs e)
{
int empid = autoempid();
SqlCommand cmd = new SqlCommand("insert into employee values(@empid,@ename, @esalary,@deptid)", conn);
cmd.Parameters.AddWithValue("@empid", empid);
cmd.Parameters.AddWithValue("@ename", txtename.Text);
cmd.Parameters.AddWithValue("@deptid", dddeptname.SelectedValue);
cmd.Parameters.AddWithValue("@esalary", calgrosssal());
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
ClearControls();
displaymsg(i);
}
internal void ClearControls()
{
txtename.Text = " ";
txtesal.Text = " ";
dddeptname.SelectedIndex = 0;
txtename.Focus();
}
internal void displaymsg(int i)
{
lblmsg.Visible = true;
if (i != 0)
{
lblmsg.Text = "Record inserted";
}
else
{
lblmsg.Text = "record not inserted";
}
}
internal double calgrosssal()
{
double bsal = double.Parse(txtesal.Text);
double hra = bsal * 20 / 100;
double da = bsal * 15 / 100;
double ta = bsal * 10 / 100;
double grosssal = bsal + hra + da + ta;
return grosssal;
}
}
}
dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLkNvbmZpZ3VyYXRpb247CnVzaW5nIFN5c3RlbS5EYXRhLlNxbENsaWVudDsKdXNpbmcgU3lzdGVtLkxpbnE7CnVzaW5nIFN5c3RlbS5XZWI7CnVzaW5nIFN5c3RlbS5XZWIuVUk7CnVzaW5nIFN5c3RlbS5XZWIuVUkuV2ViQ29udHJvbHM7CnVzaW5nIFN5c3RlbS5EYXRhOwp1c2luZyBTeXN0ZW0uRHJhd2luZzsKCgpuYW1lc3BhY2Ugb25ldGllcmFyY2hpdGVjdHVyZTEKewogICAgcHVibGljIHBhcnRpYWwgY2xhc3Mgb25ldGllciA6IFN5c3RlbS5XZWIuVUkuUGFnZQogICAgewogICAgICAgIFNxbENvbm5lY3Rpb24gY29ubiA9IG5ldyBTcWxDb25uZWN0aW9uKENvbmZpZ3VyYXRpb25NYW5hZ2VyLkNvbm5lY3Rpb25TdHJpbmdzWyJjcyJdLlRvU3RyaW5nKCkpOwogICAgICAgIGludGVybmFsIHZvaWQgQklORERFUFQoKQogICAgICAgIHsKICAgICAgICAgICAgU3FsQ29tbWFuZCBjbWQgPSBuZXcgU3FsQ29tbWFuZCgic2VsZWN0ICogZnJvbSBkZXB0IiwgY29ubik7CiAgICAgICAgICAgIFNxbERhdGFBZGFwdGVyIGRhID0gbmV3IFNxbERhdGFBZGFwdGVyKGNtZCk7CiAgICAgICAgICAgIERhdGFTZXQgZHMgPSBuZXcgRGF0YVNldCgpOwogICAgICAgICAgICBkYS5GaWxsKGRzLCAiZGVwdCBuZXciKTsKICAgICAgICAgICAgZGRkZXB0bmFtZS5EYXRhU291cmNlID0gZHMuVGFibGVzWyJkZXB0bmV3Il07CiAgICAgICAgICAgIGRkZGVwdG5hbWUuRGF0YVRleHRGaWVsZCA9ICJkZXB0aWQgIjsKICAgICAgICAgICAgZGRkZXB0bmFtZS5EYXRhVGV4dEZpZWxkID0gImRlcHRuYW1lIjsKICAgICAgICAgICAgZGRkZXB0bmFtZS5EYXRhQmluZCgpOwogICAgICAgICAgICBkZGRlcHRuYW1lLkl0ZW1zLkluc2VydCgwLCAiX3NlbGVjdF8iKTsKCiAgICAgICAgfQoKICAgICAgICBwcm90ZWN0ZWQgdm9pZCBQYWdlX0xvYWQob2JqZWN0IHNlbmRlciwgRXZlbnRBcmdzIGUpCiAgICAgICAgewogICAgICAgICAgICBpZiAoIUlzUG9zdEJhY2spCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIEJJTkRERVBUKCk7CiAgICAgICAgICAgIH0KICAgICAgICB9CiAgICAgICAgaW50ZXJuYWwgaW50IGF1dG9lbXBpZCgpCiAgICAgICAgewogICAgICAgICAgICBTcWxDb21tYW5kIGNtZCA9IG5ldyBTcWxDb21tYW5kKCJzZWxlY3QgSXNOdWxsKG1heChpZCksMCkgZnJvbSAgZW1wbG95ZWUiLCBjb25uKTsKICAgICAgICAgICAgY29ubi5PcGVuKCk7CiAgICAgICAgICAgIGludCBlbXBpZCA9IChpbnQpY21kLkV4ZWN1dGVTY2FsYXIoKTsKICAgICAgICAgICAgY29ubi5DbG9zZSgpOwogICAgICAgICAgICBlbXBpZCsrOwogICAgICAgICAgICByZXR1cm4gZW1waWQ7CgoKICAgICAgICB9CgogICAgICAgIHByb3RlY3RlZCB2b2lkIGJ0bmluc2VydF9DbGljayhvYmplY3Qgc2VuZGVyLCBFdmVudEFyZ3MgZSkKICAgICAgICB7CiAgICAgICAgICAgIGludCBlbXBpZCA9IGF1dG9lbXBpZCgpOwogICAgICAgICAgICBTcWxDb21tYW5kIGNtZCA9IG5ldyBTcWxDb21tYW5kKCJpbnNlcnQgaW50byBlbXBsb3llZSB2YWx1ZXMoQGVtcGlkLEBlbmFtZSwgQGVzYWxhcnksQGRlcHRpZCkiLCBjb25uKTsKICAgICAgICAgICAgY21kLlBhcmFtZXRlcnMuQWRkV2l0aFZhbHVlKCJAZW1waWQiLCBlbXBpZCk7CiAgICAgICAgICAgIGNtZC5QYXJhbWV0ZXJzLkFkZFdpdGhWYWx1ZSgiQGVuYW1lIiwgdHh0ZW5hbWUuVGV4dCk7CiAgICAgICAgICAgIGNtZC5QYXJhbWV0ZXJzLkFkZFdpdGhWYWx1ZSgiQGRlcHRpZCIsIGRkZGVwdG5hbWUuU2VsZWN0ZWRWYWx1ZSk7CiAgICAgICAgICAgIGNtZC5QYXJhbWV0ZXJzLkFkZFdpdGhWYWx1ZSgiQGVzYWxhcnkiLCBjYWxncm9zc3NhbCgpKTsKCiAgICAgICAgICAgIGNvbm4uT3BlbigpOwogICAgICAgICAgICBpbnQgaSA9IGNtZC5FeGVjdXRlTm9uUXVlcnkoKTsKICAgICAgICAgICAgY29ubi5DbG9zZSgpOwoKICAgICAgICAgICAgQ2xlYXJDb250cm9scygpOwogICAgICAgICAgICBkaXNwbGF5bXNnKGkpOwogICAgICAgIH0KICAgICAgICBpbnRlcm5hbCB2b2lkIENsZWFyQ29udHJvbHMoKQogICAgICAgIHsKICAgICAgICAgICAgdHh0ZW5hbWUuVGV4dCA9ICIgIjsKICAgICAgICAgICAgdHh0ZXNhbC5UZXh0ID0gIiAiOwogICAgICAgICAgICBkZGRlcHRuYW1lLlNlbGVjdGVkSW5kZXggPSAwOwogICAgICAgICAgICB0eHRlbmFtZS5Gb2N1cygpOwoKICAgICAgICB9CiAgICAgICAgaW50ZXJuYWwgdm9pZCBkaXNwbGF5bXNnKGludCBpKQogICAgICAgIHsKCiAgICAgICAgICAgIGxibG1zZy5WaXNpYmxlID0gdHJ1ZTsKCiAgICAgICAgICAgIGlmIChpICE9IDApCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGxibG1zZy5UZXh0ID0gIlJlY29yZCBpbnNlcnRlZCI7CiAgICAgICAgICAgIH0KICAgICAgICAgICAgZWxzZQogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBsYmxtc2cuVGV4dCA9ICJyZWNvcmQgbm90IGluc2VydGVkIjsKCiAgICAgICAgICAgIH0KICAgICAgICAgICAgCgogICAgICAgIH0KICAgICAgICBpbnRlcm5hbCBkb3VibGUgY2FsZ3Jvc3NzYWwoKQogICAgICAgIHsKICAgICAgICAgICAgZG91YmxlIGJzYWwgPSBkb3VibGUuUGFyc2UodHh0ZXNhbC5UZXh0KTsKICAgICAgICAgICAgZG91YmxlIGhyYSA9IGJzYWwgKiAyMCAvIDEwMDsKICAgICAgICAgICAgZG91YmxlIGRhID0gYnNhbCAqIDE1IC8gMTAwOwogICAgICAgICAgICBkb3VibGUgdGEgPSBic2FsICogMTAgLyAxMDA7CiAgICAgICAgICAgIGRvdWJsZSBncm9zc3NhbCA9IGJzYWwgKyBocmEgKyBkYSArIHRhOwogICAgICAgICAgICByZXR1cm4gZ3Jvc3NzYWw7CgogICAgICAgIH0KICAgIH0KfQ==
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Drawing;
namespace onetierarchitecture1
{
public partial class onetier : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cs"].ToString());
internal void BINDDEPT()
{
SqlCommand cmd = new SqlCommand("select * from dept", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "dept new");
dddeptname.DataSource = ds.Tables["deptnew"];
dddeptname.DataTextField = "deptid ";
dddeptname.DataTextField = "deptname";
dddeptname.DataBind();
dddeptname.Items.Insert(0, "_select_");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BINDDEPT();
}
}
internal int autoempid()
{
SqlCommand cmd = new SqlCommand("select IsNull(max(id),0) from employee", conn);
conn.Open();
int empid = (int)cmd.ExecuteScalar();
conn.Close();
empid++;
return empid;
}
protected void btninsert_Click(object sender, EventArgs e)
{
int empid = autoempid();
SqlCommand cmd = new SqlCommand("insert into employee values(@empid,@ename, @esalary,@deptid)", conn);
cmd.Parameters.AddWithValue("@empid", empid);
cmd.Parameters.AddWithValue("@ename", txtename.Text);
cmd.Parameters.AddWithValue("@deptid", dddeptname.SelectedValue);
cmd.Parameters.AddWithValue("@esalary", calgrosssal());
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
ClearControls();
displaymsg(i);
}
internal void ClearControls()
{
txtename.Text = " ";
txtesal.Text = " ";
dddeptname.SelectedIndex = 0;
txtename.Focus();
}
internal void displaymsg(int i)
{
lblmsg.Visible = true;
if (i != 0)
{
lblmsg.Text = "Record inserted";
}
else
{
lblmsg.Text = "record not inserted";
}
}
internal double calgrosssal()
{
double bsal = double.Parse(txtesal.Text);
double hra = bsal * 20 / 100;
double da = bsal * 15 / 100;
double ta = bsal * 10 / 100;
double grosssal = bsal + hra + da + ta;
return grosssal;
}
}
}