protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
nsgaanamania.tbsgsdwnlds obj = new nsgaanamania.tbsgsdwnlds();
nsgaanamania.clstbsgsdwnldsprp objprp = new nsgaanamania.clstbsgsdwnldsprp();
if (e.CommandName == "abck")
{
List <nsgaanamania.clstbsgsdwnldsprp> k = obj.find_rec_sgs(Convert.ToInt32(Request.QueryString["sgsid"]));
if (k.Count == 0)
{
objprp.sgsdwnldsno = 1;
objprp.sgsdwnldssgsid = Convert.ToInt32(Request.QueryString["sgsid"]);
obj.save_rec(objprp);
// insert query
}
else
{
//update query
objprp.sgsdwnldssgsid = Convert.ToInt32(Request.QueryString["sgsid"]);
objprp.sgsdwnldsno = k[0].sgsdwnldsno + 1;
obj.upd_rec(objprp);
}
Response.Redirect(e.CommandArgument.ToString());
}
}
public List <clstbsgsdwnldsprp> disp_rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("disp_tbsgsdwnlds", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <clstbsgsdwnldsprp> obj = new List <clstbsgsdwnldsprp>();
while (dr.Read())
{
clstbsgsdwnldsprp k = new clstbsgsdwnldsprp();
k.sgsdwnldsid = Convert.ToInt32(dr[0]);
k.sgsdwnldssgsid = Convert.ToInt32(dr[1]);
k.sgsdwnldsno = Convert.ToInt32(dr[2]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public List <clstbsgsdwnldsprp> find_rec_sgs(Int32 sgsdwnldssgsid)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("find_tbsgsdwnlds_sgsdwnldssgsid", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sgsdwnldssgsid", SqlDbType.Int).Value = sgsdwnldssgsid;
SqlDataReader dr = cmd.ExecuteReader();
List <clstbsgsdwnldsprp> obj = new List <clstbsgsdwnldsprp>();
if (dr.HasRows)
{
dr.Read();
clstbsgsdwnldsprp k = new clstbsgsdwnldsprp();
k.sgsdwnldsid = Convert.ToInt32(dr[0]);
k.sgsdwnldssgsid = Convert.ToInt32(dr[1]);
k.sgsdwnldsno = Convert.ToInt32(dr[2]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public void del_rec(clstbsgsdwnldsprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("del_tbsgsdwnlds", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sgsdwnldsid", SqlDbType.Int).Value = p.sgsdwnldsid;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}