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));
}
