//Update:
public bool UpdateDepartment(DepartmentModel objDepartmentModel)
{
string SqlString="Update Department Set SchNum='"+objDepartmentModel.SchNum+"',DeptNum='"+objDepartmentModel.DeptNum+"',DeptName='"+objDepartmentModel.DeptName+"'where DeptNum='"+objDepartmentModel.DeptNum+"'";
if (objDataBaseOperaClass.GetExecute(SqlString))
return (true);
else
return (false);
}
//Delete:
public bool DelDepatment(DepartmentModel objDepartmentModel)
{
string SqlString = "Delete From Department Where DeptNum='" + objDepartmentModel.DeptNum + "'";
if (objDataBaseOperaClass.GetExecute(SqlString))
return (true);
else
return (false);
}
//Add:
public bool AddDepartment(DepartmentModel objDepartmentModel )
{
string SqlString = "insert into Department values('" + objDepartmentModel.DeptNum + "','" + objDepartmentModel.DeptName + "','" + objDepartmentModel.SchNum + "')";
if (objDataBaseOperaClass.GetExecute(SqlString))
return (true);
else
return (false);
}
//Updatae:
public bool UpdateDeptment(DepartmentModel objDepartmentModel)
{
return objDepartmentDAL.UpdateDepartment(objDepartmentModel);
}
//Search:
public DataTable SearchDeptment(DepartmentModel objDepartmentModel)
{
return objDepartmentDAL.SearchDeptment(objDepartmentModel);
}
//Delete:
public bool DelDeptment(DepartmentModel objDepartmentModel)
{
return objDepartmentDAL.DelDepatment(objDepartmentModel);
}
//Add
public bool AddDeptment(DepartmentModel objDepartmentModel)
{
return objDepartmentDAL.AddDepartment(objDepartmentModel);
}
//Search:
public DataTable SearchDeptment(DepartmentModel objDepartmentModel)
{
string SqlString = "Select * From Department Where DeptName='"+objDepartmentModel.DeptName+"'";
return objDataBaseOperaClass.ShowTable(SqlString);
}
