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);
}
