public async Task <ActionResult> CreateChurch(cm.Church church)
{
try
{
InitSession();
church.CreatedByUserId = _session.UserId;
var json = await _apiProvider.PostItemAsync <cm.Church>(_uri, church);
var ch = _apiProvider.DeserializeJson <cm.Church>(json);
if (ch != null)
{
return(Content("Created: " + ch.id.ToString()));
}
else
{
return(Content("Error creating church"));
}
}
catch (Exception ex)
{
return(Content("Error creating church: " + ex.Message));
}
}
public RepositoryActionResult <TeamMetadata> GetMetadata(int churchId, int userId)
{
var metadata = new TeamMetadata();
using (var cn = new SqlConnection(_executor.ConnectionString))
{
using (var cmd = new SqlCommand("GetTeamProfileMetadata", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("churchId", churchId));
cmd.Parameters.Add(new SqlParameter("userId", userId));
cn.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
// read enum types
while (reader.Read())
{
var appEnum = new AppEnum();
appEnum.ID = reader.ValueOrDefault <int>("EnumID");
appEnum.Desc = reader.ValueOrDefault <string>("EnumDesc");
appEnum.AppEnumTypeID = reader.ValueOrDefault <int>("EnumTypeID");
appEnum.AppEnumTypeName = reader.ValueOrDefault <string>("EnumTypeName");
appEnum.OptionsEnumTypeID = reader.ValueOrDefault <int>("OptionsEnumTypeID");
metadata.EnumTypes.Add(appEnum);
}
// read enums for above enum types
reader.NextResult();
while (reader.Read())
{
var appEnum = new AppEnum();
appEnum.ID = reader.ValueOrDefault <int>("EnumID");
appEnum.Desc = reader.ValueOrDefault <string>("EnumDesc");
appEnum.AppEnumTypeID = reader.ValueOrDefault <int>("EnumTypeID");
appEnum.AppEnumTypeName = reader.ValueOrDefault <string>("EnumTypeName");
appEnum.OptionsEnumTypeID = reader.ValueOrDefault <int>("OptionsEnumTypeID");
metadata.Enums.Add(appEnum);
}
// read churches
reader.NextResult();
while (reader.Read())
{
var church = new c.Church();
church.id = reader.ValueOrDefault <int>("Id");
church.Name = reader.ValueOrDefault <string>("Name");
metadata.Churches.Add(church);
}
// read members
reader.NextResult();
while (reader.Read())
{
var member = new Core.Models.Members.Member();
member.id = reader.ValueOrDefault <int>("Id");
member.FirstName = reader.ValueOrDefault <string>("FirstName");
member.LastName = reader.ValueOrDefault <string>("LastName");
metadata.Members.Add(member);
}
}
}
}
}
return(new RepositoryActionResult <TeamMetadata>(metadata, RepositoryActionStatus.Ok));
}