protected void SaveDepartmentDetails()
{
if (txtDepartmentName.Text != "")
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("INSERT INTO Department (DepartmentName) VALUES(@name)", con);
cmd.Parameters.AddWithValue("@name", txtDepartmentName.Text);
con.Open();
int rowCount = cmd.ExecuteNonQuery();
if (rowCount > 0)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con);
DataTable dt = new DataTable();
da.Fill(dt);
GrdViewDepartment.DataSource = dt;
GrdViewDepartment.DataBind();
}
}
}
}
protected void UpdateDepartmentDetails()
{
if (txtDepartmentName.Text != "")
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("UPDATE Department SET DepartmentName = @name WHERE DepartmentID = @id", con);
cmd.Parameters.AddWithValue("@name", txtDepartmentName.Text);
cmd.Parameters.AddWithValue("@id", ViewState["id"]);
con.Open();
int rowCount = cmd.ExecuteNonQuery();
if (rowCount > 0)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con);
DataTable dt = new DataTable();
da.Fill(dt);
GrdViewDepartment.DataSource = dt;
GrdViewDepartment.DataBind();
}
}
ClearControls();
}
Response.RedirectToRoute("DepartmentDetails");
}
private void ViewAllDepartment()
{
if (GrdViewDepartment.Rows.Count < 1)
{
GrdViewDepartment.EmptyDataText = "There is no Department to view.";
}
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con);
con.Open();
DataTable dt = new DataTable();
da.Fill(dt);
GrdViewDepartment.DataSource = dt;
GrdViewDepartment.DataBind();
}
}
