private List <ResearchRoommateBo> FillLst(DataTable pdtDataTable)
{
List <ResearchRoommateBo> lstItems = new List <ResearchRoommateBo>();
try
{
ResearchRoommateBo researchRoommateBo = null;
foreach (DataRow dr in pdtDataTable.Rows)
{
researchRoommateBo = new ResearchRoommateBo
{
IdResearchRoommate = ABLib.Databases.GetInt32(dr, "IdResearchRoommate"),
IdPerson = ABLib.Databases.GetInt32(dr, "IdPerson"),
MaxBudget = ABLib.Databases.GetInt16(dr, "MaxBudget"),
EmailAlert = ABLib.Databases.GetByte(dr, "EmailAlert"),
SearchCriteria = ABLib.Databases.GetString(dr, "SearchCriteria"),
EcoPractice = ABLib.Databases.GetString(dr, "EcoPractice"),
PictureName = ABLib.Databases.GetString(dr, "PictureName"),
ActivatedAnnouncement = ABLib.Databases.GetBoolean(dr, "ActivatedAnnouncement")
};
lstItems.Add(researchRoommateBo);
}
}
catch (Exception)
{
throw;
}
return(lstItems);
}
public ResearchRoommateBo GetByPersonId(int idPerson)
{
ABLib.DAL.Sql.SqlParametersCollection oSqlParameters = new ABLib.DAL.Sql.SqlParametersCollection();
oSqlParameters.Add("IdPerson", idPerson, SqlDbType.Int);
ResearchRoommateBo researchRoommateBo = this.FillLst(this.SqlDbStoredProcedureDAL.ExecWithResultDt("ResearchRoommate_GetByPersonId", oSqlParameters)).FirstOrDefault();
return(researchRoommateBo);
}
public int Upd(ResearchRoommateBo researchRoommateBo, int idPerson)
{
if (this.ResearchRoommateSql == null)
{
return(0);
}
else
{
return(this.ResearchRoommateSql.Upd(researchRoommateBo, idPerson));
}
}
public PeopleSearchingViewModel(bool init)
{
if (init == true)
{
PlaceBo = new PlaceBo(true);
ResearchRoommateBo = new ResearchRoommateBo(true);
LstPeopleSearchingVM = new List <PeopleSearchingViewModel>();
LstPlaceBo = new List <PlaceBo>();
IdPeopleSearching = new int();
}
}
public int Upd(ResearchRoommateBo researchRoommateBo, int idPerson)
{
ABLib.DAL.Sql.SqlParametersCollection oSqlParameters = new ABLib.DAL.Sql.SqlParametersCollection();
oSqlParameters.AddIdOut("IdResearchRoommate");
oSqlParameters.Add("IdPerson", idPerson, SqlDbType.Int);
oSqlParameters.Add("MaxBudget", researchRoommateBo.MaxBudget, SqlDbType.SmallInt);
oSqlParameters.Add("EmailAlert", researchRoommateBo.EmailAlert, SqlDbType.TinyInt);
oSqlParameters.Add("SearchCriteria", researchRoommateBo.SearchCriteria, SqlDbType.NVarChar);
oSqlParameters.Add("EcoPractice", researchRoommateBo.EcoPractice, SqlDbType.NVarChar);
oSqlParameters.Add("PictureName", researchRoommateBo.PictureName, SqlDbType.NVarChar);
oSqlParameters.Add("ActivatedAnnouncement", 1, SqlDbType.Bit);
this.SqlDbStoredProcedureDAL.Add(researchRoommateBo, "IdResearchRoommate", 0, "ResearchRoommate_Upd", oSqlParameters);
return(researchRoommateBo.IdResearchRoommate);
}
