private void bind() { Businesslayer bus = new Businesslayer(); prop.strDate = txtstrdate.Text; prop.endDate = txtenddate.Text; int count = bus.bll_salecount(prop); if (count > 0) { lblresult.Visible = false; GridView1.Visible = true; Label2.Visible = true; Label3.Visible = true; lblsale.Visible = true; GridView1.DataSource = GridDataSource(); GridView1.DataBind(); // btnsbt.Attributes["onclick"] = "some problem"; } else { GridView1.Visible = false; lblresult.Visible = true; Label2.Visible = false; Label3.Visible = false; lblsale.Visible = false; //Button1.Attributes["onclick"] = "AlertHello()"; //btnsbt.Attributes["onclick"] = "show_alert()"; lblresult.Text = "Sorry no Records found between these dates"; } }
protected void _rowdeleting(object sender, GridViewDeleteEventArgs e) { //String Username = GridView1.DataKeys[e.RowIndex].Value.ToString(); GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; Label user = (Label)row.FindControl("lblusername"); string Username = user.Text; // instantiate BAL Businesslayer pBAL = new Businesslayer(); try { pBAL.Delete(Username); lblMessage.Text = "Record Deleted Successfully."; } catch (Exception ee) { lblMessage.Text = ee.Message.ToString(); } finally { pBAL = null; } // GridView1.EditIndex = -1; // Refresh the list BindGrid(); }
protected void Page_Load(object sender, EventArgs e) { ecprops prop = new ecprops(); prop.customerid = HttpContext.Current.User.Identity.Name; Businesslayer bus = new Businesslayer(); int count = bus.bll_viewcart(prop); if (HttpContext.Current.User.Identity.IsAuthenticated) { lbluser.Text = "Welcome  " + HttpContext.Current.User.Identity.Name; lnksignin.Visible = false; lnksignout.Visible = true; lnkorderhistory.Visible = true; lnkviewcart.Visible = true; //top menu Lnktopsignin.Visible = false; lnktopsignout.Visible = true; lnktoporders.Visible = true; lnktopviewcart.Visible = true; lnktopregister.Visible = false; lblshow.Text = " " + count + " items in cart"; } else { lbluser.Text = "Welcome Guest"; lnksignin.Visible = true; lnksignout.Visible = false; lnkviewcart.Visible = false; lnkorderhistory.Visible = false; //top menu Lnktopsignin.Visible = true; lnktopsignout.Visible = false; lnktopviewcart.Visible = false; lnktoporders.Visible = false; lnktopregister.Visible = true; } if (HttpContext.Current.User.IsInRole("Admin")) { lnkadmin.Visible = true; lnkadminmenu.Visible = true; } else { lnkadmin.Visible = false; lnkadminmenu.Visible = false; } }
public int db_deletefnamelname(Businesslayer blayer) { SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandText = ""; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.AddWithValue("@id", blayer.sid); con.Open(); int p = cmd.ExecuteNonQuery(); con.Close(); return(p); }
public int db_insert(Businesslayer bs) { SqlConnection con = new SqlConnection(str); SqlCommand cm = new SqlCommand(); cm.CommandText = ""; cm.CommandType = CommandType.StoredProcedure; cm.Connection = con; cm.Parameters.AddWithValue("@fn", bs.fname); cm.Parameters.AddWithValue("@ln", bs.lname); con.Open(); int p = cm.ExecuteNonQuery(); con.Close(); return(p); }
private DataTable GridDataSource() { Businesslayer p = new Businesslayer(); DataTable dTable = new DataTable(); try { dTable = p.bll_catnav(); } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dTable); }
private SqlDataReader loadcomb() { Businesslayer p = new Businesslayer(); SqlDataReader dr = null; try { dr = p.bllloadreader(); } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dr); }
private DataTable gridorder() { Businesslayer p = new Businesslayer(); DataTable dTable = new DataTable(); props.orderidgrid = Request.QueryString["ID"]; try { dTable = p.bllgridorder(props); } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dTable); }
private DataTable GridDataSource() { Businesslayer p = new Businesslayer(); DataTable dTable = new DataTable(); pro.proid = Request.QueryString["ID"]; try { dTable = p.bllstockhistory(pro); } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dTable); }
public int db_insertform(Businesslayer bslayer) { SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert_fullregform"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.AddWithValue("@fname", bslayer.fname); cmd.Parameters.AddWithValue("@mname", bslayer.mname); cmd.Parameters.AddWithValue("@lname", bslayer.lname); cmd.Parameters.AddWithValue("@gender", bslayer.gender); cmd.Parameters.AddWithValue("@hobby", bslayer.hobby); cmd.Parameters.AddWithValue("@state", bslayer.state); con.Open(); int p = cmd.ExecuteNonQuery(); con.Close(); return(p); }
private DataTable GridDataSource() { prop.strDate = txtstrdate.Text; prop.endDate = txtenddate.Text; Businesslayer p = new Businesslayer(); DataTable dTable = new DataTable(); try { dTable = p.bllLoadProfit(prop); } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dTable); }
private DataSet GridDataSource() { Businesslayer p = new Businesslayer(); //DataTable dTable = new DataTable(); DataSet dTable = new DataSet(); try { Global.currentpage = 0; dTable = p.bllLoadDt(); ViewState["ds"] = dTable; } catch (Exception ee) { //lblMessage.Text = ee.Message.ToString(); } finally { p = null; } return(dTable); }
public int blayer_deletefnamelname(Businesslayer blayer) { return(daccess.db_deletefnamelname(blayer)); }
public int bs_insertform(Businesslayer bslayer) { return(daccess.db_insertform(bslayer)); }
public Exporteren(Businesslayer.Playbackband pbb) { InitializeComponent(); currentPBB = pbb; }
public int bs_insert(Businesslayer bs) { return(db.db_insert(bs)); }