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.");
}
}
