public void CreateProspect(PersonId person, AccomodationId accomodation)
{
var personEntity = Database.Persons.Single(p => p.Id == person.SurrogateId.ValueOrFailure());
var accomodationEntity = Database.Accomodations.Single(p => p.Number == accomodation.Number);
var prospect = new ProspectEntity
{
Person = personEntity,
Accomodation = accomodationEntity
};
Database.Prospects.Add(prospect);
}
public static IProspect GetProspect(int prospectId, char isActiveOnly)
{
string strExecution = "[common].[uspGetProspect]";
IProspect prospect = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@ProspectId", prospectId);
oDq.AddCharParam("@IsActiveOnly", 1, isActiveOnly);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
prospect = new ProspectEntity(reader);
}
reader.Close();
}
return(prospect);
}
public static List <IProspect> GetProspect(char isActiveOnly)
{
string strExecution = "[common].[uspGetProspect]";
List <IProspect> lstProspect = new List <IProspect>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddCharParam("@IsActiveOnly", 1, isActiveOnly);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IProspect prospect = new ProspectEntity(reader);
lstProspect.Add(prospect);
}
reader.Close();
}
return(lstProspect);
}