public List <PageMetaTags> Get()
{
List <PageMetaTags> list = new List <PageMetaTags>();
DataProvider.ExecuteCmd("dbo.PageMetaTags_SelectAll"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
PageMetaTags singleItem = Mapper(reader);
list.Add(singleItem);
});
return(list);
}
} // PageMetaTagsSelectAll
private static PageMetaTags Mapper(IDataReader reader)
{
PageMetaTags p = new PageMetaTags();
int startingIndex = 0;
p.ID = reader.GetSafeInt32(startingIndex++);
p.MetaTagName = reader.GetSafeString(startingIndex++);
p.MetaTagValue = reader.GetSafeString(startingIndex++);
p.MetaTagID = (MtEnum)reader.GetSafeInt32(startingIndex++); // cast to Enum from int
p.OwnerName = reader.GetSafeString(startingIndex++);
p.OwnerTypeId = reader.GetSafeInt32(startingIndex++);
return(p);
} //PageMetaTags Mapper
public PageMetaTags Get(int id)
{
PageMetaTags singleItem = null;
DataProvider.ExecuteCmd("dbo.PageMetaTags_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
singleItem = Mapper(reader);
});
return(singleItem);
}
private PageMetaTags Mapper(IDataReader reader)
{
PageMetaTags singleItem = new PageMetaTags();
int startingIndex = 0;
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.PageUrl = reader.GetSafeString(startingIndex++);
singleItem.PageName = reader.GetSafeString(startingIndex++);
singleItem.PageOwner = reader.GetSafeString(startingIndex++);
singleItem.MetaName = reader.GetSafeString(startingIndex++);
singleItem.MetaDescription = reader.GetSafeString(startingIndex++);
singleItem.MetaExample = reader.GetSafeString(startingIndex++);
singleItem.MetaTemplate = reader.GetSafeString(startingIndex++);
singleItem.Value = reader.GetSafeString(startingIndex++);
return(singleItem);
}
public List <PageMetaTags> GetByUrlId(int id)
{
List <PageMetaTags> list = new List <PageMetaTags>();
DataProvider.ExecuteCmd("dbo.PageMetaTags_SelectByUrlId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
PageMetaTags singleItem = Mapper(reader);
list.Add(singleItem);
});
return(list);
}
} //PageMetaTags Mapper
public PageMetaTags PageMetaTagsSelectById(int id)
{
PageMetaTags row = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.PageMetaTags_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ID", id);
}, map : delegate(IDataReader reader, short set)
{
PageMetaTags p = Mapper(reader);
if (row == null)
{
row = p;
}
}
);
return(row);
} //PageMetaTagsSelectById
} // PageMetaTagsInsert
public List <PageMetaTags> PageMetaTagsSelectAll()
{
List <PageMetaTags> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.PageMetaTags_SelectAll"
, inputParamMapper : null, map : delegate(IDataReader reader, short set)
{
PageMetaTags p = Mapper(reader);
if (list == null)
{
list = new List <PageMetaTags>();
}
list.Add(p);
}
);
return(list);
} // PageMetaTagsSelectAll
public HttpResponseMessage CreatePageMetaTag([FromUri] int id, [FromBody] Dictionary <string, string> payload)
{
try
{
List <PageMetaTags> pageMetaTagList = new List <PageMetaTags>();
foreach (var kv_pair in payload)
{
MtEnum metaTag;
bool success = Enum.TryParse <MtEnum>(kv_pair.Key, out metaTag);
if (success)
{
PageMetaTags pmt = new PageMetaTags();
pmt.MetaTagValue = kv_pair.Value;
pmt.MetaTagID = metaTag;
pageMetaTagList.Add(pmt);
}
}
// creating a new object to match requested parameter for the service
PageMetaTagsAddRequest request = new PageMetaTagsAddRequest(); // instantiating model
request.OwnerTypeId = id;
request.MetaTags = pageMetaTagList; // set MetaTags property of model to a variable
_metaTagsService.PageMetaTagsInsert(request); // pass model into web service
// confirming that everything went OK
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
ErrorLogService svc = new ErrorLogService();
ErrorLogAddRequest error = new ErrorLogAddRequest();
error.ErrorFunction = "Aic.Web.Controllers.Api.CreatePageMetaTag";
error.ErrorMessage = ex.Message;
error.UserId = UserService.UserSelect().PersonId;
svc.ErrorLogInsert(error);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
} // CreatePageMetaTag
} // MetaTagsSelectAll
public List <PageMetaTags> PageMetaTags_SelectAllByOwnerName(string ownerName)
{
//List<PageMetaTags> list = null;
List <PageMetaTags> list = new List <PageMetaTags>(); //set default list to empty list
// list will hydrate with data if available from DB below
DataProvider.ExecuteCmd(GetConnection, "dbo.PageMetaTags_SelectAllByOwnerName"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@OwnerName", ownerName);
}, map : delegate(IDataReader reader, short set)
{
PageMetaTags m = new PageMetaTags();
int startingIndex = 0;
m.ID = reader.GetSafeInt32(startingIndex++);
m.MetaTagName = reader.GetSafeString(startingIndex++);
m.MetaTagValue = reader.GetSafeString(startingIndex++);
m.MetaTagID = (MtEnum)reader.GetSafeInt32(startingIndex++);
m.OwnerName = reader.GetSafeString(startingIndex++);
m.OwnerTypeId = reader.GetSafeInt32(startingIndex++);
list.Add(m);
});
// find everything within the list hydrated that has the ownerName equal to the ownerName param passed in
List <PageMetaTags> newList = list.FindAll(obj => obj.OwnerName == ownerName);
if (newList.Count > 0)
{
return(newList);
}
else
{
return(list);
}
} //PageMetaTags_SelectAllByOwnerName
