protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] == null) { Response.Redirect("ViewPackage.aspx"); } if (!IsPostBack) { DataView dv = SqlDataSourcePackage.Select(DataSourceSelectArguments.Empty) as DataView; if (dv != null) { for (int i = 0; i < dv.Table.Rows.Count; i++) { if (Request.QueryString["id"] == dv.Table.Rows[i]["Package_Id"].ToString()) { pkgname.Text = dv.Table.Rows[i]["Package_Name"].ToString(); nohits.Text = dv.Table.Rows[i]["Number_of_Hits"].ToString(); price.Text = dv.Table.Rows[i]["Price"].ToString(); break; } } } } }
protected void Button1_Click(object sender, EventArgs e) { DataView dv = SqlDataSourcePackage.Select(DataSourceSelectArguments.Empty) as DataView; if (dv != null) { bool exists = false; for (int i = 0; i < dv.Table.Rows.Count; i++) { if (pkgname.Text.ToLower() == dv.Table.Rows[i]["Package_Name"].ToString().ToLower()) { exists = true; break; } } if (exists) { msg.Text = "package name already exits"; msg.CssClass = "text-danger"; } else { msg.Text = ""; SqlDataSourcePackage.Insert(); msg.Text = "Package created successfully!"; msg.CssClass = "text-success"; } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "$('#myModal').modal('hide');$('body').removeClass('modal-open');$('.modal-backdrop').remove();$('#myModal').modal('show');", true); } //SqlDataSourcePackage.Insert(); //msg.Text = "done"; //msg.CssClass = "text-success"; }
protected void Button2_Click(object sender, EventArgs e) { //DataView dv = SqlDataSourcePackage.Select(DataSourceSelectArguments.Empty) as DataView; //if (dv != null) //{ // for (int i = 0; i < dv.Table.Rows.Count; i++) // if (pkgname.Text == dv.Table.Rows[i]["Package_Name"].ToString()) // { SqlDataSourcePackage.Delete(); //msg.Text = "done"; Response.Redirect("ViewPackage.aspx"); //} //else //{ // msg.Text = "enter a valid package name"; // msg.CssClass = "text-danger"; //} ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "$('#myModal').modal('hide');$('body').removeClass('modal-open');$('.modal-backdrop').remove();$('#myModal').modal('show');", true); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSourcePackage.Update(); Response.Redirect("ViewPackage.aspx"); }