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;
}
}
