protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtUsrName.Text != "")
{
string UserName = txtUsrName.Text.Trim();
Session["UserName"] = UserName;
OpnConntionCls logUsrIn = new OpnConntionCls {SqlString = (string) (Session["UserName"])};
ds = logUsrIn.GetConnection;
MaxRows = ds.Tables[0].Rows.Count;
if (MaxRows == 0 )
{
Response.Write("<script>alert(' Wrong User-Name...')</script>");
txtUsrName.Text = string.Empty;
txtUsrName.Focus();
return;
}
Response.Redirect("Default.aspx?UserName="******"<script>alert(' Need to add something to User-Name...')</script>");
}
}
protected void btnMySch_Click(object sender, EventArgs e)
{
string cs = ConfigurationManager.ConnectionStrings["BarsslsConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
if (chkBrk.Checked)
{
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = txtSch.Text ;
objOpnCnt.myBrk = chkBrk.Checked.ToString();
ds = objOpnCnt.GetConnection2;
MaxRows = ds.Tables[0].Rows.Count;
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
else if (chkRep.Checked)
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = txtSch.Text;
objOpnCnt.myRep = chkRep.Checked.ToString();
ds = objOpnCnt.GetConnection2;
MaxRows = ds.Tables[0].Rows.Count;
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void DrpPayMethod()
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.getPayMethod;
MaxRows = ds.Tables[0].Rows.Count;
drpPayMethod.DataSource = ds;
drpPayMethod.DataValueField = "Pay_Method";
drpPayMethod.DataTextField = "Pay_Method";
drpPayMethod.DataBind();
}
protected void DrpPromoRes()
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.getPrmoRes;
MaxRows = ds.Tables[0].Rows.Count;
droPromoRes.DataSource = ds;
droPromoRes.DataValueField = "Promo_Reason";
droPromoRes.DataTextField = "Promo_Reason";
if (drpPromType.SelectedItem.ToString().Equals("Advertising"))
{
droPromoRes.SelectedIndex = 11;
}
droPromoRes.DataBind();
}
//***What this method is doing calling the OpnConntionCls for it to go to the next rows on the gridview***//
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//ScriptManager.RegisterStartupScript(this, GetType(), "Javascript", "BeforePostBack();", true);
string cs = ConfigurationManager.ConnectionStrings["BarsslsConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
if (chkBrk.Checked)
{
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.GetConnection;
MaxRows = ds.Tables[0].Rows.Count;
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
else if (chkRep.Checked)
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.GetConnection;
MaxRows = ds.Tables[0].Rows.Count;
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void DrpPromoType()
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.getPromoType;
MaxRows = ds.Tables[0].Rows.Count;
drpPromType.DataSource = ds;
drpPromType.DataValueField = "Promo_Type";
drpPromType.DataTextField = "Promo_Type";
drpPromType.DataBind();
}
protected void openDropData()
{
try
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.GetConnectionDrop;
MaxRows = ds.Tables[0].Rows.Count;
DropDownCheckBoxes1.DataSource = ds;
DropDownCheckBoxes1.DataValueField = "CM_ID";
DropDownCheckBoxes1.DataTextField = "Cust_Name";
DropDownCheckBoxes1.DataBind();
}
catch (Exception err)
{
throw new ApplicationException("Data error.", err);
}
}
protected void gtOpnRegion()
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.GetRegion;
MaxRows = ds.Tables[0].Rows.Count;
drpRegion.DataSource = ds;
drpRegion.DataValueField = "RW_Rep_ID";
drpRegion.DataTextField = "RW_Region";
drpRegion.DataBind();
}
protected void DrpUPC()
{
try
{
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.getUPCDrpdown;
MaxRows = ds.Tables[0].Rows.Count;
drpUPCBox.DataSource = ds;
drpUPCBox.DataValueField = "product_desc";
drpUPCBox.DataTextField = "product_desc";
drpUPCBox.DataBind();
}
catch (Exception err)
{
throw new ApplicationException("Data error.", err);
}
}
protected void openDatgrid()
{
//--This Method calls the Class OpnConntionCls to retrieve sql query and populate into a gridview--//
objOpnCnt = new OpnConntionCls();
objOpnCnt.SqlString = (string)(Session["UserName"]);
ds = objOpnCnt.GetConnection;
MaxRows = ds.Tables[0].Rows.Count;
if (objOpnCnt.StrCon == "2")
{
chkRep.Checked = true;
}
else
{
chkBrk.Checked = true;
}
GridView1.DataSource = ds;
GridView1.DataBind();
}