public void RefreshPage()
{
txtItemName.Text = "";
txtItemCode.Text = "";
txtItemSubQty.Text = "1";
txtSubItem1.Text = "";
lblSaveOption.Text = "";
txtSubItem1.Visible = false;
lstSubItem.Items.Clear();
lstSubItem.Visible = false;
txtItemNameSearch.Focus();
SqlGridSource.SelectCommand = "SELECT * FROM ItemMaster WHERE ItemName<>'' AND BranchId='" + Globals.BranchID + "' ORDER BY ItemName";
SqlGridSource.DataBind();
btnSave.Visible = true;
btnCopy.Visible = false;
btnUpdate.Visible = false;
lblItem1.Visible = false;
txtItemNameSearch.Text = "";
rdbPcs.Checked = true;
rdbinch.Checked = false;
rdbpanel.Checked = false;
txtItemSubQty.Enabled = true;
txtItemName.Enabled = true;
rdbinch.Enabled = true;
rdbpanel.Enabled = true;
rdbPcs.Enabled = true;
txtDefaultRate.Text = "";
txtProcess.Text = "";
txtNewListName.Text = "";
BindDropDown();
}
private void ShowBookingDetails(string strStartDate, string strToDate, string strReportType)
{
////DataSet dsMain = new DataSet();
//grdSearchResult.DataSource = BAL.BALFactory.Instance.Bal_Report.GetExpenseReport(strStartDate, strToDate, strReportType, Globals.BranchID);
//grdSearchResult.DataBind();
//// With All Ledger
if (strReportType == "All")
{
SqlGridSource.SelectCommand = "SELECT TransId, convert(VARCHAR,TransDate,106) As Expense_Date, Narration As Particulars,SUBSTRING(Particulars,4,LEN(Particulars)) As AccountType,SUM(Debit) As Amount FROM EntLedgerEntries WHERE (LedgerName = 'CASH') AND (Particulars Like 'By %') AND BranchId='" + Globals.BranchID + "' AND TransId<>'' And SUBSTRING(Particulars,4,LEN(Particulars)) In (Select LedgerName from LedgerGroup where GroupName='Indirect Income' AND BranchId='" + Globals.BranchID + "') AND EntLedgerEntries.TransDate BETWEEN '" + strStartDate + "' AND '" + strToDate + "' GROUP BY LedgerName, Particulars,Narration,TransDate,TransId order BY TransId desc";
SqlGridSource.DataBind();
}
else
// ledger wise
{
strReportType = "By " + strReportType;
SqlGridSource.SelectCommand = "SELECT TransId, convert(VARCHAR,TransDate,106) As Expense_Date, Narration As Particulars,SUBSTRING(Particulars,4,LEN(Particulars)) As AccountType,SUM(Debit) As Amount FROM EntLedgerEntries WHERE (LedgerName = 'CASH') AND (Particulars Like 'By %') AND BranchId='" + Globals.BranchID + "' AND TransId<>'' And SUBSTRING(Particulars,4,LEN(Particulars)) In (Select LedgerName from LedgerGroup where GroupName='Indirect Income' AND BranchId='" + Globals.BranchID + "') AND Particulars='" + strReportType + "' AND EntLedgerEntries.TransDate BETWEEN '" + strStartDate + "' AND '" + strToDate + "' GROUP BY LedgerName, Particulars,Narration,TransDate,TransId order BY TransId desc";
SqlGridSource.DataBind();
}
bool rights = AppClass.CheckExportToExcelRightOnPage();
if (rights)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
}
protected void btnShowAll_Click(object sender, EventArgs e)
{
//Item = SetValue();
//grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Item.ShowAllItem(Item);
//grdSearchResult.DataBind();
SqlGridSource.SelectCommand = "SELECT * FROM ItemMaster WHERE BranchId='" + Globals.BranchID + "' ORDER BY ItemName";
SqlGridSource.DataBind();
}
public void BindGridView()
{
Ob.BID = Globals.BranchID;
//grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_City.ShowAllExpense(Ob);
//grdSearchResult.DataBind();
SqlGridSource.SelectCommand = "SELECT TransId, convert(VARCHAR,TransDate,106) As Expense_Date, Narration As Particulars, SUBSTRING(Particulars,4,LEN(Particulars)) As AccountType, SUM(Credit) As Amount FROM EntLedgerEntries WHERE (LedgerName = 'CASH') AND (Particulars Like 'To %') AND BranchId='" + Globals.BranchID + "' AND TransId<>'' And SUBSTRING(Particulars,4,LEN(Particulars)) IN (Select LedgerName from LedgerGroup where GroupName='Indirect Expenses' AND BranchId='" + Globals.BranchID + "') GROUP BY LedgerName, Particulars,Narration,TransDate,TransId order BY TransId desc";
SqlGridSource.DataBind();
}
public void BindGrid(string strItemName)
{
//Item = SetValue();
//grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Item.ShowItem(Item);
//grdSearchResult.DataBind();
if (strItemName == "Pageing")
{
SqlGridSource.SelectCommand = "SELECT * FROM ItemMaster WHERE ItemName<>'' AND BranchId='" + Globals.BranchID + "' ORDER BY ItemName";
SqlGridSource.DataBind();
}
else
{
SqlGridSource.SelectCommand = "SELECT * FROM ItemMaster WHERE ItemName<>'' AND BranchId='" + Globals.BranchID + "' AND ItemName LIKE '%'+'" + strItemName + "'+'%' OR ItemCode Like '%'+'" + strItemName + "'+'%' ORDER BY ItemName";
SqlGridSource.DataBind();
}
}
public void BindGridView()
{
Ob.BID = Globals.BranchID;
SqlGridSource.SelectCommand = "SELECT TransId, convert(VARCHAR,TransDate,106) As Expense_Date, Narration As Particulars, SUBSTRING(Particulars,4,LEN(Particulars)) As AccountType, SUM(Debit) As Amount FROM EntLedgerEntries WHERE (LedgerName = 'CASH') AND (Particulars Like 'By %') AND BranchId='" + Globals.BranchID + "' AND TransId<>'' And SUBSTRING(Particulars,4,LEN(Particulars)) In (Select LedgerName from LedgerGroup where GroupName='Indirect Income') GROUP BY LedgerName, Particulars,Narration,TransDate,TransId order BY TransId desc";
SqlGridSource.DataBind();
}
