public void Create_sp(CharacterDashboardPage model, string UserID)
{
string consString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand("Character_DuplicateLayout_And_Page"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@CharacterLayoutID", model.CharacterDashboardLayoutId);
cmd.Parameters.AddWithValue("@OldCharacterDashboardPageId", model.CharacterDashboardPageId);
cmd.Parameters.AddWithValue("@CharacterId", model.CharacterId);
cmd.Parameters.AddWithValue("@PageName", model.Name);
cmd.Parameters.AddWithValue("@UserId", UserID);
cmd.Parameters.AddWithValue("@IsDuplicatingLayout", false);
cmd.Parameters.AddWithValue("@PageSortOrder", model.SortOrder);
con.Open();
try
{
var a = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
con.Close();
throw ex;
}
con.Close();
//return true;
}
}
}
public async Task <CharacterDashboardPage> Update(CharacterDashboardPage item)
{
var CharacterDashboardPage = await _repo.Get(item.CharacterDashboardPageId);
if (CharacterDashboardPage == null)
{
return(CharacterDashboardPage);
}
CharacterDashboardPage.Name = item.Name;
CharacterDashboardPage.ContainerHeight = item.ContainerHeight;
CharacterDashboardPage.ContainerWidth = item.ContainerWidth;
CharacterDashboardPage.BodyBgColor = item.BodyBgColor;
CharacterDashboardPage.BodyTextColor = item.BodyTextColor;
CharacterDashboardPage.TitleBgColor = item.TitleBgColor;
CharacterDashboardPage.TitleTextColor = item.TitleTextColor;
try
{
await _repo.Update(CharacterDashboardPage);
}
catch (Exception ex)
{
throw ex;
}
return(CharacterDashboardPage);
}
public CharacterDashboardPage GetById(int?id)
{
CharacterDashboardPage CharacterDashboardPage = _context.CharacterDashboardPages
.Include(d => d.Tiles)
.Where(x => x.CharacterDashboardPageId == id && x.IsDeleted != true).SingleOrDefault();
if (CharacterDashboardPage == null)
{
return(CharacterDashboardPage);
}
CharacterDashboardPage.Tiles = CharacterDashboardPage.Tiles.Where(p => p.IsDeleted != true).ToList();
return(CharacterDashboardPage);
}
public async Task <CharacterDashboardPage> Create(CharacterDashboardPage item)
{
return(await _repo.Add(item));
}
