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)); }