/// <summary>
/// Get ClassificationInfo for Classification name
/// </summary>
/// <param name="classificationNids"></param>
/// <returns></returns>
public NotesClassificationInfo GetNotesClassificationNidBYName(string classificationName)
{
NotesClassificationInfo RetVal = null;
DbDataReader DataReader = null;
string SqlQuery = string.Empty;
try
{
SqlQuery = this.DBQueries.Notes.GetNotesClassificationBYName(classificationName);
DataReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
if (DataReader.HasRows)
{
RetVal = new NotesClassificationInfo();
while (DataReader.Read())
{
RetVal.Classification_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Classification.ClassificationNId];
RetVal.Classification_Name = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Classification.ClassificationName]);
}
}
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
finally
{
if (!DataReader.IsClosed)
{
DataReader.Close();
}
}
return(RetVal);
}
/// <summary>
///Update Notes Classification
/// </summary>
/// <param name="notesClassInfo"></param>
/// <returns >Count Of Records Updated</returns>
public int UpdateNotesClassification(NotesClassificationInfo notesClassInfo)
{
int RetVal = 0;
string SqlQuery = string.Empty;
try
{
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesClassification(this.DBQueries.TablesName.NotesClassification, notesClassInfo.Classification_NId, notesClassInfo.Classification_Name);
RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
return(RetVal);
}
/// <summary>
/// Insert Notes Classification by NotesClassificationInfo
/// </summary>
/// <param name="notesClassInfo">NotesClassificationInfo Object</param>
/// <returns >Return Inserted Notes Nid</returns>
public int InsertNotesClassification(NotesClassificationInfo notesClassInfo)
{
int RetVal = 0;
DITables TableNames;
string LanguageCode = string.Empty;
string DefaultLanguageCode = string.Empty;
string ClassName = string.Empty;
string SqlQuery = string.Empty;
try
{
DefaultLanguageCode = this.DBQueries.LanguageCode;
//-- Insert Classification for Each Language
foreach (DataRow Row in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
{
LanguageCode = Convert.ToString(Row[Language.LanguageCode]);
if (LanguageCode == DefaultLanguageCode.Replace("_", String.Empty))
{
ClassName = notesClassInfo.Classification_Name;
}
else
{
ClassName = Constants.PrefixForNewValue + notesClassInfo.Classification_Name;
}
TableNames = new DITables(this.DBQueries.DataPrefix, "_" + LanguageCode);
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Insert.InsertNotesClassification(TableNames.NotesClassification, ClassName);
this.DBConnection.ExecuteNonQuery(SqlQuery);
}
RetVal = this.DBConnection.GetNewId();
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
return(RetVal);
}
/// <summary>
/// Get ClassificationInfo for ClassificationNids
/// </summary>
/// <param name="classificationNids"></param>
/// <returns></returns>
public List<NotesClassificationInfo> GetNotesClassification(string classificationNids)
{
List<NotesClassificationInfo> RetVal = null;
NotesClassificationInfo ClassificationInfo;
DbDataReader DataReader = null;
string SqlQuery = string.Empty;
try
{
SqlQuery = this.DBQueries.Notes.GetAllNotesClassification(classificationNids);
DataReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
if (DataReader.HasRows)
{
RetVal = new List<NotesClassificationInfo>();
while (DataReader.Read())
{
ClassificationInfo = new NotesClassificationInfo();
ClassificationInfo.Classification_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Classification.ClassificationNId];
ClassificationInfo.Classification_Name = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Classification.ClassificationName]);
RetVal.Add(ClassificationInfo);
}
}
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
finally
{
if (!DataReader.IsClosed)
DataReader.Close();
}
return RetVal;
}
/// <summary>
///Update Notes Classification
/// </summary>
/// <param name="notesClassInfo"></param>
/// <returns >Count Of Records Updated</returns>
public int UpdateNotesClassification(NotesClassificationInfo notesClassInfo)
{
int RetVal = 0;
string SqlQuery = string.Empty;
try
{
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesClassification(this.DBQueries.TablesName.NotesClassification, notesClassInfo.Classification_NId, notesClassInfo.Classification_Name);
RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
return RetVal;
}
/// <summary>
/// Insert Notes Classification by NotesClassificationInfo
/// </summary>
/// <param name="notesClassInfo">NotesClassificationInfo Object</param>
/// <returns >Return Inserted Notes Nid</returns>
public int InsertNotesClassification(NotesClassificationInfo notesClassInfo)
{
int RetVal = 0;
DITables TableNames;
string LanguageCode = string.Empty;
string DefaultLanguageCode = string.Empty;
string ClassName = string.Empty;
string SqlQuery = string.Empty;
try
{
DefaultLanguageCode = this.DBQueries.LanguageCode;
//-- Insert Classification for Each Language
foreach (DataRow Row in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
{
LanguageCode = Convert.ToString(Row[Language.LanguageCode]);
if (LanguageCode == DefaultLanguageCode.Replace("_", String.Empty))
{
ClassName = notesClassInfo.Classification_Name;
}
else
{
ClassName = Constants.PrefixForNewValue + notesClassInfo.Classification_Name;
}
TableNames = new DITables(this.DBQueries.DataPrefix, "_" + LanguageCode);
SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Insert.InsertNotesClassification(TableNames.NotesClassification, ClassName);
this.DBConnection.ExecuteNonQuery(SqlQuery);
}
RetVal = this.DBConnection.GetNewId();
}
catch (Exception ex)
{
ExceptionHandler.ExceptionFacade.ThrowException(ex);
}
return RetVal;
}