public static void BindCompanyComboOnlyActive(ref ComboBox cbo, bool ALL)
{
bool UseNames = ConfigurationReader.ReadKeyBoolean(ConfigurationKeys.UseCompanyNames);
Company item = new Company();
DataTable dt = new DataTable();
string valueMember = "CompanyId";
string displayMember = "CompanyCode";
if (UseNames)
displayMember = "CompanyName";
dt = item.SelectAllActiveCompanies();
BindCombo(ref cbo, dt, displayMember, valueMember, ALL);
if (cbo.Items.Count > 0)
cbo.SelectedIndex = 0;
}
void Initialize(bool isCustomer)
{
IsCustomer = isCustomer;
customer = new Customer();
company = new Company();
//cbCustomersSuppliers.Items.Clear();
cbCustomersSuppliers.DataSource = null;
if (IsCustomer)
{
Common.BindCustomerComboOnlyActive(ref cbCustomersSuppliers, false);
}
else
{
Common.BindCompanyComboOnlyActive(ref cbCustomersSuppliers, false);
}
}
private void GetData()
{
DataTable dt = null;
dgvData.DataSource = dt;
DateTime? startDate = dtpStartDate.Value;
DateTime? endDate = dtpEndDate.Value;
if (chkAllDates.Checked)
{
startDate = null;
endDate = null;
}
string strId = string.IsNullOrEmpty(cbSelect.ValueMember) ? string.Empty : Convert.ToString(((DataRowView)(cbSelect.SelectedItem)).Row[cbSelect.ValueMember]);//Convert.ToString(cbSelect.SelectedValue);
long Id = 0;
if (long.TryParse(strId, out Id) && Id >= 0)
{
if (IsCutomerReport)
{
FetchCustomerTransaction(dt, startDate, endDate, strId);
}
else
{
Company comp = new Company();
dt = comp.SelectCompanyTransactions(Common.FormateDateForDB(startDate), Common.FormateDateForDB(endDate), strId);
dgvData.DataSource = dt;
dgvData.Columns["TransactionId"].Visible = false;
dgvData.Columns["TransactionDate"].HeaderText = "Date";
dgvData.Columns["TransactionDate"].DefaultCellStyle.Format = "dd-MM-yyyy HH:mm";
dgvData.Columns["Name"].HeaderText = "Supplier";
Common.FormatCurrencyColumn(dgvData, "Debit,Credit,Amount,Balance");
}
FormatGrid();
}
if (dt != null)
{
dgvData.DataSource = dt;
}
}
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
lblCompanyName.Visible = true;
Company comp = new Company();
DataTable dt = null;
string companyId = string.IsNullOrEmpty(cbCompany.ValueMember) ? string.Empty : Convert.ToString(((DataRowView)(cbCompany.SelectedItem)).Row[cbCompany.ValueMember]);
if (!string.IsNullOrEmpty(companyId))
{
dt = comp.SelectCompanyById(companyId);
lblCompanyName.Text = dt.Rows[0]["CompanyName"].ToString();
}
}
private void Initialize(bool isPurchase)
{
InitializeComponent();
IsPurchase = isPurchase;
item = new Item();
company = new Company();
customer = new Customer();
if (flag == 3)
{
report = Report.BuyerLedger;
SetReports();
cbReport.SelectedIndex = 3;
}
else if (flag == 2)
{
report = Report.ProductSaleReport;
SetReports();
cbReport.SelectedIndex = 2;
}
else if (flag == 1)
{
report = Report.ProductPurchaseReport;
SetReports();
cbReport.SelectedIndex = 1;
}
else if (flag == 0)
{
report = Report.CustomerSalesReport;
SetReports();
cbReport.SelectedIndex = 0;
}
}
