/// <summary> /// Method to Get List of UniversityProfile /// </summary> /// <param name="argEn">UniversityProfile Entity as an Input.</param> /// <returns>Returns List of UniversityProfile</returns> public List <UniversityProfileEn> GetList(UniversityProfileEn argEn) { List <UniversityProfileEn> loEnList = new List <UniversityProfileEn>(); string sqlCmd = "select * from SAS_UniversityProfile"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { UniversityProfileEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Delete UniversityProfile /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.UniversityProfileCode as Input Propoerty.</param> /// <returns>Returns Boolean</returns> public bool Delete(UniversityProfileEn argEn) { bool lbRes = false; string sqlCmd = "DELETE FROM SAS_UniversityProfile WHERE SAUP_Code = @SAUP_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Code", DbType.String, argEn.UniversityProfileCode); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Delete Failed! No Row has been deleted..."); } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Get UniversityProfile Entity /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.UniversityProfileCode as Input Property.</param> /// <returns>Returns UniversityProfile Entity</returns> public UniversityProfileEn GetItem(UniversityProfileEn argEn) { UniversityProfileEn loItem = new UniversityProfileEn(); string sqlCmd = "Select * FROM SAS_UniversityProfile WHERE SAUP_Code = @SAUP_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Code", DbType.String, argEn.UniversityProfileCode); _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 UniversityProfile Entity /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.UniversityProfileCode as Input Property.</param> /// <returns>Returns UniversityProfile Entity</returns> public UniversityProfileEn GetItem(UniversityProfileEn argEn) { try { UniversityProfileDAL loDs = new UniversityProfileDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All UniversityProfiles /// </summary> /// <param name="argEn">UniversityProfile Entity as an Input.UniversityProfileCode,Name and SName as Input Properties.</param> /// <returns>Returns List of UniversityProfile</returns> public List <UniversityProfileEn> GetUniversityProfileList(UniversityProfileEn argEn) { try { UniversityProfileDAL loDs = new UniversityProfileDAL(); return(loDs.GetUniversityProfileList(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All UniversityProfiles /// </summary> /// <param name="argEn">UniversityProfile Entity as an Input.UniversityProfileCode,Name and SName as Input Properties.</param> /// <returns>Returns List of UniversityProfile</returns> public List <UniversityProfileEn> GetUniversityProfileList(UniversityProfileEn argEn) { List <UniversityProfileEn> loEnList = new List <UniversityProfileEn>(); argEn.UniversityProfileCode = argEn.UniversityProfileCode.Replace("*", "%"); argEn.Name = argEn.Name.Replace("*", "%"); argEn.SName = argEn.SName.Replace("*", "%"); string sqlCmd = "select SAUP_Code, SAUP_Name, SAUP_SName, SAUP_Adress, SAUP_Adress1, SAUP_Adress2, SAUP_City," + "SAUP_State, SAUP_Country, SAUP_PostCode, SAUP_Phone, SAUP_Fax, SAUP_Email, SAUP_Website, SAUP_Logo, " + "SABR_Code from SAS_UniversityProfile where SAUP_Code <> '' "; if (argEn.UniversityProfileCode.Length != 0) { sqlCmd = sqlCmd + " and SAUP_Code like '" + argEn.UniversityProfileCode + "'"; } if (argEn.Name.Length != 0) { sqlCmd = sqlCmd + " and SAUP_Name like '" + argEn.Name + "'"; } if (argEn.SName.Length != 0) { sqlCmd = sqlCmd + " and SAUP_SName like '" + argEn.SName + "'"; } sqlCmd = sqlCmd + " order by SAUP_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { UniversityProfileEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Update UniversityProfile /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(UniversityProfileEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { UniversityProfileDAL loDs = new UniversityProfileDAL(); flag = loDs.Update(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">UniversityProfile Entity as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(UniversityProfileEn argEn) { try { if (argEn.UniversityProfileCode == null || argEn.UniversityProfileCode.ToString().Length <= 0) { throw new Exception("UniversityProfileCode Is Required!"); } if (argEn.Name == null || argEn.Name.ToString().Length <= 0) { throw new Exception("Name Is Required!"); } return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Load UniversityProfile Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns UniversityProfile Entity</returns> private UniversityProfileEn LoadObject(IDataReader argReader) { UniversityProfileEn loItem = new UniversityProfileEn(); loItem.UniversityProfileCode = GetValue <string>(argReader, "SAUP_Code"); loItem.Name = GetValue <string>(argReader, "SAUP_Name"); loItem.SName = GetValue <string>(argReader, "SAUP_SName"); loItem.Adress = GetValue <string>(argReader, "SAUP_Adress"); loItem.Adress1 = GetValue <string>(argReader, "SAUP_Adress1"); loItem.Adress2 = GetValue <string>(argReader, "SAUP_Adress2"); loItem.City = GetValue <string>(argReader, "SAUP_City"); loItem.State = GetValue <string>(argReader, "SAUP_State"); loItem.Country = GetValue <string>(argReader, "SAUP_Country"); loItem.PostCode = GetValue <string>(argReader, "SAUP_PostCode"); loItem.Phone = GetValue <string>(argReader, "SAUP_Phone"); loItem.Fax = GetValue <string>(argReader, "SAUP_Fax"); loItem.Email = GetValue <string>(argReader, "SAUP_Email"); loItem.Website = GetValue <string>(argReader, "SAUP_Website"); loItem.Logo = GetValue <string>(argReader, "SAUP_Logo"); loItem.Code = GetValue <int>(argReader, "SABR_Code"); return(loItem); }
/// <summary> /// Method to Update UniversityProfile /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.</param> /// <returns>Returns Boolean</returns> /// modified by Hafiz @ 24/11/2016 - system should only allow one University Profile in the table public bool Update(UniversityProfileEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From SAS_UniversityProfile WHERE SAUP_Code = @SAUP_Code Or SAUP_Name = @SAUP_Name"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SAUP_Code", DbType.String, argEn.UniversityProfileCode); _DatabaseFactory.AddInParameter(ref cmdSel, "@SAUP_Name", DbType.String, argEn.Name); _DbParameterCollection = cmdSel.Parameters; using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { if (dr.Read()) { iOut = clsGeneric.NullToInteger(dr["cnt"]); } if (iOut > 0) { throw new Exception("Either Code or Desription Of This Record Already Exist"); } } if (iOut == 0) { sqlCmd = "UPDATE SAS_UniversityProfile SET SAUP_Code = @SAUP_Code, SAUP_Name = @SAUP_Name, SAUP_SName = @SAUP_SName, SAUP_Adress = @SAUP_Adress, SAUP_Adress1 = @SAUP_Adress1, SAUP_Adress2 = @SAUP_Adress2, SAUP_City = @SAUP_City, SAUP_State = @SAUP_State, SAUP_Country = @SAUP_Country, SAUP_PostCode = @SAUP_PostCode, SAUP_Phone = @SAUP_Phone, SAUP_Fax = @SAUP_Fax, SAUP_Email = @SAUP_Email, SAUP_Website = @SAUP_Website, SAUP_Logo = @SAUP_Logo, SABR_Code = @SABR_Code, SAUP_UpdatedUser = @SAUP_UpdatedUser, SAUP_UpdatedDtTm = @SAUP_UpdatedDtTm "; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Code", DbType.String, argEn.UniversityProfileCode); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Name", DbType.String, argEn.Name); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_SName", DbType.String, argEn.SName); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress", DbType.String, argEn.Adress); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress1", DbType.String, argEn.Adress1); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress2", DbType.String, argEn.Adress2); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_City", DbType.String, argEn.City); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_State", DbType.String, argEn.State); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Country", DbType.String, argEn.Country); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_PostCode", DbType.String, argEn.PostCode); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Phone", DbType.String, argEn.Phone); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Fax", DbType.String, argEn.Fax); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Email", DbType.String, argEn.Email); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Website", DbType.String, argEn.Website); //_DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Logo", DbType.String, argEn.Logo); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Logo", DbType.String, string.Empty); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.Code); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_UpdatedUser", DbType.String, argEn.UpdatedUser); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm); _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 Insert UniversityProfile /// </summary> /// <param name="argEn">UniversityProfile Entity is an Input.</param> /// <returns>Returns Boolean</returns> /// modified by Hafiz @ 24/11/2016 - system should only allow one University Profile in the table public bool Insert(UniversityProfileEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "SELECT COUNT(*) AS cnt FROM SAS_UniversityProfile "; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { iOut = clsGeneric.NullToInteger(loReader["cnt"]); if (iOut > 0) { throw new Exception("Record Already Exist"); } } loReader.Close(); } if (iOut == 0) { sqlCmd = "INSERT INTO SAS_UniversityProfile(SAUP_Code,SAUP_Name,SAUP_SName,SAUP_Adress,SAUP_Adress1,SAUP_Adress2,SAUP_City,SAUP_State,SAUP_Country,SAUP_PostCode,SAUP_Phone,SAUP_Fax,SAUP_Email,SAUP_Website,SAUP_Logo,SABR_Code,SAUP_UpdatedUser,SAUP_UpdatedDtTm) VALUES (@SAUP_Code,@SAUP_Name,@SAUP_SName,@SAUP_Adress,@SAUP_Adress1,@SAUP_Adress2,@SAUP_City,@SAUP_State,@SAUP_Country,@SAUP_PostCode,@SAUP_Phone,@SAUP_Fax,@SAUP_Email,@SAUP_Website,@SAUP_Logo,@SABR_Code,@SAUP_UpdatedUser,@SAUP_UpdatedDtTm) "; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Code", DbType.String, argEn.UniversityProfileCode); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Name", DbType.String, argEn.Name); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_SName", DbType.String, argEn.SName); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress", DbType.String, argEn.Adress); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress1", DbType.String, argEn.Adress1); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Adress2", DbType.String, argEn.Adress2); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_City", DbType.String, argEn.City); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_State", DbType.String, argEn.State); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Country", DbType.String, argEn.Country); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_PostCode", DbType.String, argEn.PostCode); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Phone", DbType.String, argEn.Phone); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Fax", DbType.String, argEn.Fax); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Email", DbType.String, argEn.Email); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Website", DbType.String, argEn.Website); //_DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Logo", DbType.String, argEn.Logo); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_Logo", DbType.String, string.Empty); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.Code); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_UpdatedUser", DbType.String, argEn.UpdatedUser); _DatabaseFactory.AddInParameter(ref cmd, "@SAUP_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm); _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); }