public bool Delete(CreditMemo obj) { try { _db.CreditMemos.DeleteOnSubmit(obj); _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(false); } return(true); }
public bool Update(CreditMemo obj) { try { obj.UpdatedDate = DateTime.Now; _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(false); } return(true); }
public int Add(CreditMemo obj) { try { var nowYear = DateTime.Now.ToString("yy"); var last = (from q in _db.CreditMemos where q.CreditMemoNumber.Substring(2, 2) == nowYear orderby q.CreditMemoIndex descending select q).FirstOrDefault(); var creditType = _db.Dicts.FirstOrDefault(q => q.DictType == 69 && q.Value == obj.CreditMemoType); if (last == null) { obj.CreditMemoIndex = 1; } else { obj.CreditMemoIndex = last.CreditMemoIndex + 1; } //var lastPartial = (from q in db.CreditMemos // where q.CreditMemoNumber.Substring(4, 2) == nowYear && q.InvoiceId == obj.InvoiceId // orderby q.CreditMemoPartialIndex descending // select q).FirstOrDefault(); //if (lastPartial == null) obj.CreditMemoPartialIndex = 1; //else // obj.CreditMemoPartialIndex = lastPartial.CreditMemoIndex + 1; obj.CreditMemoNumber = "CM" + creditType.Abbreviation + nowYear + obj.CreditMemoIndex.ToString("D6") + "_" + obj.CreditMemoPartialIndex.ToString("D2"); _db.CreditMemos.InsertOnSubmit(obj); _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(-1); } return(_db.CreditMemos.Max(x => x.CreditMemoId)); }