/// <summary>
/// Get NotesProfilesInfo for NotesProfileNid
/// </summary>
/// <param name="notesProfileNid"></param>
/// <returns></returns>
public NotesProfilesInfo GetNotesProfilesInfo(string notesProfileNid)
{
NotesProfilesInfo RetVal = null;
string SqlQuery = string.Empty;
DbDataReader DBReader = null;
try
{
SqlQuery = this.DBQueries.Notes.GetNotesProfiles(FilterFieldType.NId, notesProfileNid);
DBReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
if (DBReader.HasRows)
{
RetVal = new NotesProfilesInfo();
while (DBReader.Read())
{
RetVal.Profile_NId = (int)DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileNId];
RetVal.Profile_Name = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileName]);
RetVal.Profile_EMail = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileEMail]);
RetVal.Profile_Country = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileCountry]);
RetVal.ProfileOrganization = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileOrg]);
RetVal.Profile_Org_Type = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileOrgType]);
break;
}
}
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
finally
{
if (!DBReader.IsClosed) { DBReader.Close(); }
}
return RetVal;
}
/// <summary>
/// Update Notes Profiles and return Count Of Records Updated
/// </summary>
/// <param name="notesProfileInfo"></param>
/// <returns >Count Of Records Updated</returns>
public int UpdateNotesProfiles(NotesProfilesInfo notesProfileInfo)
{
int RetVal = 0;
string SqlQuery = string.Empty;
try
{
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesProfiles(this.DBQueries.TablesName.NotesProfile, notesProfileInfo.Profile_NId, notesProfileInfo.Profile_Name, notesProfileInfo.Profile_EMail, notesProfileInfo.Profile_Country, notesProfileInfo.ProfileOrganization, notesProfileInfo.Profile_Org_Type);
RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
return(RetVal);
}
/// <summary>
/// Get NotesProfilesInfo for NotesProfileNid
/// </summary>
/// <param name="notesProfileNid"></param>
/// <returns></returns>
public NotesProfilesInfo GetNotesProfilesInfo(string notesProfileNid)
{
NotesProfilesInfo RetVal = null;
string SqlQuery = string.Empty;
DbDataReader DBReader = null;
try
{
SqlQuery = this.DBQueries.Notes.GetNotesProfiles(FilterFieldType.NId, notesProfileNid);
DBReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
if (DBReader.HasRows)
{
RetVal = new NotesProfilesInfo();
while (DBReader.Read())
{
RetVal.Profile_NId = (int)DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileNId];
RetVal.Profile_Name = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileName]);
RetVal.Profile_EMail = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileEMail]);
RetVal.Profile_Country = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileCountry]);
RetVal.ProfileOrganization = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileOrg]);
RetVal.Profile_Org_Type = Convert.ToString(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Profile.ProfileOrgType]);
break;
}
}
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
finally
{
if (!DBReader.IsClosed)
{
DBReader.Close();
}
}
return(RetVal);
}
/// <summary>
/// Update Notes Profiles and return Count Of Records Updated
/// </summary>
/// <param name="notesProfileInfo"></param>
/// <returns >Count Of Records Updated</returns>
public int UpdateNotesProfiles(NotesProfilesInfo notesProfileInfo)
{
int RetVal = 0;
string SqlQuery = string.Empty;
try
{
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesProfiles(this.DBQueries.TablesName.NotesProfile,notesProfileInfo.Profile_NId, notesProfileInfo.Profile_Name, notesProfileInfo.Profile_EMail, notesProfileInfo.Profile_Country, notesProfileInfo.ProfileOrganization, notesProfileInfo.Profile_Org_Type);
RetVal=this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
return RetVal;
}