public static ADUser SelectByUserNameAndPassword(string UserName, string Password) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.AddParameter("@UserName", UserName); oDatabaseHelper.AddParameter("@Password", Password); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectUserNameAndPassword", ref ExecutionState); if (dr.Read()) { ADUser obj = new ADUser(); PopulateObjectFromReader(obj, dr); dr.Close(); oDatabaseHelper.Dispose(); return obj; } else { dr.Close(); oDatabaseHelper.Dispose(); return null; } }
public static bool InsertGroupRoles(ADGroupRoleCollection aDGroupRoleCollection, int groupID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); if (Deletelines(oDatabaseHelper, groupID)) { foreach (ADGroupRole groupRole in aDGroupRoleCollection) { if (!InsertDetails(oDatabaseHelper, groupRole)) { ExecutionState = false; break; } else ExecutionState = true; } if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); } else ExecutionState = false; oDatabaseHelper.Dispose(); return ExecutionState; }
public int SaveTransaction(SALSalesReturnHeader sALSalesReturnHeader, SALSalesReturnLineCollection sALSalesReturnLineCollection) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; int salesReturnHeaderID = -1; oDatabaseHelper.BeginTransaction(); if (InsertHeader(oDatabaseHelper, sALSalesReturnHeader, out salesReturnHeaderID)) { foreach (SALSalesReturnLine sALSalesLine in sALSalesReturnLineCollection) { if (!InsertDetails(oDatabaseHelper, sALSalesLine, salesReturnHeaderID)) { ExecutionState = false; break; } else ExecutionState = true; } if (ExecutionState) { oDatabaseHelper.CommitTransaction(); } else { oDatabaseHelper.RollbackTransaction(); salesReturnHeaderID = -1; } } oDatabaseHelper.Dispose(); return salesReturnHeaderID; }
public static PURPurchaseHeaderCollection HeaderSearch(int InventoryID, DateTime FromDate, DateTime ToDate, string SupplierName, string InvoiceNumber) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@InventoryID", InventoryID ); oDatabaseHelper.AddParameter("@FromDate", FromDate); oDatabaseHelper.AddParameter("@ToDate", ToDate ); if (SupplierName!="") { oDatabaseHelper.AddParameter("@SupplierName", SupplierName); } if (InvoiceNumber != "") { oDatabaseHelper.AddParameter("@InvoiceNumber", InvoiceNumber); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseHeader_SearchByCriteria", ref ExecutionState); PURPurchaseHeaderCollection PURPurchaseHeaderCollection = PopulateFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return PURPurchaseHeaderCollection; }
public static bool CloseOrder(int SalesHeaderID, int UserID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. oDatabaseHelper.AddParameter("@UserID", UserID); oDatabaseHelper.AddParameter("@SlaesReturnHeaderID", SalesHeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_SALSalesReturnHader_CloseOrder", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
public bool CloseOrder(int INVTransferHeaderID, int UserID, INVTransferLineCollection transferLineCollection) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); oDatabaseHelper.AddParameter("@UserID", UserID); oDatabaseHelper.AddParameter("@INVTransferHeaderID", INVTransferHeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_INVTransferHader_CloseOrder", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); oDatabaseHelper.Dispose(); return ExecutionState; }
public static VPurchaseReturnHeaderCollection SearchByriteria(string CustomerName, DateTime FromDate, DateTime ToDate, string InvoiceNumber) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.AddParameter("@SupplierName", CustomerName); oDatabaseHelper.AddParameter("@FromDate", FromDate); oDatabaseHelper.AddParameter("@DateTo", ToDate); oDatabaseHelper.AddParameter("@InvoiceNumber", InvoiceNumber); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_VPurchaseReturnHeader_SearchByCriteria", ref ExecutionState); VPurchaseReturnHeaderCollection VPurchaseReturnHeaderCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return VPurchaseReturnHeaderCollection; }
public static BDProductGroupCollection SearcByCriteria(string ProductGroupName) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@ProductGroupName", ProductGroupName); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_ProductGroup_SearchByCriteria", ref ExecutionState); BDProductGroupCollection BDProductGroupCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return BDProductGroupCollection; }
public bool SaveAccountUpdates(PURPurchaseHeader purchaseHeader, BDSupplierAccount supplierAccount) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); ExecutionState = UpdateSupplierAccount(oDatabaseHelper, supplierAccount, ExecutionState); if (!UpdatePurchaseHeader(oDatabaseHelper, purchaseHeader)) { ExecutionState = false; } else ExecutionState = true; if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); oDatabaseHelper.Dispose(); return ExecutionState; }
public static BDProductCollection SelectAllProductsByGroupID(int InventoryID, BDProductGroupPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; BDProductCollection obj = null; oDatabaseHelper.AddParameter("@ProductGroupID", pk.ProductGroupID); oDatabaseHelper.AddParameter("@InventoryID", InventoryID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_SelectAllByGroupID", ref ExecutionState); obj = new BDProductCollection(); obj = PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper); dr.Close(); oDatabaseHelper.Dispose(); return obj; }
public bool SaveAccountUpdates(SALSalesHeader salesHeader, BDCustomerAccount customerAccount) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); ExecutionState = UpdateCustomerAccount(oDatabaseHelper, customerAccount, ExecutionState); if (!UpdateSalesHeader(oDatabaseHelper, salesHeader)) { ExecutionState = false; } else ExecutionState = true; if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); oDatabaseHelper.Dispose(); return ExecutionState; }
public static SALSalesHeaderCollection HeaderSearch(string CustomerName, string InvoiceNumber) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@CustomerName", CustomerName); oDatabaseHelper.AddParameter("@InvoiceDate", null); oDatabaseHelper.AddParameter("@InvoiceNumber", InvoiceNumber); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_SALSalesHeader_SearchByCriteria", ref ExecutionState); SALSalesHeaderCollection SALSalesHeaderCollection = PopulateFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return SALSalesHeaderCollection; }
public static VSALSalesOrderCollection SelectByInvoiceNumber(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@Field", field); oDatabaseHelper.AddParameter("@Value", fieldValue); oDatabaseHelper.AddParameter("@Value2", fieldValue2); oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation]); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_VSALSalesOrder_SelectByField", ref ExecutionState); VSALSalesOrderCollection VSALSalesOrderCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return VSALSalesOrderCollection; }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table /// using the value of the field specified /// </summary> /// /// <param name="field" type="string">Field of the class BDCustomer</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// <param name="fieldValue2" type="object">Value for the field specified.</param> /// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// /// <returns>List of object of class BDCustomer in the form of an object of class BDCustomerCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:00 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static BDCustomerCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@Field", field); oDatabaseHelper.AddParameter("@Value", fieldValue); oDatabaseHelper.AddParameter("@Value2", fieldValue2); oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation]); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@SkipPages", skipPages); oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_BDCustomer_SelectByFieldPaged", ref ExecutionState); BDCustomerCollection BDCustomerCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return(BDCustomerCollection); }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="ADUserPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class ADUser</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static ADUser SelectOneWithBDCustomerAccountsUsingCreatedBy(ADUserPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; ADUser obj=null; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectOneWithBDCustomerAccountsUsingCreatedBy", ref ExecutionState); if (dr.Read()) { obj= new ADUser(); PopulateObjectFromReader(obj,dr); dr.NextResult(); //Get the child records. obj.BDCustomerAccountCollectionUsingCreatedBy=BDCustomerAccount.PopulateObjectsFromReader(dr); } dr.Close(); oDatabaseHelper.Dispose(); return obj; }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table /// using the value of the field specified /// </summary> /// /// <param name="field" type="string">Field of the class ADUser</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// <param name="fieldValue2" type="object">Value for the field specified.</param> /// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// /// <returns>List of object of class ADUser in the form of an object of class ADUserCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static ADUserCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@Field",field); oDatabaseHelper.AddParameter("@Value", fieldValue ); oDatabaseHelper.AddParameter("@Value2", fieldValue2 ); oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation] ); oDatabaseHelper.AddParameter("@PageSize",pageSize); oDatabaseHelper.AddParameter("@SkipPages", skipPages ); oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectByFieldPaged", ref ExecutionState); ADUserCollection ADUserCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return ADUserCollection; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="ADUserPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class ADUser</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static ADUser SelectOne(ADUserPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { ADUser obj=new ADUser(); PopulateObjectFromReader(obj,dr); dr.Close(); oDatabaseHelper.Dispose(); return obj; } else { dr.Close(); oDatabaseHelper.Dispose(); return null; } }
/// <summary> /// This method will Delete one row from the database using the primary key information /// </summary> /// /// <param name="pk" type="ADUserPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static bool Delete(ADUserPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_ADUser_Delete", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will Update one new row into the database using the property Information /// </summary> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Update() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_userID' as parameter 'UserID' of the stored procedure. oDatabaseHelper.AddParameter("@UserID", _userIDNonDefault ); // Pass the value of '_userFullName' as parameter 'UserFullName' of the stored procedure. oDatabaseHelper.AddParameter("@UserFullName", _userFullNameNonDefault ); // Pass the value of '_userName' as parameter 'UserName' of the stored procedure. oDatabaseHelper.AddParameter("@UserName", _userNameNonDefault ); // Pass the value of '_password' as parameter 'Password' of the stored procedure. oDatabaseHelper.AddParameter("@Password", _passwordNonDefault ); // Pass the value of '_groupID' as parameter 'GroupID' of the stored procedure. oDatabaseHelper.AddParameter("@GroupID", _groupIDNonDefault ); // Pass the value of '_email' as parameter 'Email' of the stored procedure. oDatabaseHelper.AddParameter("@Email", _emailNonDefault ); // Pass the value of '_address' as parameter 'Address' of the stored procedure. oDatabaseHelper.AddParameter("@Address", _addressNonDefault ); // Pass the value of '_phone' as parameter 'Phone' of the stored procedure. oDatabaseHelper.AddParameter("@Phone", _phoneNonDefault ); // Pass the value of '_mobile' as parameter 'Mobile' of the stored procedure. oDatabaseHelper.AddParameter("@Mobile", _mobileNonDefault ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_ADUser_Update", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of ADUserCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static ADUserCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { ADUserCollection list = new ADUserCollection(); if (rdr.Read()) { ADUser obj = new ADUser(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new ADUser(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
/// <summary> /// This method will Update one new row into the database using the property Information /// </summary> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:09 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Update() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_adjustStockReasonID' as parameter 'AdjustStockReasonID' of the stored procedure. oDatabaseHelper.AddParameter("@AdjustStockReasonID", _adjustStockReasonIDNonDefault ); // Pass the value of '_adjustStockreasonName' as parameter 'AdjustStockreasonName' of the stored procedure. oDatabaseHelper.AddParameter("@AdjustStockreasonName", _adjustStockreasonNameNonDefault ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVAdjustStockReason_Update", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:24 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_productName' as parameter 'ProductName' of the stored procedure. if (_productNameNonDefault != null) { oDatabaseHelper.AddParameter("@ProductName", _productNameNonDefault); } else { oDatabaseHelper.AddParameter("@ProductName", DBNull.Value); } // Pass the value of '_productGroupID' as parameter 'ProductGroupID' of the stored procedure. if (_productGroupIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductGroupID", _productGroupIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductGroupID", DBNull.Value); } // Pass the value of '_productCode' as parameter 'ProductCode' of the stored procedure. if (_productCodeNonDefault != null) { oDatabaseHelper.AddParameter("@ProductCode", _productCodeNonDefault); } else { oDatabaseHelper.AddParameter("@ProductCode", DBNull.Value); } // Pass the value of '_isAcceptBatch' as parameter 'IsAcceptBatch' of the stored procedure. if (_isAcceptBatchNonDefault != null) { oDatabaseHelper.AddParameter("@IsAcceptBatch", _isAcceptBatchNonDefault); } else { oDatabaseHelper.AddParameter("@IsAcceptBatch", DBNull.Value); } // Pass the value of '_productPrice' as parameter 'ProductPrice' of the stored procedure. if (_productPriceNonDefault != null) { oDatabaseHelper.AddParameter("@ProductPrice", _productPriceNonDefault); } else { oDatabaseHelper.AddParameter("@ProductPrice", DBNull.Value); } // Pass the value of '_isFixedPrice' as parameter 'IsFixedPrice' of the stored procedure. if (_isFixedPriceNonDefault != null) { oDatabaseHelper.AddParameter("@IsFixedPrice", _isFixedPriceNonDefault); } else { oDatabaseHelper.AddParameter("@IsFixedPrice", DBNull.Value); } // Pass the value of '_hasDiscount' as parameter 'HasDiscount' of the stored procedure. if (_hasDiscountNonDefault != null) { oDatabaseHelper.AddParameter("@HasDiscount", _hasDiscountNonDefault); } else { oDatabaseHelper.AddParameter("@HasDiscount", DBNull.Value); } // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (_discountAmountNonDefault != null) { oDatabaseHelper.AddParameter("@DiscountAmount", _discountAmountNonDefault); } else { oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); } // Pass the value of '_descountRatio' as parameter 'DescountRatio' of the stored procedure. if (_descountRatioNonDefault != null) { oDatabaseHelper.AddParameter("@DescountRatio", _descountRatioNonDefault); } else { oDatabaseHelper.AddParameter("@DescountRatio", DBNull.Value); } // Pass the value of '_isActive' as parameter 'IsActive' of the stored procedure. if (_isActiveNonDefault != null) { oDatabaseHelper.AddParameter("@IsActive", _isActiveNonDefault); } else { oDatabaseHelper.AddParameter("@IsActive", DBNull.Value); } // Pass the value of '_notes' as parameter 'Notes' of the stored procedure. if (_notesNonDefault != null) { oDatabaseHelper.AddParameter("@Notes", _notesNonDefault); } else { oDatabaseHelper.AddParameter("@Notes", DBNull.Value); } // Pass the value of '_minPrice' as parameter 'MinPrice' of the stored procedure. if (_minPriceNonDefault != null) { oDatabaseHelper.AddParameter("@MinPrice", _minPriceNonDefault); } else { oDatabaseHelper.AddParameter("@MinPrice", DBNull.Value); } // Pass the value of '_maxPrice' as parameter 'MaxPrice' of the stored procedure. if (_maxPriceNonDefault != null) { oDatabaseHelper.AddParameter("@MaxPrice", _maxPriceNonDefault); } else { oDatabaseHelper.AddParameter("@MaxPrice", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_BDProduct_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:55:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_takingHeaderID' as parameter 'TakingHeaderID' of the stored procedure. if (_takingHeaderIDNonDefault != null) { oDatabaseHelper.AddParameter("@TakingHeaderID", _takingHeaderIDNonDefault); } else { oDatabaseHelper.AddParameter("@TakingHeaderID", DBNull.Value); } // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (_productIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_actualQty' as parameter 'ActualQty' of the stored procedure. if (_actualQtyNonDefault != null) { oDatabaseHelper.AddParameter("@ActualQty", _actualQtyNonDefault); } else { oDatabaseHelper.AddParameter("@ActualQty", DBNull.Value); } // Pass the value of '_expectedQty' as parameter 'ExpectedQty' of the stored procedure. if (_expectedQtyNonDefault != null) { oDatabaseHelper.AddParameter("@ExpectedQty", _expectedQtyNonDefault); } else { oDatabaseHelper.AddParameter("@ExpectedQty", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. if (_deleteDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeleteDate", _deleteDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeleteDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVTakingInventoryLine_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will Update one new row into the database using the property Information /// </summary> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Update() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_salesLineID' as parameter 'SalesLineID' of the stored procedure. oDatabaseHelper.AddParameter("@SalesLineID", _salesLineIDNonDefault ); // Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure. oDatabaseHelper.AddParameter("@SalesHeaderID", _salesHeaderIDNonDefault ); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault ); // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. oDatabaseHelper.AddParameter("@TotalQty", _totalQtyNonDefault ); // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. oDatabaseHelper.AddParameter("@TotalBonus", _totalBonusNonDefault ); // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. oDatabaseHelper.AddParameter("@DiscountAmount", _discountAmountNonDefault ); // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. oDatabaseHelper.AddParameter("@DiscountRatio", _discountRatioNonDefault ); // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. oDatabaseHelper.AddParameter("@UnitPrice", _unitPriceNonDefault ); // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault ); // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault ); // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault ); // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault ); // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault ); // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault ); // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. oDatabaseHelper.AddParameter("@DeleteDate", _deleteDateNonDefault ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_SALSalesLine_Update", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_userFullName' as parameter 'UserFullName' of the stored procedure. if (_userFullNameNonDefault != null) { oDatabaseHelper.AddParameter("@UserFullName", _userFullNameNonDefault); } else { oDatabaseHelper.AddParameter("@UserFullName", DBNull.Value); } // Pass the value of '_userName' as parameter 'UserName' of the stored procedure. if (_userNameNonDefault != null) { oDatabaseHelper.AddParameter("@UserName", _userNameNonDefault); } else { oDatabaseHelper.AddParameter("@UserName", DBNull.Value); } // Pass the value of '_password' as parameter 'Password' of the stored procedure. if (_passwordNonDefault != null) { oDatabaseHelper.AddParameter("@Password", _passwordNonDefault); } else { oDatabaseHelper.AddParameter("@Password", DBNull.Value); } // Pass the value of '_groupID' as parameter 'GroupID' of the stored procedure. if (_groupIDNonDefault != null) { oDatabaseHelper.AddParameter("@GroupID", _groupIDNonDefault); } else { oDatabaseHelper.AddParameter("@GroupID", DBNull.Value); } // Pass the value of '_email' as parameter 'Email' of the stored procedure. if (_emailNonDefault != null) { oDatabaseHelper.AddParameter("@Email", _emailNonDefault); } else { oDatabaseHelper.AddParameter("@Email", DBNull.Value); } // Pass the value of '_address' as parameter 'Address' of the stored procedure. if (_addressNonDefault != null) { oDatabaseHelper.AddParameter("@Address", _addressNonDefault); } else { oDatabaseHelper.AddParameter("@Address", DBNull.Value); } // Pass the value of '_phone' as parameter 'Phone' of the stored procedure. if (_phoneNonDefault != null) { oDatabaseHelper.AddParameter("@Phone", _phoneNonDefault); } else { oDatabaseHelper.AddParameter("@Phone", DBNull.Value); } // Pass the value of '_mobile' as parameter 'Mobile' of the stored procedure. if (_mobileNonDefault != null) { oDatabaseHelper.AddParameter("@Mobile", _mobileNonDefault); } else { oDatabaseHelper.AddParameter("@Mobile", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_ADUser_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_userFullName' as parameter 'UserFullName' of the stored procedure. if (_userFullNameNonDefault != null) { oDatabaseHelper.AddParameter("@UserFullName", _userFullNameNonDefault); } else { oDatabaseHelper.AddParameter("@UserFullName", DBNull.Value); } // Pass the value of '_userName' as parameter 'UserName' of the stored procedure. if (_userNameNonDefault != null) { oDatabaseHelper.AddParameter("@UserName", _userNameNonDefault); } else { oDatabaseHelper.AddParameter("@UserName", DBNull.Value); } // Pass the value of '_password' as parameter 'Password' of the stored procedure. if (_passwordNonDefault != null) { oDatabaseHelper.AddParameter("@Password", _passwordNonDefault); } else { oDatabaseHelper.AddParameter("@Password", DBNull.Value); } // Pass the value of '_groupID' as parameter 'GroupID' of the stored procedure. if (_groupIDNonDefault != null) { oDatabaseHelper.AddParameter("@GroupID", _groupIDNonDefault); } else { oDatabaseHelper.AddParameter("@GroupID", DBNull.Value); } // Pass the value of '_email' as parameter 'Email' of the stored procedure. if (_emailNonDefault != null) { oDatabaseHelper.AddParameter("@Email", _emailNonDefault); } else { oDatabaseHelper.AddParameter("@Email", DBNull.Value); } // Pass the value of '_address' as parameter 'Address' of the stored procedure. if (_addressNonDefault != null) { oDatabaseHelper.AddParameter("@Address", _addressNonDefault); } else { oDatabaseHelper.AddParameter("@Address", DBNull.Value); } // Pass the value of '_phone' as parameter 'Phone' of the stored procedure. if (_phoneNonDefault != null) { oDatabaseHelper.AddParameter("@Phone", _phoneNonDefault); } else { oDatabaseHelper.AddParameter("@Phone", DBNull.Value); } // Pass the value of '_mobile' as parameter 'Mobile' of the stored procedure. if (_mobileNonDefault != null) { oDatabaseHelper.AddParameter("@Mobile", _mobileNonDefault); } else { oDatabaseHelper.AddParameter("@Mobile", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_ADUser_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_ADUser_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:07 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (_productIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (_totalQtyNonDefault != null) { oDatabaseHelper.AddParameter("@TotalQty", _totalQtyNonDefault); } else { oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value); } // Pass the value of '_stockTypeID' as parameter 'StockTypeID' of the stored procedure. if (_stockTypeIDNonDefault != null) { oDatabaseHelper.AddParameter("@StockTypeID", _stockTypeIDNonDefault); } else { oDatabaseHelper.AddParameter("@StockTypeID", DBNull.Value); } // Pass the value of '_openingQty' as parameter 'OpeningQty' of the stored procedure. if (_openingQtyNonDefault != null) { oDatabaseHelper.AddParameter("@OpeningQty", _openingQtyNonDefault); } else { oDatabaseHelper.AddParameter("@OpeningQty", DBNull.Value); } // Pass the value of '_opennigDate' as parameter 'OpennigDate' of the stored procedure. if (_opennigDateNonDefault != null) { oDatabaseHelper.AddParameter("@OpennigDate", _opennigDateNonDefault); } else { oDatabaseHelper.AddParameter("@OpennigDate", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_INVProductStock_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_INVProductStock_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:07 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (_productIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (_totalQtyNonDefault != null) { oDatabaseHelper.AddParameter("@TotalQty", _totalQtyNonDefault); } else { oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value); } // Pass the value of '_stockTypeID' as parameter 'StockTypeID' of the stored procedure. if (_stockTypeIDNonDefault != null) { oDatabaseHelper.AddParameter("@StockTypeID", _stockTypeIDNonDefault); } else { oDatabaseHelper.AddParameter("@StockTypeID", DBNull.Value); } // Pass the value of '_openingQty' as parameter 'OpeningQty' of the stored procedure. if (_openingQtyNonDefault != null) { oDatabaseHelper.AddParameter("@OpeningQty", _openingQtyNonDefault); } else { oDatabaseHelper.AddParameter("@OpeningQty", DBNull.Value); } // Pass the value of '_opennigDate' as parameter 'OpennigDate' of the stored procedure. if (_opennigDateNonDefault != null) { oDatabaseHelper.AddParameter("@OpennigDate", _opennigDateNonDefault); } else { oDatabaseHelper.AddParameter("@OpennigDate", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVProductStock_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:55:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_takingDate' as parameter 'TakingDate' of the stored procedure. if (_takingDateNonDefault != null) { oDatabaseHelper.AddParameter("@TakingDate", _takingDateNonDefault); } else { oDatabaseHelper.AddParameter("@TakingDate", DBNull.Value); } // Pass the value of '_takingName' as parameter 'TakingName' of the stored procedure. if (_takingNameNonDefault != null) { oDatabaseHelper.AddParameter("@TakingName", _takingNameNonDefault); } else { oDatabaseHelper.AddParameter("@TakingName", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure. if (_createdDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedDate", _createdDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deletedDate' as parameter 'DeletedDate' of the stored procedure. if (_deletedDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedDate", _deletedDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedDate", DBNull.Value); } // Pass the value of '_notes' as parameter 'Notes' of the stored procedure. if (_notesNonDefault != null) { oDatabaseHelper.AddParameter("@Notes", _notesNonDefault); } else { oDatabaseHelper.AddParameter("@Notes", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVTakingInventory_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:23 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_returnDate' as parameter 'ReturnDate' of the stored procedure. if (_returnDateNonDefault != null) { oDatabaseHelper.AddParameter("@ReturnDate", _returnDateNonDefault); } else { oDatabaseHelper.AddParameter("@ReturnDate", DBNull.Value); } // Pass the value of '_originalHeaderID' as parameter 'OriginalHeaderID' of the stored procedure. if (_originalHeaderIDNonDefault != null) { oDatabaseHelper.AddParameter("@OriginalHeaderID", _originalHeaderIDNonDefault); } else { oDatabaseHelper.AddParameter("@OriginalHeaderID", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. if (_deleteDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeleteDate", _deleteDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeleteDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_PURPurchaseReturnHeader_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:03 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure. if (_salesHeaderIDNonDefault != null) { oDatabaseHelper.AddParameter("@SalesHeaderID", _salesHeaderIDNonDefault); } else { oDatabaseHelper.AddParameter("@SalesHeaderID", DBNull.Value); } // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (_productIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (_totalQtyNonDefault != null) { oDatabaseHelper.AddParameter("@TotalQty", _totalQtyNonDefault); } else { oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value); } // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. if (_totalBonusNonDefault != null) { oDatabaseHelper.AddParameter("@TotalBonus", _totalBonusNonDefault); } else { oDatabaseHelper.AddParameter("@TotalBonus", DBNull.Value); } // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (_discountAmountNonDefault != null) { oDatabaseHelper.AddParameter("@DiscountAmount", _discountAmountNonDefault); } else { oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); } // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. if (_discountRatioNonDefault != null) { oDatabaseHelper.AddParameter("@DiscountRatio", _discountRatioNonDefault); } else { oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value); } // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. if (_unitPriceNonDefault != null) { oDatabaseHelper.AddParameter("@UnitPrice", _unitPriceNonDefault); } else { oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. if (_deleteDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeleteDate", _deleteDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeleteDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_SALSalesLine_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table. /// </summary> /// /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number</param> /// /// <returns>list of objects of class INVAdjustStockReason in the form of object of INVAdjustStockReasonCollection </returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:09 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static INVAdjustStockReasonCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@PageSize",pageSize); oDatabaseHelper.AddParameter("@SkipPages", skipPages); oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_INVAdjustStockReason_SelectAllPaged", ref ExecutionState); INVAdjustStockReasonCollection INVAdjustStockReasonCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return INVAdjustStockReasonCollection; }
/// <summary> /// This method will Update one new row into the database using the property Information /// </summary> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:36:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Update() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_iNVTransferHeaderID' as parameter 'INVTransferHeaderID' of the stored procedure. oDatabaseHelper.AddParameter("@INVTransferHeaderID", _iNVTransferHeaderIDNonDefault); // Pass the value of '_transferDate' as parameter 'TransferDate' of the stored procedure. oDatabaseHelper.AddParameter("@TransferDate", _transferDateNonDefault); // Pass the value of '_fromInventoryID' as parameter 'FromInventoryID' of the stored procedure. oDatabaseHelper.AddParameter("@FromInventoryID", _fromInventoryIDNonDefault); // Pass the value of '_toInventoryID' as parameter 'ToInventoryID' of the stored procedure. oDatabaseHelper.AddParameter("@ToInventoryID", _toInventoryIDNonDefault); // Pass the value of '_invoiceNumber' as parameter 'InvoiceNumber' of the stored procedure. oDatabaseHelper.AddParameter("@InvoiceNumber", _invoiceNumberNonDefault); // Pass the value of '_invoiceDate' as parameter 'InvoiceDate' of the stored procedure. oDatabaseHelper.AddParameter("@InvoiceDate", _invoiceDateNonDefault); // Pass the value of '_isVoid' as parameter 'IsVoid' of the stored procedure. oDatabaseHelper.AddParameter("@IsVoid", _isVoidNonDefault); // Pass the value of '_isPrinted' as parameter 'IsPrinted' of the stored procedure. oDatabaseHelper.AddParameter("@IsPrinted", _isPrintedNonDefault); // Pass the value of '_isClosed' as parameter 'IsClosed' of the stored procedure. oDatabaseHelper.AddParameter("@IsClosed", _isClosedNonDefault); // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); // Pass the value of '_deletedDate' as parameter 'DeletedDate' of the stored procedure. oDatabaseHelper.AddParameter("@DeletedDate", _deletedDateNonDefault); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVTransferHeader_Update", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_userFullName' as parameter 'UserFullName' of the stored procedure. if(_userFullNameNonDefault!=null) oDatabaseHelper.AddParameter("@UserFullName", _userFullNameNonDefault); else oDatabaseHelper.AddParameter("@UserFullName", DBNull.Value ); // Pass the value of '_userName' as parameter 'UserName' of the stored procedure. if(_userNameNonDefault!=null) oDatabaseHelper.AddParameter("@UserName", _userNameNonDefault); else oDatabaseHelper.AddParameter("@UserName", DBNull.Value ); // Pass the value of '_password' as parameter 'Password' of the stored procedure. if(_passwordNonDefault!=null) oDatabaseHelper.AddParameter("@Password", _passwordNonDefault); else oDatabaseHelper.AddParameter("@Password", DBNull.Value ); // Pass the value of '_groupID' as parameter 'GroupID' of the stored procedure. if(_groupIDNonDefault!=null) oDatabaseHelper.AddParameter("@GroupID", _groupIDNonDefault); else oDatabaseHelper.AddParameter("@GroupID", DBNull.Value ); // Pass the value of '_email' as parameter 'Email' of the stored procedure. if(_emailNonDefault!=null) oDatabaseHelper.AddParameter("@Email", _emailNonDefault); else oDatabaseHelper.AddParameter("@Email", DBNull.Value ); // Pass the value of '_address' as parameter 'Address' of the stored procedure. if(_addressNonDefault!=null) oDatabaseHelper.AddParameter("@Address", _addressNonDefault); else oDatabaseHelper.AddParameter("@Address", DBNull.Value ); // Pass the value of '_phone' as parameter 'Phone' of the stored procedure. if(_phoneNonDefault!=null) oDatabaseHelper.AddParameter("@Phone", _phoneNonDefault); else oDatabaseHelper.AddParameter("@Phone", DBNull.Value ); // Pass the value of '_mobile' as parameter 'Mobile' of the stored procedure. if(_mobileNonDefault!=null) oDatabaseHelper.AddParameter("@Mobile", _mobileNonDefault); else oDatabaseHelper.AddParameter("@Mobile", DBNull.Value ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if(!getBackValues ) { oDatabaseHelper.ExecuteScalar("gsp_ADUser_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this,dr); } dr.Close(); } oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:36:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_transferDate' as parameter 'TransferDate' of the stored procedure. if (_transferDateNonDefault != null) { oDatabaseHelper.AddParameter("@TransferDate", _transferDateNonDefault); } else { oDatabaseHelper.AddParameter("@TransferDate", DBNull.Value); } // Pass the value of '_fromInventoryID' as parameter 'FromInventoryID' of the stored procedure. if (_fromInventoryIDNonDefault != null) { oDatabaseHelper.AddParameter("@FromInventoryID", _fromInventoryIDNonDefault); } else { oDatabaseHelper.AddParameter("@FromInventoryID", DBNull.Value); } // Pass the value of '_toInventoryID' as parameter 'ToInventoryID' of the stored procedure. if (_toInventoryIDNonDefault != null) { oDatabaseHelper.AddParameter("@ToInventoryID", _toInventoryIDNonDefault); } else { oDatabaseHelper.AddParameter("@ToInventoryID", DBNull.Value); } // Pass the value of '_invoiceNumber' as parameter 'InvoiceNumber' of the stored procedure. if (_invoiceNumberNonDefault != null) { oDatabaseHelper.AddParameter("@InvoiceNumber", _invoiceNumberNonDefault); } else { oDatabaseHelper.AddParameter("@InvoiceNumber", DBNull.Value); } // Pass the value of '_invoiceDate' as parameter 'InvoiceDate' of the stored procedure. if (_invoiceDateNonDefault != null) { oDatabaseHelper.AddParameter("@InvoiceDate", _invoiceDateNonDefault); } else { oDatabaseHelper.AddParameter("@InvoiceDate", DBNull.Value); } // Pass the value of '_isVoid' as parameter 'IsVoid' of the stored procedure. if (_isVoidNonDefault != null) { oDatabaseHelper.AddParameter("@IsVoid", _isVoidNonDefault); } else { oDatabaseHelper.AddParameter("@IsVoid", DBNull.Value); } // Pass the value of '_isPrinted' as parameter 'IsPrinted' of the stored procedure. if (_isPrintedNonDefault != null) { oDatabaseHelper.AddParameter("@IsPrinted", _isPrintedNonDefault); } else { oDatabaseHelper.AddParameter("@IsPrinted", DBNull.Value); } // Pass the value of '_isClosed' as parameter 'IsClosed' of the stored procedure. if (_isClosedNonDefault != null) { oDatabaseHelper.AddParameter("@IsClosed", _isClosedNonDefault); } else { oDatabaseHelper.AddParameter("@IsClosed", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (_createDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreateDate", _createDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deletedDate' as parameter 'DeletedDate' of the stored procedure. if (_deletedDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedDate", _deletedDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_INVTransferHeader_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_INVTransferHeader_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will Delete one row from the database using the property Information /// </summary> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Delete() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_userID' as parameter 'UserID' of the stored procedure. if(_userIDNonDefault!=null) oDatabaseHelper.AddParameter("@UserID", _userIDNonDefault ); else oDatabaseHelper.AddParameter("@UserID", DBNull.Value ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_ADUser_Delete", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:00 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_customerName' as parameter 'CustomerName' of the stored procedure. if (_customerNameNonDefault != null) { oDatabaseHelper.AddParameter("@CustomerName", _customerNameNonDefault); } else { oDatabaseHelper.AddParameter("@CustomerName", DBNull.Value); } // Pass the value of '_customerCode' as parameter 'CustomerCode' of the stored procedure. if (_customerCodeNonDefault != null) { oDatabaseHelper.AddParameter("@CustomerCode", _customerCodeNonDefault); } else { oDatabaseHelper.AddParameter("@CustomerCode", DBNull.Value); } // Pass the value of '_address' as parameter 'Address' of the stored procedure. if (_addressNonDefault != null) { oDatabaseHelper.AddParameter("@Address", _addressNonDefault); } else { oDatabaseHelper.AddParameter("@Address", DBNull.Value); } // Pass the value of '_phone1' as parameter 'Phone1' of the stored procedure. if (_phone1NonDefault != null) { oDatabaseHelper.AddParameter("@Phone1", _phone1NonDefault); } else { oDatabaseHelper.AddParameter("@Phone1", DBNull.Value); } // Pass the value of '_phone2' as parameter 'Phone2' of the stored procedure. if (_phone2NonDefault != null) { oDatabaseHelper.AddParameter("@Phone2", _phone2NonDefault); } else { oDatabaseHelper.AddParameter("@Phone2", DBNull.Value); } // Pass the value of '_mobile1' as parameter 'Mobile1' of the stored procedure. if (_mobile1NonDefault != null) { oDatabaseHelper.AddParameter("@Mobile1", _mobile1NonDefault); } else { oDatabaseHelper.AddParameter("@Mobile1", DBNull.Value); } // Pass the value of '_mobile2' as parameter 'Mobile2' of the stored procedure. if (_mobile2NonDefault != null) { oDatabaseHelper.AddParameter("@Mobile2", _mobile2NonDefault); } else { oDatabaseHelper.AddParameter("@Mobile2", DBNull.Value); } // Pass the value of '_email' as parameter 'Email' of the stored procedure. if (_emailNonDefault != null) { oDatabaseHelper.AddParameter("@Email", _emailNonDefault); } else { oDatabaseHelper.AddParameter("@Email", DBNull.Value); } // Pass the value of '_isActive' as parameter 'IsActive' of the stored procedure. if (_isActiveNonDefault != null) { oDatabaseHelper.AddParameter("@IsActive", _isActiveNonDefault); } else { oDatabaseHelper.AddParameter("@IsActive", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_BDCustomer_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_BDCustomer_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will Delete row(s) from the database using the value of the field specified /// </summary> /// /// <param name="field" type="ADUserFields">Field of the class ADUser</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static bool DeleteByField(string field, object fieldValue) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@Field",field); oDatabaseHelper.AddParameter("@Value", fieldValue ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_ADUser_DeleteByField", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:00 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_customerName' as parameter 'CustomerName' of the stored procedure. if (_customerNameNonDefault != null) { oDatabaseHelper.AddParameter("@CustomerName", _customerNameNonDefault); } else { oDatabaseHelper.AddParameter("@CustomerName", DBNull.Value); } // Pass the value of '_customerCode' as parameter 'CustomerCode' of the stored procedure. if (_customerCodeNonDefault != null) { oDatabaseHelper.AddParameter("@CustomerCode", _customerCodeNonDefault); } else { oDatabaseHelper.AddParameter("@CustomerCode", DBNull.Value); } // Pass the value of '_address' as parameter 'Address' of the stored procedure. if (_addressNonDefault != null) { oDatabaseHelper.AddParameter("@Address", _addressNonDefault); } else { oDatabaseHelper.AddParameter("@Address", DBNull.Value); } // Pass the value of '_phone1' as parameter 'Phone1' of the stored procedure. if (_phone1NonDefault != null) { oDatabaseHelper.AddParameter("@Phone1", _phone1NonDefault); } else { oDatabaseHelper.AddParameter("@Phone1", DBNull.Value); } // Pass the value of '_phone2' as parameter 'Phone2' of the stored procedure. if (_phone2NonDefault != null) { oDatabaseHelper.AddParameter("@Phone2", _phone2NonDefault); } else { oDatabaseHelper.AddParameter("@Phone2", DBNull.Value); } // Pass the value of '_mobile1' as parameter 'Mobile1' of the stored procedure. if (_mobile1NonDefault != null) { oDatabaseHelper.AddParameter("@Mobile1", _mobile1NonDefault); } else { oDatabaseHelper.AddParameter("@Mobile1", DBNull.Value); } // Pass the value of '_mobile2' as parameter 'Mobile2' of the stored procedure. if (_mobile2NonDefault != null) { oDatabaseHelper.AddParameter("@Mobile2", _mobile2NonDefault); } else { oDatabaseHelper.AddParameter("@Mobile2", DBNull.Value); } // Pass the value of '_email' as parameter 'Email' of the stored procedure. if (_emailNonDefault != null) { oDatabaseHelper.AddParameter("@Email", _emailNonDefault); } else { oDatabaseHelper.AddParameter("@Email", DBNull.Value); } // Pass the value of '_isActive' as parameter 'IsActive' of the stored procedure. if (_isActiveNonDefault != null) { oDatabaseHelper.AddParameter("@IsActive", _isActiveNonDefault); } else { oDatabaseHelper.AddParameter("@IsActive", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_BDCustomer_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class ADUser in the form of object of ADUserCollection </returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static ADUserCollection SelectAll() { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectAll", ref ExecutionState); ADUserCollection ADUserCollection = PopulateObjectsFromReader(dr); dr.Close(); oDatabaseHelper.Dispose(); return ADUserCollection; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:12 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_stockTypeName' as parameter 'StockTypeName' of the stored procedure. if(_stockTypeNameNonDefault!=null) oDatabaseHelper.AddParameter("@StockTypeName", _stockTypeNameNonDefault); else oDatabaseHelper.AddParameter("@StockTypeName", DBNull.Value ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVStockType_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will return a count all records in the table. /// </summary> /// /// <returns>count records</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:27 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static int SelectAllCount() { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); Object dr=oDatabaseHelper.ExecuteScalar("gsp_ADUser_SelectAllCount"); int count = Convert.ToInt32(dr); oDatabaseHelper.Dispose(); return count; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:04 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (_qtyNonDefault != null) { oDatabaseHelper.AddParameter("@Qty", _qtyNonDefault); } else { oDatabaseHelper.AddParameter("@Qty", DBNull.Value); } // Pass the value of '_reason' as parameter 'Reason' of the stored procedure. if (_reasonNonDefault != null) { oDatabaseHelper.AddParameter("@Reason", _reasonNonDefault); } else { oDatabaseHelper.AddParameter("@Reason", DBNull.Value); } // Pass the value of '_originalSalesLineID' as parameter 'OriginalSalesLineID' of the stored procedure. if (_originalSalesLineIDNonDefault != null) { oDatabaseHelper.AddParameter("@OriginalSalesLineID", _originalSalesLineIDNonDefault); } else { oDatabaseHelper.AddParameter("@OriginalSalesLineID", DBNull.Value); } // Pass the value of '_batchID' as parameter 'BatchID' of the stored procedure. if (_batchIDNonDefault != null) { oDatabaseHelper.AddParameter("@BatchID", _batchIDNonDefault); } else { oDatabaseHelper.AddParameter("@BatchID", DBNull.Value); } // Pass the value of '_batchNumber' as parameter 'BatchNumber' of the stored procedure. if (_batchNumberNonDefault != null) { oDatabaseHelper.AddParameter("@BatchNumber", _batchNumberNonDefault); } else { oDatabaseHelper.AddParameter("@BatchNumber", DBNull.Value); } // Pass the value of '_expiryDate' as parameter 'ExpiryDate' of the stored procedure. if (_expiryDateNonDefault != null) { oDatabaseHelper.AddParameter("@ExpiryDate", _expiryDateNonDefault); } else { oDatabaseHelper.AddParameter("@ExpiryDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_SALSalesReturnLine_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_SALSalesReturnLine_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:55:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_takingDate' as parameter 'TakingDate' of the stored procedure. if (_takingDateNonDefault != null) { oDatabaseHelper.AddParameter("@TakingDate", _takingDateNonDefault); } else { oDatabaseHelper.AddParameter("@TakingDate", DBNull.Value); } // Pass the value of '_takingName' as parameter 'TakingName' of the stored procedure. if (_takingNameNonDefault != null) { oDatabaseHelper.AddParameter("@TakingName", _takingNameNonDefault); } else { oDatabaseHelper.AddParameter("@TakingName", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure. if (_createdDateNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedDate", _createdDateNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (_isDeletedNonDefault != null) { oDatabaseHelper.AddParameter("@IsDeleted", _isDeletedNonDefault); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (_deletedByNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedBy", _deletedByNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deletedDate' as parameter 'DeletedDate' of the stored procedure. if (_deletedDateNonDefault != null) { oDatabaseHelper.AddParameter("@DeletedDate", _deletedDateNonDefault); } else { oDatabaseHelper.AddParameter("@DeletedDate", DBNull.Value); } // Pass the value of '_notes' as parameter 'Notes' of the stored procedure. if (_notesNonDefault != null) { oDatabaseHelper.AddParameter("@Notes", _notesNonDefault); } else { oDatabaseHelper.AddParameter("@Notes", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if (!getBackValues) { oDatabaseHelper.ExecuteScalar("gsp_INVTakingInventory_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_INVTakingInventory_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this, dr); } dr.Close(); } oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:04 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (_qtyNonDefault != null) { oDatabaseHelper.AddParameter("@Qty", _qtyNonDefault); } else { oDatabaseHelper.AddParameter("@Qty", DBNull.Value); } // Pass the value of '_reason' as parameter 'Reason' of the stored procedure. if (_reasonNonDefault != null) { oDatabaseHelper.AddParameter("@Reason", _reasonNonDefault); } else { oDatabaseHelper.AddParameter("@Reason", DBNull.Value); } // Pass the value of '_originalSalesLineID' as parameter 'OriginalSalesLineID' of the stored procedure. if (_originalSalesLineIDNonDefault != null) { oDatabaseHelper.AddParameter("@OriginalSalesLineID", _originalSalesLineIDNonDefault); } else { oDatabaseHelper.AddParameter("@OriginalSalesLineID", DBNull.Value); } // Pass the value of '_batchID' as parameter 'BatchID' of the stored procedure. if (_batchIDNonDefault != null) { oDatabaseHelper.AddParameter("@BatchID", _batchIDNonDefault); } else { oDatabaseHelper.AddParameter("@BatchID", DBNull.Value); } // Pass the value of '_batchNumber' as parameter 'BatchNumber' of the stored procedure. if (_batchNumberNonDefault != null) { oDatabaseHelper.AddParameter("@BatchNumber", _batchNumberNonDefault); } else { oDatabaseHelper.AddParameter("@BatchNumber", DBNull.Value); } // Pass the value of '_expiryDate' as parameter 'ExpiryDate' of the stored procedure. if (_expiryDateNonDefault != null) { oDatabaseHelper.AddParameter("@ExpiryDate", _expiryDateNonDefault); } else { oDatabaseHelper.AddParameter("@ExpiryDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_SALSalesReturnLine_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:09 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool InsertWithDefaultValues(bool getBackValues) { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_adjustStockreasonName' as parameter 'AdjustStockreasonName' of the stored procedure. if(_adjustStockreasonNameNonDefault!=null) oDatabaseHelper.AddParameter("@AdjustStockreasonName", _adjustStockreasonNameNonDefault); else oDatabaseHelper.AddParameter("@AdjustStockreasonName", DBNull.Value ); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); if(!getBackValues ) { oDatabaseHelper.ExecuteScalar("gsp_INVAdjustStockReason_Insert_WithDefaultValues", ref ExecutionState); } else { IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_INVAdjustStockReason_Insert_WithDefaultValues_AndReturn", ref ExecutionState); if (dr.Read()) { PopulateObjectFromReader(this,dr); } dr.Close(); } oDatabaseHelper.Dispose(); return ExecutionState; }
public static bool OpenTakingInventory(string TakingName, DateTime TakingDate, int InventoryID, int TakingType, int?ProductID, int?ProductGroupID, string Notes, int UserID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_transferHeaderID' as parameter 'TransferHeaderID' of the stored procedure. if (TakingName != null) { oDatabaseHelper.AddParameter("@TakingName", TakingName); } else { oDatabaseHelper.AddParameter("@TakingName", DBNull.Value); } // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (TakingDate != null) { oDatabaseHelper.AddParameter("@TakingDate", TakingDate); } else { oDatabaseHelper.AddParameter("@TakingDate", DBNull.Value); } // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (InventoryID != null) { oDatabaseHelper.AddParameter("@InventoryID", InventoryID); } else { oDatabaseHelper.AddParameter("@InventoryID", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (TakingType != null) { oDatabaseHelper.AddParameter("@TakingType", TakingType); } else { oDatabaseHelper.AddParameter("@TakingType", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (ProductID != null) { oDatabaseHelper.AddParameter("@ProductID", ProductID); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (ProductGroupID != null) { oDatabaseHelper.AddParameter("@ProductGroupID", ProductGroupID); } else { oDatabaseHelper.AddParameter("@ProductGroupID", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (Notes != null) { oDatabaseHelper.AddParameter("@Notes", Notes); } else { oDatabaseHelper.AddParameter("@Notes", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (UserID != null) { oDatabaseHelper.AddParameter("@UserID", UserID); } else { oDatabaseHelper.AddParameter("@UserID", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. oDatabaseHelper.ExecuteScalar("usp_INVTakingInventoryline_OpenTakingInventory", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }
public bool UpdateTransaction(SALSalesReturnHeader sALSalesReturnHeader, SALSalesReturnLineCollection sALSalesReturnLineCollection) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); if (UpdateHeader(oDatabaseHelper, sALSalesReturnHeader)) { if (DeleteDetails(oDatabaseHelper, (int)sALSalesReturnHeader.SlaesReturnHeaderID, (int)sALSalesReturnHeader.UpdatedBy)) { foreach (SALSalesReturnLine sALSalesReturnLine in sALSalesReturnLineCollection) { if (!InsertDetails(oDatabaseHelper, sALSalesReturnLine, (int)sALSalesReturnHeader.SlaesReturnHeaderID)) { ExecutionState = false; break; } else ExecutionState = true; } if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); } else ExecutionState = false; } else ExecutionState = false; oDatabaseHelper.Dispose(); return ExecutionState; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 4/4/2015 1:32:30 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public bool Insert() { bool ExecutionState = false; oDatabaseHelper = new DatabaseHelper(); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (_productIDNonDefault != null) { oDatabaseHelper.AddParameter("@ProductID", _productIDNonDefault); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_batchID' as parameter 'BatchID' of the stored procedure. if (_batchIDNonDefault != null) { oDatabaseHelper.AddParameter("@BatchID", _batchIDNonDefault); } else { oDatabaseHelper.AddParameter("@BatchID", DBNull.Value); } // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (_qtyNonDefault != null) { oDatabaseHelper.AddParameter("@Qty", _qtyNonDefault); } else { oDatabaseHelper.AddParameter("@Qty", DBNull.Value); } // Pass the value of '_adjustReasonID' as parameter 'AdjustReasonID' of the stored procedure. if (_adjustReasonIDNonDefault != null) { oDatabaseHelper.AddParameter("@AdjustReasonID", _adjustReasonIDNonDefault); } else { oDatabaseHelper.AddParameter("@AdjustReasonID", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (_createdByNonDefault != null) { oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_credateDate' as parameter 'CredateDate' of the stored procedure. if (_credateDateNonDefault != null) { oDatabaseHelper.AddParameter("@CredateDate", _credateDateNonDefault); } else { oDatabaseHelper.AddParameter("@CredateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (_updatedByNonDefault != null) { oDatabaseHelper.AddParameter("@UpdatedBy", _updatedByNonDefault); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (_updateDateNonDefault != null) { oDatabaseHelper.AddParameter("@UpdateDate", _updateDateNonDefault); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_stockTypeID' as parameter 'StockTypeID' of the stored procedure. if (_stockTypeIDNonDefault != null) { oDatabaseHelper.AddParameter("@StockTypeID", _stockTypeIDNonDefault); } else { oDatabaseHelper.AddParameter("@StockTypeID", DBNull.Value); } // Pass the value of '_oldStockTypeID' as parameter 'OldStockTypeID' of the stored procedure. if (_oldStockTypeIDNonDefault != null) { oDatabaseHelper.AddParameter("@OldStockTypeID", _oldStockTypeIDNonDefault); } else { oDatabaseHelper.AddParameter("@OldStockTypeID", DBNull.Value); } // Pass the value of '_inventoryID' as parameter 'InventoryID' of the stored procedure. if (_inventoryIDNonDefault != null) { oDatabaseHelper.AddParameter("@InventoryID", _inventoryIDNonDefault); } else { oDatabaseHelper.AddParameter("@InventoryID", DBNull.Value); } // Pass the value of '_expiryDate' as parameter 'ExpiryDate' of the stored procedure. if (_expiryDateNonDefault != null) { oDatabaseHelper.AddParameter("@ExpiryDate", _expiryDateNonDefault); } else { oDatabaseHelper.AddParameter("@ExpiryDate", DBNull.Value); } // Pass the value of '_batchNumber' as parameter 'BatchNumber' of the stored procedure. if (_batchNumberNonDefault != null) { oDatabaseHelper.AddParameter("@BatchNumber", _batchNumberNonDefault); } else { oDatabaseHelper.AddParameter("@BatchNumber", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("gsp_INVAdjustStock_Insert", ref ExecutionState); oDatabaseHelper.Dispose(); return(ExecutionState); }