public Variety Get(Guid id)
{
Variety variety = null;
SqlCommand cmd = _unitOfWork.CreateCommand();
cmd.CommandText = "Select VarietyId, Name, CreateDate, LastModifiedDate From dbo.Varieties Where VarietyId = @VarietyId";
cmd.Parameters.AddWithValue("@VarietyId", id);
using (SqlDataReader infoReader = cmd.ExecuteReader())
{
if (infoReader.Read())
{
int idxVarietyId = infoReader.GetOrdinal("VarietyId");
int idxName = infoReader.GetOrdinal("Name");
int idxCreateDate = infoReader.GetOrdinal("CreateDate");
int idxLastModifiedDate = infoReader.GetOrdinal("LastModifiedDate");
variety = new Variety(
EntityId.ForExistingEntity(infoReader.GetGuid(idxVarietyId)),
new TimeStamp(infoReader.GetDateTimeOffset(idxCreateDate).DateTime,
infoReader.GetSafeDateTimeOffset(idxLastModifiedDate)),
infoReader.GetString(idxName));
}
}
return(variety);
}
public void Insert(Plan entity)
{
SqlCommand cmd = _unitOfWork.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "insert into dbo.tblPlan(PlanId, CalendarId, RecurrenceId, EventDescription, VarietyId, PlanDate, ActualDate, Notes) values(@PlanId, @CalendarId, @RecurrenceId, @EventDescription, @VarietyId, @PlanDate, @ActualDate, @Notes)";
int planId = GetNextPlanId();
cmd.Parameters.AddWithValue("@PlanId", planId);
cmd.Parameters.AddWithValue("@RecurrenceId", DBNull.Value);
cmd.Parameters.AddWithValue("@EventDescription", DbUtil.GetDbParamValue(entity.EventDescription));
cmd.Parameters.AddWithValue("@PlanDate", DbUtil.GetDbParamValue(entity.PlanDate));
cmd.Parameters.AddWithValue("@ActualDate", DbUtil.GetDbParamValue(entity.ActualDate));
cmd.ExecuteNonQuery();
}
