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(); }