public override void Modify(InvheaderRecord record)
{
DbCommand command = this.Provider.GetStoredProcedure("spInsertUpdateInvHeader");
this.MapParameterIn(command, "@PA_USER_LOGIN_ID", "dev");
if (record.AccId == null)
{
record.AccId = string.Empty;
record.AccStatus = string.Empty;
}
if (record.OrgId == null)
{
record.OrgId = string.Empty;
record.InvOrgName = string.Empty;
record.Add = string.Empty;
record.AddMailstring = string.Empty;
}
if (record.ProleId == null)
{
record.ProleId = string.Empty;
record.PersonId = string.Empty;
}
this.MapParametersIn(command, record, true);
this.Execute(command);
this.MapParametersOut(command, record);
}
public override void Create(InvheaderRecord record)
{
DbCommand command = this.Provider.GetStoredProcedure("spInsertUpdateInvHeader");
this.MapParameterIn(command, "@PA_USER_LOGIN_ID", "dev");
this.MapParametersIn(command, record, true);
this.Execute(command);
this.MapParametersOut(command, record);
}
public void CreditInvoice(InvheaderRecord record, string invId, string userloginId)
{
DbCommand command = this.Provider.GetStoredProcedure("spInsertUpdateInvHeader");
this.MapParameterIn(command, "@PA_USER_LOGIN_ID", userloginId);
this.MapParameterIn(command, "@PA_INV_CREDIT_NTE_REF", record.Id);
this.MapParameterIn(command, "@PA_CREDIT_INVOICE", 1);
this.Execute(command);
this.MapParametersOut(command, record);
}
public void RollbackInvoice(InvheaderRecord record)
{
DbCommand command = this.Provider.GetStoredProcedure("spInsertUpdateInvHeader");
this.MapParameterIn(command, "@PA_USER_LOGIN_ID", "dev");
this.MapParameterIn(command, "@PA_INV_CREDIT_NTE_REF", record.Id);
this.MapParameterIn(command, "@PA_CREDIT_INVOICE", "1");
this.MapParameterIn(command, "@PA_INV_MEP_ID", record.MepId);
this.Execute(command);
this.MapParametersOut(command, record);
}
/// <summary>
/// Indicates whether the current <see cref="InvheaderRecord" /> instance is equal to another <see cref="InvheaderRecord" /> instance.
/// </summary>
/// <param name="that">
/// The <see cref="InvheaderRecord" /> instance to be compared against this instance.
/// </param>
/// <returns>
/// True if both instances are considered equal; otherwise, false.
/// </returns>
public Boolean Equals(InvheaderRecord that)
{
Boolean result = true;
result = result && (this.Id.TrimOrNullify() == that.Id.TrimOrNullify());
result = result && (this.Lock.TrimOrNullify() == that.Lock.TrimOrNullify());
result = result && (this.BookId.TrimOrNullify() == that.BookId.TrimOrNullify());
result = result && (this.OrgId.TrimOrNullify() == that.OrgId.TrimOrNullify());
result = result && (this.PersonId.TrimOrNullify() == that.PersonId.TrimOrNullify());
result = result && (this.SalesmanId.TrimOrNullify() == that.SalesmanId.TrimOrNullify());
result = result && (this.DelvryRef.TrimOrNullify() == that.DelvryRef.TrimOrNullify());
result = result && (this.Carrier.TrimOrNullify() == that.Carrier.TrimOrNullify());
result = result && (this.DelvryDate == that.DelvryDate);
result = result && (this.OrderDate == that.OrderDate);
result = result && (this.CustOrderNo.TrimOrNullify() == that.CustOrderNo.TrimOrNullify());
result = result && (this.DelvryAdd.TrimOrNullify() == that.DelvryAdd.TrimOrNullify());
result = result && (this.Ref.TrimOrNullify() == that.Ref.TrimOrNullify());
result = result && (this.Date == that.Date);
result = result && (this.Status == that.Status);
result = result && (this.Add.TrimOrNullify() == that.Add.TrimOrNullify());
result = result && (this.CreditNteRef.TrimOrNullify() == that.CreditNteRef.TrimOrNullify());
result = result && (this.CreditNteDte == that.CreditNteDte);
result = result && (this.CreditNteSta == that.CreditNteSta);
result = result && (this.Notes.TrimOrNullify() == that.Notes.TrimOrNullify());
result = result && (this.NetTotal == that.NetTotal);
result = result && (this.VatTotal == that.VatTotal);
result = result && (this.GrossTotal == that.GrossTotal);
result = result && (this.NetTotalBc == that.NetTotalBc);
result = result && (this.VatTotalBc == that.VatTotalBc);
result = result && (this.GrossTotalBc == that.GrossTotalBc);
result = result && (this.CurrencyType.TrimOrNullify() == that.CurrencyType.TrimOrNullify());
result = result && (this.Type.TrimOrNullify() == that.Type.TrimOrNullify());
result = result && (this.AccountType.TrimOrNullify() == that.AccountType.TrimOrNullify());
result = result && (this.InRespectOf.TrimOrNullify() == that.InRespectOf.TrimOrNullify());
result = result && (this.Footer.TrimOrNullify() == that.Footer.TrimOrNullify());
result = result && (this.CreditPercent == that.CreditPercent);
result = result && (this.CourseId.TrimOrNullify() == that.CourseId.TrimOrNullify());
result = result && (this.CourseName.TrimOrNullify() == that.CourseName.TrimOrNullify());
result = result && (this.CorsStrtDte == that.CorsStrtDte);
result = result && (this.CourseEndDte == that.CourseEndDte);
result = result && (this.CorsCostCode.TrimOrNullify() == that.CorsCostCode.TrimOrNullify());
result = result && (this.BookRef.TrimOrNullify() == that.BookRef.TrimOrNullify());
result = result && (this.Booker.TrimOrNullify() == that.Booker.TrimOrNullify());
result = result && (this.BookOrgName.TrimOrNullify() == that.BookOrgName.TrimOrNullify());
result = result && (this.AddMailstring.TrimOrNullify() == that.AddMailstring.TrimOrNullify());
result = result && (this.BkOrgCustAc.TrimOrNullify() == that.BkOrgCustAc.TrimOrNullify());
result = result && (this.VenueOrgName.TrimOrNullify() == that.VenueOrgName.TrimOrNullify());
result = result && (this.Penalty == that.Penalty);
result = result && (this.BookOrgRegi.TrimOrNullify() == that.BookOrgRegi.TrimOrNullify());
result = result && (this.PrintBooker == that.PrintBooker);
result = result && (this.InvOrgName.TrimOrNullify() == that.InvOrgName.TrimOrNullify());
result = result && (this.ExtraNotes.TrimOrNullify() == that.ExtraNotes.TrimOrNullify());
result = result && (this.BatId.TrimOrNullify() == that.BatId.TrimOrNullify());
result = result && (this.SalesId.TrimOrNullify() == that.SalesId.TrimOrNullify());
result = result && (this.Text.TrimOrNullify() == that.Text.TrimOrNullify());
result = result && (this.PayDate == that.PayDate);
result = result && (this.PayStatus.TrimOrNullify() == that.PayStatus.TrimOrNullify());
result = result && (this.ProjId.TrimOrNullify() == that.ProjId.TrimOrNullify());
result = result && (this.CcardId.TrimOrNullify() == that.CcardId.TrimOrNullify());
result = result && (this.Recvd == that.Recvd);
result = result && (this.RecvdBc == that.RecvdBc);
result = result && (this.Period.TrimOrNullify() == that.Period.TrimOrNullify());
result = result && (this.DueDate == that.DueDate);
result = result && (this.UnpaidVal == that.UnpaidVal);
result = result && (this.UnpaidValBc == that.UnpaidValBc);
result = result && (this.NotesId.TrimOrNullify() == that.NotesId.TrimOrNullify());
result = result && (this.CrystalRpt.TrimOrNullify() == that.CrystalRpt.TrimOrNullify());
result = result && (this.AppBy.TrimOrNullify() == that.AppBy.TrimOrNullify());
result = result && (this.AppDate == that.AppDate);
result = result && (this.ForAttnOf.TrimOrNullify() == that.ForAttnOf.TrimOrNullify());
result = result && (this.Printed == that.Printed);
result = result && (this.CurrRateBc == that.CurrRateBc);
result = result && (this.CurrRateBc2 == that.CurrRateBc2);
result = result && (this.SelcoSpId.TrimOrNullify() == that.SelcoSpId.TrimOrNullify());
result = result && (this.MepId.TrimOrNullify() == that.MepId.TrimOrNullify());
result = result && (this.LtId.TrimOrNullify() == that.LtId.TrimOrNullify());
result = result && (this.Userchar1.TrimOrNullify() == that.Userchar1.TrimOrNullify());
result = result && (this.AccStatus.TrimOrNullify() == that.AccStatus.TrimOrNullify());
result = result && (this.AccRef.TrimOrNullify() == that.AccRef.TrimOrNullify());
result = result && (this.AccNotes.TrimOrNullify() == that.AccNotes.TrimOrNullify());
result = result && (this.AccModBy.TrimOrNullify() == that.AccModBy.TrimOrNullify());
result = result && (this.AccModDate == that.AccModDate);
result = result && (this.NetTotalBc2 == that.NetTotalBc2);
result = result && (this.VatTotalBc2 == that.VatTotalBc2);
result = result && (this.GrossTotalBc2 == that.GrossTotalBc2);
result = result && (this.UnpaidTotalBc2 == that.UnpaidTotalBc2);
result = result && (this.PrintBatId.TrimOrNullify() == that.PrintBatId.TrimOrNullify());
result = result && (this.PersonPhone.TrimOrNullify() == that.PersonPhone.TrimOrNullify());
result = result && (this.AccId.TrimOrNullify() == that.AccId.TrimOrNullify());
result = result && (this.BatError == that.BatError);
result = result && (this.SalesProleId.TrimOrNullify() == that.SalesProleId.TrimOrNullify());
result = result && (this.ProleId.TrimOrNullify() == that.ProleId.TrimOrNullify());
return(result);
}
/// <summary>
/// Creates a new <see cref="InvheaderRecord" /> object instance that is a shallow-copy of the current object instance.
/// </summary>
/// <returns>
/// The shallow-copy of the current <see cref="InvheaderRecord" /> object instance.
/// </returns>
public InvheaderRecord Clone()
{
InvheaderRecord record = new InvheaderRecord();
record.Id = this.Id;
record.Lock = this.Lock;
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.BookId = this.BookId;
record.OrgId = this.OrgId;
record.PersonId = this.PersonId;
record.SalesmanId = this.SalesmanId;
record.DelvryRef = this.DelvryRef;
record.Carrier = this.Carrier;
record.DelvryDate = this.DelvryDate;
record.OrderDate = this.OrderDate;
record.CustOrderNo = this.CustOrderNo;
record.DelvryAdd = this.DelvryAdd;
record.Ref = this.Ref;
record.Date = this.Date;
record.Status = this.Status;
record.Add = this.Add;
record.CreditNteRef = this.CreditNteRef;
record.CreditNteDte = this.CreditNteDte;
record.CreditNteSta = this.CreditNteSta;
record.Notes = this.Notes;
record.NetTotal = this.NetTotal;
record.VatTotal = this.VatTotal;
record.GrossTotal = this.GrossTotal;
record.NetTotalBc = this.NetTotalBc;
record.VatTotalBc = this.VatTotalBc;
record.GrossTotalBc = this.GrossTotalBc;
record.CurrencyType = this.CurrencyType;
record.Type = this.Type;
record.AccountType = this.AccountType;
record.InRespectOf = this.InRespectOf;
record.Footer = this.Footer;
record.CreditPercent = this.CreditPercent;
record.CourseId = this.CourseId;
record.CourseName = this.CourseName;
record.CorsStrtDte = this.CorsStrtDte;
record.CourseEndDte = this.CourseEndDte;
record.CorsCostCode = this.CorsCostCode;
record.BookRef = this.BookRef;
record.Booker = this.Booker;
record.BookOrgName = this.BookOrgName;
record.AddMailstring = this.AddMailstring;
record.BkOrgCustAc = this.BkOrgCustAc;
record.VenueOrgName = this.VenueOrgName;
record.Penalty = this.Penalty;
record.BookOrgRegi = this.BookOrgRegi;
record.PrintBooker = this.PrintBooker;
record.InvOrgName = this.InvOrgName;
record.ExtraNotes = this.ExtraNotes;
record.BatId = this.BatId;
record.SalesId = this.SalesId;
record.Text = this.Text;
record.PayDate = this.PayDate;
record.PayStatus = this.PayStatus;
record.ProjId = this.ProjId;
record.CcardId = this.CcardId;
record.Recvd = this.Recvd;
record.RecvdBc = this.RecvdBc;
record.Period = this.Period;
record.DueDate = this.DueDate;
record.UnpaidVal = this.UnpaidVal;
record.UnpaidValBc = this.UnpaidValBc;
record.NotesId = this.NotesId;
record.CrystalRpt = this.CrystalRpt;
record.AppBy = this.AppBy;
record.AppDate = this.AppDate;
record.ForAttnOf = this.ForAttnOf;
record.Printed = this.Printed;
record.CurrRateBc = this.CurrRateBc;
record.CurrRateBc2 = this.CurrRateBc2;
record.SelcoSpId = this.SelcoSpId;
record.MepId = this.MepId;
record.LtId = this.LtId;
record.Userchar1 = this.Userchar1;
record.AccStatus = this.AccStatus;
record.AccRef = this.AccRef;
record.AccNotes = this.AccNotes;
record.AccModBy = this.AccModBy;
record.AccModDate = this.AccModDate;
record.NetTotalBc2 = this.NetTotalBc2;
record.VatTotalBc2 = this.VatTotalBc2;
record.GrossTotalBc2 = this.GrossTotalBc2;
record.UnpaidTotalBc2 = this.UnpaidTotalBc2;
record.PrintBatId = this.PrintBatId;
record.PersonPhone = this.PersonPhone;
record.AccId = this.AccId;
record.BatError = this.BatError;
record.SalesProleId = this.SalesProleId;
record.ProleId = this.ProleId;
return(record);
}