public async Task <RulesetDashboardLayout> Create(RulesetDashboardLayout item) { //item.IsDefaultComputer = false; //item.IsDefaultTablet = false; //item.IsDefaultMobile = false; return(await _repo.Add(item)); }
public void Create_sp(RulesetDashboardLayout model, string UserId, int old_RulesetDashboardLayoutId) { string consString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value; using (SqlConnection con = new SqlConnection(consString)) { using (SqlCommand cmd = new SqlCommand("Ruleset_DuplicateLayout_And_Page")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.AddWithValue("@RulesetLayoutID", model.RulesetDashboardLayoutId); cmd.Parameters.AddWithValue("@OldRulesetDashboardLayoutId", old_RulesetDashboardLayoutId); cmd.Parameters.AddWithValue("@RulesetId", model.RulesetId); cmd.Parameters.AddWithValue("@UserId", UserId); cmd.Parameters.AddWithValue("@IsDuplicatingLayout", true); con.Open(); try { var a = cmd.ExecuteNonQuery(); } catch (Exception ex) { con.Close(); throw ex; } con.Close(); //return true; } } }
private void RemoveDefaultComputerDeviceFromOtherLayouts(RulesetDashboardLayout RDL) { var layouts = _context.RulesetDashboardLayouts.Where(x => x.RulesetDashboardLayoutId != RDL.RulesetDashboardLayoutId && x.RulesetId == RDL.RulesetId && x.IsDeleted != true).ToList(); foreach (var item in layouts) { item.IsDefaultComputer = false; } _context.SaveChanges(); }
public RulesetDashboardLayout GetById(int?id) { RulesetDashboardLayout RulesetDashboardLayout = _context.RulesetDashboardLayouts .Include(d => d.RulesetDashboardPages) .Where(x => x.RulesetDashboardLayoutId == id && x.IsDeleted != true).SingleOrDefault(); if (RulesetDashboardLayout == null) { return(RulesetDashboardLayout); } RulesetDashboardLayout.RulesetDashboardPages = RulesetDashboardLayout.RulesetDashboardPages.Where(p => p.IsDeleted != true).OrderBy(x => x.SortOrder).ToList(); return(RulesetDashboardLayout); }
public async Task <RulesetDashboardLayout> Update(RulesetDashboardLayout item) { var RulesetDashboardLayout = await _repo.Get(item.RulesetDashboardLayoutId); if (RulesetDashboardLayout == null) { return(RulesetDashboardLayout); } RulesetDashboardLayout.Name = item.Name; RulesetDashboardLayout.DefaultPageId = item.DefaultPageId; RulesetDashboardLayout.LayoutHeight = item.LayoutHeight; RulesetDashboardLayout.LayoutWidth = item.LayoutWidth; RulesetDashboardLayout.IsDefaultComputer = item.IsDefaultComputer; RulesetDashboardLayout.IsDefaultTablet = item.IsDefaultTablet; RulesetDashboardLayout.IsDefaultMobile = item.IsDefaultMobile; try { await _repo.Update(RulesetDashboardLayout); if (RulesetDashboardLayout.IsDefaultComputer) { RemoveDefaultComputerDeviceFromOtherLayouts(RulesetDashboardLayout); } if (RulesetDashboardLayout.IsDefaultTablet) { RemoveDefaultTabletDeviceFromOtherLayouts(RulesetDashboardLayout); } if (RulesetDashboardLayout.IsDefaultMobile) { RemoveDefaultMobileDeviceFromOtherLayouts(RulesetDashboardLayout); } } catch (Exception ex) { throw ex; } return(RulesetDashboardLayout); }