public Prospect GetProspect(int ID)
{
Prospect item = new Prospect();
SqlCommand cmd = new SqlCommand("GetProspect") { CommandType = CommandType.StoredProcedure };
cmd.Parameters.AddWithValue("@ID", ID);
using (SqlDataReader rdr = (SqlDataReader)_repo.ExecuteReader(cmd))
{
while (rdr.Read())
{
item = new Prospect()
{
ID = (int)rdr["ID"]
,
Name = rdr["Name"] != DBNull.Value ? rdr["Name"].ToString() : ""
,
Phone = rdr["Phone"] != DBNull.Value ? rdr["Phone"].ToString() : ""
,
Email = rdr["Email"] != DBNull.Value ? rdr["Email"].ToString() : ""
,
EventDate = rdr["EventDate"] != DBNull.Value ? rdr["EventDate"].ToString() : ""
,
DateInserted = (DateTime)rdr["DateInserted"]
,
DateUpdated = rdr["DateUpdated"] != DBNull.Value ? (DateTime?)rdr["DateUpdated"] : null
,
IsActive = (bool)rdr["IsActive"]
};
}
}
return item;
}
public void UpdateProspect(Prospect prospect)
{
SqlCommand cmd = new SqlCommand("UpdateProspect") { CommandType = CommandType.StoredProcedure };
cmd.Parameters.AddWithValue("@ID", prospect.ID);
cmd.Parameters.AddWithValue("@Name", prospect.Name);
cmd.Parameters.AddWithValue("@Phone", prospect.Phone);
cmd.Parameters.AddWithValue("@Email", prospect.Email);
cmd.Parameters.AddWithValue("@EventDate", prospect.EventDate);
cmd.Parameters.AddWithValue("@IsActive", prospect.IsActive);
try
{
_repo.ExecuteNonQuery(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public int CreateProspect(Prospect prospect)
{
int id;
SqlCommand cmd = new SqlCommand("CreateProspect") { CommandType = CommandType.StoredProcedure };
cmd.Parameters.AddWithValue("@Name", prospect.Name);
cmd.Parameters.AddWithValue("@Phone", prospect.Phone);
cmd.Parameters.AddWithValue("@Email", prospect.Email);
cmd.Parameters.AddWithValue("@EventDate", prospect.EventDate);
SqlParameter param = new SqlParameter("@ID", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
try
{
_repo.ExecuteNonQuery(cmd);
id = (int)cmd.Parameters["@ID"].Value;
}
catch (Exception exc)
{
throw exc;
}
return id;
}
