public bool SaveProgram(ProgramVO ProgramVO)
{
using (ProgramDAC programDAC = new ProgramDAC())
{
return(programDAC.SaveProgram(ProgramVO));
}
}
public bool DeleteProgram(string prog_id)
{
using (ProgramDAC programDAC = new ProgramDAC())
{
return(programDAC.DeleteProgram(prog_id));
}
}
public DataTable GetPrograms(int module_id)
{
using (ProgramDAC programDAC = new ProgramDAC())
{
return(programDAC.GetPrograms(module_id));
}
}
public ProgramVO GetProgram(int prog_id)
{
using (ProgramDAC programDAC = new ProgramDAC())
{
return(programDAC.GetProgram(prog_id));
}
}
public Program GetByID(int _programId)
{
ProgramDAC _programComponent = new ProgramDAC();
IDataReader reader = _programComponent.GetByIDProgram(_programId);
Program _program = null;
while (reader.Read())
{
_program = new Program();
if (reader["ProgramId"] != DBNull.Value)
{
_program.ProgramId = Convert.ToInt32(reader["ProgramId"]);
}
if (reader["ProgramTypeId"] != DBNull.Value)
{
_program.ProgramTypeId = Convert.ToInt32(reader["ProgramTypeId"]);
}
if (reader["DepartmentId"] != DBNull.Value)
{
_program.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
}
if (reader["ProgramName"] != DBNull.Value)
{
_program.ProgramName = Convert.ToString(reader["ProgramName"]);
}
if (reader["ProgramDescription"] != DBNull.Value)
{
_program.ProgramDescription = Convert.ToString(reader["ProgramDescription"]);
}
_program.NewRecord = false;
}
reader.Close();
return(_program);
}
public DataTable GetAllPrograms()
{
using (ProgramDAC programDAC = new ProgramDAC())
{
return(programDAC.GetAllPrograms());
}
}
public bool Insert(int ProgramTypeId, int DepartmentId, string ProgramName, string ProgramDescription)
{
ProgramDAC programComponent = new ProgramDAC();
int ProgramId = 0;
return(programComponent.InsertNewProgram(ref ProgramId, ProgramTypeId, DepartmentId, ProgramName, ProgramDescription));
}
public bool Insert(Program program)
{
int autonumber = 0;
ProgramDAC programComponent = new ProgramDAC();
bool endedSuccessfuly = programComponent.InsertNewProgram(ref autonumber, program.ProgramTypeId, program.DepartmentId, program.ProgramName, program.ProgramDescription);
if (endedSuccessfuly)
{
program.ProgramId = autonumber;
}
return(endedSuccessfuly);
}
public List <Program> GetAllByProgramTypeId(string ProgramTypeId)
{
ProgramDAC _programComponent = new ProgramDAC();
IDataReader reader = _programComponent.GetAllProgram(" ProgramTypeId = " + ProgramTypeId).CreateDataReader();
List <Program> _programList = new List <Program>();
while (reader.Read())
{
if (_programList == null)
{
_programList = new List <Program>();
}
Program _program = new Program();
if (reader["ProgramId"] != DBNull.Value)
{
_program.ProgramId = Convert.ToInt32(reader["ProgramId"]);
}
if (reader["ProgramTypeId"] != DBNull.Value)
{
_program.ProgramTypeId = Convert.ToInt32(reader["ProgramTypeId"]);
}
if (reader["DepartmentId"] != DBNull.Value)
{
_program.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
}
if (reader["ProgramName"] != DBNull.Value)
{
_program.ProgramName = Convert.ToString(reader["ProgramName"]);
}
if (reader["ProgramDescription"] != DBNull.Value)
{
_program.ProgramDescription = Convert.ToString(reader["ProgramDescription"]);
}
_program.NewRecord = false;
_programList.Add(_program);
}
reader.Close();
return(_programList);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
ProgramDAC programcomponent = new ProgramDAC();
return(programcomponent.UpdateDataset(dataset));
}
public void Delete(int Original_ProgramId)
{
ProgramDAC programComponent = new ProgramDAC();
programComponent.DeleteProgram(Original_ProgramId);
}
public bool Update(int ProgramTypeId, int DepartmentId, string ProgramName, string ProgramDescription, int Original_ProgramId)
{
ProgramDAC programComponent = new ProgramDAC();
return(programComponent.UpdateProgram(ProgramTypeId, DepartmentId, ProgramName, ProgramDescription, Original_ProgramId));
}
public bool Update(Program program, int old_programId)
{
ProgramDAC programComponent = new ProgramDAC();
return(programComponent.UpdateProgram(program.ProgramTypeId, program.DepartmentId, program.ProgramName, program.ProgramDescription, old_programId));
}
