public List <clsareprp> Disp_Rec(Int32 ctycod)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dspare", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctycod", SqlDbType.Int).Value = ctycod;
SqlDataReader dr = cmd.ExecuteReader();
List <clsareprp> obj = new List <clsareprp>();
while (dr.Read())
{
clsareprp k = new clsareprp();
k.arecod = Convert.ToInt32(dr[0]);
k.arenam = dr[1].ToString();
k.arectycod = Convert.ToInt32(dr[2]);
k.arelatlng = dr[3].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public List <clsareprp> Find_Rec(Int32 arecod)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("fndare", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@arecod", arecod);
SqlDataReader dr = cmd.ExecuteReader();
List <clsareprp> obj = new List <clsareprp>();
if (dr.HasRows)
{
dr.Read();
clsareprp k = new clsareprp();
k.arecod = Convert.ToInt32(dr[0]);
k.arenam = dr[1].ToString();
k.arectycod = Convert.ToInt32(dr[2]);
k.arelatlng = dr[3].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public void Delete_Rec(clsareprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("delare", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@arecod", p.arecod);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
protected void btnsub_Click(object sender, EventArgs e)
{
nsgetwell.clsare obj = new nsgetwell.clsare();
nsgetwell.clsareprp objprp = new nsgetwell.clsareprp();
objprp.arectycod = Convert.ToInt32(drpcty.SelectedValue);
objprp.arenam = txtare.Text;
objprp.arelatlng = Hidden1.Value;
if (btnsub.Text == "Submit")
{
obj.Save_Rec(objprp);
}
else
{
objprp.arecod = Convert.ToInt32(ViewState["cod"]);
obj.Update_Rec(objprp);
btnsub.Text = "Submit";
}
txtare.Text = String.Empty;
lblcrd.Text = String.Empty;
GridView1.DataBind();
}