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