public override void RemoveById(InvlineRecord record)
{
DbCommand command = this.Provider.GetStoredProcedure("spDeleteInvLine");
this.MapParameterIn(command, "@PA_USER_LOGIN_ID", "dev");
this.MapParametersIn(command, record, true);
this.Execute(command);
this.MapParametersOut(command, record);
}
/// <summary>
/// Creates a new <see cref="InvlineRecord" /> object instance that is a shallow-copy of the current object instance.
/// </summary>
/// <returns>
/// The shallow-copy of the current <see cref="InvlineRecord" /> object instance.
/// </returns>
public InvlineRecord Clone()
{
InvlineRecord record = new InvlineRecord();
record.Id = this.Id;
record.AddDate = this.AddDate;
record.AddBy = this.AddBy;
record.ModDate = this.ModDate;
record.ModBy = this.ModBy;
record.RcvDate = this.RcvDate;
record.RcvFrom = this.RcvFrom;
record.InvId = this.InvId;
record.ProductId = this.ProductId;
record.OrderLnId = this.OrderLnId;
record.LineNo = this.LineNo;
record.Qty = this.Qty;
record.UnitPrice = this.UnitPrice;
record.Discount = this.Discount;
record.DisctPrice = this.DisctPrice;
record.Net = this.Net;
record.VatCode = this.VatCode;
record.VatRate = this.VatRate;
record.VatAmt = this.VatAmt;
record.TotalPrice = this.TotalPrice;
record.CreditDesc = this.CreditDesc;
record.UnitPrceBc = this.UnitPrceBc;
record.DiscountBc = this.DiscountBc;
record.DiscPrceBc = this.DiscPrceBc;
record.NetBc = this.NetBc;
record.TotPriceBc = this.TotPriceBc;
record.CurrType = this.CurrType;
record.Description = this.Description;
record.SalesId = this.SalesId;
record.SalesDetId = this.SalesDetId;
record.BookId = this.BookId;
record.ElemId = this.ElemId;
record.CourseId = this.CourseId;
record.Type = this.Type;
record.ProdName = this.ProdName;
record.PrdRevCode = this.PrdRevCode;
record.ProjId = this.ProjId;
record.MelId = this.MelId;
record.UntPrceBc2 = this.UntPrceBc2;
record.NetBc2 = this.NetBc2;
record.TotPrceBc2 = this.TotPrceBc2;
record.VatAmtBc = this.VatAmtBc;
record.VatAmtBc2 = this.VatAmtBc2;
record.CostCode = this.CostCode;
record.Credited = this.Credited;
record.Userchar1 = this.Userchar1;
record.Anl1 = this.Anl1;
record.Anl2 = this.Anl2;
record.Anl3 = this.Anl3;
record.DiscountBc2 = this.DiscountBc2;
record.DiscPriceBc2 = this.DiscPriceBc2;
record.CreditForInvlnId = this.CreditForInvlnId;
record.DoNotPrint = this.DoNotPrint;
record.DelCostCode = this.DelCostCode;
record.SelcoSpId = this.SelcoSpId;
record.CurrencyType = this.CurrencyType;
record.CurrRateBc = this.CurrRateBc;
record.CurrRateBc2 = this.CurrRateBc2;
record.UnitPriceDisc = this.UnitPriceDisc;
record.UnitPriceDiscBc = this.UnitPriceDiscBc;
record.UnitPriceDiscBc2 = this.UnitPriceDiscBc2;
record.Dept = this.Dept;
record.Sku = this.Sku;
record.JobCode = this.JobCode;
record.JobAnalCode = this.JobAnalCode;
record.JobType = this.JobType;
record.JobParent = this.JobParent;
record.PrsType = this.PrsType;
return(record);
}
/// <summary>
/// Indicates whether the current <see cref="InvlineRecord" /> instance is equal to another <see cref="InvlineRecord" /> instance.
/// </summary>
/// <param name="that">
/// The <see cref="InvlineRecord" /> instance to be compared against this instance.
/// </param>
/// <returns>
/// True if both instances are considered equal; otherwise, false.
/// </returns>
public Boolean Equals(InvlineRecord that)
{
Boolean result = true;
result = result && (this.Id.TrimOrNullify() == that.Id.TrimOrNullify());
result = result && (this.InvId.TrimOrNullify() == that.InvId.TrimOrNullify());
result = result && (this.ProductId.TrimOrNullify() == that.ProductId.TrimOrNullify());
result = result && (this.OrderLnId.TrimOrNullify() == that.OrderLnId.TrimOrNullify());
result = result && (this.LineNo == that.LineNo);
result = result && (this.Qty == that.Qty);
result = result && (this.UnitPrice == that.UnitPrice);
result = result && (this.Discount == that.Discount);
result = result && (this.DisctPrice == that.DisctPrice);
result = result && (this.Net == that.Net);
result = result && (this.VatCode.TrimOrNullify() == that.VatCode.TrimOrNullify());
result = result && (this.VatRate == that.VatRate);
result = result && (this.VatAmt == that.VatAmt);
result = result && (this.TotalPrice == that.TotalPrice);
result = result && (this.CreditDesc.TrimOrNullify() == that.CreditDesc.TrimOrNullify());
result = result && (this.UnitPrceBc == that.UnitPrceBc);
result = result && (this.DiscountBc == that.DiscountBc);
result = result && (this.DiscPrceBc == that.DiscPrceBc);
result = result && (this.NetBc == that.NetBc);
result = result && (this.TotPriceBc == that.TotPriceBc);
result = result && (this.CurrType.TrimOrNullify() == that.CurrType.TrimOrNullify());
result = result && (this.Description.TrimOrNullify() == that.Description.TrimOrNullify());
result = result && (this.SalesId.TrimOrNullify() == that.SalesId.TrimOrNullify());
result = result && (this.SalesDetId.TrimOrNullify() == that.SalesDetId.TrimOrNullify());
result = result && (this.BookId.TrimOrNullify() == that.BookId.TrimOrNullify());
result = result && (this.ElemId.TrimOrNullify() == that.ElemId.TrimOrNullify());
result = result && (this.CourseId.TrimOrNullify() == that.CourseId.TrimOrNullify());
result = result && (this.Type == that.Type);
result = result && (this.ProdName.TrimOrNullify() == that.ProdName.TrimOrNullify());
result = result && (this.PrdRevCode.TrimOrNullify() == that.PrdRevCode.TrimOrNullify());
result = result && (this.ProjId.TrimOrNullify() == that.ProjId.TrimOrNullify());
result = result && (this.MelId.TrimOrNullify() == that.MelId.TrimOrNullify());
result = result && (this.UntPrceBc2 == that.UntPrceBc2);
result = result && (this.NetBc2 == that.NetBc2);
result = result && (this.TotPrceBc2 == that.TotPrceBc2);
result = result && (this.VatAmtBc == that.VatAmtBc);
result = result && (this.VatAmtBc2 == that.VatAmtBc2);
result = result && (this.CostCode.TrimOrNullify() == that.CostCode.TrimOrNullify());
result = result && (this.Credited == that.Credited);
result = result && (this.Userchar1.TrimOrNullify() == that.Userchar1.TrimOrNullify());
result = result && (this.Anl1.TrimOrNullify() == that.Anl1.TrimOrNullify());
result = result && (this.Anl2.TrimOrNullify() == that.Anl2.TrimOrNullify());
result = result && (this.Anl3.TrimOrNullify() == that.Anl3.TrimOrNullify());
result = result && (this.DiscountBc2 == that.DiscountBc2);
result = result && (this.DiscPriceBc2 == that.DiscPriceBc2);
result = result && (this.CreditForInvlnId.TrimOrNullify() == that.CreditForInvlnId.TrimOrNullify());
result = result && (this.DoNotPrint == that.DoNotPrint);
result = result && (this.DelCostCode.TrimOrNullify() == that.DelCostCode.TrimOrNullify());
result = result && (this.SelcoSpId.TrimOrNullify() == that.SelcoSpId.TrimOrNullify());
result = result && (this.CurrencyType.TrimOrNullify() == that.CurrencyType.TrimOrNullify());
result = result && (this.CurrRateBc == that.CurrRateBc);
result = result && (this.CurrRateBc2 == that.CurrRateBc2);
result = result && (this.UnitPriceDisc == that.UnitPriceDisc);
result = result && (this.UnitPriceDiscBc == that.UnitPriceDiscBc);
result = result && (this.UnitPriceDiscBc2 == that.UnitPriceDiscBc2);
result = result && (this.Dept.TrimOrNullify() == that.Dept.TrimOrNullify());
result = result && (this.Sku.TrimOrNullify() == that.Sku.TrimOrNullify());
result = result && (this.JobCode.TrimOrNullify() == that.JobCode.TrimOrNullify());
result = result && (this.JobAnalCode.TrimOrNullify() == that.JobAnalCode.TrimOrNullify());
result = result && (this.JobType.TrimOrNullify() == that.JobType.TrimOrNullify());
result = result && (this.JobParent.TrimOrNullify() == that.JobParent.TrimOrNullify());
result = result && (this.PrsType == that.PrsType);
return(result);
}
