private void btnAdd_Click(object sender, EventArgs e)
{
String stockid, bookid, bookname, price, quantity, selPrice;
String format = "0000000";
Boolean isValid = true;
for (int i = 0; i < bookListView.Items.Count; i++)
{
bookid = bookListView.Items[i].SubItems[0].Text;
bookname = bookListView.Items[i].SubItems[1].Text;
price = bookListView.Items[i].SubItems[2].Text;
quantity = bookListView.Items[i].SubItems[3].Text;
selPrice = bookListView.Items[i].SubItems[4].Text;
if (selPrice.Equals("0"))
{
SetSellprice setsell = new SetSellprice(this);
setsell.txtBook.Text = bookname;
setsell.txtPurPrice.Text = price;
setsell.index = i;
isValid = false; //
setsell.Show();
}
if (isValid)
{
stockid = "S" + (int.Parse(bookid.Substring(1, (bookid.Length - 1))).ToString(format));
String strQty = "SELECT BOOK_QTY FROM STOCK WHERE BOOK_ID = '" + bookid + "'";
SqlDataAdapter daQty = new SqlDataAdapter(strQty, consql);
DataSet dsQty = new DataSet();
daQty.Fill(dsQty, "QTY");
DataTable dtQty = dsQty.Tables["QTY"];
String addStock;
if (dtQty.Rows.Count > 0)
{
quantity = (int.Parse(quantity) + int.Parse(dtQty.Rows[0].ItemArray[0].ToString())).ToString();
addStock = "UPDATE STOCK SET BOOK_QTY ='" + quantity + "' WHERE BOOK_ID ='" + bookid + "'";
}
else
{
addStock = "INSERT INTO STOCK VALUES('" + stockid + "','" + bookid + "','" + quantity + "','" + selPrice + "','" + CommonConstant.CREATED_BY + "','" + DateTime.Now + "','" + DateTime.Now + "')";
}
SqlCommand stockcmd = new SqlCommand(addStock, consql);
stockcmd.ExecuteNonQuery();
MessageBox.Show("FINISH");
stocklist.refreshform();
String updateOrder = "UPDATE PURCHASE_ORDER SET ORDER_STATUS = 'Done' WHERE ORDER_ID = '" + cbOrderid.Text + "'";
SqlCommand upOrderstatus = new SqlCommand(updateOrder, consql);
upOrderstatus.ExecuteNonQuery();
this.Close();
}
}
}
private void btnSet_Click(object sender, EventArgs e)
{
if (stocklist == null)
{
String sellPrice;
Boolean isValid = true;
sellPrice = txtSellprice.Text;
if (sellPrice.Equals("0"))
{
MessageBox.Show("Enter Sell Price !");
isValid = false;
}
if (isValid)
{
stockadd.bookListView.Items[index].SubItems[4].Text = sellPrice;
}
this.Close();
}
else
{
String sellPrice;
Boolean isValid = true;
sellPrice = txtSellprice.Text;
if (sellPrice.Equals("0") || sellPrice.Equals(null))
{
MessageBox.Show("Enter Sell Price !");
isValid = false;
}
if (isValid)
{
connection();
String changePrice = "UPDATE STOCK SET SELL_PRICE ='" + sellPrice + "' WHERE BOOK_ID ='" + bookid + "'";
SqlCommand changePricecmd = new SqlCommand(changePrice, consql);
changePricecmd.ExecuteNonQuery();
stocklist.refreshform();
MessageBox.Show("FINISH");
this.Close();
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
connection();
String stockid, bookid, quantity, sellprice, strStock;
String format = "0000000";
bookid = dtODT.Rows[cbOrderdetail.SelectedIndex][4].ToString();
stockid = "S" + (int.Parse(bookid.Substring(1, (bookid.Length - 1))).ToString(format));
quantity = txtQty.Text;
sellprice = txtSellprice.Text;
String test = "SELECT BOOK_ID,BOOK_QTY FROM STOCK WHERE STOCK_ID = '" + stockid + "'";
SqlDataAdapter daTest = new SqlDataAdapter(test, consql);
DataSet dsTest = new DataSet();//DataSet For OrderDetail
daTest.Fill(dsTest, "Test");
DataTable dtTest = new DataTable();
dtTest = dsTest.Tables["Test"];
int i = dtTest.Rows.Count;
if (i == 0)
{
strStock = "INSERT INTO STOCK VALUES('" + stockid + "','" + bookid + "','" + quantity + "','" + CommonConstant.CREATED_BY + "','" + DateTime.Now + "','" + DateTime.Now + "')";
}
else
{
int qty = int.Parse(dtTest.Rows[0][1].ToString());
quantity = (int.Parse(quantity) + qty).ToString();
strStock = "UPDATE STOCK SET BOOK_QTY ='" + quantity + "'";
}
SqlCommand stockCmd = new SqlCommand(strStock, consql);
stockCmd.ExecuteNonQuery();
MessageBox.Show("FINISH");
stocklist.refreshform();
this.Close();
}
