public Pawn()
{
Customer = new Party();
Items = new ObservableCollection<Item>();
Date = DateTime.Now;
PawnStatusId = 'A';
}
private void PrintAndDoMore_Click(object sender, RoutedEventArgs e)
{
PreSavePurchase();
if (PurchaseIsValid())
{
bool saved = SavePurchase();
if (saved)
{
Print();
Data.Party p = purchase.Customer;
purchase = new Data.Purchase();
purchase.Customer = p;
InitializeFields();
}
}
else
{
MessageBox.Show("Purchase Failed Validation. Please Correct and try again.");
}
}
public Party PartySearchById(string IDNumber)
{
SqlConnection conn = new SqlConnection(connectionString);
//Create Command w/Parameters
SqlCommand cmd = new SqlCommand("PartySearchById", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDNumber", IDNumber);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleResult);
Party p = null;
DateTime dob;
while (reader.Read())
{
p = new Party(
int.Parse(reader["PartyId"].ToString()),
reader["IDNumber"].ToString(),
DateTime.TryParse(reader["DateOfBirth"].ToString(), out dob) ? dob : (DateTime?)null,
reader["Last"].ToString(),
reader["First"].ToString(),
reader["City"].ToString(),
int.Parse(reader["ActivePawns"].ToString()),
int.Parse(reader["TotalPawns"].ToString()),
0//ItemsAvailable
);
}
return p;
}
catch (Exception Ex)
{
throw Ex;
}
}
public Collection<Party> PartySearch(string Last, string First, ref int PawnToCustomerId)
{
SqlConnection conn = new SqlConnection(connectionString);
//Create Command w/Parameters
SqlCommand cmd = new SqlCommand("PartySearch", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Last", Last);
cmd.Parameters.AddWithValue("@First", First);
SqlParameter PawnToCustomerIdParameter = new SqlParameter("@PawnToCustomerId", SqlDbType.Int);
PawnToCustomerIdParameter.Direction = ParameterDirection.InputOutput;
PawnToCustomerIdParameter.Value = PawnToCustomerId;
cmd.Parameters.Add(PawnToCustomerIdParameter);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleResult);
Collection<Party> parties = new Collection<Party>();
Party currentparty;
DateTime dob;
while (reader.Read())
{
currentparty = new Party(
int.Parse(reader["PartyId"].ToString()),
reader["IDNumber"].ToString(),
DateTime.TryParse(reader["DateOfBirth"].ToString(), out dob) ? dob : (DateTime?)null,
reader["Last"].ToString(),
reader["First"].ToString(),
reader["City"].ToString(),
int.Parse(reader["ActivePawns"].ToString()),
int.Parse(reader["TotalPawns"].ToString()),
0//ItemsAvailable
);
parties.Add(currentparty);
}
PawnToCustomerId = int.Parse(PawnToCustomerIdParameter.Value.ToString());
return parties;
}
catch (Exception Ex)
{
throw Ex;
}
}
public int PartySave(Party party, int employee)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("PartyUpsert", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = cmd.Parameters.Add("@PartyId", SqlDbType.Int);
if (party.PartyId == 0)
p.Direction = ParameterDirection.Output;
else
p.Direction = ParameterDirection.Input;
p.Value = party.PartyId;
cmd.Parameters.AddWithValue("@EmployeeId", employee);
cmd.Parameters.AddWithValue("@IdTypeId", 1);
cmd.Parameters.AddWithValue("@IdState", "WA");
cmd.Parameters.AddWithValue("@IDNumber", party.IDNumber);
cmd.Parameters.AddWithValue("@IdIssued", null);
cmd.Parameters.AddWithValue("@IdExpiration", party.IdExpiration);
cmd.Parameters.AddWithValue("@DateOfBirth", party.DateOfBirth);
cmd.Parameters.AddWithValue("@Last", party.Last);
cmd.Parameters.AddWithValue("@First", party.First);
cmd.Parameters.AddWithValue("@Middle", party.Middle);
cmd.Parameters.AddWithValue("@Street", party.Street);
cmd.Parameters.AddWithValue("@City", party.City);
cmd.Parameters.AddWithValue("@State", party.State);
cmd.Parameters.AddWithValue("@Zip", party.Zip);
cmd.Parameters.AddWithValue("@Sex", party.Sex);
cmd.Parameters.AddWithValue("@Height", party.Height);
cmd.Parameters.AddWithValue("@Weight", party.Weight);
cmd.Parameters.AddWithValue("@Eyes", party.Eyes);
cmd.Parameters.AddWithValue("@Race", party.Race);
cmd.Parameters.AddWithValue("@Hair", party.Hair);
cmd.Parameters.AddWithValue("@Phone", party.Phone);
cmd.Parameters.AddWithValue("@Email", party.Email);
cmd.Parameters.AddWithValue("@Note", party.Note);
cmd.ExecuteNonQuery();
return Int32.Parse(p.Value.ToString());
}
public Party PartyGetDetails(int partyid)
{
SqlConnection conn = new SqlConnection(connectionString);
try
{
SqlCommand cmd = new SqlCommand("PartyGetDetails", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PartyId", partyid);
//cmd.Parameters.AddWithValue("@IDNumber", IDNumber);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
DateTime dti;
DateTime dtb;
Party party = new Party(partyid, reader["IDNumber"].ToString(),
DateTime.TryParse(reader["IdExpiration"].ToString(), out dti) ? dti : (DateTime?)null,
DateTime.TryParse(reader["DateOfBirth"].ToString(), out dtb) ? dtb : (DateTime?)null,
reader["Last"].ToString(), reader["First"].ToString(), reader["Middle"].ToString(),
reader["Street"].ToString(), reader["City"].ToString(), reader["State"].ToString(), reader["Zip"].ToString(),
reader["Sex"].ToString(), reader["Height"].ToString(), reader["Weight"].ToString(), reader["Eyes"].ToString(), reader["Race"].ToString(), reader["Hair"].ToString(),
reader["Phone"].ToString(), reader["Email"].ToString(), reader["Note"].ToString(),
0, 0, int.Parse(reader["ItemsAvailable"].ToString()), reader["IntegrationId"].ToString());
return party;
}
else
{
return null;
}
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
public Purchase()
{
Customer = new Party();
Items = new ObservableCollection<Item>();
Date = DateTime.Now;
}
public Purchase()
{
Customer = new Party();
Items = new ObservableCollection <Item>();
Date = DateTime.Now;
}
