private void btnSearch_Click(object sender, EventArgs e)
{
List <DatabaseColumn> list = new List <DatabaseColumn>();
CombineDataGridView combineDataGridView = new CombineDataGridView();
if (txtSearch.Text != "")
{
DatabaseColumn databaseColumn = new DatabaseColumn();
Connector connector = new MYSQLDatabaseConnection();
connector.establish();
if (redioBtnCompanyName.Checked == true)
{
databaseColumn.company_name = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCompanyWithName();
combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
}
else if (redioBtnCompanyAddress.Checked == true)
{
databaseColumn.company_address = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCompanyWithAddress();
combineDataGridView.SetDataGridViewList(list, mDgv);
}
else if (redioBtnCompanyPhoneNumber.Checked == true)
{
databaseColumn.company_phone_no = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCompanyWithPhoneNo();
combineDataGridView.SetDataGridViewList(list, mDgv);
}
else if (redioBtnCompanyId.Checked == true)
{
databaseColumn.company_id = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCompanyWithId();
combineDataGridView.SetDataGridViewList(list, mDgv);
}
if (list.Count > 0)
{
txtCompanyAddress.Text = list[0].company_address;
txtCompanyId.Text = list[0].company_id;
txtCompanyName.Text = list[0].company_name;
txtCompanyPhoneNumber.Text = list[0].company_phone_no;
}
else
{
txtCompanyAddress.Clear();
txtCompanyId.Clear();
txtCompanyName.Clear();
txtCompanyPhoneNumber.Clear();
}
}
else
{
combineDataGridView.SetDataGridViewList(list, mDgv);
}
}
private void btnChange_Click(object sender, EventArgs e)
{
if (cmbCompanyName.SelectedItem != null && cmbCategoryName.SelectedItem != null && cmbProductName.SelectedItem != null)
{
Connector connection = new MYSQLDatabaseConnection();
DatabaseColumn dataset = new DatabaseColumn();
dataset.product_id = connection.SearchProductList(tempProductList, cmbProductName.SelectedIndex.ToString()).product_id;
dataset.stock_date = txtStockDate.Text.ToString();
dataset.invoice_number = txtInvoiceNumber.Text.ToString();
dataset.start_quantity = txtQuantity.Text.ToString();
dataset.exp_date = txtExpDate.Text.ToString();
dataset.get_price = txtGetPrice.Text.ToString();
dataset.barcode = barcode;
connection.SetData(dataset);
connection.establish();
if (connection.ChangeStockDetails())
{
List <DatabaseColumn> dgvList = new List <DatabaseColumn>();
dgvList.Add(dataset);
CombineDataGridView combindDataGrid = new CombineDataGridView();
combindDataGrid.SetDataGridViewList(dgvList, dgv);
MessageBox.Show("changed");
}
else
{
MessageBox.Show("can't changed");
}
}
else
{
MessageBox.Show("fill all requred data");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
Connector databaseConnect = new MYSQLDatabaseConnection();
DatabaseColumn databaseColumn = new DatabaseColumn();
databaseColumn.category_name = txtCategoryName.Text.ToString();
databaseColumn.category_id = txtCategoryId.Text.ToString();
databaseConnect.SetData(databaseColumn);
if (databaseConnect.establish() == true && databaseConnect.InsertCategoryDetails() == true)
{
var list = new List <DatabaseColumn>()
{
new DatabaseColumn {
category_name = txtCategoryName.Text.ToString(), category_id = txtCategoryId.Text.ToString()
}
};
CombineDataGridView combineDataGridView = new CombineDataGridView();
combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
txtCategoryId.Clear();
txtCategoryName.Clear();
}
else
{
MessageBox.Show("operation error");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DatabaseColumn databaseColumn = new DatabaseColumn();
List <DatabaseColumn> list = new List <DatabaseColumn>();
CombineDataGridView combineDataGridView = new CombineDataGridView();
if (txtSearch.Text != "")
{
Connector connector = new MYSQLDatabaseConnection();
connector.establish();
if (redioBtnCategoryName.Checked == true)
{
databaseColumn.category_name = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCategoryWithName();
combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
}
else if (redioBtnCategoryId.Checked == true)
{
databaseColumn.category_id = txtSearch.Text.ToString();
connector.SetData(databaseColumn);
list = connector.SearchCategoryWithId();
combineDataGridView.SetDataGridViewList(list, mDgv);
}
if (list.Count > 0)
{
txtCategoryId.Text = list[0].category_id;
txtCategoryName.Text = list[0].category_name;
}
else
{
txtCategoryName.Clear();
txtCategoryId.Clear();
}
}
else
{
txtCategoryName.Clear();
txtCategoryId.Clear();
}
}
private void txtBarcodeValue_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (insertStock.InsertStock())
{
CombineDataGridView datagrid = new CombineDataGridView();
datagrid.SetDataGridViewList(columnList, mDGV);
this.Close();
}
}
}
private void btnAdd_Click_1(object sender, EventArgs e)
{
if (txtDiscount.Text != "" && txtMinimumQuantity.Text != "" && txtProductId.Text != "" && txtProductName.Text != "" && txtSellPrice.Text != "" && cmbCategoryName.Text != "" && cmbCompanyName.Text != "")
{
Connector databaseConnect = new MYSQLDatabaseConnection();
DatabaseColumn databaseColumn = new DatabaseColumn();
CombineDataGridView combineDataGridView = new CombineDataGridView();
List <DatabaseColumn> list = new List <DatabaseColumn>();
/*get data into database column object*/
databaseColumn.product_id = txtProductId.Text.ToString();
databaseColumn.product_name = txtProductName.Text.ToString();
databaseColumn.company_name = cmbCompanyName.Text;
databaseColumn.category_id = databaseConnect.SearchCategoryList(TempCategoryList, cmbCategoryName.Text).category_id;
databaseColumn.category_name = cmbCategoryName.Text;
databaseColumn.company_id = databaseConnect.SearchCompanyList(TempCompanyList, cmbCompanyName.Text).company_id;
databaseColumn.minimum_quantity = txtMinimumQuantity.Text.ToString();
databaseColumn.product_discount_price = txtDiscount.Text.ToString();
databaseColumn.sell_price = txtSellPrice.Text.ToString();
databaseConnect.SetData(databaseColumn);
databaseConnect.establish();
if (databaseConnect.InsertProductDetails() == true)
{
list.Add(databaseColumn);
combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
MessageBox.Show("comlete");
txtDiscount.Clear();
txtMinimumQuantity.Clear();
txtProductId.Clear();
txtProductName.Clear();
txtSellPrice.Clear();
cmbCategoryName.Text = "";
cmbCompanyName.Text = "";
}
else
{
MessageBox.Show("operation error");
}
}
else
{
MessageBox.Show("Fill all deteils");
}
}
private void btnChange_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you Sure update product details?", "Veryfy", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Connector connector = new MYSQLDatabaseConnection();
/*catch update details into databaseColumn*/
DatabaseColumn updateDatabaseColumn = new DatabaseColumn();
updateDatabaseColumn.company_id = connector.SearchCompanyList(TempCompanyList, cmbCompanyName.SelectedItem.ToString()).company_id;
updateDatabaseColumn.category_id = connector.SearchCategoryList(TempCategoryList, cmbCategoryName.SelectedItem.ToString()).category_id;
updateDatabaseColumn.product_id = txtProductId.Text.ToString();
updateDatabaseColumn.product_name = txtProductName.Text;
updateDatabaseColumn.sell_price = txtSellPrice.Text;
updateDatabaseColumn.product_discount_price = txtDiscount.Text;
updateDatabaseColumn.minimum_quantity = txtMinimumQuantity.Text;
List <DatabaseColumn> TempListForDGV = new List <DatabaseColumn>();
TempListForDGV.Add(updateDatabaseColumn);
connector.establish();
connector.SetData(updateDatabaseColumn);
if (connector.ChangeProductDetails() == true)
{
CombineDataGridView combineDataGridView = new CombineDataGridView();
combineDataGridView.SetDataGridViewList(TempListForDGV, mDgv);
MessageBox.Show("Update compliete");
txtDiscount.Clear();
txtMinimumQuantity.Clear();
txtProductId.Clear();
txtProductName.Clear();
txtSellPrice.Clear();
}
else
{
MessageBox.Show("Try again");
}
}
}
private void button1_Click(object sender, EventArgs e)
{ // Add company details into database
DatabaseColumn databaseColumn = new DatabaseColumn();
Connector connector = new MYSQLDatabaseConnection();
databaseColumn.company_name = txtCompayName.Text.ToString();
databaseColumn.company_phone_no = txtCompanyPhoneNumber.Text.ToString();
databaseColumn.company_address = txtCompanyAddress.Text.ToString();
databaseColumn.company_id = txtCompanyId.Text.ToString();
connector.SetData(databaseColumn);
if (connector.establish() == true && connector.InsertCompanyDetails() == true)
{
//create database column list with data
var list = new List <DatabaseColumn>()
{
new DatabaseColumn {
company_name = txtCompayName.Text.ToString(), company_phone_no = txtCompanyPhoneNumber.Text.ToString(), company_address = txtCompanyAddress.Text.ToString(), company_id = txtCompanyId.Text.ToString()
}
};
CombineDataGridView combineDataGridView = new CombineDataGridView();
combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
MessageBox.Show("Compleat");
txtCompanyPhoneNumber.Clear();
txtCompayName.Clear();
txtCompanyAddress.Clear();
txtCompanyId.Clear();
}
else
{
MessageBox.Show("operation error");
}
}