public static Proposal SelectById(int id)
{
Proposal p = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Proposal_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, map : delegate(IDataReader reader, short set)
{
p = new Proposal();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.Budget = reader.GetSafeInt32(startingIndex++);
p.Deadline = reader.GetSafeString(startingIndex++);
p.ProjectType = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.Company = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
ProposalStatusCategory ps = new ProposalStatusCategory();
ps.Id = reader.GetSafeInt32(startingIndex++);
ps.Name = reader.GetSafeString(startingIndex++);
p.Status = ps;
}
);
return(p);
}
public static List <Proposal> SelectAll()
{
List <Proposal> list = new List <Proposal>();
DataProvider.ExecuteCmd(GetConnection, "dbo.Proposal_SelectAll"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
Proposal p = new Proposal();
int startingIndex = 0;
p.Id = reader.GetSafeInt32(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.Budget = reader.GetSafeInt32(startingIndex++);
p.Deadline = reader.GetSafeString(startingIndex++);
p.ProjectType = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.Company = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
ProposalStatusCategory ps = new ProposalStatusCategory();
ps.Id = reader.GetSafeInt32(startingIndex++);
ps.Name = reader.GetSafeString(startingIndex++);
p.Status = ps;
list.Add(p);
}
);
return(list);
}
public static List <Proposal> Search(ProposalSearchRequest model)
{
List <Proposal> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Proposal_Search"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Name", model.Name);
}
, map : delegate(IDataReader reader, short set)
{
{
Proposal p = new Proposal();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.Budget = reader.GetSafeInt32(startingIndex++);
p.Deadline = reader.GetSafeString(startingIndex++);
p.ProjectType = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.Company = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
ProposalStatusCategory ps = new ProposalStatusCategory();
ps.Id = reader.GetSafeInt32(startingIndex++);
ps.Name = reader.GetSafeString(startingIndex++);
p.Status = ps;
if (list == null)
{
list = new List <Proposal>();
}
list.Add(p);
}
}
);
return(list);
}
