public Result Update(List <MenuEntity> list, string type)
{
var con = new DapperConnectionManager();
var queryList = new List <QueryEntity>();
var query = new QueryEntity
{
Query = @"DELETE from Menus WHERE Type = @Type",
Entity = new { Type = type },
};
queryList.Add(query);
foreach (var item in list)
{
item.Type = type;
var queryItem = new QueryEntity()
{
Entity = item,
Query = @"INSERT into Menus (Title, Href, Position, Type, Submenu, Separator) VALUES(@Title, @Href, @Position, @Type, @Submenu, @Separator)"
};
queryList.Add(queryItem);
}
var result = con.ExecuteQueries(queryList);
result.Message = result.Success ? "The menu have been modifed" : "An error has ocurred";
return(result);
}