public static void UpdateAmountViolation(Violation violation, ref List<string> errors)
{
if (violation == null)
{
errors.Add("Invalid violation");
}
DALViolations.UpdateAmountViolation(violation, ref errors);
}
public static void CreateViolation(Violation violation, ref List<string> errors)
{
if (violation == null)
{
errors.Add("Violation cannot be null");
}
if (errors.Count > 0)
return;
violation.violation_id = DALViolations.CreateViolation(violation, ref errors);
}
public void CreatePermitErrorTest()
{
Customer customer = new Customer();
customer.customer_name = "bltestcreatecustomer";
customer.customer_pw = "fakepassword1"; // TODO: Initialize to an appropriate value
customer.customer_type = "undertest";
customer.first_name = "test"; // TODO: Initialize to an appropriate value
customer.middle_name = "test"; // TODO: Initialize to an appropriate value
customer.last_name = "test"; // TODO: Initialize to an appropriate value
List<string> errors = new List<string>();
using (var scop = new System.Transactions.TransactionScope())
{
BLCustomers.CreateCustomer(customer, ref errors);
Permit permit = new Permit();
permit.permit_name = "bl customertest";
permit.customer_type = "undergrad";
permit.price = 50;
permit.v_description = "test";
BLPermitTypes.CreatePermitType(permit, ref errors);
Record record = new Record();
record.customer_id = customer.customer_id;
record.permit_type_id = permit.id;
record.expire_date = DateTime.Parse("11/11/2011");
record.valid = true;
BLRecords.CreatePermit(record, ref errors);
Violation violation = new Violation();
violation.permit_id = record.permit_id;
violation.fee = 48;
violation.v_description = "testing create violations - test1";
violation.violation_date = DateTime.Parse("11/11/2011");
violation.paid = false;
BLViolations.CreateViolation(violation, ref errors);
Record record1 = new Record();
record1.customer_id = customer.customer_id;
record1.permit_type_id = permit.id;
record1.expire_date = DateTime.Parse("11/11/2011");
record1.valid = true;
BLRecords.CreatePermit(record1, ref errors);
Assert.AreEqual(1, errors.Count);
}
}
public static int CreateViolation(Violation violation, ref List<string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
string violationId = string.Empty;
try
{
string strSQL = "createViolation";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
DataSet myDS = new DataSet();
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.SelectCommand.Parameters.Add(new SqlParameter("@permitId", SqlDbType.Int));
mySA.SelectCommand.Parameters.Add(new SqlParameter("@Fee", SqlDbType.Int));
mySA.SelectCommand.Parameters.Add(new SqlParameter("@ViolationDate", SqlDbType.DateTime));
mySA.SelectCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 200));
mySA.SelectCommand.Parameters.Add(new SqlParameter("@Paid", SqlDbType.Bit));
mySA.SelectCommand.Parameters["@permitId"].Value = violation.permit_id;
mySA.SelectCommand.Parameters["@Fee"].Value = violation.fee;
mySA.SelectCommand.Parameters["@ViolationDate"].Value = violation.violation_date;
mySA.SelectCommand.Parameters["@Description"].Value = violation.v_description;
mySA.SelectCommand.Parameters["@Paid"].Value = violation.paid;
mySA.Fill(myDS, "result_table");
violationId = myDS.Tables["result_table"].Rows[0][0].ToString();
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
int retId;
Int32.TryParse(violationId, out retId);
return retId;
}
public static List<Violation> GetCustomerViolations(int customerId, ref List<string> errors)
{
//connections variables and dataset
SqlConnection conn = new SqlConnection(connection_string);
DataSet dS = new DataSet();
List<Violation> violations = new List<Violation>();
try
{
string strSql = "getCustomerViolations";
SqlDataAdapter adapter = new SqlDataAdapter(strSql, conn);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add("@CustomerId", SqlDbType.Int);
adapter.SelectCommand.Parameters["@CustomerId"].Value = customerId;
adapter.Fill(dS, "result_table");
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
if (dS.Tables["result_table"].Rows.Count == 0)
{
return null;
}
else
{
foreach (DataRow row in dS.Tables["result_table"].Rows)
{
Violation vio = new Violation();
vio.violation_id =(int) row["violation_id"];
vio.permit_id = (int)row["permit_id"];
vio.fee = (int)row["fee"];
vio.paid = (bool)row["paid"];
vio.v_description = (string)row["v_description"];
vio.violation_date = (DateTime)row["violation_date"];
violations.Add(vio);
}
return violations;
}
}
public static void UpdateAmountViolation(Violation violation, ref List<string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
try
{
string strSQL = "updateAmountViolation";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.SelectCommand.Parameters.Add(new SqlParameter("@Violation_id", SqlDbType.Int));
mySA.SelectCommand.Parameters.Add(new SqlParameter("@Amount", SqlDbType.Int));
mySA.SelectCommand.Parameters["@Violation_id"].Value = violation.violation_id;
mySA.SelectCommand.Parameters["@Amount"].Value = violation.fee;
DataSet myDS = new DataSet();
mySA.Fill(myDS);
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
}
public static List<Violation> ListViolations(ref List<string> errors)
{
{
SqlConnection conn = new SqlConnection(connection_string);
List<Violation> violations = new List<Violation>();
DataSet dS = new DataSet();
try
{
string strSQL = "listViolations";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.Fill(dS, "result_table");
for (int i =0;i<dS.Tables["result_table"].Rows.Count;i++)
{
Violation violation = new Violation();
violation.violation_id = (int)dS.Tables["result_table"].Rows[i]["violation_id"];
violation.permit_id = (int)dS.Tables["result_table"].Rows[i]["permit_id"];
violation.fee = (int)dS.Tables["result_table"].Rows[i]["fee"];
violation.violation_date = (DateTime)dS.Tables["result_table"].Rows[i]["violation_date"];
violation.v_description = dS.Tables["result_table"].Rows[i]["v_description"].ToString();
violation.paid = (bool)dS.Tables["result_table"].Rows[i]["paid"];
violations.Add(violation);
}
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
return violations;
}
}
public static Violation GetViolationById(int violation_id, ref List<string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
Violation violation = new Violation();
DataSet dS = new DataSet();
try
{
string strSQL = "getViolationById";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.SelectCommand.Parameters.Add(new SqlParameter("@ViolationId", SqlDbType.Int));
mySA.SelectCommand.Parameters["@ViolationId"].Value = violation_id;
mySA.Fill(dS, "result_table");
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
if (dS.Tables["result_table"].Rows.Count > 1)
{
errors.Add("Multiple results");
return null;
}
if (dS.Tables["result_table"].Rows.Count == 0)
{
return null;
}
else
{
violation.violation_id = (int)dS.Tables["result_table"].Rows[0]["violation_id"];
violation.permit_id = (int)dS.Tables["result_table"].Rows[0]["permit_id"];
violation.fee = (int)dS.Tables["result_table"].Rows[0]["fee"];
violation.violation_date = (DateTime)dS.Tables["result_table"].Rows[0]["violation_date"];
violation.v_description = dS.Tables["result_table"].Rows[0]["v_description"].ToString();
violation.paid = (bool)dS.Tables["result_table"].Rows[0]["paid"];
return violation;
}
}
public void createViolationTest()
{
List<string> errors = new List<string>();
using (var scop = new System.Transactions.TransactionScope())
{
Customer customer = new Customer();
customer.customer_name = "create record test";
customer.customer_pw = "test";
customer.customer_type = "test";
customer.first_name = "test";
customer.middle_name = "test";
customer.last_name = "test";
customer.customer_id = DALCustomers.CreateCustomer(customer, ref errors);
Permit permit = new Permit();
permit.permit_name = "create record test";
permit.customer_type = "test";
permit.price = 50;
permit.v_description = "test";
permit.id = DALPermitTypes.CreatePermitType(permit, ref errors);
Record record = new Record();
record.customer_id = customer.customer_id;
record.permit_type_id = permit.id;
record.expire_date = DateTime.Parse("11/11/2011");
record.valid = true;
record.permit_id = DALRecords.CreatePermit(record, ref errors);
Record r_check = DALRecords.GetPermitInfo(customer.customer_id, ref errors);
Violation violation = new Violation();
violation.permit_id = record.permit_id;
violation.fee = 48;
violation.v_description = "testing create violations - test1";
violation.violation_date = DateTime.Parse("11/11/2011");
violation.paid = true;
violation.violation_id = DALViolations.CreateViolation(violation, ref errors);
Violation violation2 = new Violation();
violation2.permit_id = record.permit_id;
violation2.fee = 100;
violation2.v_description = "testing create violations - test2";
violation2.violation_date = DateTime.Parse("11/11/2011");
violation2.paid = false;
violation2.violation_id = DALViolations.CreateViolation(violation2, ref errors);
List<Violation> check = DALViolations.GetCustomerViolations(record.customer_id, ref errors);
Violation check_single_vio = DALViolations.GetViolationById(violation.violation_id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreNotEqual(0, check.Count);
bool pass = false;
Assert.AreEqual(violation.violation_id, check_single_vio.violation_id);
Assert.AreEqual(violation.permit_id, check_single_vio.permit_id);
Assert.AreEqual(violation.fee, check_single_vio.fee);
Assert.AreEqual(violation.paid, check_single_vio.paid);
Assert.AreEqual(violation.v_description, check_single_vio.v_description);
Assert.AreEqual(violation.violation_date, check_single_vio.violation_date);
foreach (Violation v in check)
{
Assert.AreEqual(violation.permit_id, v.permit_id);
Assert.AreEqual(violation2.permit_id, v.permit_id);
if (v.violation_id == violation.violation_id)
{
//Assert.AreEqual(violation.violation_id, v.violation_id);
Assert.AreEqual(violation.fee, v.fee);
Assert.AreEqual(violation.paid, v.paid);
Assert.AreEqual(violation.v_description, v.v_description);
Assert.AreEqual(violation.violation_date, v.violation_date);
pass = true;
}
if (v.violation_id == violation2.violation_id)
{
//Assert.AreEqual(violation.violation_id, v.violation_id);
Assert.AreEqual(violation2.fee, v.fee);
Assert.AreEqual(violation2.paid, v.paid);
Assert.AreEqual(violation2.v_description, v.v_description);
Assert.AreEqual(violation2.violation_date, v.violation_date);
pass = true;
}
}
Assert.AreEqual(true, pass);
}
}
public void ListViolationsTest()
{
List<string> errors = new List<string>();
using (var scop = new System.Transactions.TransactionScope())
{
Customer customer = new Customer();
customer.customer_name = "create record test";
customer.customer_pw = "test";
customer.customer_type = "test";
customer.first_name = "test";
customer.middle_name = "test";
customer.last_name = "test";
customer.customer_id = DALCustomers.CreateCustomer(customer, ref errors);
Permit permit = new Permit();
permit.permit_name = "create record test";
permit.customer_type = "test";
permit.price = 50;
permit.v_description = "test";
permit.id = DALPermitTypes.CreatePermitType(permit, ref errors);
Record record = new Record();
record.customer_id = customer.customer_id;
record.permit_type_id = permit.id;
record.expire_date = DateTime.Parse("11/11/2011");
record.valid = true;
record.permit_id = DALRecords.CreatePermit(record, ref errors);
Record r_check = DALRecords.GetPermitInfo(customer.customer_id, ref errors);
Violation violation = new Violation();
violation.permit_id = record.permit_id;
violation.fee = 48;
violation.v_description = "testing create violations - test1";
violation.violation_date = DateTime.Parse("11/11/2011");
violation.paid = false;
violation.violation_id = DALViolations.CreateViolation(violation, ref errors);
Violation violation2 = new Violation();
violation2.permit_id = record.permit_id;
violation2.fee = 48;
violation2.v_description = "testing create violations - test1";
violation2.violation_date = DateTime.Parse("11/11/2011");
violation2.paid = false;
violation2.violation_id = DALViolations.CreateViolation(violation2, ref errors);
List<Violation> expected_violations = new List<Violation>();
expected_violations.Add(violation);
expected_violations.Add(violation2);
List<Violation> check = DALViolations.ListViolations(ref errors);
Assert.AreEqual(0, errors.Count);
for (int i = 0;i<expected_violations.Count;i++)
{
Assert.AreEqual(expected_violations[i].violation_id, check[i].violation_id);
Assert.AreEqual(expected_violations[i].permit_id, check[i].permit_id);
Assert.AreEqual(expected_violations[i].fee, check[i].fee);
Assert.AreEqual(expected_violations[i].violation_date, check[i].violation_date);
Assert.AreEqual(expected_violations[i].v_description, check[i].v_description);
Assert.AreEqual(expected_violations[i].paid, check[i].paid);
}
}
}
public void UpdateAmountViolation(Violation violation, ref List<string> errors)
{
BLViolations.UpdateAmountViolation(violation, ref errors);
}
public void CreateViolation(Violation violation, ref List<string> errors)
{
BLViolations.CreateViolation(violation, ref errors);
}
public void getCustomerInvoiceHistoryTest()
{
//connections variables and dataset
SqlConnection conn = new SqlConnection(connection_string);
List<string> errors = new List<string>();
using (var scop = new System.Transactions.TransactionScope())
{
Customer customer = new Customer();
customer.customer_name = "get customer invoice";
customer.customer_pw = "test";
customer.customer_type = "test";
customer.first_name = "test";
customer.middle_name = "test";
customer.last_name = "test";
customer.customer_id = DALCustomers.CreateCustomer(customer, ref errors);
Permit permit = new Permit();
permit.permit_name = "get customer invoice1";
permit.customer_type = "test";
permit.price = 50;
permit.v_description = "test";
permit.id = DALPermitTypes.CreatePermitType(permit, ref errors);
Record record = new Record();
record.customer_id = customer.customer_id;
record.permit_type_id = permit.id;
record.expire_date = DateTime.Parse("11/11/2011");
record.valid = true;
record.permit_id = DALRecords.CreatePermit(record, ref errors);
Violation violation1 = new Violation();
violation1.permit_id = record.permit_id;
violation1.fee = 48;
violation1.v_description = "testing create violation1s - test1";
violation1.violation_date = DateTime.Parse("11/11/2011");
violation1.paid = true;
violation1.violation_id = DALViolations.CreateViolation(violation1, ref errors);
Violation violation2 = new Violation();
violation2.permit_id = record.permit_id;
violation2.fee = 100;
violation2.v_description = "testing create violations - test2";
violation2.violation_date = DateTime.Parse("11/11/2011");
violation2.paid = false;
violation2.violation_id = DALViolations.CreateViolation(violation2, ref errors);
Invoice invoice1 = new Invoice();
invoice1.invoice_type = "getcustomerinvoice1";
invoice1.customer_id = customer.customer_id;
invoice1.item_id = record.permit_id;
invoice1.amt_paid = 200;
invoice1.pay_method = "visa";
invoice1.pay_date = DateTime.Parse("11/11/2011");
invoice1.invoice_id = DALInvoices.CreateInvoice(invoice1, ref errors);
Invoice invoice2 = new Invoice();
invoice2.invoice_type = "getcustomerinvoie2";
invoice2.customer_id = customer.customer_id;
invoice2.item_id = violation1.violation_id;
invoice2.amt_paid = 200;
invoice2.pay_method = "visa";
invoice2.pay_date = DateTime.Parse("11/11/2011");
invoice2.invoice_id = DALInvoices.CreateInvoice(invoice2, ref errors);
Invoice invoice3 = new Invoice();
invoice3.invoice_type = "getcustomerinvoice3";
invoice3.customer_id = customer.customer_id;
invoice3.item_id = 500;
invoice3.amt_paid = 200;
invoice3.pay_method = "visa";
invoice3.pay_date = DateTime.Parse("11/11/2011");
invoice3.invoice_id = DALInvoices.CreateInvoice(invoice3, ref errors);
List<Invoice> exepectedInvoices = new List<Invoice>();
exepectedInvoices.Add(invoice1); exepectedInvoices.Add(invoice2); exepectedInvoices.Add(invoice3);
List<Invoice> check = DALCustomers.getCustomerInvoiceHistory(customer.customer_id, ref errors);
int index = 0;
Assert.AreEqual(0, errors.Count);
foreach (Invoice i in exepectedInvoices)
{
Assert.AreEqual(i.invoice_id, check[index].invoice_id);
Assert.AreEqual(i.invoice_type, check[index].invoice_type);
Assert.AreEqual(i.customer_id, check[index].customer_id);
Assert.AreEqual(i.item_id, check[index].item_id);
Assert.AreEqual(i.amt_paid, check[index].amt_paid);
Assert.AreEqual(i.pay_method, check[index].pay_method);
Assert.AreEqual(i.pay_date, check[index].pay_date);
index++;
}
}
}
public void CreateCustomerTest()
{
Customer customer = new Customer();
List<string> errors = new List<string>();
customer.customer_name = "bltestcreatecustomer";
customer.customer_pw = "fakepassword1"; // TODO: Initialize to an appropriate value
customer.customer_type = "undergrad";
customer.first_name = "test"; // TODO: Initialize to an appropriate value
customer.middle_name = "test"; // TODO: Initialize to an appropriate value
customer.last_name = "test"; // TODO: Initialize to an appropriate value
Customer check = new Customer();
using (var scop = new System.Transactions.TransactionScope())
{
//insert
BLCustomers.CreateCustomer(customer, ref errors);
//check = BLCustomers.GetCustomerInfo(customer.customer_id.ToString(), ref errors);
check = BLCustomers.CheckCustomerLoginPassword(customer.customer_name, customer.customer_pw, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.IsNotNull(check);
Assert.AreEqual(customer.customer_id, check.customer_id);
Assert.AreEqual(customer.customer_name, check.customer_name);
Assert.AreEqual(customer.customer_pw, check.customer_pw);
Assert.AreEqual(customer.customer_type, check.customer_type);
Assert.AreEqual(customer.first_name, check.first_name);
Assert.AreEqual(customer.middle_name, check.middle_name);
Assert.AreEqual(customer.last_name, check.last_name);
//update test
customer.customer_pw = "fakepassword1"; // TODO: Initialize to an appropriate value
customer.first_name = "updated BL "; // TODO: Initialize to an appropriate value
customer.middle_name = "updated BL"; // TODO: Initialize to an appropriate value
customer.last_name = "updated BL"; // TODO: Initialize to an appropriate value
BLCustomers.UpdateCustomer(customer, ref errors);
check = BLCustomers.GetCustomerInfo(customer.customer_id.ToString(), ref errors);
Assert.AreEqual(0, errors.Count);
Assert.IsNotNull(check);
Assert.AreEqual(customer.customer_id, check.customer_id);
Assert.AreEqual(customer.customer_name, check.customer_name);
Assert.AreEqual(customer.customer_pw, check.customer_pw);
Assert.AreEqual(customer.customer_type, check.customer_type);
Assert.AreEqual(customer.first_name, check.first_name);
Assert.AreEqual(customer.middle_name, check.middle_name);
Assert.AreEqual(customer.last_name, check.last_name);
//delete test
BLCustomers.DeleteCustomer(customer.customer_id.ToString(), ref errors);
check = BLCustomers.GetCustomerInfo(customer.customer_id.ToString(), ref errors);
Assert.AreEqual(0, errors.Count);
Assert.IsNull(check);
//get record, invoice and violation test
BLCustomers.CreateCustomer(customer, ref errors);
Permit permit = new Permit();
permit.permit_name = "bl customertest";
permit.customer_type = "undergrad";
permit.price = 50;
permit.v_description = "test";
BLPermitTypes.CreatePermitType(permit, ref errors);
Record record = new Record();
record.customer_id = customer.customer_id;
record.permit_type_id = permit.id;
record.expire_date = DateTime.Parse("11/11/2011");
record.valid = true;
BLRecords.CreatePermit(record, ref errors);
Invoice invoice1 = new Invoice();
invoice1.invoice_type = "purchase";
invoice1.customer_id = customer.customer_id;
invoice1.item_id = record.permit_id;
invoice1.amt_paid = 200;
invoice1.pay_method = "debit";
invoice1.pay_date = DateTime.Parse("11/11/2011");
BLInvoices.CreateInvoice(invoice1, ref errors);
Violation violation = new Violation();
violation.permit_id = record.permit_id;
violation.fee = 48;
violation.v_description = "testing create violations - test1";
violation.violation_date = DateTime.Parse("11/11/2011");
violation.paid = false;
BLViolations.CreateViolation(violation, ref errors);
Invoice invoice2 = new Invoice();
invoice2.invoice_type = "violation";
invoice2.customer_id = customer.customer_id;
//invoice2.item_id = violation.violation_id;
invoice2.item_id = 500;
invoice2.amt_paid = 220;
invoice2.pay_method = "debit";
invoice2.pay_date = DateTime.Parse("11/11/2011");
BLInvoices.CreateInvoice(invoice2, ref errors);
List<Violation> expected_violations = new List<Violation>();
expected_violations.Add(violation);
List<Violation> violations = BLViolations.GetCustomerViolations(record.customer_id.ToString(), ref errors);
for (int index = 0; index < expected_violations.Count; index++)
{
Assert.AreEqual(violations[index].permit_id, expected_violations[index].permit_id);
Assert.AreEqual(violations[index].fee, expected_violations[index].fee);
Assert.AreEqual(violations[index].v_description, expected_violations[index].v_description);
Assert.AreEqual(violations[index].violation_date, expected_violations[index].violation_date);
Assert.AreEqual(violations[index].paid, expected_violations[index].paid);
}
List<Invoice> expected_invoices = new List<Invoice>();
expected_invoices.Add(invoice1);
expected_invoices.Add(invoice2);
List<Invoice> invoices = new List<Invoice>();
invoices = BLCustomers.GetCustomerInvoiceHistory(customer.customer_id.ToString(), ref errors);
Assert.AreEqual(0, errors.Count);
for (int index = 0; index < expected_invoices.Count; index++)
{
Assert.AreEqual(expected_invoices[index].invoice_id, invoices[index].invoice_id);
Assert.AreEqual(expected_invoices[index].invoice_type, invoices[index].invoice_type);
Assert.AreEqual(expected_invoices[index].customer_id, invoices[index].customer_id);
Assert.AreEqual(expected_invoices[index].item_id, invoices[index].item_id);
Assert.AreEqual(expected_invoices[index].amt_paid, invoices[index].amt_paid);
Assert.AreEqual(expected_invoices[index].pay_method, invoices[index].pay_method);
Assert.AreEqual(expected_invoices[index].pay_date, invoices[index].pay_date);
}
//update record and invoice test
record.valid = false;
BLRecords.UpdateRecordTable(record, ref errors);
violation.fee = 250;
violation.paid = true;
BLViolations.UpdateAmountViolation(violation, ref errors);
BLViolations.UpdatePayViolation(violation.violation_id.ToString(), ref errors);
expected_violations = new List<Violation>();
expected_violations.Add(violation);
violations = BLViolations.GetCustomerViolations(record.customer_id.ToString(), ref errors);
for (int index = 0; index < expected_violations.Count; index++)
{
Assert.AreEqual(violations[index].permit_id, expected_violations[index].permit_id);
Assert.AreEqual(violations[index].fee, expected_violations[index].fee);
Assert.AreEqual(violations[index].v_description, expected_violations[index].v_description);
Assert.AreEqual(violations[index].violation_date, expected_violations[index].violation_date);
Assert.AreEqual(violations[index].paid, expected_violations[index].paid);
}
//update invoice test
invoice2.amt_paid = 110;
invoice2.pay_method = "credit";
invoice2.pay_date = DateTime.Parse("12/11/2011");
BLInvoices.UpdateInvoiceTable(invoice2, ref errors);
expected_invoices = new List<Invoice>();
expected_invoices.Add(invoice1);
expected_invoices.Add(invoice2);
invoices = new List<Invoice>();
invoices = BLCustomers.GetCustomerInvoiceHistory(customer.customer_id.ToString(), ref errors);
Assert.AreEqual(0, errors.Count);
for (int index = 0; index < expected_invoices.Count; index++)
{
Assert.AreEqual(expected_invoices[index].invoice_id, invoices[index].invoice_id);
Assert.AreEqual(expected_invoices[index].invoice_type, invoices[index].invoice_type);
Assert.AreEqual(expected_invoices[index].customer_id, invoices[index].customer_id);
Assert.AreEqual(expected_invoices[index].item_id, invoices[index].item_id);
Assert.AreEqual(expected_invoices[index].amt_paid, invoices[index].amt_paid);
Assert.AreEqual(expected_invoices[index].pay_method, invoices[index].pay_method);
Assert.AreEqual(expected_invoices[index].pay_date, invoices[index].pay_date);
}
//getpermit based on customer level test
System.Diagnostics.Debug.WriteLine(customer.customer_id);
Permit check_permit = BLPermitTypes.GetPermitsBasedOnCustomer(record.customer_id.ToString(), ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(permit.id, check_permit.id);
Assert.AreEqual(permit.permit_name, check_permit.permit_name);
Assert.AreEqual(permit.customer_type, check_permit.customer_type);
Assert.AreEqual(permit.price, check_permit.price);
Assert.AreEqual(permit.v_description, check_permit.v_description);
//getpermit list
List<Permit> permits = BLPermitTypes.GetPermitsList(ref errors);
Assert.AreEqual(1, permits.Count);
}
}
