protected void saveFacultyButton_Click(object sender, EventArgs e)
{
AddFacultyModel addFacultyModel = new AddFacultyModel();
addFacultyModel.Name = facultyNameTextBox.Text;
if (addFacultyBll.IsDepartNameExist(addFacultyModel))
{
failStatusLabel.InnerText = "Faculty name already exist";
successStatusLabel.InnerText = "";
}
else
{
if (addFacultyBll.SaveDepartmentName(addFacultyModel)>0)
{
successStatusLabel.InnerText = "Faculty name saved";
GetAllFaculty();
failStatusLabel.InnerText = "";
}
else
{
successStatusLabel.InnerText = "";
failStatusLabel.InnerText = "Faculty name not saved.Try again";
}
}
}
public int DeleteFaculty(AddFacultyModel addFacultyModel)
{
string query = String.Format("Delete from tblFaculty where facultyName=@facultyName1");
sqlCommand.CommandText = query;
SqlParameter facultyName1Parameter = new SqlParameter("@facultyName1",addFacultyModel.Name);
sqlCommand.Parameters.Add(facultyName1Parameter);
sqlConnection.Open();
int rowsDelated = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return rowsDelated;
}
public List<AddFacultyModel> GetAllFacultyName()
{
List<AddFacultyModel> addFacultyModels = new List<AddFacultyModel>();
string query = String.Format("Select * from tblFaculty");
sqlCommand.CommandText = query;
sqlConnection.Open();
SqlDataReader rdr = sqlCommand.ExecuteReader();
while (rdr.Read())
{
AddFacultyModel addFacultyModel = new AddFacultyModel();
addFacultyModel.ID = Convert.ToInt32(rdr[0]);
addFacultyModel.Name = rdr[1].ToString();
addFacultyModels.Add(addFacultyModel);
}
sqlConnection.Close();
return addFacultyModels;
}
public bool IsFacultyNameExist(AddFacultyModel addFacultyModel)
{
bool isFacultyNameExist = false;
string query = String.Format("Select * from tblFaculty where facultyName=@facultyName");
SqlParameter nameParameter = new SqlParameter("@facultyName",addFacultyModel.Name);
sqlCommand.Parameters.Add(nameParameter);
sqlCommand.CommandText = query;
sqlConnection.Open();
SqlDataReader rdr = sqlCommand.ExecuteReader();
while (rdr.Read())
{
isFacultyNameExist = true;
}
sqlConnection.Close();
return isFacultyNameExist;
}
protected void facultyGridview_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//DataTable sourceData = (DataTable)facultyGridview.DataSource;
//sourceData.Rows[e.RowIndex].Delete();
//facultyGridview.DataSource = sourceData;
//facultyGridview.DataBind();
// string deptName = facultyGridview.SelectedRow.Cells[1].Text;
//int categoryID = (int)GridView1.DataKeys[e.RowIndex].Value;
//DeleteRecordByID(categoryID);
AddFacultyModel addFacultyModel = new AddFacultyModel();
addFacultyModel.Name = facultyGridview.DataKeys[e.RowIndex].Value.ToString();
if (addFacultyBll.DeleteFaculty(addFacultyModel)>0)
{
successStatusLabel.InnerText = "Row deleted";
failStatusLabel.InnerText = "";
GetAllFaculty();
}
else
{
successStatusLabel.InnerText = "";
failStatusLabel.InnerText = "Row not deleted";
}
//string username = GrdView1.DataKeys[e.RowIndex].Value.ToString();
//MAconn.Open();
//SqlCommand cmd = new SqlCommand("Delete From ROLES (UserId,GroupId) SELECT UserId FROM Users WHERE username= @username", MAconn);
//cmd.Parameters.AddWithValue("@username", username);
//cmd.ExecuteNonQuery();
//MAconn.Close();
//bind();
}
public int SaveDepartmentName(AddFacultyModel addFacultyModel)
{
string query = String.Format("Insert into tblFaculty values(@name)");
SqlParameter nameParameter = new SqlParameter("@name", addFacultyModel.Name);
sqlCommand.Parameters.Add(nameParameter);
sqlCommand.CommandText = query;
sqlConnection.Open();
int rowsAffected = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return rowsAffected;
}
public int DeleteFaculty(AddFacultyModel addFacultyModel)
{
return addFacultyDal.DeleteFaculty(addFacultyModel);
}
public int SaveDepartmentName(AddFacultyModel addFacultyModel)
{
return addFacultyDal.SaveDepartmentName(addFacultyModel);
}
public bool IsDepartNameExist(AddFacultyModel addFacultyModel)
{
return addFacultyDal.IsFacultyNameExist(addFacultyModel);
}
