private void ImportFileData(DataTable dt) { try { Updation update = new Updation(); foreach (DataRow row in dt.Rows) { DataTable dtProductId = retrieve.GetId("usp_GetProductID", row[0].ToString()); //stocks in update.UpdateIncreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[2]), Convert.ToDateTime(row[1])); //stocks out update.UpdateDecreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[3]), Convert.ToDateTime(row[1])); //stock onhold update.UpdateIncreaseInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[4]), Convert.ToDateTime(row[1])); //resolve onhold update.UpdateResolveInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[5]), Convert.ToDateTime(row[1])); //stock rejected update.UpdateIncreaseRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[6]), Convert.ToDateTime(row[1])); //resolve rejected update.UpdateIResolveRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[7]), Convert.ToDateTime(row[1])); //stock reworked update.UpdateIncreaseInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[8]), Convert.ToDateTime(row[1])); //resolve reworked update.UpdateResolveInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[9]), Convert.ToDateTime(row[1])); } MainClass.ShowMessage("Stocks Updated Successfully. ", "Success", "Success"); } catch (Exception exp) { MainClass.ShowMessage(exp.Message, "Error", "Error"); } }
public override void buttonSave_Click(object sender, EventArgs e) { if (dataGridViewSalesLines.Rows.Count > 0) { int SalesID = 0; Insertion insert = new Insertion(); using (TransactionScope tc = new TransactionScope()) { SalesID = insert.SaveSales(Convert.ToInt32(comboBoxCustomer.SelectedValue), Convert.ToDecimal(labelGrandTotalValue.Text), Retrievel.User_ID); int SalesLines = 0; foreach (DataGridViewRow row in dataGridViewSalesLines.Rows) { SalesLines += insert.SaveSalesLine(SalesID, Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ProductTotalPrice"].Value), Convert.ToDecimal(row.Cells["ProductQuantityGv"].Value), row.Cells["Unit"].Value.ToString(), Convert.ToInt32(row.Cells[1].Value)); if (SalesLines > 0) //decrease the stock { Updation update = new Updation(); int rowsDec = update.UpdateDecreaseAvailableStocks(Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ProductQuantityGv"].Value)); } } if (SalesLines > 0) { MainClass.ShowMessage("Sales Invoice Created Successfully.", "Success", "Success"); dataGridViewSalesLines.Rows.Clear(); textBoxSalesNumber.Text = retrieve.RetrunSalesNumber().ToString(); comboBoxCustomer.Text = ""; comboBoxSelectProduct.Text = ""; textBoxUnit.Clear(); textBoxQuantity.Clear(); textBoxProdCost.Clear(); textBoxTotalCost.Clear(); CreateSalesPdfReport(SalesID); labelGrandTotalValue.Text = "0.00"; } else { MainClass.ShowMessage("Unable to create Sales Invoice.", "Error", "Error"); } tc.Complete(); } } }
private void buttonStocksOut_Click(object sender, EventArgs e) { if (comboBoxSelectProduct.SelectedIndex == -1) { labelProductDateError.Visible = true; } else { labelProductDateError.Visible = false; } if (textBoxQuantity.Text == "") { labelQuantityError.Visible = true; } else { labelQuantityError.Visible = false; } if (string.IsNullOrEmpty(dateTimePickerEntryDate.Text)) { labelEntryDateError.Visible = true; } else { labelEntryDateError.Visible = false; } if (labelProductDateError.Visible || labelQuantityError.Visible || labelEntryDateError.Visible) { MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message. } else { Updation update = new Updation(); int row = update.UpdateDecreaseAvailableStocks(Convert.ToInt32(comboBoxSelectProduct.SelectedValue.ToString()), Convert.ToDecimal(textBoxQuantity.Text), dateTimePickerEntryDate.Value); retrieve.ShowStock(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductUnitGv, ProductMinValGv, AvailableStocks, ReworkedStock, RejectedStock, OnholdStock); foreach (DataGridViewRow rows in dataGridViewProduct.Rows) { if (Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value) < Convert.ToDecimal(rows.Cells["AvailableStocks"].Value)) { rows.Cells["ProductNameGv"].Style.BackColor = Color.LightGreen; rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black; rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen; rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; } else { rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed; rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; rows.Cells["ProductNameGv"].Style.BackColor = Color.IndianRed; rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black; } } if (row > 0) { MainClass.ShowMessage("Stocks decreased sucessfully", "Success", "Success"); textBoxQuantity.Clear(); } else { MainClass.ShowMessage("Please add stock of the product first through stock in or receiving.", "Error", "Error"); } } }