public int CreateClassroom(Classroom_lkpInfo info)
{
if (info == null)
{
throw new Exception(ExceptionMessage.InputParameterNull);
}
using (SqlConnectionManager cm = new SqlConnectionManager())
{
Nullable<int> classroom_id = null;
using(var cmd = new Classroom_lkp_Save_p())
{
cmd.Parameters.IsInsert = true;
cmd.Parameters.Classroom_id = info.Classroom_id;
cmd.Parameters.School_id = info.School_id;
cmd.Parameters.IsDeleted = info.IsDeleted;
cmd.Parameters.ClassroomName = info.ClassroomName;
cmd.Parameters.Classroom_Blurb_id = info.Classroom_Blurb_id;
cmd.Parameters.DefaultPhysicalCapacity = info.DefaultPhysicalCapacity;
cmd.Parameters.DisplayOrder = info.DisplayOrder;
cmd.Parameters.Insertby = info.Insertby;
cmd.Parameters.Updateby = info.Updateby;
cmd.Parameters.IsHidden = info.IsHidden;
cm.ExecuteNonQuery(cmd, _context);
classroom_id = cmd.Parameters.Classroom_id;
if (!classroom_id.HasValue)
{
throw new Exception(ExceptionMessage.NoIdReturnedForCreatedObject);
}
}
return classroom_id.Value;
}
}
public void UpdateClassroom(Classroom_lkpInfo info)
{
if (info == null)
{
throw new Exception(ExceptionMessage.InputParameterNull);
}
using (SqlConnectionManager cm = new SqlConnectionManager())
{
using (var cmd = new Classroom_lkp_Save_p())
{
cmd.Parameters.IsInsert = false;
cmd.Parameters.Classroom_id = info.Classroom_id;
cmd.Parameters.School_id = info.School_id;
cmd.Parameters.IsDeleted = info.IsDeleted;
cmd.Parameters.ClassroomName = info.ClassroomName;
cmd.Parameters.Classroom_Blurb_id = info.Classroom_Blurb_id;
cmd.Parameters.DefaultPhysicalCapacity = info.DefaultPhysicalCapacity;
cmd.Parameters.DisplayOrder = info.DisplayOrder;
cmd.Parameters.Insertby = info.Insertby;
cmd.Parameters.Updateby = info.Updateby;
cmd.Parameters.IsHidden = info.IsHidden;
cm.ExecuteNonQuery(cmd, _context);
}
}
}
