private void btnAdd_Click(object sender, EventArgs e) { try { if (Validate()) { BLSaleTransaction obj_Sale = new BLSaleTransaction(); if (temp == 1) { int SaleTransactionID = 0; int MedicalShopID = Convert.ToInt32(cbMedical.SelectedValue); MedID = MedicalShopID; int UpdatedByUserID = 2; //DateTime dt = Convert.ToDateTime(dtpDate.Text); string SaleDate = dtpDate.Text; string SaleTransactionNo = txtSaleTranNo.Text; double DiscountAmount = 0;//Convert.ToDouble(txtDiscount.Text); double BalanceAmount = 0;//Total - DiscountAmount; string Result = obj_SaleTransaction.SaveSaleTransaction(SaleTransactionID, SaleTransactionNo, MedicalShopID, SaleDate, UpdatedByUserID, DiscountAmount, BalanceAmount);// WarehouseID, if (Convert.ToInt32(Result) > 0) { rst = Convert.ToInt32(Result); btnSave.Enabled = true; //cbWarehouse.Enabled = false; dtpDate.Enabled = false; cbMedical.Enabled = false; temp = 2; } else { MessageBox.Show("Record Not Added"); } } int WarehouseID = Convert.ToInt32(cbWarehouse.SelectedValue); int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString()); double SellingPrice = Convert.ToDouble(txtSellingPrice.Text); double Quantity = Convert.ToDouble(txtQuantity.Text); double Discount = 0;// Convert.ToDouble(txtDiscount.Text); string result = obj_SaleTransaction.SaveSaleRecord(ProductID, Quantity, SellingPrice, Discount, rst, WarehouseID); //Total = Total + (Quantity * SellingPrice); //txtTotal.Text = Total.ToString(); Usp_BindSellTransactionGrid(rst); DataTable dt2= obj_SaleTransaction.GetTempTotal(rst); txtTotal.Text = dt2.Rows[0]["Total"].ToString(); Total = Convert.ToDouble(txtTotal.Text); DataTable dtQty = obj_SaleTransaction.GetQtySumForManagerSaleTrans(rst, ProductID,WarehouseID); if (dtQty.Rows.Count > 0) { TotQty = Convert.ToInt32(dtQty.Rows[0][0]); } clearFields(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void Usp_BindSellTransactionGrid(int SaleTransactionID) { DataTable dt = new DataTable(); BLSaleTransaction objBL = new BLSaleTransaction(); dt = objBL.BindFullGrid(SaleTransactionID); if (dt.Rows.Count > 0) { dgvSellTransaction.DataSource = dt; dgvSellTransaction.Refresh(); dgvSellTransaction.Show(); dgvSellTransaction.Columns["ProductID"].Visible = false; dgvSellTransaction.Columns["Discount"].Visible = false; dgvSellTransaction.AllowUserToAddRows = false; dgvSellTransaction.AllowUserToDeleteRows = false; } }
public void getSellTransactionID() { BLSaleTransaction objSellTransactionDetails = new BLSaleTransaction(); DataTable dt = objSellTransactionDetails.getSellTransactionID(); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { if (string.IsNullOrEmpty(dt.Rows[i][j].ToString())) { } else { } } } }
private void Usp_BindSellTransactionGrid() { DataTable dt = null; BLSaleTransaction objBL = new BLSaleTransaction(); dt = objBL.BindFullGrid(); if (dt.Rows.Count > 0) { dgvSellTransaction.DataSource = dt; dgvSellTransaction.Refresh(); dgvSellTransaction.Show(); } }
private void dgvSellTransaction_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgvSellTransaction.SelectedRows.Count > 0) { cmbMedical.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[0].Value); cmbDoctor.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[1].Value); cmbProduct.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[2].Value); int Medical = Convert.ToInt32(cmbMedical.SelectedValue); int doctor = Convert.ToInt32(cmbDoctor.SelectedValue); int product = Convert.ToInt32(cmbProduct.SelectedValue); string Product = cmbProduct.Text; BLSaleTransaction objSellTransaction = new BLSaleTransaction(); DataTable dt = objSellTransaction.GetSaleTransactionID(Medical,doctor,product); if (dt.Rows.Count != 0) { lblSellTranid.Text = dt.Rows[0]["SalesTransactionID"].ToString(); } txtSellingPrice.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[3].Value); dtpDate.Text =Convert.ToString( dgvSellTransaction.SelectedRows[0].Cells[4].Value); txtPreviousStock.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[5].Value); txtUpdateStock.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[6].Value); cbCountry.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[7].Value); cbState.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[8].Value); cbCity.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[9].Value); txtArea.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[10].Value); string IsActive = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[11].Value); if (IsActive == "Yes") { chkActive.Checked = true; } else { chkActive.Checked = false; } btnSave.Text = "Update"; } }
private void Usp_BindSellTransactionGrid(int SaleTransactionID) { DataTable dt = new DataTable(); BLSaleTransaction objBL = new BLSaleTransaction(); dt = objBL.BindFullGrid(SaleTransactionID); if (dt.Rows.Count > 0) { dgvSellTransaction.DataSource = dt; //dgvSellTransaction.Columns[0].HeaderCell.Value = "Medical Name"; ////dgvSellTransaction.Columns[1].HeaderCell.Value = "Doctor Name"; //dgvSellTransaction.Columns[2].HeaderCell.Value = "Product Name"; //dgvSellTransaction.Columns[3].HeaderCell.Value = "Selling Price"; //dgvSellTransaction.Columns[4].HeaderCell.Value = "Date"; //dgvSellTransaction.Columns[5].HeaderCell.Value = "Quantity"; //dgvSellTransaction.Columns[6].HeaderCell.Value = "Warehouse"; ////dgvSellTransaction.Columns[7].HeaderCell.Value = "Country"; ////dgvSellTransaction.Columns[8].HeaderCell.Value = "State"; ////dgvSellTransaction.Columns[7].HeaderCell.Value = "City"; ////dgvSellTransaction.Columns[8].HeaderCell.Value = "Area"; dgvSellTransaction.Refresh(); dgvSellTransaction.Show(); dgvSellTransaction.Columns["ProductID"].Visible = false; dgvSellTransaction.Columns["WarehouseID"].Visible = false; dgvSellTransaction.Columns["Discount"].Visible = false; dgvSellTransaction.AllowUserToAddRows = false; dgvSellTransaction.AllowUserToDeleteRows = false; } else { dgvSellTransaction.DataSource = null; dgvSellTransaction.Refresh(); dgvSellTransaction.Show(); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (Validate()) { BLSaleTransaction obj_Sale = new BLSaleTransaction(); if (temp == 1) { int SaleTransactionID = 0; int MedicalShopID = Convert.ToInt32(cbMedical.SelectedValue); MedID = MedicalShopID; int UpdatedByUserID = 1; //DateTime dt = Convert.ToDateTime(dtpDate.Text); string SaleDate = dtpDate.Text; string SaleTransactionNo = txtSaleTranNo.Text; double DiscountAmount = 0;//Convert.ToDouble(txtDiscount.Text); double BalanceAmount = 0;//Total - DiscountAmount; string Result = obj_SaleTransaction.SaveSaleTransaction(SaleTransactionID, SaleTransactionNo, MedicalShopID, SaleDate, UpdatedByUserID, DiscountAmount, BalanceAmount);// WarehouseID, if (Convert.ToInt32(Result) > 0) { rst = Convert.ToInt32(Result); btnSave.Enabled = true; // cbWarehouse.Enabled = false; dtpDate.Enabled = false; cbMedical.Enabled = false; temp = 2; } else { MessageBox.Show("Record Not Added"); } } int WarehouseID = Convert.ToInt32(cbWarehouse.SelectedValue); int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString()); double SellingPrice = Convert.ToDouble(txtSellingPrice.Text); double Quantity = Convert.ToDouble(txtQuantity.Text); double Discount = 0;// Convert.ToDouble(txtDiscount.Text); //string IsActive = "Yes"; //string IsDelete = "No"; string result = obj_SaleTransaction.SaveSaleRecord(ProductID, Quantity, SellingPrice, Discount, rst, WarehouseID); //if (result == "1") //{ // MessageBox.Show("Transactions Saved Successfully..."); Total = Total + (Quantity * SellingPrice); txtTotal.Text = Total.ToString(); Usp_BindSellTransactionGrid(rst); DataTable dtQty = obj_SaleTransaction.GetQtySumForManagerSaleTrans(rst, ProductID,WarehouseID); if (dtQty.Rows.Count > 0) { TotQty = Convert.ToInt32(dtQty.Rows[0][0]); } clearFields(); //} //else //{ // //MessageBox.Show("This Product Name is Already Exits"); //} //clearFields(); //} //else //{ // int SalesTransactionID = Convert.ToInt32(lblSaleTranID.Text); // int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString()); // double SellingPrice = Convert.ToDouble(txtSellingPrice.Text); // double Quantity = Convert.ToDouble(txtQuantity.Text); // string IsActive = "Yes"; // string IsDelete = "No"; // string result = obj_SaleTransaction.saveSaleTransaction(SalesTransactionID, ProductID, SellingPrice, Quantity, IsActive, IsDelete); // if (result == "1") // { // MessageBox.Show("Record Updated successfully..."); // Usp_BindSellTransactionGrid(); // clearFields(); // lblSaleTranID.Text = ""; // } // btnAdd.Text = "Save"; //} } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }