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("@CalendarId", entity.Calendar.CalendarId);
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();
}
public Calendar Get(int id)
{
Calendar rtnCalendar = null;
SqlCommand cmd = _unitOfWork.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select CalendarId, Description, Year From dbo.tblCalendar Where CalendarId = @CalendarId";
cmd.Parameters.AddWithValue("@CalendarId", id);
using (SqlDataReader r = cmd.ExecuteReader())
{
if (r.Read())
{
rtnCalendar = MapCalendar(r);
}
}
return(rtnCalendar);
}
public void Insert(Family newFamily)
{
SqlCommand familyCommand = _unitOfWork.CreateCommand();
familyCommand.CommandType = System.Data.CommandType.Text;
familyCommand.CommandText = "insert into dbo.tblFamilies(FamilyId, Name) values(@FamilyId, @Name)";
int familyId = GetNextFamilyId();
familyCommand.Parameters.AddWithValue("@FamilyId", familyId);
familyCommand.Parameters.AddWithValue("@Name", newFamily.Name);
familyCommand.ExecuteNonQuery();
newFamily.FamilyId = familyId;
if (newFamily.Companions.Count > 0)
{
SyncRelatedFamilies(newFamily.FamilyId.Value, newFamily.Companions, "tblCompanions");
}
if (newFamily.Enemies.Count > 0)
{
SyncRelatedFamilies(newFamily.FamilyId.Value, newFamily.Enemies, "tblEnemies");
}
}
