private void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtItemID.Text) || string.IsNullOrWhiteSpace(txtQuty.Text) || string.IsNullOrWhiteSpace(txtDiscount.Text))
{
MyDialog.Show("Error...!", "All Fields should be filled");
}
else
{
int selectedrowindex = ItemsdataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = ItemsdataGrid.Rows[selectedrowindex];
string ItemID = Convert.ToString(selectedRow.Cells[0].Value);
string description = Convert.ToString(selectedRow.Cells[2].Value);
string unitPrice = Convert.ToString(selectedRow.Cells[5].Value);
string Quntity = Convert.ToString(selectedRow.Cells[4].Value);
float QuntityF = float.Parse(Quntity);
float unitprice1 = float.Parse(unitPrice);
float fQuntity = float.Parse(txtQuty.Text);
float TOt = unitprice1 * fQuntity;
float Discount = float.Parse(txtDiscount.Text);
if (fQuntity > QuntityF)
{
MyDialog.Show("Error...!", "Invalid Quantity");
resetFields1();
}
else if (Discount >= TOt)
{
MyDialog.Show("Error...!", "Invalid Discount Amount");
resetFields1();
}
else
{
float total = float.Parse(totalLabel.Text);
total = total + unitprice1 * float.Parse(txtQuty.Text) - float.Parse(txtDiscount.Text);
totalLabel.Text = Convert.ToString(total);
string SalsItemID = CodeGenerator.generateSalesItemCode();
string SalsID = CodeGenerator.generateSalescode();
if (SalesdataGrid.Rows.Count == 0)
{
QuntityF = QuntityF - float.Parse(txtQuty.Text);
updateStocks(ItemID, QuntityF);
lodesalesItem(SalsItemID, ItemID, SalsID, description, txtQuty.Text, txtDiscount.Text, unitPrice, "0");
int selectedrowindex1 = SalesdataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow1 = SalesdataGrid.Rows[selectedrowindex1];
ItemID1 = Convert.ToString(selectedRow1.Cells[0].Value);
resetFields1();
}
else
{
int selectedrowindex1 = SalesdataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow1 = SalesdataGrid.Rows[selectedrowindex1];
ItemID1 = Convert.ToString(selectedRow1.Cells[0].Value);
String XItemID1 = Convert.ToString(selectedRow1.Cells[1].Value);
String sDescount = Convert.ToString(selectedRow1.Cells[5].Value);
String Squntity = Convert.ToString(selectedRow1.Cells[4].Value);
float SFQuntity = float.Parse(Squntity);
float SFDescount = float.Parse(sDescount);
float RealQuntity = SFQuntity + float.Parse(txtQuty.Text);
float RealDescount = SFDescount + float.Parse(txtDiscount.Text);
float QuntityF1 = float.Parse(Quntity);
QuntityF1 = QuntityF1 - float.Parse(txtQuty.Text);
if (ItemID == XItemID1)
{
selectedRow1.Cells[4].Value = Convert.ToString(RealQuntity);
selectedRow1.Cells[5].Value = Convert.ToString(RealDescount);
updateStocks(ItemID, QuntityF1);
}
else
{
String NUMBER_FORMAT = "{0:D4}";
string SalsItemID1 = ItemID1.Substring(2);
string SalesItemid = ("SI" + String.Format(NUMBER_FORMAT, (Convert.ToInt32(SalsItemID1) + 1)));
updateStocks(ItemID, QuntityF1);
lodesalesItem(SalesItemid, ItemID, SalsID, description, txtQuty.Text, txtDiscount.Text, unitPrice, "0");
resetFields1();
}
}
SalesdataGrid.Sort(SalesdataGrid.Columns["ItemID"], ListSortDirection.Descending);
SalesdataGrid.Rows[0].Selected = true;
}
}
}
public void loadData()
{
Database db = new Database();
db.openConnection();
String q1 = "SELECT * FROM rental_details";
db.sqlQuery(q1);
DataTable dt = db.executeQuery();
bunifuCustomDataGrid1.DataSource = dt;
for (int i = 0; i < bunifuCustomDataGrid1.Columns.Count; i++)
{
bunifuCustomDataGrid1.Columns[i].Visible = false;
}
bunifuCustomDataGrid1.Columns[0].Visible = true;
bunifuCustomDataGrid1.Columns[0].HeaderText = "Rent ID";
bunifuCustomDataGrid1.Columns[1].Visible = true;
bunifuCustomDataGrid1.Columns[1].HeaderText = "Customer ID";
bunifuCustomDataGrid1.Columns[2].Visible = true;
bunifuCustomDataGrid1.Columns[2].HeaderText = "Vehicle ID";
bunifuCustomDataGrid1.Columns[3].Visible = true;
bunifuCustomDataGrid1.Columns[3].HeaderText = "Rent Date";
bunifuCustomDataGrid1.Columns[4].Visible = true;
bunifuCustomDataGrid1.Columns[4].HeaderText = "Return Date";
bunifuCustomDataGrid1.Columns[5].Visible = true;
bunifuCustomDataGrid1.Columns[5].HeaderText = "Minimum Deposit";
//get customer id's to combo box
String q2 = "SELECT c_code FROM customers";
db.sqlQuery(q2);
DataTable table = db.executeQuery();
// select distinct valuves to the combo box
IList <string> list1 = new List <string>();
foreach (DataRow dr in table.Rows)
{
list1.Add("Select Customer");
list1.Add(dr["c_code"].ToString());
}
list1 = list1.Distinct().ToList();
cmb_cus_id.DataSource = list1;
//get Available Vehicle's to combo box
String q3 = "SELECT rv_id FROM rental_vehicle WHERE rv_status = 'Available'";
db.sqlQuery(q3);
DataTable table1 = db.executeQuery();
// select distinct valuves to the combo box
IList <string> list = new List <string>();
foreach (DataRow dr in table1.Rows)
{
list.Add("Select A Vehicle");
list.Add(dr["rv_id"].ToString());
}
list = list.Distinct().ToList();
cmb_vehicle_id.DataSource = list;
db.closeConnection();
btn_update.Visible = false;
btn_remove.Visible = false;
btn_add.Enabled = true;
clear();
txt_rnt_id.Text = CodeGenerator.generateRentalDetailsCode();
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtName.Text) && string.IsNullOrWhiteSpace(txtAddress.Text) && string.IsNullOrWhiteSpace(txttelephone.Text))
{
MyDialog.Show("Error...!", "Please fill Personal details");
}
else
{
if (txtName.Enabled)
{
String Cus_id = CodeGenerator.generateSalescustomercode();
string query = "INSERT INTO salescustomer VALUES('" + Cus_id + "','" + txtName.Text + "','" + txtAddress.Text + "','" + txtAddress.Text + "')";
Database db = new Database();
db.openConnection();
db.sqlQuery(query);
if (db.nonQuery())
{
MyDialog.Show("Success...!", "Customer added");
}
else
{
MyDialog.Show("Error...!", "Customer not added");
}
string SalesID = CodeGenerator.generateSalescode();
string query1 = "INSERT INTO sales VALUES('" + SalesID + "','" + Cus_id + "','" + totalLabel.Text + "','" + DateTime.Now + "')";
db.sqlQuery(query1);
if (db.nonQuery())
{
MyDialog.Show("Success...!", "Sales added");
}
else
{
MyDialog.Show("Error...!", "Sales not added");
}
}
else
{
String CusID = getCusID(txtName.Text);
string SalesID = CodeGenerator.generateSalescode();
string query1 = "INSERT INTO sales VALUES('" + SalesID + "','" + CusID + "','" + totalLabel.Text + "','" + DateTime.Now + "')";
Database db = new Database();
db.openConnection();
db.sqlQuery(query1);
if (db.nonQuery())
{
MyDialog.Show("Success...!", "Sales added");
}
else
{
MyDialog.Show("Error...!", "Sales notadded");
}
}
for (int i = 0; i < SalesdataGrid.Rows.Count; i++)
{
string SIid = SalesdataGrid.Rows[i].Cells[0].Value.ToString();
string Stockid = SalesdataGrid.Rows[i].Cells[1].Value.ToString();
string Salesid = SalesdataGrid.Rows[i].Cells[2].Value.ToString();
string Description = SalesdataGrid.Rows[i].Cells[3].Value.ToString();
float Quntity = float.Parse(SalesdataGrid.Rows[i].Cells[4].Value.ToString());
float Discount = float.Parse(SalesdataGrid.Rows[i].Cells[5].Value.ToString());
float price = float.Parse(SalesdataGrid.Rows[i].Cells[6].Value.ToString());
int rncount = Convert.ToInt32(SalesdataGrid.Rows[i].Cells[7].Value.ToString());
Database db = new Database();
db.openConnection();
string query = "INSERT INTO sales_items(item_id,stock_id,sales_id,description,quantity,discount,price,return_cnt) VALUES('" + SIid + "','" + Stockid + "','" + Salesid + "','" + Description + "','" + Quntity + "','" + Discount + "','" + price + "','" + rncount + "')";
db.sqlQuery(query);
if (db.nonQuery())
{
MyDialog.Show("Success...!", "Sale Item added");
}
else
{
MyDialog.Show("Error...!", "Sale Item not added");
}
}
new Sales_Bill().Show();
totalLabel.Text = "0.0";
}
}
