private void Usp_BindReturnSaleTransactionGrid(int SalesReturnID) { DataTable dt = new DataTable(); BLReturnSales objBL = new BLReturnSales(); dt = objBL.BindFullGrid(SalesReturnID); if (dt.Rows.Count > 0) { dgvReturnSales.DataSource = dt; dgvReturnSales.Refresh(); dgvReturnSales.Show(); dgvReturnSales.Columns["ProductID"].Visible = false; dgvReturnSales.AllowUserToAddRows = false; dgvReturnSales.AllowUserToDeleteRows = false; dgvReturnSales.AllowUserToAddRows = false; dgvReturnSales.AllowUserToDeleteRows = false; } }
private void bindgridDmp() { try { DataTable dt = null; BLReturnSales objBL = new BLReturnSales(); dt = objBL.BindFullGrid(); if (dt.Rows.Count > 0) { dgvReturnSales.DataSource = dt; } else { dgvReturnSales.DataSource = null; } dgvReturnSales.Refresh(); dgvReturnSales.Show(); { dgvReturnSales.DataSource = dt; dgvReturnSales.Columns[0].HeaderCell.Value = "Medical Name "; dgvReturnSales.Columns[1].HeaderCell.Value = "Product Name"; dgvReturnSales.Columns[2].HeaderCell.Value = "Return Quantity"; dgvReturnSales.Columns[3].HeaderCell.Value = "Return Date"; dgvReturnSales.Columns[4].HeaderCell.Value = "Reason"; dgvReturnSales.Refresh(); dgvReturnSales.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnAdd_Click(object sender, EventArgs e) { try { Setparameter(); if (Validate()) { BLReturnSales obj_Ret = new BLReturnSales(); if (temp == 1) { SalesReturnID = 0; string result = obj_ReturnSales.saveReturnSales(SalesReturnID, ReturnInvoiceNo1, MedicalID, ReturnDate, UpdatedByUserID, WarehouseID, Comment); if (Convert.ToInt32(result) > 0) { btnSave.Enabled = true; dtpdate.Enabled = false; cbWarehouse.Enabled = false; cbMedicalShop.Enabled = false; txtComment.Enabled = false; temp = 2; } MaxSalesReturnID = Convert.ToInt32(result); } string Result = obj_ReturnSales.SaveReturnSalesRecord(ProductID, Quantity, MaxSalesReturnID, Reason, Rate); Usp_BindReturnSaleTransactionGrid(MaxSalesReturnID); txtQuantity.Text = ""; txtReason.Text = ""; txtRate.Text = ""; txtCurrentStock.Text = ""; cbProduct.SelectedValue = "0"; DataTable dtQty = obj_ReturnSales.GetQuantitySum(MaxSalesReturnID, MedicalID, ProductID); if (dtQty.Rows.Count > 0) { TotQty = Convert.ToInt32(dtQty.Rows[0][0]); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void Usp_BindReturnSaleTransactionGrid(int SalesReturnID) { DataTable dt = new DataTable(); BLReturnSales objBL = new BLReturnSales(); dt = objBL.BindFullGrid(SalesReturnID); if (dt.Rows.Count > 0) { dgvReturnSales.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"; dgvReturnSales.Refresh(); dgvReturnSales.Show(); dgvReturnSales.Columns["ProductID"].Visible = false; dgvReturnSales.AllowUserToAddRows = false; dgvReturnSales.AllowUserToDeleteRows = false; } }