protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(IsPostBack))
{
if (Session["XMLFile"] != null)
{
hdnXMLFileName.Value = Session["XMLFile"].ToString().Trim();
}
BrandsTransaction b = new BrandsTransaction();
lstBrandsCarried.DataSource = b.GetAllBrands(connstring);
lstBrandsCarried.DataValueField = "BrandId";
lstBrandsCarried.DataTextField = "BrandName";
lstBrandsCarried.DataBind();
ItemsCarriedTransaction i = new ItemsCarriedTransaction();
lstItemsCarried.DataSource = i.GetAllItemsCarried(connstring);
lstItemsCarried.DataValueField = "ItemNo";
lstItemsCarried.DataTextField = "ItemsCarried";
lstItemsCarried.DataBind();
ServicesTransaction s = new ServicesTransaction();
lstServicesOffered.DataSource = s.GetAllServices(connstring);
lstServicesOffered.DataValueField = "ServiceId";
lstServicesOffered.DataTextField = "ServiceName";
lstServicesOffered.DataBind();
LocationsTransaction l = new LocationsTransaction();
lstLocation.DataSource = l.GetAllLocations(connstring);
lstLocation.DataValueField = "LocationId";
lstLocation.DataTextField = "LocationName";
lstLocation.DataBind();
PCABClassTransaction p = new PCABClassTransaction();
ddlPCABClass.DataSource = p.GetAllPCABClass(connstring);
ddlPCABClass.DataValueField = "PCABClassId";
ddlPCABClass.DataTextField = "PCABClassName";
ddlPCABClass.DataBind();
ListItem li = new ListItem();
li.Value = "";
li.Text = "-- PCAB Class --";
ddlPCABClass.Items.Insert(0, li);
ISOStandard iso = new ISOStandard();
chkISOStandard_white.DataSource = iso.GetISOStandard(connstring);
chkISOStandard_white.DataTextField = "ISOStandardName";
chkISOStandard_white.DataValueField = "ISOStandardId";
chkISOStandard_white.DataBind();
}
}
private void FillDropDownLists()
{
//CategoryTransaction c = new CategoryTransaction();
//ddlCategory.DataSource = c.GetAllCategories();
//ddlCategory.DataTextField = "CategoryName";
//ddlCategory.DataValueField = "CategoryId";
//ddlCategory.DataBind();
ListItem l = new ListItem();
//l.Value = "";
//l.Text = "---Category---";
//ddlCategory.Items.Insert(0, l);
//SubCategory s = new SubCategory();
//ddlSubCategory.DataSource = s.GetAllSubCategories(connstring);
//ddlSubCategory.DataTextField = "SubCategoryName";
//ddlSubCategory.DataValueField = "SubCategoryId";
//ddlSubCategory.DataBind();
//l = new ListItem();
//l.Value = "";
//l.Text = "---Sub-Category---";
//ddlSubCategory.Items.Insert(0, l);
SupplierType sty = new SupplierType();
ddlSupplierType.DataSource = sty.GetAllSupplierTypes(connstring);
ddlSupplierType.DataTextField = "SupplierTypeDesc";
ddlSupplierType.DataValueField = "SupplierTypeId";
ddlSupplierType.DataBind();
l = new ListItem();
l.Value = "";
l.Text = "---Supplier Type---";
ddlSupplierType.Items.Insert(0, l);
PCABClassTransaction p = new PCABClassTransaction();
ddlPCABClass.DataSource = p.GetAllPCABClass(connstring);
ddlPCABClass.DataValueField = "PCABClassId";
ddlPCABClass.DataTextField = "PCABClassName";
ddlPCABClass.DataBind();
l = new ListItem();
l.Value = "";
l.Text = "-- PCAB Class --";
ddlPCABClass.Items.Insert(0, l);
ISOStandard iso = new ISOStandard();
chkISOStandard_white.DataSource = iso.GetISOStandard(connstring);
chkISOStandard_white.DataTextField = "ISOStandardName";
chkISOStandard_white.DataValueField = "ISOStandardId";
chkISOStandard_white.DataBind();
}
private void PutDataToComboBoxes()
{
BrandsTransaction brands = new BrandsTransaction();
ItemsCarriedTransaction items = new ItemsCarriedTransaction();
LocationsTransaction loc = new LocationsTransaction();
ServicesTransaction serv = new ServicesTransaction();
CategoryTransaction cat = new CategoryTransaction();
SubCategory sub = new SubCategory();
PCABClassTransaction pcab = new PCABClassTransaction();
ISOStandard iso = new ISOStandard();
ddlBrands.DataSource = brands.GetAllBrands(connstring);
ddlBrands.DataTextField = "BrandName";
ddlBrands.DataValueField = "BrandId";
ddlBrands.DataBind();
ListItem lst = new ListItem();
lst.Text = "Select Brands";
lst.Value = "";
ddlBrands.Items.Insert(0, lst);
ddlItemsCarried.DataSource = items.GetAllItemsCarried(connstring);
ddlItemsCarried.DataTextField = "ItemsCarried";
ddlItemsCarried.DataValueField = "ItemNo";
ddlItemsCarried.DataBind();
ListItem lst1 = new ListItem();
lst1.Text = "Select Items";
lst1.Value = "";
ddlItemsCarried.Items.Insert(0, lst1);
ddlLocations.DataSource = loc.GetAllLocations(connstring);
ddlLocations.DataTextField = "LocationName";
ddlLocations.DataValueField = "LocationId";
ddlLocations.DataBind();
ListItem lst2 = new ListItem();
lst2.Text = "Select Locations";
lst2.Value = "";
ddlLocations.Items.Insert(0, lst2);
ddlServices.DataSource = serv.GetAllServices(connstring);
ddlServices.DataTextField = "ServiceName";
ddlServices.DataValueField = "ServiceId";
ddlServices.DataBind();
ListItem lst3 = new ListItem();
lst3.Text = "Select Services";
lst3.Value = "";
ddlServices.Items.Insert(0, lst3);
ddlCategory.DataSource = cat.GetCategories(connstring);
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
ListItem lst4 = new ListItem();
lst4.Text = "Select Category";
lst4.Value = "";
ddlCategory.Items.Insert(0, lst4);
ddlSubCategory.DataSource = sub.GetSubCategoryByCategoryId(connstring, ddlCategory.SelectedItem.Value);
ddlSubCategory.DataTextField = "SubCategoryName";
ddlSubCategory.DataValueField = "SubCategoryId";
ddlSubCategory.DataBind();
ListItem lst5 = new ListItem();
lst5.Text = "Select Sub-category";
lst5.Value = "";
ddlSubCategory.Items.Insert(0, lst5);
ddlPCAAB.DataSource = pcab.GetAllPCABClass(connstring);
ddlPCAAB.DataTextField = "PCABClassName";
ddlPCAAB.DataValueField = "PCABClassId";
ddlPCAAB.DataBind();
ListItem lst6 = new ListItem();
lst6.Text = "PCAB Class";
lst6.Value = "";
ddlPCAAB.Items.Insert(0, lst6);
chkISOStandard.DataSource = iso.GetISOStandard(connstring);
//chkISOStandard.DataSource = iso.GetISOStandard(connstring);
chkISOStandard.DataTextField = "ISOStandardName";
chkISOStandard.DataValueField = "ISOStandardId";
chkISOStandard.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
if (Session["VendorId"] != null)
{
ViewState["VendorId"] = Session["VendorId"].ToString().Trim();
SupplierTransaction st = new SupplierTransaction();
Supplier s = st.QuerySuppliers(connstring, ViewState["VendorId"].ToString().Trim());
lblCompanyName.Text = s.VendorName.Trim();
lblAddressHeadOffice.Text = s.VendorAddress.Trim() + " " + s.VendorAddress1.Trim();
lblTelephone.Text = s.TelephoneNumber.Trim();
lblFax.Text = s.Fax.Trim();
lblExtension.Text = s.Extension.Trim();
lblAddressBranch.Text = s.VendorAddress2.Trim() + " " + s.VendorAddress3.Trim();
lblTelephone1.Text = s.BranchTelephoneNo.Trim();
lblFax1.Text = s.BranchFax.Trim();
lblExtension1.Text = s.BranchExtension.Trim();
lblVatRegNo.Text = s.VatRegNo.Trim();
lblTin.Text = s.TIN.Trim();
lblPOBox.Text = s.POBOX.Trim();
lblPostalCode.Text = s.PostalCode.Trim();
lblEmail.Text = s.VendorEmail.Trim();
lblStandardTerms.Text = s.TermsOfPayment.Trim();
lblSpecialTerms.Text = s.SpecialTerms.Trim();
lblMinimumOrderValue.Text = s.MinOrderValue.Trim();
lblSalesPerson.Text = s.ContactPerson.Trim();
lblTelephone2.Text = s.SalesPersonTelNo.Trim();
lblTypeOfBusinessOrganization.Text = s.OrgTypeId;
lblFilipino.Text = s.OwnershipFilipino.Trim();
lblOtherNationality.Text = s.OwnershipOther.Trim();
lblCompanyClassification.Text = "";
lblSoleSupplier.Text = s.SoleSupplier1.Trim() + " " + s.SoleSupplier2.Trim();
lblSpecialization.Text = s.Specialization.Trim();
SupplierType sut = new SupplierType();
lblSupplierType.Text = sut.GetSupplierType(connstring, s.Accredited.Trim());
PCABClassTransaction pcab = new PCABClassTransaction();
lblPCABClass.Text = pcab.GetPCABClasName(connstring, s.PCABClass.Trim());
switch (s.ISOStandard.Trim())
{
case "01":
lblISOStandard.Text = "ISO 9002";
break;
case "10":
lblISOStandard.Text = "ISO 9001";
break;
case "11":
lblISOStandard.Text = "ISO 9001<br />ISO 9002";
break;
}
DataSet ds = st.QueryCategoryAndSubCategory(connstring, ViewState["VendorId"].ToString().Trim());
string strcategory = "";
string strsubcategory = "";
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
DataTable dtCategory = ds.Tables[0];
if (dtCategory.Rows.Count > 0)
{
for (int i = 0; i < dtCategory.Rows.Count; i++)
{
strcategory = (strcategory == "" ? dtCategory.Rows[i]["CategoryName"].ToString() : strcategory + "<br />" + dtCategory.Rows[i]["CategoryName"].ToString());
}
}
}
if (ds.Tables[1] != null)
{
DataTable dtSubCategory = ds.Tables[1];
if (dtSubCategory.Rows.Count > 0)
{
for (int i = 0; i < dtSubCategory.Rows.Count; i++)
{
strsubcategory = (strsubcategory == "" ? dtSubCategory.Rows[i]["CompleteName"].ToString() : strsubcategory + "<br />" + dtSubCategory.Rows[i]["CompleteName"].ToString());
}
}
}
}
lblCategory.Text = strcategory;
lblSubCategory.Text = strsubcategory;
gvKeyPersonnel.DataSource = CreateKeyPersonell(s.KeyPersonnel.Trim(), s.KeyPosition.Trim());
gvKeyPersonnel.DataBind();
gvPresentServices.DataSource = st.QueryPresentServices(connstring, ViewState["VendorId"].ToString().Trim());
gvPresentServices.DataBind();
DataTable dt = st.QueryMajorCustomers(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyMajorCustomers();
}
gvMajorCustomers.DataSource = dt;
gvMajorCustomers.DataBind();
dt = st.QueryBanks(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyBanks();
}
gvBanks.DataSource = dt;
gvBanks.DataBind();
dt = st.QueryAffiliatedCompanies(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyAffiliatedCompanies();
}
gvAffiliatedCompanies.DataSource = dt;
gvAffiliatedCompanies.DataBind();
dt = st.QueryExternalAuditors(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyExternalAuditor();
}
gvExternalAuditors.DataSource = dt;
gvExternalAuditors.DataBind();
dt = st.QueryEquipment(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyEquipment();
}
gvEquipment.DataSource = dt;
gvEquipment.DataBind();
dt = st.QueryRelatives(connstring, ViewState["VendorId"].ToString().Trim());
if (dt.Rows.Count == 0)
{
dt = CreateEmptyRelativesTable();
}
gvRelatives.DataSource = dt;
gvRelatives.DataBind();
DataTable dtBrands = st.QueryBrandsByVendorId(connstring, Session["VendorId"].ToString().Trim());
gvBrands.DataSource = dtBrands;
gvBrands.DataBind();
DataTable dtItems = st.QueryItemsCarriedByVendorId(connstring, Session["VendorId"].ToString().Trim());
gvItems.DataSource = dtItems;
gvItems.DataBind();
DataTable dtLocations = st.QueryLocationsByVendorId(connstring, Session["VendorId"].ToString().Trim());
gvLocations.DataSource = dtLocations;
gvLocations.DataBind();
DataTable dtServices = st.QueryServicesByVendorId(connstring, Session["VendorId"].ToString().Trim());
gvServices.DataSource = dtServices;
gvServices.DataBind();
}
else
{
Response.Redirect("suppliers.aspx");
}
}
}
