public void getMedicalShopID()
{
BLMedicalShop objMedicalShopDetails = new BLMedicalShop();
DataTable dt = objMedicalShopDetails.getMedicalShopID();
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()))
{
//int a = 1;
//txttransationId.Text = Convert.ToString(a);
}
else
{
//txttransationId.Text = dt.Rows[0][0].ToString();
}
}
}
}
private void Usp_BindMedicalShopGrid()
{
try
{
DataTable dt = new DataTable();
BLMedicalShop objBL = new BLMedicalShop();
dt = objBL.BindFullGrid();
if (dt.Rows.Count > 0)
{
dgvMedicalShop.DataSource = dt;
}
else
{
dgvMedicalShop.DataSource = null;
}
dgvMedicalShop.Refresh();
dgvMedicalShop.Show();
{
dgvMedicalShop.DataSource = dt;
dgvMedicalShop.Columns[0].HeaderCell.Value = "Medical Name";
//dgvMedicalShop.Columns[1].HeaderCell.Value = "Contact Number";
dgvMedicalShop.Columns[1].HeaderCell.Value = "Country Name";
dgvMedicalShop.Columns[2].HeaderCell.Value = "State Name";
dgvMedicalShop.Columns[3].HeaderCell.Value = "City Name";
dgvMedicalShop.Columns[4].HeaderCell.Value = "Area";
dgvMedicalShop.Columns[5].HeaderCell.Value = "Address";
dgvMedicalShop.Columns[6].HeaderCell.Value = "Owner Name";
dgvMedicalShop.Columns[7].HeaderCell.Value = "Contact Number";
dgvMedicalShop.Columns[8].HeaderCell.Value = "Shop Type";
dgvMedicalShop.Columns[9].HeaderCell.Value = "IsActive";
dgvMedicalShop.Columns[9].Visible = false;
dgvMedicalShop.Columns[10].HeaderCell.Value = "IsDelete";
dgvMedicalShop.Columns[10].Visible = false;
dgvMedicalShop.AllowUserToAddRows = false;
dgvMedicalShop.AllowUserToDeleteRows = false;
dgvMedicalShop.Refresh();
dgvMedicalShop.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void dgvMedicalShop_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvMedicalShop.SelectedRows.Count > 0)
{
txtMedicalName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[0].Value);
string ShopName = txtMedicalName.Text;
BLMedicalShop objMedicalShop = new BLMedicalShop();
DataTable dt = objMedicalShop.GetID(ShopName);
if (dt.Rows.Count != 0)
{
lblMedicalShopid.Text = dt.Rows[0]["MedicalShopID"].ToString();
}
// lblMedicalShopid.Text = dgvMedicalShop.SelectedRows[0].Cells["MedicalShopID"].Value.ToString();
txtMedicalName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[0].Value);
cbCountry.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[1].Value);
cbState.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[2].Value);
cbCity.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[3].Value);
txtArea.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[4].Value);
txtAddress.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[5].Value);
txtOwnerName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[6].Value);
txtSellerContactNo.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[7].Value);
cbShopType.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[8].Value);
//dgvMedicalShop.Columns["MedicalShopID"].Visible = false;
string Active= Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[9].Value);
txtOpningBalance.Text=Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[11].Value);
txtOpningBalance.ReadOnly = true;
if (Active == "Yes")
{
cbActive.Checked = true;
}
else
{
cbActive.Checked = false;
}
btnsave.Text = "Update";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
