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