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;
}
}
