public void LoadDataToGrid() //Use DAL,Class Create Const,Enum
{
try
{
SqlCommand cmd = new SqlCommand("spLoadBookDataToGrid", con.ActiveCon());
SqlDataAdapter ad = new SqlDataAdapter(cmd); //
ad.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView1.Rows.Add();
dataGridView1["BookId", i].Value = dt.Rows[i]["Book_Id"];
dataGridView1["BookName", i].Value = dt.Rows[i]["Book_Name"];
dataGridView1["BookStatus", i].Value = dt.Rows[i]["Book_Status"];
}
}
catch (Exception ex)
{
BookMasterBL objbook = new BookMasterBL();
objbook.InserToErrorLog("Book", ex.Message.ToString(), "LoadDataToGrid");
}
finally
{
con.CloseCon();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
BookMasterBL objbook = new BookMasterBL();
try
{
BookMaster b = new BookMaster(); //b--->>bookmaster
b.BookId = Convert.ToInt32(txtBookId.Text);
b.BookName = txtBookName.Text;
b.BookStatus = Convert.ToString(cmbStatus.SelectedItem);
objbook.SaveBookMasterdata(b);
MessageBox.Show("Record is Saved...");
}
catch (Exception ex)
{
MessageBox.Show("Record is Not Saved...");
objbook.InserToErrorLog("Book", ex.Message.ToString(), "btnSave_Click");
}
finally
{
}
}
public void LoadDataToGrid(int bookId)
{
BookMasterBL bookBL = new BookMasterBL();
DataTable dt = bookBL.LoadBookDataToGrid(bookId);
dataGridView1.Rows.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView1.Rows.Add();
dataGridView1["BookId", i].Value = dt.Rows[i]["Book_Id"];
dataGridView1["BookName", i].Value = dt.Rows[i]["Book_Name"];
dataGridView1["BookStatus", i].Value = dt.Rows[i]["Book_Status"];
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
BookMasterBL objbook = new BookMasterBL();
try
{
BookMaster b = new BookMaster();
b.BookId = Convert.ToInt32(txtBookId.Text);
objbook.DeleteBookMasterData(b);
MessageBox.Show("Record is Deleted...");
}
catch (Exception ex)
{
MessageBox.Show("Record is Not Deleted...");
objbook.InserToErrorLog("Book", ex.Message.ToString(), "btnDelete_Click");
}
}
public void LoadBookId()
{
int count = 0;
try
{
SqlCommand cmd = new SqlCommand("spCntBookRecords", con.ActiveCon());
count = Convert.ToInt32(cmd.ExecuteScalar());
txtBookId.Text = Convert.ToString(++count);
}
catch (Exception ex)
{
BookMasterBL objbook = new BookMasterBL();
objbook.InserToErrorLog("Book", ex.Message.ToString(), "LoadBookId");
}
finally
{
con.CloseCon();
}
}
