protected void ddlVendorName_SelectedIndexChanged(object sender, EventArgs e)
{
itemname = ddlVendorName.SelectedItem.Text;
PropVendor prpven = new PropVendor();
prpven.Name = itemname;
dsop = BusinessSearch.busConatctVendor(prpven);
if (dsop.Tables[0].Rows.Count > 0)
{
Frmviwenquiries.DataSource = dsop;
// grd.DataSource = dsop;
Panop.Visible = true;
// PanResult.Visible = true;
Frmviwenquiries.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["data"] != null)//session checking
{
if (!IsPostBack)
{
PropVendor objVendor = new PropVendor(); //onject initialization
ddlVendorName.DataSource = BusinessNewPurchase.busSelectVendor(objVendor);
ddlVendorName.DataBind(); //data binding
}
}
else
{
Response.Redirect("~/login.aspx");
}
}
public void fillVendor()
{
PropVendor prpVendor = new PropVendor();
vendorname = ddlSearchVenderName.SelectedItem.Text;
prpVendor.Name = vendorname;
dsop = BusinessSearch.busSearchbyVendorName(prpVendor);
PanelDate.Visible = false;
PanelOrder.Visible = false;
PanResult.Visible = false;
Panelcustom.Visible = false;
PanelCat.Visible = false;
GridViewvendor.DataSource = dsop;
Panelvendor.Visible = true;
GridViewvendor.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
PropVendor newVendor = new PropVendor();
newVendor.Name = txtVendorName.Text;
newVendor.address = txtVendorAddress.Text;
newVendor.phone = txtPhone.Text;
newVendor.AlternatePhone = txtMobile.Text;
newVendor.fax = txtFax.Text;
newVendor.Email = txtemail.Text;
int a = BusinessNewPurchase.buspopVendor(newVendor);
if (a <= 0)
{
ClientScript.RegisterStartupScript(Page.GetType(), "test", "<script>window.opener.location.reload(true);window.close();</script>");
}
else
{
Response.Write("Error in processing.Please Try Again!!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["data"] != null)//session checking
{
if (!IsPostBack)
{
PropItem objItem = new PropItem();
ddlItemName.DataSource = BusinessNewPurchase.busSelectItem(objItem);
ddlItemName.DataBind();//data binding
PropCategory objcat = new PropCategory();
ddlCategory.DataSource = BusinessNewPurchase.busSelectCategory(objcat);
ddlCategory.DataBind();
PropVendor objVendor = new PropVendor();
ddlSupplierName.DataSource = BusinessNewPurchase.busSelectVendor(objVendor);
ddlSupplierName.DataBind();
PropDestination objDes = new PropDestination();
DdlSite.DataSource = BusinessNewPurchase.busFillDestination(objDes);
DdlSite.DataBind();
//propunit objUnit = new propunit();
//drplUnit.DataSource = BusinessNewPurchase.busSelectUnit(objUnit);
//drplUnit.DataBind();
addItem.Attributes.Add("onclick", "openPopUp('PopUpItem.aspx')");
AddVendor.Attributes.Add("onclick", "openPopUpVendor('PopUpVendor.aspx')");
}
Label1.Text = "";
}
else
{
Response.Redirect("~/Login.aspx");//page redirection
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["data"] != null)//session checking
{
if (!IsPostBack)
{
PropItem objItem = new PropItem();
ddlSearchItemName.DataSource = BusinessNewPurchase.busSelectItem(objItem);
ddlSearchItemName.DataBind();
PropCategory objcat = new PropCategory();
ddlCategory.DataSource = BusinessNewPurchase.busSelectCategory(objcat);
ddlCategory.DataBind();
PropVendor objVendor = new PropVendor();
ddlSearchVenderName.DataSource = BusinessNewPurchase.busSelectVendor(objVendor);
ddlSearchVenderName.DataBind();
}
}
else
{
Response.Redirect("~/Login.aspx");
}
}
public static DataSet ConatctVendor(PropVendor obj7)
{
return(DBManager.ExecuteDataset("spVendorContact", obj7.Name));
}
public static DataSet searchbyVname(PropVendor obj2)
{
return(DBManager.ExecuteDataset("spSearchVendorName", obj2.Name));
}
public static int buspopVendor(PropVendor objvendor)
{
return(DalItemPurchase.InsertpopVendor(objvendor));
}
public static DataSet busSelectVendor(PropVendor obj4)
{
return(DalItemPurchase.selectvendor(obj4));
}
public static DataSet busConatctVendor(PropVendor objven)
{
return(DalSearching.ConatctVendor(objven));
}
public static DataSet busSearchbyVendorName(PropVendor obj3)
{
return(DalSearching.searchbyVname(obj3));
}
public static int InsertpopVendor(PropVendor objVendor)
{
return(DBManager.ExecuteNonQuery("spPopVendorName", objVendor.Name, objVendor.address, objVendor.phone, objVendor.AlternatePhone, objVendor.fax, objVendor.Email));
}
public static DataSet selectvendor(PropVendor obj3)
{
return(DBManager.ExecuteDataset("spSeelctSupplierName", obj3.Name));
}
