public static PosResponse Update(SellingHeaderViewModel entities) { PosResponse result = new PosResponse(); result.Reference = GetNewReference(); try { using (var db = new PayrollContext()) { SellingHeader sh = new SellingHeader(); sh.Id = 0; sh.DateOfSelling = entities.DateOfSelling; sh.SellingTotal = entities.SellingTotal; sh.Reference = result.Reference; sh.Payment = entities.Payment; sh.IsActivated = true; sh.CreateBy = entities.CreateBy; sh.CreateDate = entities.DateOfSelling; foreach (var item in entities.Details) { SellingDetail sd = new SellingDetail(); sd.SellingHeaderId = sh.Id; sd.ItemId = item.ItemId; sd.Quantity = item.Quantity; sd.Price = item.Price; sd.Amount = item.Amount; sd.IsActivated = item.IsActivated; sd.CreateBy = entities.CreateBy; sd.CreateDate = entities.DateOfSelling; db.SellingDetail.Add(sd); } db.SellingHeader.Add(sh); db.SaveChanges(); } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
public static Responses Update(SellingHeaderViewModel entity) { Responses result = new Responses(); try { using (var db = new PayrollContext()) { if (entity.Id != 0) { SellingHeader sh = db.SellingHeader.Where(o => o.Id == entity.Id).FirstOrDefault(); if (sh != null) { sh.Reference = entity.Reference; sh.DateOfSelling = entity.DateOfSelling; sh.SellingTotal = entity.SellingTotal; sh.Payment = entity.Payment; sh.IsActivated = entity.IsActivated; sh.ModifyBy = "Sol"; sh.ModifyDate = DateTime.Now; db.SaveChanges(); } } else { SellingHeader sh = new SellingHeader(); sh.Reference = entity.Reference; sh.DateOfSelling = entity.DateOfSelling; sh.SellingTotal = entity.SellingTotal; sh.Payment = entity.Payment; sh.IsActivated = entity.IsActivated; sh.CreateBy = "Sol"; sh.CreateDate = DateTime.Now; db.SellingHeader.Add(sh); db.SaveChanges(); } } } catch (Exception ex) { result.Message = ex.Message; result.Success = false; } return(result); }
public static Responses Delete(int id) { Responses result = new Responses(); try { using (var db = new PayrollContext()) { SellingHeader sh = db.SellingHeader.Where(o => o.Id == id).FirstOrDefault(); if (sh != null) { db.SellingHeader.Remove(sh); db.SaveChanges(); } } } catch (Exception ex) { result.Message = ex.Message; result.Success = false; } return(result); }