//public string[] brandValues(string a, string b, string c) {
// string[] brandthings = new string[] {a,b,c };
// return brandthings;
//}
private void brandUBTN_Click(object sender, EventArgs e)
{
int selectedrowindex = dataGridView2.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView2.Rows[selectedrowindex];
string a = Convert.ToString(selectedRow.Cells["brandNameDT"].Value);
sqlCommandAB brandSql = new sqlCommandAB();
int id = brandSql.getSingleValue("SELECT brandID FROM Brand WHERE( categoryName = '" + selectCat.SelectedItem.ToString() + "' AND brandName ='" + a + "')");
if (brandNameTB.Text.Equals(""))
{
MessageBox.Show("Please Enter a Brand Name");
}
else
{
brandSql.updateDB("UPDATE Brand set brandName='" + (string)brandNameTB.Text + "',brandDescription='" + (string)brandDescriptionTB.Text + "' WHERE brandID='" + id + "'");
if (sqlCommandAB.message != null)
{
MessageBox.Show(sqlCommandAB.message + "Couldn't update " + a + "\nDue to netwrok Error, Please check your network and try again");
}
else
{
MessageBox.Show("The brand " + a + " update succefully");
dataGridView2.Rows.Clear();
CategorysAndBrand[] customer;
getBrandData(out customer);
Clear();
}
}
}
private void loggedOut()
{
sqlCommandAB logout = new sqlCommandAB();
int id = logout.getSingleValue("SELECT loginID FROM loginLog ORDER BY loginID DESC");
logout.updateDB("UPDATE loginLog set loginEnd = getDate() WHERE loginID = '" + id + "'");
}
public void updateInv(string pCode, int q)
{
sqlCommandAB upIn = new sqlCommandAB();
int pqtyy = upIn.getSingleValue("SELECT pQty FROM Product WHERE pCode ='" + pCode + "'");
upIn.updateDB("UPDATE Product set pQty =' " + (pqtyy - q) + "' WHERE pCode ='" + pCode + "'");
}
private void updateBTN_Click(object sender, EventArgs e)
{
sqlCommandAB categroySql = new sqlCommandAB();
if (CategoryNameTB.Text == "")
{
MessageBox.Show("Category is Blank");
}
else
{
categroySql.updateDB("UPDATE Category set categoryDescription='" + (string)Category_DescriptionTB.Text + "' WHERE categoryName='" + (string)CategoryNameTB.Text + "'");
if (sqlCommandAB.message != null)
{
MessageBox.Show(sqlCommandAB.message + "Couldn't update " + (string)CategoryNameTB.Text + "\nDue to netwrok Error, Please check your network and try again");
}
else
{
MessageBox.Show("Category Description for " + (string)CategoryNameTB.Text + " update succefully");
dataGridView2.Rows.Clear();
CategorysAndBrand[] customer;
getBrandData(out customer);
Clear();
}
}
}
public void UpdateCustomerAccountLimit()
{
sqlCommandAB upC = new sqlCommandAB();
// upC.updateDB("UPDATE Customers Set Customer_CreditBalance = '" + Convert.ToDouble(TotalCredit) + "' WHERE (Customer_Number ='" + (string)custNumberTB.Text + "')");
upC.updateDB("UPDATE Customer set Customer_CreditLimit ='" + (getCreditB((string)custNumberTB.Text)) + (0.20) * (Convert.ToDouble(TotalCredit)) + "' WHERE Customer_Number = '" + (string)custNumberTB.Text + "'");
// MessageBox.Show(Convert.ToDouble(TotalCredit) + " " + (string)custNumberTB.Text);
}
public void updateCustomerCreditLimit()
{
string cNum = (string)custNumberTB.Text;
double credit = Convert.ToDouble(getCreditB(cNum)) + Convert.ToDouble(amountPaidTB.Text) * 0.20;
sqlCommandAB ab = new sqlCommandAB();
ab.updateDB("UPDATE Customer set Customer_CreditLimit ='" + credit + "' WHERE Customer_Number = '" + cNum + "'");
}
private void updateCredit(double credit, string b)
{
sqlCommandAB ab = new sqlCommandAB();
ab.updateDB("UPDATE Customer set Customer_CreditLimit ='" + credit + "' WHERE Customer_Number = '" + b + "'");
if (sqlCommandAB.message != null)
{
MessageBox.Show("Credit Limit failed to update Customer");
}
else
{
MessageBox.Show("Credit limit set to " + credit);
Clear();
}
}
private void updateBTN_Click(object sender, EventArgs e)
{
String PN = (string)tb_itemName.Text;
Decimal StP = Convert.ToDecimal(tb_itemSellingPrice.Text);
Decimal SP = Convert.ToDecimal(tb_itemStockPrice.Text);
int RP = Convert.ToInt32(ReorderPoint.Text);
int qunti = Convert.ToInt32(qty.Text);
String PD = (string)tb_itemDescription.Text;
// MessageBox.Show("item name " + PN + " sellingPrice " + StP + " Stock Price " + SP + " Reorder point " + RP + " qauntity " + qunti + " Des " + PD + " PCode "+pCode );
sqlCommandAB st = new sqlCommandAB();
st.updateDB("UPDATE Product set pCostPrice = '" + SP + "', pName ='" + PN + "', pSellingPrice ='" + StP + "', pReorderQty ='" + RP + "', pQty ='" + qunti + "', pDescription ='" + PD + "' WHERE pCode = '" + pCode + "'");
// pName = '" + PN + "'
DialogResult dr = MessageBox.Show("Product " + PN.ToString() + " Has Been Updated");
if (dr == DialogResult.OK)
{
Clear();
}
}
public void UpdateStaff(Staff customer)
{
sqlCommandAB brandSql = new sqlCommandAB();
brandSql.updateDB("UPDATE Staff set staff_Cell = '" + customer.cell + "',staff_Remarks='" + customer.remarks + "',staff_Email ='" + customer.email + "', staff_Type='" + customer.type + "' WHERE (staff_Number = '" + customer.staffNumber + "')");
}
public void UpdateNewCustomer(Customer customer)
{
sqlCommandAB brandSql = new sqlCommandAB();
brandSql.updateDB("UPDATE Customer set Customer_Cell = '" + customer.cell + "',Customer_Tel='" + customer.tel + "',Customer_Email ='" + customer.email + "', Customer_Address='" + customer.address + "' WHERE (Customer_Number = '" + customer.username + "')");
}
public void UpdateOrderAmount(Decimal price)
{
sqlCommandAB upo = new sqlCommandAB();
upo.updateDB("UPDATE Orders Set OrderAmount ='" + price + "' WHERE (Order_Number ='" + (string)oNumberTB.Text + "')");
}
public void UpdateOrderDetails()
{
sqlCommandAB upo = new sqlCommandAB();
upo.updateDB("UPDATE Orders Set OrderStatus ='Installment' WHERE (Order_Number ='" + (string)oNumberTB.Text + "')");
}
public void UpdateOrderStatus()
{
sqlCommandAB upo = new sqlCommandAB();
upo.updateDB("UPDATE Orders Set OrderStatus ='Completed' WHERE (Order_Number ='" + (string)oNumberTB.Text + "')");
}
