public static void Commit(Guid docid, RegisterDocumentType docType)
{
using (var db = Helpers.DB.PosConnect())
{
string Table = "";
string Direction = "";
string query = @"insert into GoodsMovement (_date, docid, StoreId, GoodId, Pcs{1}, Money{1})
SELECT p.DocumentDate,p.id,p.StoreId,d.GoodId,d.pcs,ISNULL(d.pcs,0)*ISNULL(d.cost,0)
FROM {0}Details d Left join {0} p on d.DocId=p.Id Where p.id=@DocId";
switch (docType)
{
case RegisterDocumentType.Invoice:
Table = "Invoice";
Direction = "In";
break;
case RegisterDocumentType.Receipt:
Table = "Receipt";
Direction = "Out";
break;
default:
break;
}
db.Execute(String.Format(query, Table, Direction), new { DocId = docid });
CalculateAllFollowingCosts(GetDocumentData(docid));
}
}
public static void Rollback(Guid docid, RegisterDocumentType docType)
{
using (var db = Helpers.DB.PosConnect())
{
var docData = GetDocumentData(docid);
db.Execute("DELETE FROM GoodsMovement where docid=@DocId", new { DocId = docid });
CalculateAllFollowingCosts(docData);
}
}
