public bool Insert(Abstracts abstracts)
{
int autonumber = 0;
AbstractsDAC abstractsComponent = new AbstractsDAC();
bool endedSuccessfuly = abstractsComponent.InsertNewAbstracts(ref autonumber, abstracts.PersonId, abstracts.ConferenceId, abstracts.ConferenceCategoryId, abstracts.AbstractTitle, abstracts.AbstractIntro, abstracts.AbstractAuthors, abstracts.CoverLetter, abstracts.IsAccepted, abstracts.AcceptanceType, abstracts.PresentationPath, abstracts.PosterPath, abstracts.Topic, abstracts.Background, abstracts.Methods, abstracts.Results, abstracts.Conclusions, abstracts.AbstractTerms, abstracts.AbstractKeywords, abstracts.DocumentPath1, abstracts.DocumentPath2, abstracts.DocumentPath3, abstracts.RevisionNumber, abstracts.ParentID, abstracts.AbstractStatusId);
if (endedSuccessfuly)
{
abstracts.AbstractId = autonumber;
}
return(endedSuccessfuly);
}
public Abstracts GetByID(int _abstractId)
{
AbstractsDAC _abstractsComponent = new AbstractsDAC();
IDataReader reader = _abstractsComponent.GetByIDAbstracts(_abstractId);
Abstracts _abstracts = null;
while (reader.Read())
{
_abstracts = new Abstracts();
if (reader["AbstractId"] != DBNull.Value)
{
_abstracts.AbstractId = Convert.ToInt32(reader["AbstractId"]);
}
if (reader["PersonId"] != DBNull.Value)
{
_abstracts.PersonId = Convert.ToInt32(reader["PersonId"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_abstracts.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["ConferenceCategoryId"] != DBNull.Value)
{
_abstracts.ConferenceCategoryId = Convert.ToInt32(reader["ConferenceCategoryId"]);
}
if (reader["AbstractTitle"] != DBNull.Value)
{
_abstracts.AbstractTitle = Convert.ToString(reader["AbstractTitle"]);
}
if (reader["AbstractIntro"] != DBNull.Value)
{
_abstracts.AbstractIntro = Convert.ToString(reader["AbstractIntro"]);
}
if (reader["AbstractAuthors"] != DBNull.Value)
{
_abstracts.AbstractAuthors = Convert.ToString(reader["AbstractAuthors"]);
}
if (reader["CoverLetter"] != DBNull.Value)
{
_abstracts.CoverLetter = Convert.ToString(reader["CoverLetter"]);
}
if (reader["IsAccepted"] != DBNull.Value)
{
_abstracts.IsAccepted = Convert.ToBoolean(reader["IsAccepted"]);
}
if (reader["AcceptanceType"] != DBNull.Value)
{
_abstracts.AcceptanceType = Convert.ToString(reader["AcceptanceType"]);
}
if (reader["PresentationPath"] != DBNull.Value)
{
_abstracts.PresentationPath = Convert.ToString(reader["PresentationPath"]);
}
if (reader["PosterPath"] != DBNull.Value)
{
_abstracts.PosterPath = Convert.ToString(reader["PosterPath"]);
}
if (reader["Topic"] != DBNull.Value)
{
_abstracts.Topic = Convert.ToString(reader["Topic"]);
}
if (reader["Background"] != DBNull.Value)
{
_abstracts.Background = Convert.ToString(reader["Background"]);
}
if (reader["Methods"] != DBNull.Value)
{
_abstracts.Methods = Convert.ToString(reader["Methods"]);
}
if (reader["Results"] != DBNull.Value)
{
_abstracts.Results = Convert.ToString(reader["Results"]);
}
if (reader["Conclusions"] != DBNull.Value)
{
_abstracts.Conclusions = Convert.ToString(reader["Conclusions"]);
}
if (reader["AbstractTerms"] != DBNull.Value)
{
_abstracts.AbstractTerms = Convert.ToString(reader["AbstractTerms"]);
}
if (reader["AbstractKeywords"] != DBNull.Value)
{
_abstracts.AbstractKeywords = Convert.ToString(reader["AbstractKeywords"]);
}
if (reader["DocumentPath1"] != DBNull.Value)
{
_abstracts.DocumentPath1 = Convert.ToString(reader["DocumentPath1"]);
}
if (reader["DocumentPath2"] != DBNull.Value)
{
_abstracts.DocumentPath2 = Convert.ToString(reader["DocumentPath2"]);
}
if (reader["DocumentPath3"] != DBNull.Value)
{
_abstracts.DocumentPath3 = Convert.ToString(reader["DocumentPath3"]);
}
if (reader["RevisionNumber"] != DBNull.Value)
{
_abstracts.RevisionNumber = Convert.ToInt32(reader["RevisionNumber"]);
}
if (reader["ParentID"] != DBNull.Value)
{
_abstracts.ParentID = Convert.ToInt32(reader["ParentID"]);
}
if (reader["AbstractStatusId"] != DBNull.Value)
{
_abstracts.AbstractStatusId = Convert.ToInt32(reader["AbstractStatusId"]);
}
_abstracts.NewRecord = false;
}
reader.Close();
return(_abstracts);
}
public bool Update(Abstracts abstracts, int old_abstractId)
{
AbstractsDAC abstractsComponent = new AbstractsDAC();
return(abstractsComponent.UpdateAbstracts(abstracts.PersonId, abstracts.ConferenceId, abstracts.ConferenceCategoryId, abstracts.AbstractTitle, abstracts.AbstractIntro, abstracts.AbstractAuthors, abstracts.CoverLetter, abstracts.IsAccepted, abstracts.AcceptanceType, abstracts.PresentationPath, abstracts.PosterPath, abstracts.Topic, abstracts.Background, abstracts.Methods, abstracts.Results, abstracts.Conclusions, abstracts.AbstractTerms, abstracts.AbstractKeywords, abstracts.DocumentPath1, abstracts.DocumentPath2, abstracts.DocumentPath3, abstracts.RevisionNumber, abstracts.ParentID, abstracts.AbstractStatusId, old_abstractId));
}
public List <Abstracts> GetAllByType(string AcceptedType)
{
AbstractsDAC _abstractsComponent = new AbstractsDAC();
IDataReader reader = _abstractsComponent.GetAllAbstracts(String.Format(" AcceptanceType = '{0}'", AcceptedType)).CreateDataReader();
List <Abstracts> _abstractsList = new List <Abstracts>();
while (reader.Read())
{
if (_abstractsList == null)
{
_abstractsList = new List <Abstracts>();
}
Abstracts _abstracts = new Abstracts();
if (reader["AbstractId"] != DBNull.Value)
{
_abstracts.AbstractId = Convert.ToInt32(reader["AbstractId"]);
}
if (reader["PersonId"] != DBNull.Value)
{
_abstracts.PersonId = Convert.ToInt32(reader["PersonId"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_abstracts.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["ConferenceCategoryId"] != DBNull.Value)
{
_abstracts.ConferenceCategoryId = Convert.ToInt32(reader["ConferenceCategoryId"]);
}
if (reader["AbstractTitle"] != DBNull.Value)
{
_abstracts.AbstractTitle = Convert.ToString(reader["AbstractTitle"]);
}
if (reader["AbstractIntro"] != DBNull.Value)
{
_abstracts.AbstractIntro = Convert.ToString(reader["AbstractIntro"]);
}
if (reader["AbstractAuthors"] != DBNull.Value)
{
_abstracts.AbstractAuthors = Convert.ToString(reader["AbstractAuthors"]);
}
if (reader["CoverLetter"] != DBNull.Value)
{
_abstracts.CoverLetter = Convert.ToString(reader["CoverLetter"]);
}
if (reader["IsAccepted"] != DBNull.Value)
{
_abstracts.IsAccepted = Convert.ToBoolean(reader["IsAccepted"]);
}
if (reader["AcceptanceType"] != DBNull.Value)
{
_abstracts.AcceptanceType = Convert.ToString(reader["AcceptanceType"]);
}
if (reader["PresentationPath"] != DBNull.Value)
{
_abstracts.PresentationPath = Convert.ToString(reader["PresentationPath"]);
}
if (reader["PosterPath"] != DBNull.Value)
{
_abstracts.PosterPath = Convert.ToString(reader["PosterPath"]);
}
if (reader["Topic"] != DBNull.Value)
{
_abstracts.Topic = Convert.ToString(reader["Topic"]);
}
if (reader["Background"] != DBNull.Value)
{
_abstracts.Background = Convert.ToString(reader["Background"]);
}
if (reader["Methods"] != DBNull.Value)
{
_abstracts.Methods = Convert.ToString(reader["Methods"]);
}
if (reader["Results"] != DBNull.Value)
{
_abstracts.Results = Convert.ToString(reader["Results"]);
}
if (reader["Conclusions"] != DBNull.Value)
{
_abstracts.Conclusions = Convert.ToString(reader["Conclusions"]);
}
if (reader["AbstractTerms"] != DBNull.Value)
{
_abstracts.AbstractTerms = Convert.ToString(reader["AbstractTerms"]);
}
if (reader["AbstractKeywords"] != DBNull.Value)
{
_abstracts.AbstractKeywords = Convert.ToString(reader["AbstractKeywords"]);
}
if (reader["DocumentPath1"] != DBNull.Value)
{
_abstracts.DocumentPath1 = Convert.ToString(reader["DocumentPath1"]);
}
if (reader["DocumentPath2"] != DBNull.Value)
{
_abstracts.DocumentPath2 = Convert.ToString(reader["DocumentPath2"]);
}
if (reader["DocumentPath3"] != DBNull.Value)
{
_abstracts.DocumentPath3 = Convert.ToString(reader["DocumentPath3"]);
}
if (reader["RevisionNumber"] != DBNull.Value)
{
_abstracts.RevisionNumber = Convert.ToInt32(reader["RevisionNumber"]);
}
if (reader["ParentID"] != DBNull.Value)
{
_abstracts.ParentID = Convert.ToInt32(reader["ParentID"]);
}
if (reader["AbstractStatusId"] != DBNull.Value)
{
_abstracts.AbstractStatusId = Convert.ToInt32(reader["AbstractStatusId"]);
}
_abstracts.NewRecord = false;
_abstractsList.Add(_abstracts);
}
reader.Close();
return(_abstractsList);
}
