public string ItemTypeSql(CompanySetup objCompanySetup, BranchSetup objBranchSetup)
{
string sqlString = null;
sqlString = "SELECT ItemTypeID,ItemType FROM matItemTypeSetup WHERE DataUsed = 'A' AND CompanyID = '" + objCompanySetup.CompanyID + "' AND BranchID = '" + objBranchSetup.BranchID + "' ORDER BY ItemType";
return(sqlString);
}
public string SQLGetAllSuppliers(CompanySetup objCompanySetup, BranchSetup objBranchSetup)
{
string sqlString = null;
sqlString = "SELECT ContactID,FullName FROM [AllSuppliers] WHERE CompanyID = " + objCompanySetup.CompanyID + " AND BranchID = " + objBranchSetup.BranchID + " ORDER BY FullName";
return(sqlString);
}
public string UnitSql(CompanySetup objCompanySetup, BranchSetup objBranchSetup)
{
string sqlString = null;
sqlString = "SELECT UnitID,Unit FROM matUnitSetup WHERE DataUsed = 'A' AND CompanyID = '" + objCompanySetup.CompanyID + "' AND BranchID = '" + objBranchSetup.BranchID + "' ORDER BY Unit";
return(sqlString);
}
internal void LoadDepartmentDDL(DropDownList ddlDepartment, BranchSetup objBranchSetup)
{
try
{
_objOrganizationalChartSetupController = new OrganizationalChartSetupController();
_objOrganizationalChartSetupController.LoadDepartmentDDL(ddlDepartment, objBranchSetup);
}
catch (Exception msgException)
{
throw msgException;
}
}
internal void LoadDepartmentDDL(DropDownList givenDDLID, BranchSetup objBranchSetup)
{
try
{
_objTwoColumnsTableData.TableName = "[orgDepartment]";
SectionSetup objSectionSetup = new SectionSetup();
objSectionSetup.CompanyID = objBranchSetup.CompanyID;
objSectionSetup.BranchID = objBranchSetup.BranchID;
ClsDropDownListController.LoadDropDownList(this.ConnectionString, this.SqlOrgDepartment(objSectionSetup), givenDDLID, "EntityName", "EntityID");
}
catch (Exception msgException)
{
throw msgException;
}
}
private void UCLoadDepartment(DropDownList ddlElementData)
{
try
{
_objBranchSetup = new BranchSetup();
DropDownList ddlElementDataCompany = (DropDownList)GridViewOrganizationalChart.Rows[0].FindControl("ddlElementData");
DropDownList ddlElementDataBranch = (DropDownList)GridViewOrganizationalChart.Rows[1].FindControl("ddlElementData");
_objBranchSetup.CompanyID = Convert.ToInt32(ddlElementDataCompany.SelectedValue);
_objBranchSetup.BranchID = Convert.ToInt32(ddlElementDataBranch.SelectedValue);
_objEmployeeSetupController = new EmployeeSetupController();
_objEmployeeSetupController.LoadDepartmentDDL(ddlElementData, _objBranchSetup);
}
catch (Exception msgException)
{
throw msgException;
}
}
private void LoadDropDownListData(DropDownList targetDDLItemTypeID, DropDownList targetDDLUnit, DropDownList targetDDBreakupUnit, DropDownList targetDDItemUsageID,
DropDownList targetDDRelatedSupplier, DropDownList targetDDSalesAccountNo, DropDownList targetDDStockAccountNo, DropDownList targetDDCOGSAccountNo,
DropDownList targetDDSalesReturnAccount)
{
try
{
ItemTypeSetupController objItemTypeSetupController = new ItemTypeSetupController();
_objCompanySetup = new CompanySetup();
_objCompanySetup.CompanyID = Convert.ToInt32(Session["company"].ToString());
_objBranchSetup = new BranchSetup();
_objBranchSetup.BranchID = Convert.ToInt32(Session["branch"].ToString());
ClsDropDownListController.LoadDropDownList(_connectionString, objItemTypeSetupController.ItemTypeSql(_objCompanySetup, _objBranchSetup), targetDDLItemTypeID, "ItemType", "ItemTypeID");
UnitSetupController objUnitSetupController = new UnitSetupController();
ClsDropDownListController.LoadDropDownList(_connectionString, objUnitSetupController.UnitSql(_objCompanySetup, _objBranchSetup), targetDDLUnit, "Unit", "UnitID");
ClsDropDownListController.LoadDropDownList(_connectionString, objUnitSetupController.UnitSql(_objCompanySetup, _objBranchSetup), targetDDBreakupUnit, "Unit", "UnitID");
ItemUsageSetupController objItemUsageSetupController = new ItemUsageSetupController();
ClsDropDownListController.LoadDropDownList(_connectionString, objItemUsageSetupController.ItemUsageSql(_objCompanySetup, _objBranchSetup), targetDDItemUsageID, "ItemUsage", "ItemUsageID");
SuppliersController objSuppliersController = new SuppliersController();
ClsDropDownListController.LoadDropDownList(_connectionString, objSuppliersController.SQLGetAllSuppliers(_objCompanySetup, _objBranchSetup), targetDDRelatedSupplier, "FullName", "ContactID");
_objItemSetupController = new ItemSetupController();
_objItemCategorySetup = new ItemCategorySetup();
_objItemCategorySetup.CompanyID = _objCompanySetup.CompanyID;
_objItemCategorySetup.BranchID = _objBranchSetup.BranchID;
_objItemCategorySetup.KnownValueID = Convert.ToInt32(EnumCollections.eTransactionType.eSalesTrans);
ClsDropDownListController.LoadDropDownList(_connectionString, _objItemSetupController.SQLForAccountType(_objItemCategorySetup), targetDDSalesAccountNo, "AccountName", "AccountNo");
_objItemCategorySetup.KnownValueID = Convert.ToInt32(EnumCollections.eTransactionType.eStock);
ClsDropDownListController.LoadDropDownList(_connectionString, _objItemSetupController.SQLForAccountType(_objItemCategorySetup), targetDDStockAccountNo, "AccountName", "AccountNo");
_objItemCategorySetup.KnownValueID = Convert.ToInt32(EnumCollections.eTransactionType.eCOGS);
ClsDropDownListController.LoadDropDownList(_connectionString, _objItemSetupController.SQLForAccountType(_objItemCategorySetup), targetDDCOGSAccountNo, "AccountName", "AccountNo");
_objItemCategorySetup.KnownValueID = Convert.ToInt32(EnumCollections.eTransactionType.eSalesReturn);
ClsDropDownListController.LoadDropDownList(_connectionString, _objItemSetupController.SQLForAccountType(_objItemCategorySetup), targetDDSalesReturnAccount, "AccountName", "AccountNo");
}
catch (Exception msgException)
{
throw msgException;
}
}