/// <summary> /// Method to Get List of ProgramAccount /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.</param> /// <returns>Returns List of ProgramAccount</returns> public List <ProgramAccountEn> GetListProgram(ProgramAccountEn argEn) { List <ProgramAccountEn> loEnList = new List <ProgramAccountEn>(); string sqlCmd = "select * from SAS_Program order by SAPG_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { ProgramAccountEn loItem = LoadObject1(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Delete ProgramAccount /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Delete(ProgramAccountEn argEn) { bool lbRes = false; string sqlCmd = "DELETE FROM SAS_ProgramAccount WHERE SAPA_Code = @SAPA_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAPA_Code", DbType.String, argEn.ProgramAccountCode); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Insertion Failed! No Row has been updated..."); } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Get ProgramAccount Entity /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.SAPA_Code as Input Property.</param> /// <returns>Returns ProgramAccount Entity</returns> public ProgramAccountEn GetItem(ProgramAccountEn argEn) { ProgramAccountEn loItem = new ProgramAccountEn(); string sqlCmd = "Select * FROM SAS_ProgramAccount WHERE SAPA_Code = @SAPA_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAPA_Code", DbType.String, argEn.ProgramAccountCode); _DbParameterCollection = cmd.Parameters; using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { if (loReader != null) { loReader.Read(); loItem = LoadObject(loReader); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loItem); }
/// <summary> /// Method to Get List of ProgramAccount /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.</param> /// <returns>Returns List of ProgramAccount</returns> public List <ProgramAccountEn> GetListProgramCombine(ProgramAccountEn argEn) { List <ProgramAccountEn> loEnList = new List <ProgramAccountEn>(); string sqlCmd = "select PR.SAPG_ProgramBM as descProgram from SAS_Program PR UNION "; sqlCmd += "Select 'AFC-' || FC.SAFC_Desc from SAS_Faculty FC UNION "; sqlCmd += "Select 'AFC-' || SS.SAST_Code from SAS_SemesterSetup SS"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { ProgramAccountEn loItem = LoadObject2(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Load ProgramAccount Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns ProgramAccount Entity</returns> private ProgramAccountEn LoadObject2(IDataReader argReader) { ProgramAccountEn loItem = new ProgramAccountEn(); loItem.descProgram = GetValue <string>(argReader, "descProgram"); return(loItem); }
/// <summary> /// Method to Update ProgramAccount /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(ProgramAccountEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From SAS_ProgramAccount WHERE "; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader dr = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { if (dr.Read()) { iOut = clsGeneric.NullToInteger(dr["cnt"]); } if (iOut > 0) { throw new Exception("Record Already Exist"); } } if (iOut == 0) { sqlCmd = "UPDATE SAS_ProgramAccount SET SAPA_Code = @SAPA_Code, SAPA_Desc = @SAPA_Desc, SAPA_Status = @SAPA_Status, SAPG_Code = @SAPG_Code WHERE SAPA_Code = @SAPA_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAPA_Code", DbType.String, argEn.ProgramAccountCode); _DatabaseFactory.AddInParameter(ref cmd, "@SAPA_Desc", DbType.String, argEn.ProgramAccDescription); _DatabaseFactory.AddInParameter(ref cmd, "@SAPA_Status", DbType.Boolean, argEn.ProgramAccStatus); _DatabaseFactory.AddInParameter(ref cmd, "@SAPG_Code", DbType.String, argEn.ProgramCode); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Load ProgramAccount Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns ProgramAccount Entity</returns> private ProgramAccountEn LoadObject1(IDataReader argReader) { ProgramAccountEn loItem = new ProgramAccountEn(); loItem.ProgramCode = GetValue <string>(argReader, "SAPG_Code"); loItem.descProgram = GetValue <string>(argReader, "SAPG_ProgramBM"); //loItem.CodeProgram = loItem.ProgramCode + "-" + loItem.descProgram; loItem.CodeProgram = loItem.descProgram; return(loItem); }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">ProgramAccount Entity is as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(ProgramAccountEn argEn) { try { return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Load ProgramAccount Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns ProgramAccount Entity</returns> private ProgramAccountEn LoadObject(IDataReader argReader) { ProgramAccountEn loItem = new ProgramAccountEn(); loItem.ProgramAccountCode = GetValue <string>(argReader, "SAPA_Code"); loItem.ProgramAccDescription = GetValue <string>(argReader, "SAPA_Desc"); loItem.ProgramAccStatus = GetValue <bool>(argReader, "SAPA_Status"); loItem.ProgramCode = GetValue <string>(argReader, "SAPG_Code"); return(loItem); }
/// <summary> /// Method to Get ProgramAccount Entity /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.SAPA_Code as Input Property.</param> /// <returns>Returns ProgramAccount Entity</returns> public ProgramAccountEn GetItem(ProgramAccountEn argEn) { try { ProgramAccountDAL loDs = new ProgramAccountDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of Program,Faculty And Semester /// </summary> /// <param name="argEn">Program,Faculty And Semester Entity is an Output.</param> /// <returns>Returns List of ProgramAccount</returns> public List <ProgramAccountEn> GetListProgramCombine(ProgramAccountEn argEn) { try { ProgramAccountDAL loDs = new ProgramAccountDAL(); return(loDs.GetListProgramCombine(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Insert ProgramAccount /// </summary> /// <param name="argEn">ProgramAccount Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Insert(ProgramAccountEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { ProgramAccountDAL loDs = new ProgramAccountDAL(); flag = loDs.Insert(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }