protected void btnShowAll_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = "";
if (btnShowAll.Text == "Show All")
{
objBrand = new clsBrands();
DataSet ds = objBrand.GetAllCompanyBrandData();
if (ds.Tables[0].Rows.Count != 0)
{
grdCompanyBrand.DataSource = ds.Tables[0];
grdCompanyBrand.DataBind();
}
else
{
grdCompanyBrand.EmptyDataText = "Record not found.";
grdCompanyBrand.DataBind();
}
btnShowAll.Text = "Close Grid";
divData.Visible = true;
}
else if (btnShowAll.Text == "Close Grid")
{
btnShowAll.Text = "Show All";
divData.Visible = false;
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = "";
objBrand = new clsBrands();
objBrand.strCompanyBrandName = Convert.ToString(txtName.Text);
objBrand.strCompanyBrandAbbr = Convert.ToString(txtAbbr.Text);
objBrand.strDesc = Convert.ToString(txtDesc.Text);
objBrand.intProductId = Convert.ToInt32(ddlProducts.SelectedValue);
objBrand.intStorageInstId = Convert.ToInt32(ddlStorageInst.SelectedValue);
objBrand.intCompanyId = Convert.ToInt32(ddlCompanyId.SelectedValue);
int i = objBrand.InsertCompanyBrandMasterData();
if (i == 1)
{
lblMsg.Text = "Record inserted";
ClearData();
}
else
{
lblMsg.Text = "Record not inserted";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
private void GetAllCompanyBrandIds()
{
try
{
clsBrands objBrand = new clsBrands();
DataSet dsCBData = objBrand.GetAllCompanyBrandData();
if (dsCBData.Tables[0].Rows.Count != 0)
{
ddlCBIds.DataSource = dsCBData.Tables[0];
ddlCBIds.DataTextField = "CompanyBrandName";
ddlCBIds.DataValueField = "CompanyBrandId";
ddlCBIds.DataBind();
ddlCBIds.Items.Insert(0, "--Select One--");
}
else
{
ddlProducts.Items.Insert(0, "--Select One--");
ddlProducts.Items.Insert(1, "No Data");
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
private void GetCompanyBrandId()
{
try
{
ddlCompanyBrandId.Items.Clear();
clsBrands objBrand = new clsBrands();
DataSet ds = objBrand.GetAllCompanyBrandData();
if (ds.Tables[0].Rows.Count != 0)
{
ddlCompanyBrandId.DataSource = ds.Tables[0];
ddlCompanyBrandId.DataTextField = "CompanyBrandName";
ddlCompanyBrandId.DataValueField = "CompanyBrandId";
ddlCompanyBrandId.DataBind();
}
ddlCompanyBrandId.Items.Insert(0, "--Select One--");
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void ddlCBIds_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lblMsg.Text = "";
if (ddlCBIds.SelectedIndex != 0)
{
int CBId = 0;
CBId = Convert.ToInt32(ddlCBIds.SelectedValue);
if (CBId != 0)
{
clsBrands objBrand = new clsBrands();
DataSet dsCBData = objBrand.GetCompanyBrandDataByCBId(CBId);
if (dsCBData.Tables[0].Rows.Count != 0)
{
txtName.Text = dsCBData.Tables[0].Rows[0][1].ToString();
txtDesc.Text = dsCBData.Tables[0].Rows[0][3].ToString();
txtAbbr.Text = dsCBData.Tables[0].Rows[0][2].ToString();
string ProdName = dsCBData.Tables[0].Rows[0][5].ToString();
string StorageInst = dsCBData.Tables[0].Rows[0][7].ToString();
for (int i = 0; i <= ddlProducts.Items.Count - 1; i++)
{
if (ddlProducts.Items[i].Text == ProdName)
{
ddlProducts.Items[i].Selected = true;
}
else
{
ddlProducts.Items[i].Selected = false;
}
}
for (int i = 0; i <= ddlStorageInst.Items.Count - 1; i++)
{
if (ddlStorageInst.Items[i].Text == StorageInst)
{
ddlStorageInst.Items[i].Selected = true;
}
else
{
ddlStorageInst.Items[i].Selected = false;
}
}
}
else
{
lblMsg.Text = "";
}
}
else
{
lblMsg.Text = "Company Brand not yet selected.";
}
}
else
{
ClearData();
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
