private void DeleteBill_Load(object sender, EventArgs e)
{
try
{
System.Drawing.Icon ico = new System.Drawing.Icon("favicon.ico");
this.Icon = ico;
}
catch (Exception ex)
{ }
//Bills
try
{
BillDataSet = DatabaseCalls.GetBills();
CustomerDataSet = DatabaseCalls.GetCustomers();
BillDataSet.Tables[0].Columns.Add("Customer");
for (int loop = 0; loop < BillDataSet.Tables[0].Rows.Count; loop++)
{
for (int loop1 = 0; loop1 < CustomerDataSet.Tables[0].Rows.Count; loop1++)
{
if (CustomerDataSet.Tables[0].Rows[loop1]["ID"].ToString().Equals(BillDataSet.Tables[0].Rows[loop]["Customer_ID"].ToString()) == true)
{
BillDataSet.Tables[0].Rows[loop]["Customer"] = CustomerDataSet.Tables[0].Rows[loop1]["Name"].ToString();
}
}
if (Convert.ToInt32(BillDataSet.Tables[0].Rows[loop]["ID"]) < 0)
{
BillDataSet.Tables[0].Rows[loop].Delete();
}
}
BillDataGridView.DataSource = BillDataSet.Tables[0];
BillDataGridView.CurrentCell = null;
BillDataGridView.Columns[0].HeaderText = "Bill Number";
BillDataGridView.Columns["Customer_ID"].Visible = false;
BillDataGridView.Columns["Customer"].DisplayIndex = 1;
BillDataGridView.Update();
for (int loop = 0; loop < BillDataGridView.Rows.Count; loop++)
{
BillNumberSearch_txt.Items.Add(BillDataGridView.Rows[loop].Cells["ID"].Value);
}
// BillDataGridView.Columns["Customer_ID"].HeaderText = "Customer";
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
System.Drawing.Icon ico = new System.Drawing.Icon("favicon.ico");
this.Icon = ico;
}
catch (Exception ex)
{ }
//Bills
try
{
CustomerDataSet = DatabaseCalls.GetCustomers();
BillDataSet = DatabaseCalls.GetBills();
foreach (DataRow GridViewColumn in BillDataSet.Tables[0].Rows)
{
BillNumberSearch_txt.Items.Add(GridViewColumn.ItemArray[0]);
}
BillDataSet.Tables[0].Columns.Add("Customer");
for (int loop = 0; loop < BillDataSet.Tables[0].Rows.Count; loop++)
{
for (int loop1 = 0; loop1 < CustomerDataSet.Tables[0].Rows.Count; loop1++)
{
if (CustomerDataSet.Tables[0].Rows[loop1]["ID"].ToString().Equals(BillDataSet.Tables[0].Rows[loop]["Customer_ID"].ToString()) == true)
{
// BillDataSet.Tables[0].Rows[loop]["CUSTOMER_BALANCE"] = DatabaseCalls.GetCurrentRowBalance(BillDataSet.Tables[0].Rows[loop]["Customer_ID"].ToString(), BillDataSet.Tables[0].Rows[loop][0].ToString());
BillDataSet.Tables[0].Rows[loop]["Customer"] = CustomerDataSet.Tables[0].Rows[loop1]["Name"].ToString();
break;
}
}
if (Convert.ToInt32(BillDataSet.Tables[0].Rows[loop]["ID"]) < 0)
{
BillDataSet.Tables[0].Rows[loop].Delete();
}
}
BillDataGridView.DataSource = BillDataSet.Tables[0];
BillDataGridView.CurrentCell = null;
BillDataGridView.Columns[0].HeaderText = "Bill Number";
BillDataGridView.Columns["Customer_ID"].Visible = false;
BillDataGridView.Columns["AMOUNT"].Visible = false;
BillDataGridView.Columns["REMARKS"].Visible = false;
//BillDataGridView.Columns["CUSTOMER_BALANCE"].Visible = false;
BillDataGridView.Columns["NAME"].Visible = false;
BillDataGridView.Columns["Customer"].DisplayIndex = 1;
BillDataGridView.Update();
// BillDataGridView.Columns["Customer_ID"].HeaderText = "Customer";
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
////Bills
//try
//{
// DataSet Result2 = new DataSet();
// Result2 = DatabaseCalls.GetBills();
// foreach (DataRow GridViewColumn in Result2.Tables[0].Rows)
// {
// if (Convert.ToInt32(GridViewColumn.ItemArray[0]) > -1)
// {
// BillNumberSearch_txt.Items.Add(GridViewColumn.ItemArray[0]);
// }
// else
// {
// GridViewColumn.Delete();
// }
// }
// BillDataGridView.DataSource = Result2.Tables[0];
// BillDataGridView.Columns[0].HeaderText = "Bill #";
// BillDataGridView.Columns["Customer_ID"].Visible = false;
// //BillNumber_txt.Text = (++Result1).ToString();
//}
//catch (Exception ex)
//{
// Variables.NotificationStatus = true;
//Variables.NotificationMessageTitle = this.Name;
//Variables.NotificationMessageText = ex.Message;
//}
//Customers
try
{
CustomerDataSet = DatabaseCalls.GetCustomers();
//BillDataGridView.DataSource = CustomerDataSet.Tables[0];
//BillDataGridView.Columns[0].Visible = false;
foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
{
CustomerNameSearch_txt.Items.Add(GridViewColumn.ItemArray[1]);
}
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
