public static void update_Kontrabons_Id(Guid Id, Guid?Kontrabons_Id) { FakturPajak objOld = new FakturPajak(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, "FakturPajaks_update_Kontrabons_Id", new SqlQueryParameter(COL_DB_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 FP: {0}", objOld.No)); } else { ActivityLog.submit((Guid)Kontrabons_Id, String.Format("Added FP: {0}", objOld.No)); } //remove sale invoices DataTable saleInvoices = Sale.get_by_FakturPajaks_Id(Id); foreach (DataRow row in saleInvoices.Rows) { Sale.update_Kontrabons_Id(Util.wrapNullable <Guid>(row, Sale.COL_ID), Kontrabons_Id); } //remove sale returns DataTable saleReturns = SaleReturn.get_by_FakturPajaks_Id(Id); foreach (DataRow row in saleReturns.Rows) { SaleReturn.update_Kontrabons_Id(Util.wrapNullable <Guid>(row, SaleReturn.COL_ID), Kontrabons_Id); } } } }
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); } } } }
public static void update_FakturPajaks_Id(Guid Id, Guid?FakturPajaks_Id) { SaleReturn objOld = new SaleReturn(Id); string log = ""; log = ActivityLog.appendChange(log, objOld.FakturPajaks_No, new FakturPajak(FakturPajaks_Id).No, "Faktur Pajak: '{0}' to '{1}'"); if (string.IsNullOrEmpty(log)) { Util.displayMessageBoxError("No changes to record"); } else { SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "salereturn_update_FakturPajaks_Id", new SqlQueryParameter(COL_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_FakturPajaks_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(FakturPajaks_Id)) ); if (result.IsSuccessful) { ActivityLog.submit(Id, String.Format("Updated: {0}", log)); //update faktur pajak log if (FakturPajaks_Id == null) { ActivityLog.submit((Guid)objOld.FakturPajaks_Id, String.Format("Removed Sale Return: {0}", objOld.barcode)); } else { ActivityLog.submit((Guid)FakturPajaks_Id, String.Format("Added Sale Return: {0}", objOld.barcode)); } } } }
private void populateGridFPKeluaranRetur() { Util.setGridviewDataSource(gridFPKeluaranRetur, SaleReturn.get_Reminder()); tpFPKeluaranRetur.Text = string.Format("Keluaran Retur: {0}", gridFPKeluaranRetur.Rows.Count); }