/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="SALSalesLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLine</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 12/27/2014 6:56:03 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static SALSalesLine SelectOne(SALSalesLinePrimaryKey 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_SALSalesLine_SelectbyPrimaryKey", ref ExecutionState);
if (dr.Read())
{
SALSalesLine obj = new SALSalesLine();
PopulateObjectFromReader(obj, dr);
dr.Close();
oDatabaseHelper.Dispose();
return(obj);
}
else
{
dr.Close();
oDatabaseHelper.Dispose();
return(null);
}
}
/// <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 SALSalesLineCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 12/27/2014 6:56:03 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr)
{
SALSalesLineCollection list = new SALSalesLineCollection();
while (rdr.Read())
{
SALSalesLine obj = new SALSalesLine();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
return(list);
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="sALSalesLine" type="SALSalesLine">This SALSalesLine will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(SALSalesLine sALSalesLine)
{
_sALSalesLine = POS.DataLayer.SALSalesLine.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(sALSalesLine.SalesLineID));
_sALSalesLine.SalesHeaderID = sALSalesLine.SalesHeaderID;
_sALSalesLine.ProductID = sALSalesLine.ProductID;
_sALSalesLine.TotalQty = sALSalesLine.TotalQty;
_sALSalesLine.TotalBonus = sALSalesLine.TotalBonus;
_sALSalesLine.DiscountAmount = sALSalesLine.DiscountAmount;
_sALSalesLine.DiscountRatio = sALSalesLine.DiscountRatio;
_sALSalesLine.UnitPrice = sALSalesLine.UnitPrice;
_sALSalesLine.CreatedBy = sALSalesLine.CreatedBy;
_sALSalesLine.CreateDate = sALSalesLine.CreateDate;
_sALSalesLine.UpdatedBy = sALSalesLine.UpdatedBy;
_sALSalesLine.UpdateDate = sALSalesLine.UpdateDate;
_sALSalesLine.IsDeleted = sALSalesLine.IsDeleted;
_sALSalesLine.DeletedBy = sALSalesLine.DeletedBy;
_sALSalesLine.DeleteDate = sALSalesLine.DeleteDate;
return(_sALSalesLine.Update());
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="SALSalesLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLine</returns>
public SALSalesLine SelectOne(SALSalesLinePrimaryKey pk)
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLine = POS.DataLayer.SALSalesLineBase.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(pk.SalesLineID));
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
return(_sALSalesLineWCF);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="SALSalesLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLine</returns>
public SALSalesLine SelectOne(SALSalesLinePrimaryKey pk)
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLine = POS.DataLayer.SALSalesLineBase.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(pk.SalesLineID));
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
return _sALSalesLineWCF;
}
/// <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 SALSalesLineCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 12/27/2014 6:56:03 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
SALSalesLineCollection list = new SALSalesLineCollection();
if (rdr.Read())
{
SALSalesLine obj = new SALSalesLine();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new SALSalesLine();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return(list);
}
else
{
oDatabaseHelper.Dispose();
return(null);
}
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="SALSalesLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLine</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:16 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static SALSalesLine SelectOne(SALSalesLinePrimaryKey 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_SALSalesLine_SelectbyPrimaryKey", ref ExecutionState);
if (dr.Read())
{
SALSalesLine obj=new SALSalesLine();
PopulateObjectFromReader(obj,dr);
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
else
{
dr.Close();
oDatabaseHelper.Dispose();
return null;
}
}
/// <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 SALSalesLineCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:16 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
SALSalesLineCollection list = new SALSalesLineCollection();
if (rdr.Read())
{
SALSalesLine obj = new SALSalesLine();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new SALSalesLine();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return list;
}
else
{
oDatabaseHelper.Dispose();
return null;
}
}
/// <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 SALSalesLineCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:16 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr)
{
SALSalesLineCollection list = new SALSalesLineCollection();
while (rdr.Read())
{
SALSalesLine obj = new SALSalesLine();
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesLine sALSalesLine, int salesHeaderID)
{
bool ExecutionState = false;
// Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure.
if (salesHeaderID != null)
{
oDatabaseHelper.AddParameter("@SalesHeaderID", salesHeaderID);
}
else
{
oDatabaseHelper.AddParameter("@SalesHeaderID", DBNull.Value);
}
// Pass the value of '_productID' as parameter 'ProductID' of the stored procedure.
if (sALSalesLine.ProductID != null)
{
oDatabaseHelper.AddParameter("@ProductID", sALSalesLine.ProductID);
}
else
{
oDatabaseHelper.AddParameter("@ProductID", DBNull.Value);
}
// Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure.
if (sALSalesLine.TotalQty != null)
{
oDatabaseHelper.AddParameter("@TotalQty", sALSalesLine.TotalQty);
}
else
{
oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value);
}
// Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure.
if (sALSalesLine.TotalBonus != null)
{
oDatabaseHelper.AddParameter("@TotalBonus", sALSalesLine.TotalBonus);
}
else
{
oDatabaseHelper.AddParameter("@TotalBonus", DBNull.Value);
}
// Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure.
if (sALSalesLine.DiscountAmount != null)
{
oDatabaseHelper.AddParameter("@DiscountAmount", sALSalesLine.DiscountAmount);
}
else
{
oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value);
}
// Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure.
if (sALSalesLine.DiscountRatio != null)
{
oDatabaseHelper.AddParameter("@DiscountRatio", sALSalesLine.DiscountRatio);
}
else
{
oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value);
}
// Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure.
if (sALSalesLine.UnitPrice != null)
{
oDatabaseHelper.AddParameter("@UnitPrice", sALSalesLine.UnitPrice);
}
else
{
oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value);
}
// Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
if (sALSalesLine.CreatedBy != null)
{
oDatabaseHelper.AddParameter("@CreatedBy", sALSalesLine.CreatedBy);
}
else
{
oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value);
}
// Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure.
if (sALSalesLine.CreateDate != null)
{
oDatabaseHelper.AddParameter("@CreateDate", sALSalesLine.CreateDate);
}
else
{
oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value);
}
// Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure.
if (sALSalesLine.UpdatedBy != null)
{
oDatabaseHelper.AddParameter("@UpdatedBy", sALSalesLine.UpdatedBy);
}
else
{
oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value);
}
// Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure.
if (sALSalesLine.UpdateDate != null)
{
oDatabaseHelper.AddParameter("@UpdateDate", sALSalesLine.UpdateDate);
}
else
{
oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value);
}
// Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure.
if (sALSalesLine.IsDeleted != null)
{
oDatabaseHelper.AddParameter("@IsDeleted", sALSalesLine.IsDeleted);
}
else
{
oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value);
}
// Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure.
if (sALSalesLine.DeletedBy != null)
{
oDatabaseHelper.AddParameter("@DeletedBy", sALSalesLine.DeletedBy);
}
else
{
oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value);
}
// Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure.
if (sALSalesLine.DeleteDate != null)
{
oDatabaseHelper.AddParameter("@DeleteDate", sALSalesLine.DeleteDate);
}
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("usp_SALSalesLine_InsertCommit", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);
return(ExecutionState);
}
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesLine sALSalesLine, int salesHeaderID)
{
bool ExecutionState = false;
// Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure.
if (salesHeaderID != null)
oDatabaseHelper.AddParameter("@SalesHeaderID", salesHeaderID);
else
oDatabaseHelper.AddParameter("@SalesHeaderID", DBNull.Value);
// Pass the value of '_productID' as parameter 'ProductID' of the stored procedure.
if (sALSalesLine.ProductID != null)
oDatabaseHelper.AddParameter("@ProductID", sALSalesLine.ProductID);
else
oDatabaseHelper.AddParameter("@ProductID", DBNull.Value);
// Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure.
if (sALSalesLine.TotalQty != null)
oDatabaseHelper.AddParameter("@TotalQty", sALSalesLine.TotalQty);
else
oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value);
// Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure.
if (sALSalesLine.TotalBonus != null)
oDatabaseHelper.AddParameter("@TotalBonus", sALSalesLine.TotalBonus);
else
oDatabaseHelper.AddParameter("@TotalBonus", DBNull.Value);
// Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure.
if (sALSalesLine.DiscountAmount != null)
oDatabaseHelper.AddParameter("@DiscountAmount", sALSalesLine.DiscountAmount);
else
oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value);
// Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure.
if (sALSalesLine.DiscountRatio != null)
oDatabaseHelper.AddParameter("@DiscountRatio", sALSalesLine.DiscountRatio);
else
oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value);
// Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure.
if (sALSalesLine.UnitPrice != null)
oDatabaseHelper.AddParameter("@UnitPrice", sALSalesLine.UnitPrice);
else
oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value);
// Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
if (sALSalesLine.CreatedBy != null)
oDatabaseHelper.AddParameter("@CreatedBy", sALSalesLine.CreatedBy);
else
oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value);
// Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure.
if (sALSalesLine.CreateDate != null)
oDatabaseHelper.AddParameter("@CreateDate", sALSalesLine.CreateDate);
else
oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value);
// Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure.
if (sALSalesLine.UpdatedBy != null)
oDatabaseHelper.AddParameter("@UpdatedBy", sALSalesLine.UpdatedBy);
else
oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value);
// Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure.
if (sALSalesLine.UpdateDate != null)
oDatabaseHelper.AddParameter("@UpdateDate", sALSalesLine.UpdateDate);
else
oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value);
// Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure.
if (sALSalesLine.IsDeleted != null)
oDatabaseHelper.AddParameter("@IsDeleted", sALSalesLine.IsDeleted);
else
oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value);
// Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure.
if (sALSalesLine.DeletedBy != null)
oDatabaseHelper.AddParameter("@DeletedBy", sALSalesLine.DeletedBy);
else
oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value);
// Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure.
if (sALSalesLine.DeleteDate != null)
oDatabaseHelper.AddParameter("@DeleteDate", sALSalesLine.DeleteDate);
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("usp_SALSalesLine_InsertCommit", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);
return ExecutionState;
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="sALSalesLine" type="SALSalesLine">This SALSalesLine will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(SALSalesLine sALSalesLine)
{
_sALSalesLine=POS.DataLayer.SALSalesLine.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(sALSalesLine.SalesLineID));
_sALSalesLine.SalesHeaderID=sALSalesLine.SalesHeaderID;
_sALSalesLine.ProductID=sALSalesLine.ProductID;
_sALSalesLine.TotalQty=sALSalesLine.TotalQty;
_sALSalesLine.TotalBonus=sALSalesLine.TotalBonus;
_sALSalesLine.DiscountAmount=sALSalesLine.DiscountAmount;
_sALSalesLine.DiscountRatio=sALSalesLine.DiscountRatio;
_sALSalesLine.UnitPrice=sALSalesLine.UnitPrice;
_sALSalesLine.CreatedBy=sALSalesLine.CreatedBy;
_sALSalesLine.CreateDate=sALSalesLine.CreateDate;
_sALSalesLine.UpdatedBy=sALSalesLine.UpdatedBy;
_sALSalesLine.UpdateDate=sALSalesLine.UpdateDate;
_sALSalesLine.IsDeleted=sALSalesLine.IsDeleted;
_sALSalesLine.DeletedBy=sALSalesLine.DeletedBy;
_sALSalesLine.DeleteDate=sALSalesLine.DeleteDate;
return _sALSalesLine.Update();
}
