public TransactionQuery GetUpdateQuery(RefNum refNumChanges) { refNumChanges.RefNumId = refNumChanges.RefNumId == 0 ? 1 : refNumChanges.RefNumId; var newSeriesNum = string.Format("{0:0000000}", Convert.ToInt64(refNumChanges.ReceiptSeriesNum) + 1); refNumChanges.ReceiptSeriesNum = newSeriesNum; var parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = nameof(RefNum.RefNumId).Parameterize(), ParameterValue = refNumChanges.RefNumId }); parameters.Add(new ParameterInfo() { ParameterName = nameof(RefNum.ReceiptSeriesNum).Parameterize(), ParameterValue = refNumChanges.ReceiptSeriesNum.ToUpper() }); StringBuilder qry = new StringBuilder(); qry.AppendLine("Update RefNums set"); qry.AppendLine($"{nameof(refNumChanges.ReceiptSeriesNum)}={nameof(refNumChanges.ReceiptSeriesNum).Parameterize()}"); qry.AppendLine($"where {nameof(refNumChanges.RefNumId)} = {nameof(refNumChanges.RefNumId).Parameterize()}"); return(new TransactionQuery() { Query = qry, Parameters = parameters }); }
public bool Equals(Pickup other) { if (other == null) { return(false); } return(Index.Equals(other.Index) && Unknown04h.Equals(other.Unknown04h) && Unknown08h.Equals(other.Unknown08h) && Amount.Equals(other.Amount) && Unknown10h.Equals(other.Unknown10h) && Unknown14h.Equals(other.Unknown14h) && Blip.Equals(other.Blip) && Timer.Equals(other.Timer) && Position.Equals(other.Position) && Unknown2Ch.Equals(other.Unknown2Ch) && Unknown30h.Equals(other.Unknown30h) && Rotation.Equals(other.Rotation) && Unknown40h.Equals(other.Unknown40h) && ObjectId.Equals(other.ObjectId) && RefNum.Equals(other.RefNum) && PickupType.Equals(other.PickupType) && Flags.Equals(other.Flags) && Flags2.Equals(other.Flags2) && Unknown4Bh.Equals(other.Unknown4Bh) && Unknown4Ch.Equals(other.Unknown4Ch) && Unknown50h.Equals(other.Unknown50h)); }
public RefNum Update(RefNum RefNumChanges) { var parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = nameof(RefNum.RefNumId).Parameterize(), ParameterValue = RefNumChanges.RefNumId }); parameters.Add(new ParameterInfo() { ParameterName = nameof(RefNum.ReceiptSeriesNum).Parameterize(), ParameterValue = RefNumChanges.ReceiptSeriesNum.ToUpper() }); StringBuilder qry = new StringBuilder(); qry.AppendLine("Update RefNums set"); qry.AppendLine($"{nameof(RefNumChanges.ReceiptSeriesNum)}={nameof(RefNumChanges.ReceiptSeriesNum).Parameterize()}"); qry.AppendLine($"where {nameof(RefNumChanges.RefNumId)} = {nameof(RefNumChanges.RefNumId).Parameterize()}"); int success = DBContext.ExecuteQuery(qry.ToString(), parameters); return(RefNumChanges); }
// Override ToString method public override string ToString() { return("RefNum: " + RefNum.ToString() + ",\t Name: " + Name + ",\t Color: " + Col); }