private void prtcmb_SelectedIndexChanged(object sender, EventArgs e) { txtSellingPrice.Enabled = true; SellDao selldao = new SellDao(); selldao.GetPartDetails(cbSelectPart.Text, lblSelectedPartName, lblAvailableQuantity, lblDisplayModel, lblDisplayCar, lblDisplayCostPrice); }
private void AddBtn_Click(object sender, EventArgs e) { if (listView1.Items.Count > 0) { SellDao selldao = new SellDao(); SqlConnection Conn = Connection.getConnection(); String query = "Insert INTO Sales(PartNo, SellingPrice, DateSold, CustomerType, PartyId, Qty) VALUES(@PartNo, @SellingPrice, @DateSold, @CustomerType, @PartyId, @Qty)"; using (Conn) { SqlCommand cmd = new SqlCommand(query, Conn); cmd.CommandType = CommandType.Text; Conn.Open(); for (int i = 0; i < listView1.Items.Count; i++) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@PartNo", listView1.Items[i].SubItems[0].Text); cmd.Parameters.AddWithValue("@SellingPrice", decimal.Parse(listView1.Items[i].SubItems[1].Text)); cmd.Parameters.AddWithValue("@DateSold", DateTime.Parse(listView1.Items[i].SubItems[2].Text)); cmd.Parameters.AddWithValue("@CustomerType", listView1.Items[i].SubItems[3].Text); if (listView1.Items[i].SubItems[3].Text.Equals("Customer")) { cmd.Parameters.AddWithValue("@PartyId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@PartyId", int.Parse(listView1.Items[i].SubItems[4].Text)); } cmd.Parameters.AddWithValue("@Qty", int.Parse(listView1.Items[i].SubItems[5].Text)); cmd.ExecuteNonQuery(); selldao.DecreaseQuanity(listView1.Items[i].SubItems[0].Text, int.Parse(listView1.Items[i].SubItems[5].Text)); } } MessageBox.Show("Transaction Done!"); Form1.PublicMainForm.showSales(); Form1.PublicMainForm.DisplayStockEndingAlert(); this.Close(); } else { MessageBox.Show("Select items and payment amount."); } }
private void button1_Click(object sender, EventArgs e) { SellDao salesdao = new SellDao(); if (salesdao.Available(cbSelectPart.Text, int.Parse(txtQty.Text))) { float rowTotal = (int.Parse(txtQty.Text) * float.Parse(txtSellingPrice.Text)); ListViewItem Item = new ListViewItem(cbSelectPart.Text); Item.SubItems.Add(txtSellingPrice.Text); Item.SubItems.Add(cbDate.Text); Item.SubItems.Add(cbCustomerType.Text); if (cbCustomerType.Text.Equals("Customer")) { Item.SubItems.Add(String.Empty); } else { Item.SubItems.Add(cbParty.SelectedValue.ToString()); } Item.SubItems.Add(txtQty.Text); Item.SubItems.Add(rowTotal.ToString()); listView1.Items.AddRange(new ListViewItem[] { Item }); cbSelectPart.ResetText(); txtSellingPrice.Clear(); txtQty.Clear(); float GrandTotal = 0; for (int i = 0; i < listView1.Items.Count; i++) { GrandTotal += float.Parse(listView1.Items[i].SubItems[6].Text); } lblGrandTotal.Text = GrandTotal.ToString(); } else { MessageBox.Show("Requested amount of quanity is not available in the shop."); } }
private void btnAddDept_Click(object sender, EventArgs e) { if (listView1.Items.Count > 0 && txtPayment.Text != "") { DebtDao debtdao = new DebtDao(); debtId = debtdao.InsertDebt(dtpDealDate, lblGrandTotal, txtPayment, cbParty, dtpLastPaymentDate); SellDao selldao = new SellDao(); String query = "INSERT INTO DebtDetails(PartNo, DebtId, Qty, SellPrice) VALUES(@PartNo, @DeptId, @Qty, @SellPrice)"; using (SqlConnection Conn = Connection.getConnection()) { SqlCommand cmd = new SqlCommand(query, Conn); cmd.CommandType = CommandType.Text; Conn.Open(); for (int i = 0; i < listView1.Items.Count; i++) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@PartNo", listView1.Items[i].SubItems[0].Text); cmd.Parameters.AddWithValue("@SellPrice", listView1.Items[i].SubItems[1].Text); cmd.Parameters.AddWithValue("@Qty", listView1.Items[i].SubItems[3].Text); cmd.Parameters.AddWithValue("@DeptId", debtId); cmd.ExecuteNonQuery(); selldao.DecreaseQuanity(listView1.Items[i].SubItems[0].Text, int.Parse(listView1.Items[i].SubItems[3].Text)); } } MessageBox.Show("Debt Transaction Done!"); Form1.PublicMainForm.DisplayStockEndingAlert(); this.Close(); } else { MessageBox.Show("Select items and payment amount."); } }