/*******************************************************************************************************/ #region DATABASE METHODS public Guid?submitNew() { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "users_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_NAME, SqlDbType.VarChar, name), new SqlQueryParameter(COL_DB_HashedPassword, SqlDbType.VarChar, _hashed_password), new SqlQueryParameter(COL_ROLE, SqlDbType.TinyInt, (int)role), new SqlQueryParameter(COL_DB_PercentCommission, SqlDbType.Decimal, percentCommission), new SqlQueryParameter(COL_DB_GlobalPercentComission, SqlDbType.Decimal, GlobalPercentComission), new SqlQueryParameter(COL_DB_Notes, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region DATABASE METHODS public static Guid add(Guid Users_Id, DateTime Period, decimal GlobalPercentComission, int Amount, int CorrectionAmount, string CorrectionNotes, DateTime PaymentDate) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "SaleComissions_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_Users_Id, SqlDbType.UniqueIdentifier, Users_Id), new SqlQueryParameter(COL_DB_Period, SqlDbType.DateTime, Period), new SqlQueryParameter(COL_DB_GlobalPercentComission, SqlDbType.Decimal, GlobalPercentComission), new SqlQueryParameter(COL_DB_Amount, SqlDbType.Int, Amount), new SqlQueryParameter(COL_DB_CorrectionAmount, SqlDbType.Int, CorrectionAmount), new SqlQueryParameter(COL_DB_CorrectionNotes, SqlDbType.VarChar, CorrectionNotes), new SqlQueryParameter(COL_DB_PaymentDate, SqlDbType.DateTime, PaymentDate) ); if (result.IsSuccessful) { ActivityLog.submitCreate(Id); } return(Id); }
public static Guid?add(Guid customerID, decimal debtLimit, int termDays, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "CustomerTerms_add", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_CUSTOMERS_ID, SqlDbType.UniqueIdentifier, customerID), new SqlQueryParameter(COL_DB_DEBTLIMIT, SqlDbType.Decimal, debtLimit), new SqlQueryParameter(COL_DB_TERMDAYS, SqlDbType.Int, termDays), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public Guid?submitNew() { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "inventory_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_BUYPRICE, SqlDbType.Decimal, buy_price), new SqlQueryParameter(COL_DB_GRADEID, SqlDbType.UniqueIdentifier, grade_id), new SqlQueryParameter(COL_DB_PRODUCTID, SqlDbType.UniqueIdentifier, product_id), new SqlQueryParameter(COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier, product_width_id), new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, length_unit_id), new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, color_id), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)), new SqlQueryParameter(COL_DB_POITEMID, SqlDbType.UniqueIdentifier, Util.wrapNullable(POItemID)), new SqlQueryParameter(COL_DB_PACKINGLISTNO, SqlDbType.VarChar, PackingListNo), new SqlQueryParameter(COL_DB_VENDORINVOICEID, SqlDbType.UniqueIdentifier, Util.wrapNullable(VendorInvoiceID)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region CONSTRUCTORS #endregion CONSTRUCTORS /*******************************************************************************************************/ #region DATABASE STATIC METHODS public static Guid?submitNew(Guid customerID, decimal creditAmount, Guid?salePaymentID, string notes, PaymentMethod?paymentMethod) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "customercredit_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_CUSTOMERID, SqlDbType.UniqueIdentifier, customerID), new SqlQueryParameter(COL_DB_AMOUNT, SqlDbType.Decimal, creditAmount), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, notes), new SqlQueryParameter(COL_DB_SALEPAYMENTID, SqlDbType.UniqueIdentifier, Util.wrapNullable(salePaymentID)), new SqlQueryParameter(COL_DB_USERID, SqlDbType.UniqueIdentifier, GlobalData.UserAccount.id), new SqlQueryParameter(COL_DB_METHODENUMID, SqlDbType.TinyInt, Util.wrapNullable(paymentMethod)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(string name, string address, string phone1, string phone2, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "vendor_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_NAME, SqlDbType.VarChar, name), new SqlQueryParameter(COL_DB_ADDRESS, SqlDbType.VarChar, address), new SqlQueryParameter(COL_DB_PHONE1, SqlDbType.VarChar, phone1), new SqlQueryParameter(COL_DB_PHONE2, SqlDbType.VarChar, phone2), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(string name, string address, Guid cityID, Guid?defaultTransportID, string phone1, string phone2, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "customer_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_NAME, SqlDbType.VarChar, name), new SqlQueryParameter(COL_DB_ADDRESS, SqlDbType.VarChar, address), new SqlQueryParameter(COL_DB_CITYID, SqlDbType.UniqueIdentifier, cityID), new SqlQueryParameter(COL_DB_DEFAULTTRANSPORTID, SqlDbType.UniqueIdentifier, Util.wrapNullable(defaultTransportID)), new SqlQueryParameter(COL_DB_PHONE1, SqlDbType.VarChar, phone1), new SqlQueryParameter(COL_DB_PHONE2, SqlDbType.VarChar, phone2), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, notes), new SqlQueryParameter(COL_DB_SALESUSERID, SqlDbType.UniqueIdentifier, GlobalData.UserAccount.id) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(Guid storeNameID, string nameVendor, Guid vendorID, decimal percentageOfPercentCommission, decimal?maxCommissionAmount, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "product_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_STORENAMEID, SqlDbType.UniqueIdentifier, storeNameID), new SqlQueryParameter(COL_DB_NAMEVENDOR, SqlDbType.VarChar, nameVendor), new SqlQueryParameter(COL_DB_VENDORID, SqlDbType.UniqueIdentifier, vendorID), new SqlQueryParameter(COL_DB_PercentageOfPercentCommission, SqlDbType.Decimal, percentageOfPercentCommission), new SqlQueryParameter(COL_DB_MaxCommissionAmount, SqlDbType.Decimal, Util.wrapNullable(maxCommissionAmount)), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public Guid?submitNew() { SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "inventoryitem_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_INVENTORY_ID, SqlDbType.UniqueIdentifier, inventory_id), new SqlQueryParameter(COL_DB_LENGTH, SqlDbType.Decimal, item_length), new SqlQueryParameter(COL_DB_BARCODE, SqlDbType.VarChar, barcode.ToUpper()), new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, Util.wrapNullable(ColorID)), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(id); return(id); } }
public static Guid?add(Guid?ProductStoreNameID, Guid?GradeID, Guid?ProductWidthID, Guid?LengthUnitID, decimal TagPrice, string Notes, Guid?InventoryID, Guid?ColorID, decimal?BuyPrice) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "productprice_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_PRODUCTSTORENAMEID, SqlDbType.UniqueIdentifier, Util.wrapNullable(ProductStoreNameID)), new SqlQueryParameter(COL_DB_GRADEID, SqlDbType.UniqueIdentifier, Util.wrapNullable(GradeID)), new SqlQueryParameter(COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier, Util.wrapNullable(ProductWidthID)), new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, Util.wrapNullable(LengthUnitID)), new SqlQueryParameter(COL_DB_INVENTORYID, SqlDbType.UniqueIdentifier, Util.wrapNullable(InventoryID)), new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, Util.wrapNullable(ColorID)), new SqlQueryParameter(COL_DB_SELLPRICE, SqlDbType.Decimal, TagPrice), new SqlQueryParameter(COL_DB_BuyPrice, SqlDbType.Decimal, Util.wrapNullable(BuyPrice)), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(Notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region DATABASE METHODS public static Guid add(DateTime Timestamp, Guid?Customers_Id, Guid?Vendors_Id, string No, decimal DPP, decimal PPN, string Notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "FakturPajaks_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_Timestamp, SqlDbType.DateTime, Util.getAsStartDate(Timestamp)), new SqlQueryParameter(COL_DB_Customers_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(Customers_Id)), new SqlQueryParameter(COL_DB_Vendors_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(Vendors_Id)), new SqlQueryParameter(COL_DB_No, SqlDbType.VarChar, No), new SqlQueryParameter(COL_DB_DPP, SqlDbType.Decimal, DPP), new SqlQueryParameter(COL_DB_PPN, SqlDbType.Decimal, PPN), new SqlQueryParameter(COL_DB_Notes, SqlDbType.NVarChar, Util.wrapNullable(Notes)) ); if (result.IsSuccessful) { ActivityLog.submitCreate(Id); } return(Id); }
public static Guid?add(Guid customerID, Guid gradeID, Guid productStoreNameID, Guid productWidthID, Guid lengthUnitID, Guid?colorID, decimal adjustmentPerUnit, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "customersaleadjustment_add", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_CUSTOMERID, SqlDbType.UniqueIdentifier, customerID), new SqlQueryParameter(COL_DB_GRADEID, SqlDbType.UniqueIdentifier, gradeID), new SqlQueryParameter(COL_DB_PRODUCSTORENAMEID, SqlDbType.UniqueIdentifier, productStoreNameID), new SqlQueryParameter(COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier, productWidthID), new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, lengthUnitID), new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, Util.wrapNullable(colorID)), new SqlQueryParameter(COL_DB_ADJUSTMENTPERUNIT, SqlDbType.Decimal, adjustmentPerUnit), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(string storageName, string vendorName, string vendorInfo, string description, DateTime?priceDate, decimal?pricePerUnit, DateTime?discontinueDate, string notes, Guid?lengthUnitID, decimal?sellPricePerUnit) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "sample_add", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_STORAGENAME, SqlDbType.VarChar, storageName), new SqlQueryParameter(COL_DB_VENDORNAME, SqlDbType.VarChar, vendorName), new SqlQueryParameter(COL_DB_VENDORINFO, SqlDbType.VarChar, vendorInfo), new SqlQueryParameter(COL_DB_DESCRIPTION, SqlDbType.VarChar, description), new SqlQueryParameter(COL_DB_PRICEDATE, SqlDbType.DateTime, Util.wrapNullable(priceDate)), new SqlQueryParameter(COL_DB_PRICEPERUNIT, SqlDbType.Decimal, Util.wrapNullable(pricePerUnit)), new SqlQueryParameter(COL_DB_DISCONTINUEDATE, SqlDbType.DateTime, Util.wrapNullable(discontinueDate)), new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, Util.wrapNullable(lengthUnitID)), new SqlQueryParameter(COL_DB_SELLPRICEPERUNIT, SqlDbType.Decimal, Util.wrapNullable(sellPricePerUnit)), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region CONSTRUCTORS #endregion CONSTRUCTORS /*******************************************************************************************************/ #region DATABASE METHODS public static Guid?add(Guid referenceId, PaymentMethod paymentMethod, decimal amount, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "Payments_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_ReferenceId, SqlDbType.UniqueIdentifier, referenceId), new SqlQueryParameter(COL_DB_PaymentMethod_enumid, SqlDbType.TinyInt, paymentMethod), new SqlQueryParameter(COL_DB_Amount, SqlDbType.Decimal, amount), new SqlQueryParameter(COL_DB_Notes, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static bool add(Guid id, Guid customerId, string customerInfo, List <SaleOrderItem> items, string notes, DateTime targetDate, string customerPONo) { bool isSuccess = false; SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "SaleOrders_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_Customers_Id, SqlDbType.UniqueIdentifier, customerId), new SqlQueryParameter(COL_DB_CustomerInfo, SqlDbType.VarChar, customerInfo), new SqlQueryParameter(COL_DB_TargetDate, SqlDbType.DateTime, targetDate), new SqlQueryParameter(COL_DB_CustomerPONo, SqlDbType.VarChar, customerPONo), new SqlQueryParameter(COL_DB_Notes, SqlDbType.NVarChar, Util.wrapNullable(notes)) ); if (result.IsSuccessful) { ActivityLog.submitCreate(id); //submit items if (SaleOrderItem.add(items)) { isSuccess = true; } } return(isSuccess); }
public static Guid?add(Guid gradeID, Guid productID, Guid productWidthID, Guid lengthUnitID, Guid colorID, int qty, int orderLotQty, string poNotes, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "inventorystocklevel_add", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_GRADEID, SqlDbType.UniqueIdentifier, gradeID), new SqlQueryParameter(COL_DB_PRODUCTID, SqlDbType.UniqueIdentifier, productID), new SqlQueryParameter(COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier, productWidthID), new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, lengthUnitID), new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, colorID), new SqlQueryParameter(COL_DB_ORDERLOTQTY, SqlDbType.Int, orderLotQty), new SqlQueryParameter(COL_DB_QTY, SqlDbType.Int, qty), new SqlQueryParameter(COL_DB_PONOTES, SqlDbType.VarChar, Util.wrapNullable(poNotes)), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region DATABASE METHODS public Guid?submitNew() { //submit new sale record SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, false, true, false, false, false, "salereturn_new", new SqlQueryParameter(COL_ID, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_Timestamp, SqlDbType.DateTime, time_stamp), new SqlQueryParameter(COL_DB_Users_Id, SqlDbType.UniqueIdentifier, user_id), new SqlQueryParameter(COL_DB_Notes, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(id); barcode = Tools.getHex(result.ValueInt, Settings.saleBarcodeLength); } //mark sale items as returned foreach (DataRow row in saleReturnItems.Rows) { result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "saleitem_return", new SqlQueryParameter(COL_ID, SqlDbType.UniqueIdentifier, Util.wrapNullable <Guid>(row, SaleItem.COL_ID)), new SqlQueryParameter("return_id", SqlDbType.UniqueIdentifier, id) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submit((Guid)row[SaleItem.COL_ID], "Sale Item returned in sale return ID: " + id.ToString()); ActivityLog.submit((Guid)row[SaleItem.COL_INVENTORY_ITEM_ID], "Returned in sale return ID: " + barcode); } } return(id); }
/*******************************************************************************************************/ #region DATABASE METHODS public Guid?submitNew(DataTable SaleItems) { //format notes if (string.IsNullOrWhiteSpace(notes)) { notes = null; } else { notes = string.Format("{0:MM/dd/yy}-{1}: {2}", DateTime.Now, GlobalData.UserAccount.name, notes); } SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, true, false, false, false, false, "sale_new", new SqlQueryParameter(COL_ID, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_Timestamp, SqlDbType.DateTime, time_stamp), new SqlQueryParameter(COL_DB_Voided, SqlDbType.Bit, voided), new SqlQueryParameter(COL_CUSTOMER_ID, SqlDbType.UniqueIdentifier, Util.wrapNullable(customer_id)), new SqlQueryParameter(COL_DB_Vendors_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(Vendors_Id)), new SqlQueryParameter(COL_DB_CUSTOMERINFO, SqlDbType.VarChar, customer_info), new SqlQueryParameter(COL_DB_UserId, SqlDbType.UniqueIdentifier, user_id), new SqlQueryParameter(COL_DB_TRANSPORTID, SqlDbType.UniqueIdentifier, Util.wrapNullable(TransportID)), new SqlQueryParameter(COL_DB_SHIPPINGCOST, SqlDbType.Decimal, ShippingCost), new SqlQueryParameter(COL_DB_Notes, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(id); barcode = result.ValueString; SaleItem.submitItems(getListOfSaleItems(SaleItems), barcode, customer_id); return(id); } }
public static Guid add(string name) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "color_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_NAME, SqlDbType.VarChar, name) ); if (result.IsSuccessful) { ActivityLog.submitCreate(Id); } return(Id); }
public static Guid?submitNew(Guid id, Guid vendorID, string vendorInfo, List <POItem> items, string notes, DateTime targetDate, string poNo) { //format notes if (string.IsNullOrWhiteSpace(notes)) { notes = null; } else { notes = string.Format("{0:MM/dd/yy}-{1}: {2}", DateTime.Now, GlobalData.UserAccount.name, notes); } SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "po_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_VENDORID, SqlDbType.UniqueIdentifier, vendorID), new SqlQueryParameter(COL_DB_VENDORINFO, SqlDbType.VarChar, vendorInfo), new SqlQueryParameter(COL_DB_TARGETDATE, SqlDbType.Date, targetDate), new SqlQueryParameter(COL_DB_PONO, SqlDbType.VarChar, poNo), new SqlQueryParameter(COL_DB_USERID, SqlDbType.UniqueIdentifier, GlobalData.UserAccount.id), new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes) )); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(id); //submit items POItem.submitItems(items); return(id); } }
public static Guid?add(string name, Guid stateID) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "city_new", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_NAME, SqlDbType.VarChar, name), new SqlQueryParameter(COL_DB_STATEID, SqlDbType.UniqueIdentifier, stateID) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(string invoiceNo, Guid Vendors_Id) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "VendorInvoices_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_InvoiceNo, SqlDbType.VarChar, invoiceNo), new SqlQueryParameter(COL_DB_Vendors_Id, SqlDbType.UniqueIdentifier, Vendors_Id) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
public static Guid?add(string name, string notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "PettyCashRecordsCategories_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_Name, SqlDbType.VarChar, Util.wrapNullable(name)), new SqlQueryParameter(COL_DB_Notes, SqlDbType.VarChar, Util.wrapNullable(notes)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }
/*******************************************************************************************************/ #region DATABASE METHODS public static Guid add(DateTime Timestamp, Guid Customers_Id, string No, decimal Amount, DateTime?ReturnDate, string Notes) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "Kontrabons_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_Timestamp, SqlDbType.DateTime, Util.getAsStartDate(Timestamp)), new SqlQueryParameter(COL_DB_Customers_Id, SqlDbType.UniqueIdentifier, Customers_Id), new SqlQueryParameter(COL_DB_No, SqlDbType.VarChar, No), new SqlQueryParameter(COL_DB_Amount, SqlDbType.Decimal, Amount), new SqlQueryParameter(COL_DB_ReturnDate, SqlDbType.DateTime, Util.wrapNullable(Util.getAsStartDate(ReturnDate))), new SqlQueryParameter(COL_DB_Notes, SqlDbType.NVarChar, Util.wrapNullable(Notes)) ); if (result.IsSuccessful) { ActivityLog.submitCreate(Id); } return(Id); }
public static Guid?add(string description, Guid?customerID, Guid?vendorID) { Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "todo_add", new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_DESCRIPTION, SqlDbType.VarChar, description), new SqlQueryParameter(COL_DB_CUSTOMERID, SqlDbType.UniqueIdentifier, Util.wrapNullable(customerID)), new SqlQueryParameter(COL_DB_VENDORID, SqlDbType.UniqueIdentifier, Util.wrapNullable(vendorID)) ); if (!result.IsSuccessful) { return(null); } else { ActivityLog.submitCreate(Id); return(Id); } }