private void FillFromRoom()
{
string cQuery = "SELECT * FROM tblStockRoom WHERE IsActive = 'Y' ORDER BY NameOF";
cboFrom.DataSource = GlbData.getDataSet(cQuery, "tblStockRoom").Tables[0];
cboFrom.ValueMember = "CustID";
cboFrom.DisplayMember = "NameOF";
}
private void FillCompany()
{
string cQuery = "SELECT CustID, NameOf + ' - ' + City AS Name FROM tblCompany WHERE IsActive = 'Y' ORDER BY NameOF";
cmbCompany.DataSource = GlbData.getDataSet(cQuery, "tblCompany").Tables[0];
cmbCompany.ValueMember = "CustID";
cmbCompany.DisplayMember = "Name";
}
private void LoadBills()
{
gSB.Clear();
gSB.Append("SELECT DateOn, BillNo, ManAmount, TotalPaid, (ManAmount - TotalPaid- CNAmount) AS Payable, BillID " +
" FROM tblSaleBrief " +
" WHERE IsActive = 'Y' AND (ManAmount - TotalPaid- CNAmount) > 0 AND " +
" CustID = " + gCustID + " ");
dSet = GlbData.getDataSet(gSB.ToString(), "tblSaleBrief");
DataView dView = new DataView(dSet.Tables[0]);
dgvBills.DataSource = dView;
SettingGridBills();
PatchPaidAmount();
}
private void LoadOutstanding()
{
gSB.Clear();
gSB.Append("SELECT DateOn, BillNo, NetTotal, TotalPaid, NetTotal - CNAmount - TotalPaid AS Payable, " +
" PerformedOn, UserName, BillID " +
" FROM tblPurchaseBrief " +
" WHERE MOP = 'CRE' AND (NetTotal- TotalPaid) > 0 AND CompID = " + GlobalData.GCompID + " " +
" AND CustID = " + gCustID + " ORDER BY BillID ");
dSet = GlbData.getDataSet(gSB.ToString(), "tblSaleBrief");
DataView dView = new DataView(dSet.Tables[0]);
dgvOutstanding.DataSource = dView;
SettingGrid(dgvOutstanding);
getTotalReceivable();
}
private void FillScale()
{
string cQuery = "SELECT * FROM tblScale WHERE IsActive = 'Y' ORDER BY NameOF";
cboScale.DataSource = GlbData.getDataSet(cQuery, "tblScale").Tables[0];
cboScale.ValueMember = "CustID";
cboScale.DisplayMember = "NameOF";
}
private void fillBillView()
{
string strQuery = correctQuery() + getDateRange() + "ORDER BY CP.DateOn, CP.BillNo";
dSet = GlbData.getDataSet(strQuery, "tblCustPayBrief");
DataView dView = new DataView(dSet.Tables[0]);
dgvBill.DataSource = dView;
SettingGrid();
}
private void fillBillView()
{
string strQuery = correctQuery() + getDateRange() + "ORDER BY DateOn, BillNo";
dSet = GlbData.getDataSet(strQuery, TABLE_NAME);
DataView dView = new DataView(dSet.Tables[0]);
dgvBill.DataSource = dView;
SettingGrid();
}
private void fillCommon()
{
gSB.Clear();
gSB.Append("SELECT CustID, Code, NameOf FROM " + gTableName + " ");
dSet = GlbData.getDataSet(gSB.ToString(), gTableName);
DataView dView = new DataView(dSet.Tables[0]);
dgvDetail.DataSource = dView;
SettingGrid();
}
private void fillSupplier()
{
gSB.Clear();
gSB.Append("SELECT CustID, Code, NameOF, DescriptionOf " +
" FROM " + gTableName + " " +
" WHERE IsActive = 'Y' ");
if (isCustom == false)
{
dSet = GlbData.getDataSet(gSB.ToString(), gTableName);
}
else
{
dSet = GlbData.getDataSet(gQuery, gTableName);
}
DataView dView = new DataView(dSet.Tables[0]);
dgvItem.DataSource = dView;
SettingGrid();
}
private void LoadOutstanding()
{
gSB.Clear();
gSB.Append(GetQuery() + getDateRange() + getCustomerID() + " GROUP BY BR.DateOn, CU.Tp1, CU.Code, CU.CustID, CU.NameOF ORDER BY BR.DateOn");
dSet = GlbData.getDataSet(gSB.ToString(), "tblSaleBrief");
DataView dView = new DataView(dSet.Tables[0]);
dgvGrid.DataSource = dView;
SettingGrid();
PatchPaidAmount();
}
private void fillSupplier()
{
gSB.Clear();
gSB.Append("SELECT CustID, Code, NameOF, City, Tp1 " +
" FROM " + TABLE_NAME + " " +
" WHERE IsActive = 'Y' ");
dSet = GlbData.getDataSet(gSB.ToString(), TABLE_NAME);
DataView dView = new DataView(dSet.Tables[0]);
dgvItem.DataSource = dView;
SettingGrid();
}
private void fillSupplier()
{
gSB.Clear();
gSB.Append("SELECT CustID, Code, NameOF, BrandName, SerialNo, ModelNo " +
" FROM tblItem " +
" WHERE IsActive = 'Y' ");
dSet = GlbData.getDataSet(gSB.ToString(), "tblSupplier");
DataView dView = new DataView(dSet.Tables[0]);
dgvItem.DataSource = dView;
SettingGrid();
}
private void fillItem()
{
gSB.Clear();
gSB.Append("SELECT IT.Code, IT.NameOF, CT.NameOF AS Category, IT.SellingPrice AS Price, ISNULL(ST.Qty,0) AS Qty, IT.CustId, IT.Cost " +
" FROM tblMajorCategory AS CT RIGHT OUTER JOIN " +
" tblItem AS IT ON CT.CustID = IT.CategoryID LEFT OUTER JOIN " +
" tblComSTKStore AS ST ON IT.CustID = ST.ItemID WHERE ST.CompID = " + GlobalData.GCompID + " AND ST.StockroomID = " + GlobalData.GStockRoomID + " ");
dSet = GlbData.getDataSet(gSB.ToString(), "tblItem");
DataView dView = new DataView(dSet.Tables[0]);
dgvItem.DataSource = dView;
SettingGrid();
}
private void ShowDetail()
{
gSB.Clear();
gSB.Append("SELECT PO.ItemId, PO.ItemCode, PO.ItemName, PO.CategoryId, PO.CategoryCode, PO.CategoryName, " +
" PO.SupplierId, PO.SupplierName, PO.SupplierCode, PO.CostPrice, PO.SellingPrice, PO.WholeSalePrice, " +
" PO.OpenStk, PO.Purchase, PO.PurchaseFree, PO.SCN, PO.SCNFree, PO.Sale, PO.SaleFree, PO.CCN, PO.CCNFree, PO.STKAdd, " +
" PO.StkDED, PO.CloseStk, IT.BrandName FROM tblTEMPPOAnalyser AS PO INNER JOIN tblITEM AS IT ON IT.CustID = PO.ItemId ");
dSet = GlbData.getDataSet(gSB.ToString(), "tblTEMPPOAnalyser");
DataView dView = new DataView(dSet.Tables[0]);
dgvGrid.DataSource = dView;
SettingGrid();
}
private void FillBank()
{
cmbBank.DataSource = GlbData.getDataSet("SELECT CustID, NameOF FROM tblBank ", "tblBank").Tables[0];
cmbBank.ValueMember = "CustID";
cmbBank.DisplayMember = "NameOF";
}
