//commit changes
protected void Button4_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
int customer_id = Convert.ToInt32(Request.Cookies["customer_id"].Value);
int emp_id = Convert.ToInt32(Request.Cookies["empid"].Value);
var account = from acc in allData.Accounts
where acc.id == account_id
select acc;
foreach (var acc in account)
{
if (String.IsNullOrEmpty(acc.comments))
acc.comments = "";
acc.status = status;
acc.comments += TextBox1.Text;
acc.credit_limit = Convert.ToDecimal(creditLimit.Text);
}
//create log
operationLog log = operationLog.CreateoperationLog(emp_id, customer_id, "Modify account:"+logDetails, 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
statusMSG.ForeColor = System.Drawing.Color.FromName("green");
statusMSG.Text="Changes made successful! You may return now.";
Button4.Enabled = false;
}
}
protected void Button1_Click(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;
foreach (var r in result)
{
if (r.credit_limit >= Convert.ToDecimal(TextBox1.Text))
{
r.credit_limit = Convert.ToDecimal(TextBox1.Text);
Button1.Enabled = false;
confirmation.Text = "Submission successful! New credit limit is effective.";
}
else
{
Credit_Limit_Application newApp = Credit_Limit_Application.CreateCredit_Limit_Application(1, Convert.ToDecimal(TextBox1.Text), "submitted", account_id);
allData.AddToCredit_Limit_Application(newApp);
Button1.Enabled = false;
confirmation.Text = "Submission successful! Please wait for 14 days for processing. Click 'back' button to go back to customer page";
}
}
allData.SaveChanges();
}
}
//reject application
protected void Button3_Click(object sender, EventArgs e)
{
int account_number = Convert.ToInt32(Request.Cookies["account_id"].Value);
int customer_id = 0;
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
int app_id = 0;
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var credit_application = from ca in allData.Credit_Limit_Application
where ca.acc_id == account_number
select ca;
foreach (var r in credit_application)
{
r.status = "rejected";
app_id = r.id;
}
var accounts = from acc in allData.Accounts
where acc.id == account_number
select acc;
foreach (var a in accounts)
customer_id = a.cust_id;
//create log
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "reject credit limit application: "+app_id.ToString(), 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
Button2.Enabled = false;
Button3.Enabled = false;
reject_msg.Enabled = true;
reject_msg.Visible = true;
reject_msg.Text = "Rejection successful, please return back to management page.";
}
protected void Page_Load(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;
foreach (var r in result)
{
credit_limit.Text = "$" + r.credit_limit.ToString();
//retrieve all credit limit applications for given customer
var applications = from app in allData.Credit_Limit_Application
where app.acc_id == account_id
where app.status == "submitted"
select app;
int count = 0;
decimal amount = 0;
String status = "";
foreach (var app in applications)
{
amount = app.desired_credit_limit;
status = app.status;
count++;
}
//Recent application submitted.
if (count != 0)
{
Panel2.Enabled = true;
Panel2.Visible = true;
appliedCredit.Text = amount.ToString();
creditStatus.Text = status;
}
else
{
//Customer can submit new application
Panel1.Enabled = true;
Panel1.Visible = true;
}
//display application history
var history = from app in allData.Credit_Limit_Application
where app.acc_id == account_id
select app;
int history_count = 0;
foreach (var h in history)
history_count++;
if (history_count != 0)
{
Panel4.Enabled = true;
Panel4.Visible = true;
GridView1.DataSource = history;
GridView1.DataBind();
}
}
}
}
//save card details
protected void Button6_Click(object sender, EventArgs e)
{
int card_no = Convert.ToInt32(Request.Cookies["card_number"].Value);
int customer_number = 0;
if (product_changed)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from reference in allData.Product_Card_Reference
where reference.card_no == card_no
select reference;
//delete all old references first
foreach (var r in result)
{
allData.DeleteObject(r);
}
//create new reference relations
for (int j = 0; j < purchaseOptions.Items.Count; j++)
{
if (purchaseOptions.Items[j].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(card_no, purchaseOptions.Items[j].Text, j);
allData.AddToProduct_Card_Reference(rf);
}
}
allData.SaveChanges();
}
}
//save status
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from card in allData.Cards
where card.card_no == card_no
select card;
foreach (var r in result)
{
customer_number = r.cust_id;
r.status = status.Text;
}
if (Request.Cookies["viewMode"].Value == "customerEdit")
{
operationLog log = operationLog.CreateoperationLog(customer_number,customer_number,"Card modification on "+card_no.ToString()+logDetails,1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
else
{
int empid =Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_number, "Card modification on "+card_no.ToString()+logDetails, 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
}
Change_confirmation.Text = "All changes have been saved!";
Button6.Enabled = false;
}
//search starts
protected void Button1_Click(object sender, EventArgs e)
{
record.Text = "";
using (lucia_dataEntities allData = new lucia_dataEntities())
{
if (RadioButtonList1.SelectedValue == "By Account Number")
{
int account_number = Convert.ToInt32(TextBox1.Text);
var account = from acc in allData.Accounts
from cust in allData.Customers
where acc.id == account_number
where acc.cust_id == cust.id
select new { CustomerID = cust.id, AccountID = acc.id, AccountStatus = acc.status, FirstName = cust.contact_first_name, LastName = cust.contact_last_name, CreditLimit = acc.credit_limit };
Panel2.Enabled = true;
Panel2.Visible = true;
int count = 0;
foreach (var r in account)
count++;
if (count == 0)
record.Text = "No record found: customer may not have account created. Please note: if a customer has not been approved to have an account yet, you may want to try search by customer option instead.";
GridView1.DataSource = account;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By Customer Number")
{
int customer_number = Convert.ToInt32(TextBox1.Text);
var customer = from cust in allData.Customers
where cust.id == customer_number
select new { CustomerID = cust.id, FirstName = cust.contact_first_name, LastName = cust.contact_last_name };
int count = 0;
Panel2.Enabled = true;
Panel2.Visible = true;
foreach (var r in customer)
count++;
if (count == 0)
record.Text = "No record found: there are no customer records associated with given Customer ID can ben retrieved, please double check your input.";
GridView1.DataSource = customer;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By First Name")
{
var customer = from cust in allData.Customers
where cust.contact_first_name == TextBox1.Text
select new { CustomerID = cust.id, FirstName = cust.contact_first_name, LastName = cust.contact_last_name };
int count = 0;
Panel2.Enabled = true;
Panel2.Visible = true;
foreach (var r in customer)
count++;
if (count == 0)
record.Text = "No record found: there are no customer records associated with given Customer name can ben retrieved, please double check your input.";
GridView1.DataSource = customer;
GridView1.DataBind();
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
string passworda = "aaa";
string usernamea = "aaa";
string email = "aaa";
string welcomeName = " ";
string hello = "This is password recovery of APJ ChemCrad";
int account_id = Convert.ToInt32(username.Text);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var password = from acc in alldata.Accounts
from cust in alldata.Customers
where account_id== acc.id
where acc.cust_id == cust.id
select new { acc,cust };
foreach (var r in password)
{
passworda = r.acc.password;
usernamea = Convert.ToString(r.acc.id);
email = r.cust.email;
welcomeName = r.cust.contact_first_name + " " + r.cust.contact_last_name;
}
if (usernamea == username.Text)
{
MailMessage newMsg = new MailMessage();
newMsg.To.Add(new MailAddress(email, hello));
newMsg.From = new MailAddress("*****@*****.**", "APJ Chem Card");
newMsg.Subject = hello;
newMsg.Body = "Dear," + welcomeName + ":\n "
+ "your user name is: "+usernamea + "\n "
+" your password is :" + passworda;
try
{
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.monash.edu.au";
smtp.Send(newMsg);
lblMail.Text = "Mail Successfully Sent";
}
catch (Exception exc)
{
lblMail.Text = exc.Message;
}
}
else
{
lblMail.Text = "There is no matching record";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string emppass = "******";
string empida = " ";
string empemail = " ";
string hello = "This is password recovery of APJ ChemCrad for Employee";
string welcomeName = "";
int employeeID = Convert.ToInt32(empid.Text);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var passwords = from acc in alldata.Accounts
from emp in alldata.Employees
where acc.id == emp.id
select new { acc , emp};
foreach (var r in passwords)
{
emppass = r.emp.password;
empida = Convert.ToString(r.emp.id);
empemail = r.emp.email;
welcomeName = r.emp.f_name + " " + r.emp.l_name;
}
if (empida == empid.Text)
{
MailMessage newMsg = new MailMessage();
newMsg.To.Add(new MailAddress(empemail, hello));
newMsg.From = new MailAddress("*****@*****.**", "APJ Chem Card");
newMsg.Subject = hello;
newMsg.Body = "Dear," + welcomeName + ":\n "
+ "your user name is: " + empida + "\n "
+ " your password is :" + emppass;
try
{
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.monash.edu.au";
smtp.Send(newMsg);
Label2.Text = "Mail Successfully Sent";
}
catch (Exception exc)
{
Label2.Text = exc.Message;
}
}
else
{
Label2.Text = "There is no matching record";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int employee_id = Convert.ToInt32(Request.Cookies["empid"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from log in allData.operationLogs
where log.fromOperator==employee_id
select log;
GridView1.DataSource = result;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Request.Cookies["viewMode"].Value.Contains("employee"))
{
int emp_id = Convert.ToInt32(Request.Cookies["empid"].Value);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var result = from emp in alldata.Employees
where emp.id == emp_id
where emp.password == TextBox1.Text
select emp;
if (Page.IsValid)
{
foreach (var a in result)
{
a.password = TextBox3.Text;
}
Label1.Text = "Your password has been sucessfully changed";
alldata.SaveChanges();
}
}
}
else if (Request.Cookies["viewMode"].Value.Contains("customer"))
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var result = from acc in alldata.Accounts
where acc.id == account_id
where acc.password == TextBox1.Text
select acc;
if (Page.IsValid)
{
foreach (var a in result)
{
a.password = TextBox3.Text;
}
Label1.Text = "Your password has been sucessfully changed";
alldata.SaveChanges();
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//int cust_id = 0;
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++;
allData.SaveChanges();
allData.Dispose();
lucia_dataEntities alldata = new lucia_dataEntities();
int customer_ida = customer.id;
Account account = Account.CreateAccount(defaultID, "active", Convert.ToDecimal(txCreditLimit.Text), "0000", Convert.ToDecimal(txCreditLimit.Text), customer_ida);
alldata.AddToAccounts(account);
//create log
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
alldata.SaveChanges();
operationLog log = operationLog.CreateoperationLog(empid, account.cust_id, "create new customer", 1, DateTime.Now);
alldata.AddTooperationLogs(log);
alldata.SaveChanges();
Label22.Text = "Your detail has been successfully saved." + account.id;
alldata.Dispose();
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "";
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int application_id = Convert.ToInt32(TextBox1.Text);
var result = from applicaton in allData.Applications
where applicaton.id == application_id
select applicaton;
GridView1.DataSource = result;
GridView1.DataBind();
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
}
}
public IQueryable<reportViewModel> getTransaction(String fromDt, String toDt, int? customerNumber, int? cardNumber)
{
if (String.IsNullOrEmpty(fromDt) || String.IsNullOrEmpty(toDt))
{
fromDt = "01/01/0001 12:00:00 AM";
toDt = "01/01/0001 12:00:00 AM";
}
fromDt = fromDt.Split(' ')[0];
toDt = toDt.Split(' ')[0];
int fromDay = Convert.ToInt32(fromDt.Split('/')[0]);
int fromMonth = Convert.ToInt32(fromDt.Split('/')[1]);
int fromYear = Convert.ToInt32(fromDt.Split('/')[2]);
int toDay = Convert.ToInt32(toDt.Split('/')[0]);
int toMonth = Convert.ToInt32(toDt.Split('/')[1]);
int toYear = Convert.ToInt32(toDt.Split('/')[2]);
DateTime fromDate = new DateTime(fromYear, fromMonth, fromDay);
DateTime toDate = new DateTime(toYear, toMonth, toDay);
lucia_dataEntities allData = new lucia_dataEntities();
var transactions = from tr in allData.Transactions
from cd in allData.Cards
from lc in allData.Stations
where cd.card_no==cardNumber
where lc.id == tr.station_id
where cd.card_no == tr.card_no
where tr.customer_id == customerNumber
where tr.purchase_date >= fromDate
where tr.purchase_date <= toDate
select new reportViewModel
{
cardNumber = tr.card_no,
dateOfPurchase = tr.purchase_date,
product = tr.prod_name,
unit_price_excl_gst = tr.product_unit_price,
unit_price_incl_gst = tr.uni_GST,
total_price_excl_gst = tr.total_price,
total_price_incl_gst = tr.total_GST,
stationLocation = lc.location,
cardType = cd.Card_type,
Name_Rego = cd.register
};
return transactions.AsQueryable();
}
//########################################searching performed here############################################
protected void Button1_Click1(object sender, EventArgs e)
{
Label1.Text = "";
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from inv in allData.Invoices
where inv.customer_id == customerNumber
where inv.from_inv_period >= fromDate
where inv.to_inv_period <= toDate
select inv;
GridView1.DataSource = result;
GridView1.DataBind();
int i = 0;
foreach (var r in result)
i++;
if (i == 0)
Label1.Text = "No records found!";
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.Cookies["viewMode"].Value.Contains("employee"))
{
int emp_id = Convert.ToInt32(Request.Cookies["empid"].Value);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var result = from emp in alldata.Employees
where emp.id == emp_id
where emp.password == TextBox1.Text
select emp;
int check = 0;
foreach (var r in result)
{
check++;
}
if (check == 0)
args.IsValid = false;
}
}
else if (Request.Cookies["viewMode"].Value.Contains("customer"))
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
using (lucia_dataEntities alldata = new lucia_dataEntities())
{
var result = from acc in alldata.Accounts
where acc.id == account_id
where acc.password == TextBox1.Text
select acc;
int check = 0;
foreach (var r in result)
{
check++;
}
if (check == 0)
args.IsValid = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int customer_id = Convert.ToInt32(Request.Cookies["customer_id"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from card in allData.Cards
where card.cust_id == customer_id
where card.status!="closed"
select card;
GridView1.DataSource = result;
GridView1.DataBind();
}
if (Request.Cookies["viewMode"].Value == "employeeSearchView")
{
Button1.Enabled = false;
Button1.Visible = false;
Button3.Enabled = true;
Button3.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int employee_id = Convert.ToInt32(Request.Cookies["empid"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from app in allData.Credit_Limit_Application
where app.status == "submitted"
select app;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "Please select one application item to process.";
GridView1.DataSource = result;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
String product = productdd.SelectedValue;
int stationid = Convert.ToInt32(stationdd.SelectedValue);
int cardNumber = Convert.ToInt32(carddd.SelectedValue);
decimal qtty = Convert.ToDecimal(quantity.SelectedValue);
decimal uni_price = 0;
decimal uni_price_GST = 0;
decimal total_price = 0;
decimal total_price_GST = 0;
int customer_id = 0;
var prd = from p in allData.Product_Option
where p.name == product
select p;
foreach (var p in prd)
{
uni_price = p.pro_op_price;
uni_price_GST = uni_price / 11;
}
total_price = uni_price * qtty;
total_price_GST = uni_price_GST * qtty;
var cd = from c in allData.Cards
where c.card_no == cardNumber
select c;
foreach (var c in cd)
{
customer_id = c.cust_id;
}
Transaction tra = Transaction.CreateTransaction(1, product, RandomDay(), cardNumber, qtty, uni_price, uni_price_GST, total_price, total_price_GST, customer_id);
allData.AddToTransactions(tra);
tra.station_id = stationid;
allData.SaveChanges();
Label1.Text = "Successful.";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
if (RadioButtonList1.SelectedValue == "By First Name")
{
var result = from emp in allData.Employees
from add in allData.Emp_Add
where emp.emp_add_id == add.id
where emp.f_name == TextBox1.Text
select new { ID = emp.id, FirstName = emp.f_name, LastName = emp.l_name, JobDescription = emp.job_description, UnitNumber = add.unit_number, StreetNumber = add.street_number, Street = add.street, State = add.state, PhoneNumber = emp.work_phone };
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
warning.Text = "No records can be found.";
GridView1.DataSource = result;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By ID")
{
int employeeID= Convert.ToInt32(TextBox1.Text);
var result = from emp in allData.Employees
from add in allData.Emp_Add
where emp.emp_add_id==add.id
where emp.id==employeeID
select new { ID = emp.id, FirstName = emp.f_name, LastName = emp.l_name, JobDescription = emp.job_description, UnitNumber = add.unit_number, StreetNumber = add.street_number, Street = add.street, State = add.state };
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
warning.Text = "No records can be found.";
GridView1.DataSource = result;
GridView1.DataBind();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "Start streamlining, this may take a while, please wait .....";
using (lucia_dataEntities allData = new lucia_dataEntities())
{
foreach (Card cd in allData.Cards)
{
//get account number
foreach (Account acc in allData.Accounts)
{
if (cd.cust_id == acc.cust_id)
cd.acc_id = acc.id;
}
//get cardholder details and person type
foreach (Cardholder ch in allData.Cardholders)
{
if (ch.card_no == cd.card_no)
{
cd.Card_type = "Person";
cd.register = ch.name;
}
}
//get vech details and veichle type
foreach (Vehicle v in allData.Vehicles)
{
if (v.card_no == cd.card_no)
{
cd.Card_type = "Vehicle";
cd.register = v.registration_no;
}
}
}
allData.SaveChanges();
}
Label1.Text = "Successful!";
}
//approve application
protected void Button2_Click(object sender, EventArgs e)
{
int account_number = Convert.ToInt32(Request.Cookies["account_id"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int customer_id = 0;
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
int app_id = 0;
var credit_application = from ca in allData.Credit_Limit_Application
where ca.acc_id == account_number
select ca;
var result = from account in allData.Accounts
where account.id == account_number
select account;
foreach (var r in result)
{
r.credit_limit = Convert.ToDecimal(desired_limit.Text);
customer_id = r.cust_id;
}
foreach (var r in credit_application)
{
app_id = r.id;
r.status = "approved";
}
//create log
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "approved credit limit application: "+app_id.ToString(), 1,DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
Button2.Enabled = false;
Button3.Enabled = false;
Approve_msg.Enabled = true;
Approve_msg.Visible = true;
Approve_msg.Text = "Approval successful, please return back to management page.";
}
//Submit button clicked here, so all reference check status needs to be saved
protected void Button1_Click(object sender, EventArgs e)
{
//This variable is used to retrieve proper account number for next page
//Please note, this variable should only be accessed when successful is true
//Which means an account item has been created!
Account ac = new Account();
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int customer_id = Convert.ToInt32(Request.Cookies["selected_customer"].Value);
int application_id = Convert.ToInt32(Request.Cookies["selected_application"].Value);
var result = from customer in allData.Customers
join application in allData.Applications
on customer.id equals application.cust_id
where customer.id == customer_id
select new { customer, application };
//This number is used to detect any bugs that may duplicate records
int i = 0;
Boolean successful = false;
foreach (var r in result)
{
i++;
//An error is detected!
if (i != 1 || r.application.id != application_id)
{
Response.Cookies["error"].Value = "applicationProcessingError";
Response.Redirect("~/applicationManagement/ErrorPage.aspx");
return;
}
//now assign all check fields accordingly
r.application.credit_check = get_check(CreditCheck.Checked);
r.application.reference_check = get_check(referCheck.Checked);
r.application.preliminary_check = get_check(pCheck.Checked);
r.application.final_check = get_check(fCheck.Checked);
//check if all process checks are completed
if (CreditCheck.Checked && referCheck.Checked && pCheck.Checked && fCheck.Checked)
{
//all checks completed, so create new account;
Account account = Account.CreateAccount(i, "active", r.customer.monthly_credit_limit, "0000", r.customer.monthly_credit_limit, r.customer.id);
allData.AddToAccounts(account);
ac = account;
r.application.status = "approved";
successful = true;
}
}
allData.SaveChanges();
if (successful)
{
MailMessage newMsg = new MailMessage();
newMsg.To.Add(new MailAddress(emaila, hello));
newMsg.From = new MailAddress("*****@*****.**", "APJ Chem Card");
newMsg.Subject = hello;
newMsg.Body = "Dear," + usernamea + ":\n "
+ "Congratulations! Your application has for APJ ChemCard account has been approved.\n " +
"Please use the following login details to log into our online system to get access to a vast number of exciting services we are currently offering.\n User Name:" + usernamea + "\n password:"******"\n\n\n Sincerely\n APJ";
try
{
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.monash.edu.au";
smtp.Send(newMsg);
}
catch (Exception exc)
{
}
Response.Cookies["account"].Value = ac.id.ToString();
//create log here
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "New account application approved for customer " + customer_id.ToString(), 1, DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
Response.Redirect("~/applicationManagement/accountSuccessful.aspx");
}
else
{
Response.Redirect("~/applicationManagement/applicationProcessConfirmation.aspx");
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "New account application progress saved for customer " + customer_id.ToString(), 1, DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
}
}
protected void reject_application(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
int application_id = Convert.ToInt32(Request.Cookies["selected_application"].Value);
int customer_id = 0;
var result = from application in allData.Applications
where application.id == application_id
select application;
foreach (var r in result)
{
customer_id = r.cust_id;
r.status = "rejected";
}
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "New account application rejected for customer " + customer_id.ToString(), 1, DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
Response.Redirect("~/applicationManagement/applicationReject.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = Request.Cookies["selected_application"].Value + " with Customer ID: " + Request.Cookies["selected_customer"].Value;
int customer_id = Convert.ToInt32(Request.Cookies["selected_customer"].Value);
int application_id = Convert.ToInt32(Request.Cookies["selected_application"].Value);
Boolean success = true;
Customer selected_customer = new Customer();
if (!IsPostBack)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
//This result have both customer and application
var result = from customer in allData.Customers
join application in allData.Applications
on customer.id equals application.cust_id
where customer.id == customer_id
select new { customer, application };
//This result_reference includes only reference table
var result_reference = from dir in allData.Trade_Reference
where dir.app_id == application_id
select dir;
int i = 0;
foreach (var r in result)
{
applicationID.Text = r.customer.id.ToString();
registerName.Text = r.customer.registered_business_name;
tradingName.Text = r.customer.trading_name;
yearStarts.Text = r.customer.year_of_business_commenced.ToString();
ABN.Text = r.customer.ABN_ACN;
nature.Text = r.customer.nature_of_operation;
name.Text = r.customer.contact_first_name + " " + r.customer.contact_middle_name + " " + r.customer.contact_last_name;
position.Text = r.customer.position;
phoneNo.Text = r.customer.phone_no;
fax.Text = r.customer.fax_no;
mobile.Text = r.customer.mobile_no;
email.Text = r.customer.email;
credit.Text = r.customer.monthly_credit_limit.ToString();
selected_customer = r.customer;
usernamea = r.customer.contact_first_name + " " + r.customer.contact_middle_name + " " + r.customer.contact_last_name;
emaila = email.Text;
passworda = "0000";
//now display address details for current customer
address.Text = "";
if (!String.IsNullOrEmpty(r.customer.Cust_Postal_Address.unit_number.ToString()))
address.Text += r.customer.Cust_Postal_Address.unit_number.ToString() + "/";
address.Text += r.customer.Cust_Postal_Address.street_number.ToString() + "/" + r.customer.Cust_Postal_Address.street + "/" + r.customer.Cust_Postal_Address.suburb + "/" + r.customer.Cust_Postal_Address.state + "/" + r.customer.Cust_Postal_Address.cust_postal_add_code.ToString();
//now display payment details for current customer
if (!String.IsNullOrEmpty(r.application.payment_option))
{
//Now there might be a payment item
//#########NEED TO FURTHER VALIDATE THIS PART
Label18.Text = "";
String payment_option = r.application.payment_option;
//Now check which payment table to search
if (payment_option == credit_card)
{
var payment_result = from pm in allData.Credit_Card
where pm.customer_id == r.customer.id
select pm;
foreach (var payment in payment_result)
{
Label18.Text = "Payment method: Credit card <br />Credit Card type: " + payment.card_type + "<br />"
+ "Credit card number: " + payment.credit_card_no + "<br />Expiry date: " + payment.expiry_date + "<br />"
+ "Credit Card in the name of: " + payment.holder_name;
}
}
else if (payment_option == debit_card)
{
var payment_result = from pm in allData.Direct_Debit
where pm.customer_id == r.customer.id
select pm;
foreach (var payment in payment_result)
{
Label18.Text = "Payment method: Direct Debit <br />Name of the institution: " + payment.name_of_financial_institution +
"<br />Account Name: " + payment.debit_account_name + "<br />Account type: " + payment.debit_account_type + "<br />" +
"BSB: " + payment.BSB_no + "<br />Account number" + payment.account_number;
}
}
}
//Display reference check status
CreditCheck.Checked = (r.application.credit_check == 1);
referCheck.Checked = (r.application.reference_check == 1);
pCheck.Checked = (r.application.preliminary_check == 1);
fCheck.Checked = (r.application.final_check == 1);
i++;
}
if (i != 1)
success = false;
i = 0;
//Label1.Text += "current i is " + i.ToString();
foreach (var r in result_reference)
{
referenceID.Text = r.trade_ref_id.ToString();
refer1.Text = r.trade_ref_description_1;
phone1.Text = r.phone_1;
TextBox5.Text = r.trade_ref_description_2;
phone2.Text = r.phone_2;
fuelSupply.Text = r.existing_fuel_supplier;
fuelPhone.Text = r.fuel_supplier_phone;
i++;
}
if (i != 1)
success = false;
i = 0;
//Label1.Text += "current i is " + i.ToString();
//Now display all cards applied
var select_cards = from card in allData.Cards
where card.cust_id == customer_id
select card;
GridView2.DataSource = select_cards;
GridView2.DataBind();
/*var resultt = from dir in r.application.Directors
from add in allData.Dir_Add
where dir.dir_address_id == add.id
select new { FirstName = dir.f_name, MiddleName = dir.m_name, LastName = dir.l_name, Phone = dir.phone, UnitNumber = add.unit_number, StreetNumber = add.street_number, Street = add.street, Suburb = add.suburb, State = add.state, PostCode = add.dir_add_postal_code };
GridView3.DataSource = resultt;
GridView3.DataBind();
*/
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text += Request.Cookies["customer_id"].Value;
int customer_id = Convert.ToInt32(Request.Cookies["customer_id"].Value);
int num_credit = 0;
int num_debit = 0;
//Button3.Enabled = false;
//Button3.Visible = false;
if (Request.Cookies["viewMode"].Value.Contains("employee"))
{
//Button3.Enabled = true;
//Button3.Visible = true;
}
if (!IsPostBack)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var creditt = from cd in allData.Credit_Card
where cd.customer_id == customer_id
select cd;
var debitt = from db in allData.Direct_Debit
where db.customer_id == customer_id
select db;
foreach (var r in creditt)
num_credit++;
foreach (var r in debitt)
num_debit++;
if (num_credit != 0)
{
credit.Visible = true;
RadioButtonList1.SelectedValue = "Credit Card";
foreach (var a in creditt)
{
creditCName.Text= a.holder_name;
creditCardNo.Text = a.credit_card_no;
eDate.Text = a.expiry_date;
TextBox2.Text = a.card_type;
}
}
if (num_debit != 0)
{
direct.Visible = true;
RadioButtonList1.SelectedValue = "Direct Debit";
foreach (var b in debitt)
{
nameofFI.Text = b.name_of_financial_institution;
debitAccName.Text = b.debit_account_name;
TextBox1.Text = b.debit_account_type;
BSB.Text = b.BSB_no.ToString();
debitAccNo.Text = b.account_number.ToString();
}
}
}
}
}
//create transactions, from 01/08/2012 to datetime.now, all transactions start from 1st of the month to the first of the next month.
protected void Button2_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
//loop through all card items
var cards = from cd in allData.Cards
select cd;
foreach (var c in cards)
{
int card_number = c.card_no;
int customer_number = c.cust_id;
//loop through all months to create all associated transactions
for (int i = 8; i <= DateTime.Now.Month; i++)
{
DateTime fromTime = new DateTime(2012, i, 1);
DateTime toTime = new DateTime(2012,i+1,1);
//search for whether a card fee has already been issued within the time frame
var card_fee_transaction = from cf in allData.Transactions
where cf.card_no == card_number
where cf.purchase_date >= fromTime
where cf.purchase_date <= toTime
where cf.prod_name == "card fee"
select cf;
int j = 0;
foreach (var cft in card_fee_transaction)
j++;
//no card fee, then create one for it.
if (j == 0)
{
decimal gst = 3 / 11;
Transaction newTrans = Transaction.CreateTransaction(j, "card fee", fromTime, card_number, 1, 3, gst, 3, gst, customer_number);
allData.AddToTransactions(newTrans);
}
}
}
allData.SaveChanges();
//create invoice for each customer
var customers = from c in allData.Customers
select c;
foreach(var c in customers)
{
int customer_number = c.id;
for (int i = 1; i <= DateTime.Now.Month; i++)
{
DateTime fromTime = new DateTime(2012, i, 1);
DateTime toTime = new DateTime(2012, i + 1, 1);
//now search through all corresponding transactions, and calculate for an invoice item
decimal total_due = 0;
var transactions = from ts in allData.Transactions
where ts.customer_id==c.id
where ts.purchase_date >= fromTime
where ts.purchase_date <= toTime
select ts;
foreach (var t in transactions)
{
total_due += t.total_price;
}
if (total_due != 0)
{
Invoice ninv = Invoice.CreateInvoice(i, new DateTime(2012, i, 14), customer_number, fromTime, toTime, total_due, 0);
allData.AddToInvoices(ninv);
}
}
}
allData.SaveChanges();
}
Label2.Text = "Successful!";
Button2.Enabled = false;
}
//reset password
protected void Button7_Click(object sender, EventArgs e)
{
Random r = new Random();
int newpassword = r.Next(1000000, 10000000);
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from acc in allData.Accounts
where acc.id == account_id
select acc;
foreach (var re in result)
re.password = newpassword.ToString();
allData.SaveChanges();
PassWord.Text = "New Password: "******" password reset;";
}
protected void Button1_Click(object sender, EventArgs e)
{
using (lucia_dataEntities allData = new lucia_dataEntities())
{
if (RadioButtonList1.SelectedValue == "By Card Number")
{
int card_number = Convert.ToInt32(TextBox1.Text);
var result = from card in allData.Cards
where card.card_no == card_number
select card;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "";
GridView1.DataSource = result;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By Holder Name")
{
var result = from cardholder in allData.Cardholders
from card in allData.Cards
where card.card_no == cardholder.card_no
where cardholder.name == TextBox1.Text
select card;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "";
GridView1.DataSource = result;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By Registration Number")
{
var result = from vehicle in allData.Vehicles
from card in allData.Cards
where vehicle.card_no == card.card_no
where vehicle.registration_no == TextBox1.Text
select card;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "";
GridView1.DataSource = result;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By Account Number")
{
int account_number = Convert.ToInt32(TextBox1.Text);
var result = from card in allData.Cards
from account in allData.Accounts
from customer in allData.Customers
where account.id==account_number
where account.cust_id==customer.id
where card.cust_id == customer.id
select card;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "";
GridView1.DataSource = result;
GridView1.DataBind();
}
if (RadioButtonList1.SelectedValue == "By Customer Number")
{
int customer_number = Convert.ToInt32(TextBox1.Text);
var result = from card in allData.Cards
where card.cust_id == customer_number
select card;
int count = 0;
foreach (var r in result)
count++;
if (count == 0)
Label1.Text = "No records found.";
else
Label1.Text = "";
GridView1.DataSource = result;
GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int account_id = Convert.ToInt32(Request.Cookies["account_id"].Value);
int customer_id = 0;
if(!IsPostBack){
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var account = from acc in allData.Accounts
where acc.id == account_id
select acc;
foreach (var acc in account)
{
status = acc.status;
accountNumber.Text = acc.id.ToString();
accountStatus.Text = status;
customer_id = acc.cust_id;
creditLimit.Text = acc.credit_limit.ToString();
if(String.IsNullOrEmpty(acc.comments))
{
comments.Text = "";
}else{
comments.Text = acc.comments;
}
}
var application = from app in allData.Applications
where app.cust_id == customer_id
select app;
var customer = from cust in allData.Customers
where cust.id == customer_id
select cust;
foreach (var app in application)
{
regiDate.Text = app.app_date.ToString();
}
foreach (var cust in customer)
{
tradingName.Text = cust.trading_name;
phoneNumber.Text = cust.phone_no;
}
if (status == "active")
Button1.Enabled = false;
if (status == "disabled")
Button2.Enabled = false;
if (status == "closed")
Button3.Enabled = false;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//So far, only customer_id is retrieved here, we will include account id later!!
//#############################################################################
int customer_id = Convert.ToInt32(Request.Cookies["Customer_id"].Value);
using (lucia_dataEntities allData = new lucia_dataEntities())
{
var result = from customer in allData.Customers
where customer.id == customer_id
select customer;
//Used for error detection;
int i = 0;
//Used for temp id generation
int defaultID = 0;
foreach (var r in result)
{
//create item with customer_id, reference it with current customer object later
//#####################check whether EF needs items to reference to associated objects!############
Card newCard = Card.CreateCard(i, 1, tradingName.Text, customer_id, "disabled", 1);
newCard.Customer = r;
if (RadioButtonList1.SelectedValue == "For Person")
{
Cardholder cardholder = Cardholder.CreateCardholder(defaultID, personCar.Text, newCard.card_no);
for (int j = 0; j < purchaseOptions.Items.Count; j++)
{
if (purchaseOptions.Items[j].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(newCard.card_no, purchaseOptions.Items[j].Text,defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
allData.AddToCardholders(cardholder);
}
if (RadioButtonList1.SelectedValue == "For Vehicle")
{
Vehicle car = Vehicle.CreateVehicle(personCar.Text, newCard.card_no);
for (int j = 0; j < purchaseOptions.Items.Count; j++)
{
if (purchaseOptions.Items[j].Selected)
{
Product_Card_Reference rf = Product_Card_Reference.CreateProduct_Card_Reference(newCard.card_no, purchaseOptions.Items[j].Text, defaultID);
defaultID++;
allData.AddToProduct_Card_Reference(rf);
}
}
allData.AddToVehicles(car);
}
allData.AddToCards(newCard);
i++;
//Now check whether detector i is greater than 1, which indicates duplicate record in database!!
//######################
//An error is detected!
if (i != 1 || r.id != customer_id)
{
Response.Cookies["error"].Value = "newCardError!i="+i.ToString();
Response.Redirect("~/applicationManagement/ErrorPage.aspx");
return;
}
}
if (Request.Cookies["viewMode"].Value == "customerEdit")
{
operationLog log = operationLog.CreateoperationLog(customer_id, customer_id, "Create new card", 1, DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
else
{
int empid = Convert.ToInt32(Request.Cookies["empid"].Value);
operationLog log = operationLog.CreateoperationLog(empid, customer_id, "Create new card", 1, DateTime.Now);
allData.AddTooperationLogs(log);
allData.SaveChanges();
}
allData.SaveChanges();
//redirect to confirmation page
Response.Redirect("~/accountManagement/cardConfirmation.aspx");
}
}