public List <clstecprp> fnd_rec(Int32 teccod)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("fndtec", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@teccod", SqlDbType.Int).Value = teccod;
SqlDataReader dr = cmd.ExecuteReader();
List <clstecprp> obj = new List <clstecprp>();
if (dr.HasRows)
{
dr.Read();
clstecprp x = new clstecprp();
x.teccod = Convert.ToInt32(dr[0]);
x.tecnam = dr[1].ToString();
obj.Add(x);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
nsskills.clstec obj = new nsskills.clstec();
nsskills.clstecprp objprp = new nsskills.clstecprp();
objprp.teccod = Convert.ToInt32(GridView1.DataKeys[e.RowIndex][0]);
obj.del_rec(objprp);
GridView1.DataBind();
e.Cancel = true;
}
public void del_rec(clstecprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("deltec", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@teccod", SqlDbType.Int).Value = p.teccod;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void save_rec(clstecprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("instec", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tecnam", SqlDbType.VarChar, 100).Value = p.tecnam;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
nsskills.clstec obj = new nsskills.clstec();
nsskills.clstecprp objprp = new nsskills.clstecprp();
objprp.tecnam = txttec.Text;
if (Button1.Text == "Submit")
{
obj.save_rec(objprp);
}
else
{
objprp.teccod = Convert.ToInt32(ViewState["cod"]);
obj.upd_rec(objprp);
Button1.Text = "Submit";
}
txttec.Text = String.Empty;
GridView1.DataBind();
}
public List <clstecprp> dsp_rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dsptec", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <clstecprp> obj = new List <clstecprp>();
while (dr.Read())
{
clstecprp x = new clstecprp();
x.teccod = Convert.ToInt32(dr[0]);
x.tecnam = dr[1].ToString();
obj.Add(x);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
