protected void Button2_Click(object sender, EventArgs e)
{
int empaddId = 0;
int employee_id = Convert.ToInt32(Request.Cookies["empid"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var updateE = from emp in allData.Employees
where employee_id == emp.id
select emp;
foreach (var r in updateE)
{
r.job_description = jobDescription.Text;
r.work_phone = phone.Text;
if(!String.IsNullOrEmpty(emaila.Text))
r.email = emaila.Text;
empaddId= r.emp_add_id;
}
var empadd = from empaddress in allData.Emp_Add
where empaddress.id == empaddId
select empaddress;
foreach (var a in empadd)
{
a.state = state.Text;
a.suburb = suburb.Text;
a.street = streetName.Text;
a.street_number = Convert.ToInt32(streetNumber.Text);
a.emp_add_postal_code = Convert.ToInt32(postcode.Text);
if (!String.IsNullOrEmpty(unitNumber.Text))
a.unit_number = Convert.ToInt32(unitNumber.Text);
}
allData.SaveChanges();
Label11.Text = "Your profile has been sucessfully changed";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int customer_id = Convert.ToInt32(Request.Cookies["customer_id"].Value);
var direct = from dir in allData.Direct_Debit
where customer_id == dir.customer_id
select dir;
var credit = from cre in allData.Credit_Card
where customer_id == cre.customer_id
select cre;
if (RadioButtonList1.SelectedValue == "Direct Debit")
{
foreach (var r in direct)
{
allData.DeleteObject(r);
}
foreach (var c in credit)
{
allData.DeleteObject(c);
}
Direct_Debit debitCard = Direct_Debit.CreateDirect_Debit(1, nameofFI.Text, debitAccName.Text, debitType.SelectedValue, Convert.ToInt32(BSB.Text), Convert.ToInt32(debitAccNo.Text), customer_id);
allData.AddToDirect_Debit(debitCard);
allData.SaveChanges();
}
else if (RadioButtonList1.SelectedValue == "Credit Card")
{
foreach (var r in direct)
{
allData.DeleteObject(r);
}
foreach (var c in credit)
{
allData.DeleteObject(c);
}
Credit_Card creditCard = Credit_Card.CreateCredit_Card(creditCardNo.Text, 14, creditCName.Text, creditType.SelectedValue, eDate.Text, customer_id, 2);
allData.AddToCredit_Card(creditCard);
allData.SaveChanges();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
int empaddId = 0;
int employee_id = Convert.ToInt32(Request.Cookies["empid"].Value);
empdeID.Text = employee_id.ToString();
var employee = from emp in alldata.Employees
where employee_id == emp.id
select emp;
foreach (var r in employee)
{
empdeID.Text = Convert.ToString(r.id);
jobDescription.Text = r.job_description;
phone.Text = r.work_phone;
emaila.Text = r.email;
empaddId = r.emp_add_id;
}
var empadd = from add in alldata.Emp_Add
where empaddId == add.id
select add;
foreach (var a in empadd)
{
state.Text = a.state;
suburb.Text = a.suburb;
streetName.Text = a.street;
streetNumber.Text = Convert.ToString(a.street_number);
unitNumber.Text = Convert.ToString(a.unit_number);
postcode.Text = Convert.ToString(a.emp_add_postal_code);
}
}
}
}
//This method should create all related data and insert them accordingly!
//Associated data tables include: Application, Customer, Trade_reference, Director, Card, Cardholder, Payment (credit or debit), Acknowledgement, Cust_Postal_Address, Dir_Add, Vehicle
//Because most tables have FKs toward Customer, so Customer will be created first, and Customer.ID will be then used to associate to other tables.
//Becareful with FK chains!
//This method is the main body of inserting input data into database.
//Currently, all optional fields are not inserted!!
//will put if statements in place in a later version!
//Please dont forget!
protected void fillTheForm(object sender, WizardNavigationEventArgs e)
{
int defaultID = 0;
lucia_dataEntities allData = new lucia_dataEntities();
//Create customer address first;
Cust_Postal_Address cust_address = Cust_Postal_Address.CreateCust_Postal_Address(defaultID, DropDownList2.Text, txSuburb.Text, txStreet.Text, Convert.ToInt32(txStreetNumber.Text), Convert.ToInt32(txPostCode.Text));
//assign optional unit number to customer
if (!String.IsNullOrEmpty(txUnitNumber.Text))
cust_address.unit_number = Convert.ToInt32(txUnitNumber.Text);
//add customer address to database set
allData.AddToCust_Postal_Address(cust_address);
defaultID++;
//now create customer, reference cust_address
Customer customer = Customer.CreateCustomer(defaultID, txBusinessName.Text, txTradingName.Text, Convert.ToInt32(txBusinessYear.Text), txABN.Text, txNatureOperation.Text, cust_address.id, txFirstName.Text, txLastName.Text, txPosition.Text, txPhoneNumber.Text, txMobileNumber.Text, txEmail.Text, Convert.ToDecimal(txCreditLimit.Text), DropDownList1.Text);
customer.Cust_Postal_Address = cust_address;
//assign optional middle name for customer
if (!String.IsNullOrEmpty(txMiddleName.Text))
customer.contact_middle_name = txMiddleName.Text;
//assign optional fax
if (!String.IsNullOrEmpty(txFaxNumber.Text))
customer.fax_no = txFaxNumber.Text;
//add customer to database set
allData.AddToCustomers(customer);
defaultID++;
//now create application, use customer.id to reference foreign key
APJProjv1.Application application = APJProjv1.Application.CreateApplication(defaultID, "submitted", DateTime.Now, 0, 0, 0, 0, customer.id);
defaultID++;
//now create trade_reference, this table will include 2 references and 1 existing fuel supplier
Trade_Reference reference1 = Trade_Reference.CreateTrade_Reference(defaultID, txReferenceName1.Text, txReferencePhone1.Text, txExisting.Text, fuelSPhone.Text, application.id, txReferenceName2.Text, txReferencePhone2.Text);
defaultID++;
//now add both items into database
allData.AddToApplications(application);
allData.AddToTrade_Reference(reference1);
//create address item for director 1
Dir_Add direct_address1 = Dir_Add.CreateDir_Add(defaultID, DropDownList3.Text, stSuburb1.Text, stSName1.Text, Convert.ToInt32(stSNumber1.Text), Convert.ToInt32(stPost1.Text));
//assign optional unit number for director 1 address
if (!String.IsNullOrEmpty(stUnit1.Text))
direct_address1.unit_number = Convert.ToInt32(stUnit1.Text);
//add dir_add1 to database
allData.AddToDir_Add(direct_address1);
defaultID++;
//create director1's profile, associate him with address1 and customer and application item;
//PLEASE NOTE!! TEST WHETHER FOREIGN KEYS HAVE BEEN PROPERLY SAVED IN DATABASE!!
//!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Director director1 = Director.CreateDirector(defaultID, stFName1.Text, stLName1.Text, direct_address1.id, customer.id, application.id);
//assign optional middle name for director 1
if (!String.IsNullOrEmpty(stMName1.Text))
director1.m_name = stMName1.Text;
//add phone to director 1
director1.phone = stPhoneNo1.Text;
//store director1 to database
allData.AddToDirectors(director1);
//------
defaultID++;
//create address item for director 2
Dir_Add direct_address2 = Dir_Add.CreateDir_Add(defaultID, DropDownList4.Text, stSuburb2.Text, stSName2.Text, Convert.ToInt32(stSNumber2.Text), Convert.ToInt32(stPost2.Text));
defaultID++;
//assign optional unit number for director address 2
if (!String.IsNullOrEmpty(stUnit2.Text))
direct_address2.unit_number = Convert.ToInt32(stUnit2.Text);
//add address 2 to database
allData.AddToDir_Add(direct_address2);
defaultID++;
//create director 2
Director director2 = Director.CreateDirector(defaultID, stFName2.Text, stLName2.Text, direct_address2.id, customer.id, application.id);
defaultID++;
//assign middle name to director 2
if (!String.IsNullOrEmpty(TextBox7.Text))
director2.m_name = TextBox7.Text;
//add phone number to director 2
director2.phone = stPhoneNo2.Text;
//add director 2 to database;
allData.AddToDirectors(director2);
if (cardOptionList2.SelectedValue == "For Person")
{
defaultID++;
//create a card item first
Card card = Card.CreateCard(defaultID, 0, nameOnCard.Text, customer.id, "disabled", 1);
//add card to database
allData.AddToCards(card);
//create cardholder item
//UI does not have last name in place,will duplicate first name twice
//###################NEED TO BE FIXED!!!#############################
Cardholder cardholder = Cardholder.CreateCardholder(defaultID, TextBox1.Text, card.card_no);
//add cardholder to database
allData.AddToCardholders(cardholder);
//now create reference table for card and product;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(card.card_no, CheckBoxList1.Items[i].Text, defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
}
//vehicle specific
else if (cardOptionList2.SelectedValue == "For Vehicle")
{
defaultID++;
//create a card item first
Card card = Card.CreateCard(defaultID, 0, nameOnCard.Text, customer.id, "disabled", 1);
//add card to database
allData.AddToCards(card);
//create viechel item
Vehicle vehicle = Vehicle.CreateVehicle(TextBox1.Text, card.card_no);
//now create reference table for card and product;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(card.card_no, CheckBoxList1.Items[i].Text, defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
//add vehicle to database
allData.AddToVehicles(vehicle);
}
//From here, we insert card items!
//#########################################
//This section may need further refinement, because current UI for card is not acceptable, we only use it for testing purpose!
//#########################################
//person specific
/* if (RadioButton1.Checked)
{
defaultID++;
//create a card item first
Card card = Card.CreateCard(defaultID, 0, nameOnCard.Text, customer.id, "disabled", 1);
//add card to database
allData.AddToCards(card);
//create cardholder item
//UI does not have last name in place,will duplicate first name twice
//###################NEED TO BE FIXED!!!#############################
Cardholder cardholder = Cardholder.CreateCardholder(defaultID, cdHolderName1.Text,card.card_no);
//add cardholder to database
allData.AddToCardholders(cardholder);
//now create reference table for card and product;
for (int i=0;i< CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(card.card_no, CheckBoxList1.Items[i].Text, defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
}
//vehicle specific
else if (RadioButton2.Checked)
{
defaultID++;
//create a card item first
Card card = Card.CreateCard(defaultID, 0, nameOnCard.Text, customer.id, "disabled", 1);
//add card to database
allData.AddToCards(card);
//create viechel item
Vehicle vehicle = Vehicle.CreateVehicle(carReNo1.Text, card.card_no);
//now create reference table for card and product;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(card.card_no, CheckBoxList1.Items[i].Text, defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
//add vehicle to database
allData.AddToVehicles(vehicle);
}*/
//###################################################
//########END OF CARD CREATION#######################
//Create payment item
if (RadioButtonList1.SelectedValue == debit_card)
{
//create a debit card item
//The first parameter is just an ID
Direct_Debit debitCard = Direct_Debit.CreateDirect_Debit(defaultID, nameofFI.Text, debitAccName.Text, debitType.SelectedValue, Convert.ToInt32(BSB.Text), Convert.ToInt32(debitAccNo.Text), customer.id);
//add this payment item to database
allData.AddToDirect_Debit(debitCard);
application.payment_option = debit_card;
}
else if (RadioButtonList1.SelectedValue == credit_card)
{
//create a credit card item
//#########################
//UI does not support date selection yet between 14/28
//###NEED TO MODIFY UI!!############
Credit_Card creditCard = Credit_Card.CreateCredit_Card(creditCardNo.Text, 14, creditCName.Text, creditType.SelectedValue, eDate.Text, customer.id, defaultID);
//add item to database
allData.AddToCredit_Card(creditCard);
application.payment_option = credit_card;
}
allData.SaveChanges();
Label57.Text = "successful!!";
allData.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
Response.Cookies["viewMode"].Value = "customerEdit";
Response.Cookies["fromDate"].Value = "";
Response.Cookies["toDate"].Value = "";
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from account in allData.Accounts
where account.id == account_id
select account;
//duplicaton detector
int i = 0;
foreach (var r in result)
{
i++;
//duplication detected!
if (i != 1)
{
Response.Cookies["error"].Value = "customerLoggedInError: duplicateAccount!";
Response.Redirect("~/applicationManagement/ErrorPage.aspx");
}
//retrieve customer id
Response.Cookies["customer_id"].Value = r.Customer.id.ToString();
if (r.status == "active")
{
userName.Text = r.Customer.contact_first_name;
credit_limit.Text = r.credit_limit.ToString();
//#########################################################
//Credit avaliable needs to be implemented!!!!!
//####################################################
credit_avaliable.Text = r.credit_limit.ToString();
Account_status.Text = r.status;
//Now set warning message
//Warning message includes: card PIN resetted;
var PINcards = from card in allData.Cards
where card.pin_reset == 0
where card.cust_id==r.Customer.id
select card;
int pin_card_count = 0;
foreach (var p in PINcards)
pin_card_count++;
if (pin_card_count != 0)
Warning_message.Text = "You currently have " + pin_card_count.ToString() + " card(s)' PIN resetted, please visit your nearest station to enter new PIN(s)!";
}
else
{
userName.Text = r.Customer.contact_first_name;
credit_limit.Text = "Not avaliable";
//#########################################################
//Credit avaliable needs to be implemented!!!!!
//####################################################
credit_avaliable.Text = "Not avaliable";
Account_status.Text = r.status;
Warning_message.Text = "Your account is currently inactive, please contact APJ staff for further information.";
}
}
}
}
void Page_PreInit(Object sender, EventArgs e)
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from account in allData.Accounts
where account.id == account_id
select account;
int i = 0;
foreach (var r in result)
{
i++;
//duplication detected!
if (i != 1)
{
Response.Cookies["error"].Value = "customerLoggedInError: duplicateAccount!";
Response.Redirect("~/applicationManagement/ErrorPage.aspx");
}
//retrieve customer id
Response.Cookies["customer_id"].Value = r.Customer.id.ToString();
if (r.status != "active")
{
this.MasterPageFile = "~/Site4.master";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
Response.Cookies["viewMode"].Value = "employeeView";
int employee_id = Convert.ToInt32(Request.Cookies["empid"].Value);
var result = from emp in allData.Employees
where emp.id == employee_id
select emp;
foreach (var r in result)
{
empName.Text = r.f_name;
}
var apps = from app in allData.Applications
where app.status == "submitted"
select app;
int count = 0;
foreach (var a in apps)
count++;
applicationNumber.Text = count.ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int customer_id = Convert.ToInt32(Request.Cookies["customer_id"].Value);
var direct = from dir in allData.Direct_Debit
where customer_id == dir.customer_id
select dir;
var credit = from cre in allData.Credit_Card
where customer_id == cre.customer_id
select cre;
if (RadioButtonList1.SelectedValue == "Direct Debit")
{
foreach (var r in direct)
{
allData.DeleteObject(r);
}
foreach (var c in credit)
{
allData.DeleteObject(c);
}
Direct_Debit debitCard = Direct_Debit.CreateDirect_Debit(1, nameofFI.Text, debitAccName.Text, debitType.SelectedValue, Convert.ToInt32(BSB.Text), Convert.ToInt32(debitAccNo.Text), customer_id);
allData.AddToDirect_Debit(debitCard);
allData.SaveChanges();
}
else if (RadioButtonList1.SelectedValue == "Credit Card")
{
foreach (var r in direct)
{
allData.DeleteObject(r);
}
foreach (var c in credit)
{
allData.DeleteObject(c);
}
Credit_Card creditCard = Credit_Card.CreateCredit_Card(creditCardNo.Text, 14, creditCName.Text, creditType.SelectedValue, eDate.Text, customer_id, 2);
allData.AddToCredit_Card(creditCard);
allData.SaveChanges();
}
if (Request.Cookies["viewMode"].Value.Contains("customer"))
{
operationLog log = operationLog.CreateoperationLog(customer_id, customer_id, "Payment modification", 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
else
{
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "Payment modification", 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
Button2.Enabled = false;
Label57.Text = "New payment details are successfully saved!";
}
}
