public DataSet BindConditions()
{
DataSet dsConditions = new DataSet();
dsConditions = new POSystemDataHandler().BindConditions();
return(dsConditions);
}
protected void btnSearchBudgetCode_Click(object sender, EventArgs e)
{
divBudgCode.Visible = true;
lblUpdateMessage.Visible = false;
DataSet ds = new DataSet();
try
{
DataSet dsDept = new POSystemDataHandler().GetDepartment();
ddlDepartment.DataSource = dsDept;
ddlDepartment.DataBind();
DataSet dsOrderClass = new POMain().GetOrderClassification(1);
ddlOrderClassification.DataSource = dsOrderClass;
ddlOrderClassification.DataBind();
DataSet dsStation = new POSystemDataHandler().GetStation();
ddlStation.DataSource = dsStation;
ddlStation.DataBind();
ddlStation.Items.Insert(0, new ListItem("--Select--", "0"));
string budgetCode = txtSearchBudgetCode.Text;
ds = new POMain().GetBudgetCodeDetails(budgetCode);
lblBudgetCodeID.Text = ds.Tables[0].Rows[0]["BudgetCodeID"].ToString();
txtBudgetCode.Text = ds.Tables[0].Rows[0]["BudgetCode"].ToString();
ddlDepartment.SelectedValue = ds.Tables[0].Rows[0]["Department"].ToString();
ddlOrderClassification.SelectedValue = ds.Tables[0].Rows[0]["OrderClassification"].ToString();
ddlStation.SelectedValue = ds.Tables[0].Rows[0]["Station"] != DBNull.Value ? ds.Tables[0].Rows[0]["Station"].ToString() : "0";
txtDescription.Text = ds.Tables[0].Rows[0]["Description"].ToString();
}
catch (Exception ex)
{ }
}
private void FillProject()
{
DataSet dsProject = new POSystemDataHandler().GetProject();
drpAdvSearchProject.DataSource = dsProject;
drpAdvSearchProject.DataBind();
drpAdvSearchProject.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void FillSuppliers()
{
DataSet dsSuppliers = new POSystemDataHandler().GetSupplier();
drpAdvSearchSupplier.DataSource = dsSuppliers;
drpAdvSearchSupplier.DataBind();
drpAdvSearchSupplier.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void FillShipTo()
{
DataSet dsShip = new POSystemDataHandler().GetShipTo();
drpAdvSearchShipTo.DataSource = dsShip;
drpAdvSearchShipTo.DataBind();
drpAdvSearchShipTo.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void FillType()
{
DataSet dsType = new POSystemDataHandler().GetType();
ddlPOType.DataSource = dsType;
ddlPOType.DataBind();
ddlPOType.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void GetRequester()
{
DataSet dsRequester = new POSystemDataHandler().GetRequester();
drpAdvSearchRequester.DataSource = dsRequester;
drpAdvSearchRequester.DataBind();
drpAdvSearchRequester.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void FillStation()
{
DataSet dsStation = new POSystemDataHandler().GetStation();
drpAdvSearchStation.DataSource = dsStation;
drpAdvSearchStation.DataBind();
drpAdvSearchStation.Items.Insert(0, new ListItem("--Select--", "0"));
}
//protected override void OnInit(EventArgs e)
//{
// try
// {
// base.OnInit(e);
// //Form.InnerHtml
// }
// catch (Exception ex)
// {
// Response.Write(ex.Message);
// }
//}
private void FillDepartment()
{
DataSet dsDept = new POSystemDataHandler().GetDepartment();
ddlDept.DataSource = dsDept;
ddlDept.DataBind();
ddlDept.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void FillBudhetCodeInsertValues()
{
try
{
DataSet dsDept = new POSystemDataHandler().GetDepartment();
ddlInsertDepartment.DataSource = dsDept;
ddlInsertDepartment.DataBind();
ddlInsertDepartment.Items.Insert(0, new ListItem("--Select--", "0"));
DataSet dsOrderClass = new POMain().GetOrderClassification(1);
ddlInsertOrderClassification.DataSource = dsOrderClass;
ddlInsertOrderClassification.DataBind();
ddlInsertOrderClassification.Items.Insert(0, new ListItem("--Select--", "0"));
DataSet dsStation = new POSystemDataHandler().GetStation();
ddlInsertStation.DataSource = dsStation;
ddlInsertStation.DataBind();
ddlInsertStation.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception e)
{ }
}
public int UpdateShipToDetails(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.UpdateShipToDetails(this.ShipToID, this.ShipToName, this.VAT, this.ShipToAddress, this.NewAddress, this.CreatedBy));
}
public int DeleteShipToDetails(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.DeleteShipToDetails(this.ShipToID, this.CreatedBy));
}
public int UpdatePOFor5thLevelApprovalForCFOCOO(Int64 poNumber, string status1, string comment, string empName)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.UpdatePOFor5thLevelApprovalForCFOCOO(poNumber, status1, comment, empName));
}
public DataSet GetPOForClosed()
{
DataSet dsClosedPO = new POSystemDataHandler().GetPOForClosed();
return(dsClosedPO);
}
public int UpdateSupplierDetails(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.UpdateSupplierDetails(this.SupplierID, this.MainNo, this.FaxNo, this.ContactPerson, this.PhNo, this.ContactPerson1, this.PhNo1, this.Address1, this.Address2, this.Address3, this.Address4, this.Address5, this.Country, this.Comment, this.Term, this.CreatedBy, this.Received));
}
public int DeleteRequester(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.DeleteRequester(this.RequesterID, this.CreatedBy));
}
public DataSet GetShipToDetailsByShipToId(int shipTo)
{
DataSet dsPO = new POSystemDataHandler().GetShipToDetailsByShipToId(shipTo);
return(dsPO);
}
public DataSet GetPOByAdvSearch(int?requester, int?station, int?shipTo, int?supplier, int?dept, int?project, string comment, string circitID)
{
DataSet dsPO = new POSystemDataHandler().GetPOByAdvSearch(requester, station, shipTo, supplier, dept, project, comment, circitID);
return(dsPO);
}
public DataSet GetApproverList(int roleID, int?deptID)
{
DataSet dsApprover = new POSystemDataHandler().GetApproverList(roleID, deptID);
return(dsApprover);
}
public DataSet GetSupplierDetails(int supplierID)
{
DataSet dsSupplierDetails = new POSystemDataHandler().GetSupplierDetails(supplierID);
return(dsSupplierDetails);
}
public DataSet BindShipTerm()
{
DataSet dsShipTerm = new POSystemDataHandler().BindShipTerm();
return(dsShipTerm);
}
public int InsertShipTo(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.InsertShipTo(this.ShipToName, this.VAT, this.ShipToAddress, this.NewAddress, this.CreatedBy));
}
public int InsertRequester(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.InsertRequester(this.RequesterName, this.Email, this.UserID, this.Role, this.CreatedBy));
}
public DataSet GetPOForPreApproval(string deptIDs, string userName)
{
DataSet dsPO = new POSystemDataHandler().GetPOForPreApproval(deptIDs, userName);
return(dsPO);
}
public int InsertProject(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.InsertProject(this.ProjectName, this.CreatedBy));
}
public DataSet GetPOForDeputyApproval(string userName)
{
DataSet dsPO = new POSystemDataHandler().GetPOForDeputyApproval(userName);
return(dsPO);
}
public int InsertSupplier(POMain poMain)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.InsertSupplier(this.SupplierName, this.MainNo, this.FaxNo, this.ContactPerson, this.PhNo, this.ContactPerson1, this.PhNo1, this.Address1, this.Address2, this.Address3, this.Address4, this.Address5, this.Country, this.Comment, this.Term, this.CreatedBy));
}
public DataSet GetAdditionalBillingAddress(int city)
{
DataSet dsAddnBillingAdd = new POSystemDataHandler().GetAdditionalBillingAddress(city);
return(dsAddnBillingAdd);
}
//For Tail/Circuit/Cross-Connect PO HOD
public DataSet GetPOForTailCircuitCrossHODApproval(string deptIDs, string userName)
{
DataSet dsPO = new POSystemDataHandler().GetPOForTailCircuitCrossHODApproval(deptIDs, userName);
return(dsPO);
}
public int UpdatePOToHODApproved(Int64 poNumber, string comment, string empName)
{
POSystemDataHandler dataHandler = new POSystemDataHandler();
return(dataHandler.UpdatePOToHODApproved(poNumber, comment, empName));
}
