public string[] GetItemList(string prefixText, int count, string contextKey)
{
int companyID = Convert.ToInt32(contextKey.Split(':')[0]);
int branchID = Convert.ToInt32(contextKey.Split(':')[1]);
DataTable detitem = new DataTable();
DataTable dt = new DataTable();
detitem = DataProcess.GetData(_connectionString, ItemSetupController.GetItemDetail(companyID, branchID));
int maxsize = 1000;
if (prefixText == "*")
{
dt = detitem;
}
else
{
prefixText = "%" + prefixText + "%";
dt = DataProcess.GetData(_connectionString, ItemSetupController.GetItemDetailSearch(prefixText, companyID, branchID));
}
string[] str;
if (dt.Rows.Count > maxsize)
{
str = new string[maxsize];
}
else
{
str = new string[dt.Rows.Count];
}
int indx = 0;
foreach (DataRow dr in dt.Rows)
{
str[indx] = dr["ItemCode"].ToString() + " : " + dr["ModelNo"].ToString();
indx++;
if (indx == maxsize)
{
break;
}
}
return(str);
}
public string[] GetItemName(string prefixText, int count)
{
DataTable detitem = new DataTable();
DataTable dt = new DataTable();
_objItemSetupController = new ItemSetupController();
detitem = DataProcess.GetData(_connectionString, _objItemSetupController.GetCategoryAndItem());
int maxsize = 1000;
if (prefixText == "*")
{
dt = detitem;
}
else
{
prefixText = "%" + prefixText + "%";
dt = DataProcess.GetData(_connectionString, _objItemSetupController.GetCategoryAndItem(prefixText));
}
string[] str;
if (dt.Rows.Count > maxsize)
{
str = new string[maxsize];
}
else
{
str = new string[dt.Rows.Count];
}
int indx = 0;
foreach (DataRow dr in dt.Rows)
{
str[indx] = dr["ModelNo"].ToString();
indx++;
if (indx == maxsize)
{
break;
}
}
return(str);
}
private void ShowItemDetails(ItemSetup objItemSetup)
{
try
{
DataTable dtItemDetails = null;
_objItemSetupController = new ItemSetupController();
dtItemDetails = _objItemSetupController.GetItemDetails(_connectionString, objItemSetup);
foreach (DataRow rowNo in dtItemDetails.Rows)
{
txtItemCodeUpdate.Text = rowNo["ItemCode"].ToString();
txtItemNameUpdate.Text = rowNo["ModelNo"].ToString();
ddlItemTypeIDUpdate.SelectedValue = rowNo["ItemTypeID"].ToString() == null ? "-1" : rowNo["ItemTypeID"].ToString();
ddlItemUsageIDUpdate.SelectedValue = rowNo["ItemUsageID"].ToString() == null ? "-1" : rowNo["ItemUsageID"].ToString();
ddlRelatedSupplierUpdate.SelectedValue = rowNo["SupplierID"].ToString() == "" ? "-1" : rowNo["SupplierID"].ToString();
txtDescriptionUpdate.Text = rowNo["Specification"].ToString();
txtHSCodeUpdate.Text = rowNo["HSCode"].ToString();
txtOpeningBalanceUpdate.Text = rowNo["OpenningBalance"].ToString();
ddlUnitUpdate.SelectedValue = rowNo["UnitID"].ToString() == null ? "-1" : rowNo["UnitID"].ToString();
txtBreakUpQuantityUpdate.Text = rowNo["BreakUpQuantity"].ToString();
ddlBreakupUnitUpdate.SelectedValue = rowNo["BreakUpUnitID"].ToString() == null ? "-1" : rowNo["BreakUpUnitID"].ToString();
txtReOrderLevelUpdate.Text = rowNo["ReOrderLevel"].ToString();
txtMinimumQuantityUpdate.Text = rowNo["MinimumBal"].ToString();
ddlSalesAccountNoUpdate.SelectedValue = rowNo["COASalesAccNo"].ToString() == null ? "-1" : rowNo["COASalesAccNo"].ToString();
ddlStockAccountNoUpdate.SelectedValue = rowNo["COAStockAccNo"].ToString() == null ? "-1" : rowNo["COAStockAccNo"].ToString();
ddlCOGSAccountNoUpdate.SelectedValue = rowNo["COACGSAccNo"].ToString() == null ? "-1" : rowNo["COACGSAccNo"].ToString();
ddlSalesReturnAccountUpdate.SelectedValue = rowNo["COASalesRetAccNo"].ToString() == null ? "-1" : rowNo["COASalesRetAccNo"].ToString();
var vatValue = rowNo["IsVATableItem"].ToString();
if (Convert.ToBoolean(vatValue) == true)
{
CheckBoxIsVATUpdate.Checked = true;
}
else
{
CheckBoxIsVATUpdate.Checked = false;
}
}
}
catch (Exception msgException)
{
throw msgException;
}
}
private void AssignItemValuesForUpdate()
{
try
{
_objItemSetup = new ItemSetup();
_objItemSetup.ItemCategoryID = Convert.ToInt32(ddlParentCategory.SelectedValue);
_objItemSetup.Specification = txtDescriptionUpdate.Text == string.Empty ? null : txtDescriptionUpdate.Text;
_objItemSetup.HsCode = txtHSCodeUpdate.Text == string.Empty ? null : txtHSCodeUpdate.Text;
_objItemSetup.IsVATAbleItem = CheckBoxIsVATUpdate.Checked == true ? true : false;
_objItemSetup.SupplierID = ddlRelatedSupplierUpdate.SelectedValue == "-1" ? null : ddlRelatedSupplierUpdate.SelectedValue;
_objItemSetup.OpenningBalance = txtOpeningBalanceUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtOpeningBalanceUpdate.Text);
_objItemSetup.CoaSalesAccNo = Convert.ToInt32(ddlSalesAccountNoUpdate.SelectedValue);
_objItemSetup.CoaStockAccNo = Convert.ToInt32(ddlStockAccountNoUpdate.SelectedValue);
_objItemSetup.CoacgsAccNo = Convert.ToInt32(ddlCOGSAccountNoUpdate.SelectedValue);
_objItemSetup.CoaSalesRetAccNo = Convert.ToInt32(ddlSalesReturnAccountUpdate.SelectedValue);
_objItemSetup.EntryUserName = Session["entryUserCode"].ToString();
_objItemSetup.ItemID = Convert.ToInt32(Session["itemID"].ToString());//
_objItemSetup.ModelNo = txtItemNameUpdate.Text == string.Empty ? null : txtItemNameUpdate.Text;
_objItemSetup.UnitID = Convert.ToInt32(ddlUnitUpdate.SelectedValue);
_objItemSetup.ItemCode = txtItemCodeUpdate.Text == string.Empty ? null : txtItemCodeUpdate.Text;
_objItemSetup.ItemTypeID = Convert.ToInt32(ddlItemTypeIDUpdate.SelectedValue);
_objItemSetup.ItemPropertySetID = 1;
_objItemSetup.ItemUsageID = Convert.ToInt32(ddlItemUsageIDUpdate.SelectedValue);
_objItemSetup.BreakUpQuantity = txtBreakUpQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtBreakUpQuantityUpdate.Text);
_objItemSetup.ReOrderLevel = txtReOrderLevelUpdate.Text == string.Empty ? null : txtReOrderLevelUpdate.Text;
_objItemSetup.BreakUpUnitD = Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue);
_objItemSetup.MinimumQuantity = txtMinimumQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtMinimumQuantityUpdate.Text);
_objItemSetupController = new ItemSetupController();
_objItemSetupController.Update(_connectionString, _objItemSetup);
ClearAfterUpdate();
TreeViewCategory.Nodes.Clear();
PopulateRootLevel();
}
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;
}
}
