public bool MoveShades(ShadeCard oSelectedShade, ShadeCard oAffectedShade) { try { using (var ctx = new DBAJEntities()) { int?SelectedOrderId = oSelectedShade.DisplayOrder; int?affectOrderId = oAffectedShade.DisplayOrder; //selected shade oSelectedShade.DisplayOrder = affectOrderId; ctx.Entry(oSelectedShade).State = EntityState.Modified; //affected shade oAffectedShade.DisplayOrder = SelectedOrderId; ctx.Entry(oAffectedShade).State = EntityState.Modified; ctx.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
//Load Selected Shade Cards in Form public PartialViewResult ManageShadeCard(int id = 0) { ShadeCard oShadeCard = new ShadeCard(); ViewBag.lstYarnTypes = new YarnTypeBL().GetAllYarnTypes(); var _JariCompany = SiteUtility.GetCurrentJariCompany(oUser); if (id > 0) { oShadeCard = new ShadeCardBL().GetById(id); } oShadeCard.JariCompanyId = _JariCompany.JariCompanyId; return(PartialView("_ManageShadeCard", oShadeCard)); }
public bool Delete(int id) { try { using (var ctx = new DBAJEntities()) { ShadeCard oShadeCard = ctx.ShadeCards.Where(p => p.ShadeId == id).FirstOrDefault(); ctx.ShadeCards.Remove(oShadeCard); ctx.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public void Update(ShadeCard oShadeCard) { try { using (var ctx = new DBAJEntities()) { if (oShadeCard.DisplayOrder == null) { oShadeCard.DisplayOrder = (ctx.ShadeCards.OrderByDescending(c => c.ShadeId).FirstOrDefault().ShadeId) + 1; } ctx.Entry(oShadeCard).State = EntityState.Modified; ctx.SaveChanges(); } } catch (Exception ex) { throw ex; } }