public static void update_Kontrabons_Id(Guid Id, Guid?Kontrabons_Id)
{
SaleReturn objOld = new SaleReturn(Id);
string log = "";
log = ActivityLog.appendChange(log, objOld.Kontrabons_No, new Kontrabon(Kontrabons_Id).No, "Kontrabon: '{0}' to '{1}'");
if (!string.IsNullOrEmpty(log))
{
SqlQueryResult result = DBConnection.query(
false,
DBConnection.ActiveSqlConnection,
QueryTypes.ExecuteNonQuery,
"salereturn_update_Kontrabons_Id",
new SqlQueryParameter(COL_ID, SqlDbType.UniqueIdentifier, Id),
new SqlQueryParameter(COL_DB_Kontrabons_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(Kontrabons_Id))
);
if (result.IsSuccessful)
{
ActivityLog.submit(Id, String.Format("Updated: {0}", log));
//update faktur pajak log
if (Kontrabons_Id == null)
{
ActivityLog.submit((Guid)objOld.Kontrabons_Id, String.Format("Removed: {0}", objOld.barcode));
}
else
{
ActivityLog.submit((Guid)Kontrabons_Id, String.Format("Added: {0}", objOld.barcode));
}
//remove faktur pajak and all items related to it
Guid?FakturPajaks_Id = new SaleReturn(Id).FakturPajaks_Id;
if (FakturPajaks_Id != null)
{
FakturPajak.update_Kontrabons_Id((Guid)FakturPajaks_Id, Kontrabons_Id);
}
}
}
}
