//[HttpPost]
//public ActionResult Index(HomeViewModels vm)
//{
// LoginViewModel lvm = new LoginViewModel();
// string s = User.Identity.Name.ToString();
// AccountManager mgr = new AccountManager();
// lvm = mgr.getUserNames(s);
// ViewBag.name = lvm.userFullName;
// ModelState.Clear();
// return View(vm);
//}
public PartialViewResult Details(HomeViewModels vm)
{
DetailsManager mgr = new DetailsManager();
if (vm.Dmode == "ACIS_Historical")
{
vm.Details_ACIS_Historical = mgr.GetDetails_ACIS_Historical(vm.detailsID_1, vm.detailsID_2);
}
if (vm.Dmode == "Alarm_Billing")
{
vm.Details_Alarm_Billing = mgr.GetDetails_Alarm_Billing(vm.detailsID_1);
}
if (vm.Dmode == "Business_License")
{
vm.Details_Business_License = mgr.GetDetails_Business_License(vm.detailsID_1);
}
if (vm.Dmode == "LEADS")
{
vm.Details_LEADS = mgr.GetDetails_LEADS(vm.detailsID_1);
}
if (vm.Dmode == "UB_MUNIS")
{
vm.Details_UB = mgr.GetDetails_UB_Munis(vm.detailsID_1);
}
if (vm.Dmode == "Vendors_MUNIS")
{
vm.Details_MUNIS_VENDORS = mgr.GetDetails_Vendors_Munis(vm.detailsID_1);
}
if (vm.Dmode == "GB_MUNIS")
{
vm.Details_GB = mgr.GetDetails_GB_Munis(vm.detailsID_1);
}
return(PartialView("_Details", vm));
}
// Inherited Functions
public override void Delete()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.IDENTIFICATIONS);
DoDelete(query);
DetailsManager.Remove(this);
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PERSONAL_DETAILS);
query.Add(Database.Tables.PersonalDetails.FirstName);
query.Add(Database.Tables.PersonalDetails.LastName);
query.Add(Database.Tables.PersonalDetails.Address);
query.Add(Database.Tables.PersonalDetails.PostcodeId);
query.Add(Database.Tables.PersonalDetails.DateOfBirth);
query.Add(Database.Tables.PersonalDetails.Sex);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
FirstName = reader.GetString(0);
LastName = reader.GetString(1);
Address = reader.GetString(2);
Postcode = AddressManager.GetPostcode(reader.GetInt32(3));
DateOfBirth = reader.GetDateTime(4);
Sex = reader.GetChar(5);
DetailsManager.Add(this);
}
reader.Close();
Identifications = DetailsManager.GetIdentificationsWithOwner(this);
ContactNumbers = DetailsManager.GetContactNumbersWithOwner(this);
}
// Inherited Functions
public override void Delete()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.CONTACT_NUMBERS);
DoDelete(query);
DetailsManager.Remove(this);
}
public static DetailsManager GetInstance()
{
if (instance == null)
{
instance = new DetailsManager();
}
return(instance);
}
public override void Save()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.IDENTIFICATIONS);
query.Add(Database.Tables.Identifications.Value, Value);
query.Add(Database.Tables.Identifications.DetailsId, Owner);
DoSave(query);
DetailsManager.Add(this);
}
public override void Save()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.CONTACT_NUMBERS);
query.Add(Database.Tables.ContactNumbers.Number, Number);
query.Add(Database.Tables.ContactNumbers.DetailsId, Owner);
DoSave(query);
DetailsManager.Add(this);
}
public void PlayAnimation(Animations.Animation animToPlay)
{
switch (animToPlay.animationType)
{
case Messages.AnimationMessage.AnimationMessageTypes.Scale:
ScaleTo(animToPlay.transform, animToPlay.speed, animToPlay.target);
animToPlay.isPlaying = true;
if (Vector3.Distance(animToPlay.transform.localScale, animToPlay.target) < 0.001f)
{
animToPlay.transform.localScale = animToPlay.target;
animToPlay.isPlaying = false;
animToPlay.hasFinished = true;
}
break;
case Messages.AnimationMessage.AnimationMessageTypes.MoveTo:
//Debug.Log("Anim to play speed: " + animToPlay.speed + " time " + Time.deltaTime);
MoveTo(animToPlay.transform, animToPlay.speed, animToPlay.target);
animToPlay.isPlaying = true;
animToPlay.lastTimePlay = Time.time;
if (Vector3.Distance(animToPlay.transform.GetComponent <RectTransform>().anchoredPosition, animToPlay.target) < 2.0f)
{
animToPlay.isPlaying = false;
animToPlay.hasFinished = true;
animToPlay.transform.GetComponent <RectTransform>().anchoredPosition = animToPlay.target;
}
break;
case Messages.AnimationMessage.AnimationMessageTypes.ChangeSprite:
animToPlay.isPlaying = true;
ChangeSprite(animToPlay.transform, animToPlay.targetSprite, animToPlay.targetColor);
animToPlay.hasFinished = true;
animToPlay.isPlaying = false;
break;
case Messages.AnimationMessage.AnimationMessageTypes.Scroll:
animToPlay.isPlaying = true;
DetailsManager.WriteDestroyedCashElement(animToPlay.text, animToPlay.targetSprite);
animToPlay.hasFinished = true;
animToPlay.isPlaying = false;
break;
case Messages.AnimationMessage.AnimationMessageTypes.PopUpBox:
animToPlay.isPlaying = true;
popUpText.text = animToPlay.text;
popUpImage.sprite = animToPlay.targetSprite;
popUpPanel.gameObject.SetActive(true);
Client.PauseGame();
animToPlay.hasFinished = true;
animToPlay.isPlaying = false;
break;
}
}
private void Awake()
{
if (instance == null)
{
instance = this;
}
else if (instance != this)
{
Destroy(this);
}
}
public void CompletePersonalDetailsTest()
{
// Save the detail and test it's ID
details.Save();
Assert.IsTrue(details.Valid);
// Duplicate Setup
PersonalDetails newDetails = DetailsManager.GetPersonalDetail(details.Id);
Assert.AreEqual(details.Id, newDetails.Id);
Assert.AreEqual(details.FirstName, newDetails.FirstName);
Assert.AreEqual(details.LastName, newDetails.LastName);
Assert.AreEqual(details.Sex, newDetails.Sex);
Assert.AreEqual(details.DateOfBirth.ToString(), newDetails.DateOfBirth.ToString());
Assert.AreEqual(details.Address, newDetails.Address);
Assert.AreEqual(details.Postcode.Postcode, newDetails.Postcode.Postcode);
// Make sure that all the identifications are there...
foreach (Identification original in details.Identifications)
{
bool found = false;
foreach (Identification duplicate in newDetails.Identifications)
{
if (original.Id == duplicate.Id)
{
found = true;
break;
}
}
Assert.IsTrue(found);
}
// Make sure that all contact numbers are there...
foreach (ContactNumber original in details.ContactNumbers)
{
bool found = false;
foreach (ContactNumber duplicate in newDetails.ContactNumbers)
{
if (original.Id == duplicate.Id)
{
found = true;
break;
}
}
Assert.IsTrue(found);
}
}
// Inherited Functions
public override void Delete()
{
foreach (Identification identification in Identifications)
{
identification.Delete();
}
foreach (ContactNumber contactNumber in ContactNumbers)
{
contactNumber.Delete();
}
DatabaseQuery query = new DatabaseQuery(Database.Tables.PERSONAL_DETAILS);
DoDelete(query);
DetailsManager.Remove(this);
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PATIENTS);
query.Add(Database.Tables.Patients.DetailsId);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
int detailsId = reader.GetInt32(0);
Details = DetailsManager.GetPersonalDetail(detailsId);
PatientsManager.Add(this);
}
reader.Close();
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.CONTACT_NUMBERS);
query.Add(Database.Tables.ContactNumbers.Number);
query.Add(Database.Tables.ContactNumbers.DetailsId);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
Number = reader.GetString(0);
Owner = DetailsManager.GetPersonalDetail(reader.GetInt32(1));
DetailsManager.Add(this);
}
reader.Close();
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.IDENTIFICATIONS);
query.Add(Database.Tables.Identifications.Value);
query.Add(Database.Tables.Identifications.DetailsId);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
Value = reader.GetString(0);
Owner = DetailsManager.GetPersonalDetail(reader.GetInt32(1));
DetailsManager.Add(this);
}
reader.Close();
}
public override void Save()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PERSONAL_DETAILS);
query.Add(Database.Tables.PersonalDetails.FirstName, FirstName);
query.Add(Database.Tables.PersonalDetails.LastName, LastName);
query.Add(Database.Tables.PersonalDetails.Address, Address);
query.Add(Database.Tables.PersonalDetails.PostcodeId, Postcode);
query.Add(Database.Tables.PersonalDetails.DateOfBirth, DateOfBirth);
query.Add(Database.Tables.PersonalDetails.Sex, Sex);
DoSave(query);
DetailsManager.Add(this);
foreach (Identification identification in Identifications)
{
identification.Validate();
}
foreach (ContactNumber contactNumber in ContactNumbers)
{
contactNumber.Validate();
}
}
public void SendMessageToClientChangeBalanceTo(float newAmount, GameClient client)
{
// TO-D0: Send command to client to change the U.I. with the new amount
DetailsManager.ChangeBalanceTextTo(newAmount);
}
protected void Page_Load(object sender, EventArgs e)
{
gv_details.DataSource = DetailsManager.GetInstance().GetDetails();
gv_details.DataBind();
gv_shipping.DataSource = ShippingManager.GetInstance().GetShippings();
gv_shipping.DataBind();
string payment = Request.QueryString["paymentmethod"];
txtPayment.Text = payment;
if (!IsPostBack)
{
LoadCart();
}
Master.Logout.Click += new EventHandler(loggingout);
mytime = (string)Session["Email"];
Master.onetime.SelectedIndexChanged += new EventHandler(Language);
Display();
if ((string)Session["mylang"] != null)
{
if ((string)Session["mylang"] == "en-US")
{
Page.UICulture = "en-US";
Page.Culture = "en-US";
Display();
}
else if ((string)Session["mylang"] == "zh-CH")
{
Page.UICulture = "zh-CN";
Page.Culture = "zh-CN";
Display();
}
}
//if (!IsPostBack)
//{
// if (mylang != null)
// {
// if (mylang == "en-US")
// {
// Master.onetime.SelectedValue = mylang;
// Page.UICulture = "en-US";
// Page.Culture = "en-US";
// Display();
// }
// else if (mylang == "zh-CH")
// {
// Master.onetime.SelectedValue = mylang;
// Page.UICulture = "zh-CN";
// Page.Culture = "zh-CN";
// Display();
// }
// }
// else
// {
// Page.UICulture = Master.onetime.SelectedValue;
// Page.Culture = Master.onetime.SelectedValue;
// }
//}
if (mytime == "Admin")
{
Master.one1 = false;
Master.two2 = true;
Master.three3 = true;
Master.four4 = false;
Master.MenuAccount.Text = "Welcome back, " + mytime;
}
else if (mytime != null && mytime != "User")
{
Master.one1 = false;
Master.two2 = true;
Master.three3 = false;
Master.four4 = true;
Master.MenuAccount.Text = "Welcome back, " + mytime;
}
else
{
Master.one1 = true;
Master.two2 = false;
Master.three3 = false;
Master.four4 = true;
Session["Email"] = "User";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int left;
int usercountry;
string userfirstname;
string userlastname;
string usercompany;
string useraddress1;
string useraddress2;
string usercity;
string userstate;
int userpostcode;
string useremail;
int userphone;
//Data Validation
if (ship_diff_address.Checked == true)
{
RfvShippingfirstname.Enabled = true;
RfvShippinglastname.Enabled = true;
RfvShippingaddress1.Enabled = true;
RfvShippingcity.Enabled = true;
RfvShippingpostcode.Enabled = true;
int shippingcountry;
string shippingfirstname;
string shippinglastname;
string shippingcompany;
string shippingaddress1;
string shippingaddress2;
string shippingcity;
string shippingstate;
int shippingpostcode;
usercountry = billing_country.SelectedIndex;
userfirstname = billing_first_name.Text;
userlastname = billing_last_name.Text;
usercompany = billing_company.Text;
useraddress1 = billing_address_1.Text;
useraddress2 = billing_address_2.Text;
usercity = billing_city.Text;
userstate = billing_state.Text;
userpostcode = int.Parse(billing_postcode.Text);
useremail = billing_email.Text;
userphone = int.Parse(billing_phone.Text);
shippingcountry = shipping_country.SelectedIndex;
shippingfirstname = shipping_first_name.Text;
shippinglastname = shipping_last_name.Text;
shippingcompany = shipping_company.Text;
shippingaddress1 = shipping_address_1.Text;
shippingaddress2 = shipping_address_2.Text;
shippingcity = shipping_city.Text;
shippingstate = shipping_state.Text;
shippingpostcode = int.Parse(shipping_postcode.Text);
//Billing Details
UserDetails dt = new UserDetails(usercountry, userfirstname, userlastname, usercompany, useraddress1, useraddress2, usercity,
userstate, userpostcode, useremail, userphone);
DetailsManager.GetInstance().AddDetails(dt);
//Shipping Details
ShippingDetails sh = new ShippingDetails(shippingcountry, shippingfirstname, shippinglastname, shippingcompany, shippingaddress1, shippingaddress2, shippingcity,
shippingstate, shippingpostcode);
ShippingManager.GetInstance().AddShipping(sh);
//Database////////////////////////////////////////////////////////////////////////
int TQuantity = 0;
string Product = "", quantity = "";
string date = DateTime.Now.ToString();
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
Product = Product + item.ItemID.ToString() + ",";
quantity = quantity + item.Quantity + ",";
TQuantity = TQuantity + item.Quantity;
}
string Query = "insert into [Receipt] (Product_Name, Product_Quantity, Billing_Firstname, Billing_Lastname, Billing_Company, Billing_Address_Line1, Billing_Address_Line2, Billing_City, Billing_State, Billing_Postcode, Billing_Email, Billing_Phone, Shipping_Firstname, Shipping_Lastname, Shipping_Company, Shipping_Address_Line1, Shipping_Address_Line2, Shipping_City, Shipping_State, Shipping_Postcode, UserEmail, TQuantity, Date) values('" + Product + "','" + quantity + "','" + billing_first_name.Text + "','" + billing_last_name.Text + "','" + billing_company.Text + "','" + billing_address_1.Text + "','" + billing_address_2.Text + "','" + billing_city.Text + "','" + billing_state.Text + "','" + billing_postcode.Text + "','" + billing_email.Text + "','" + billing_phone.Text + "','" + shipping_first_name.Text + "','" + shipping_last_name.Text + "','" + shipping_company.Text + "','" + shipping_address_1.Text + "','" + shipping_address_2.Text + "','" + shipping_city.Text + "','" + shipping_state.Text + "','" + shipping_postcode.Text + "','" + (string)Session["Email"] + "','" + TQuantity.ToString() + "','" + date + "')";
string strConnectionString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
SqlConnection myConnect = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand(Query, myConnect);
myConnect.Open();
cmd.ExecuteNonQuery();
myConnect.Close();
//////////////////////////////////////////////////////////////////////////////////////
if (RdoCredit.Checked == true)
{
if (txtCardno.Text.Length < 16)
{
lblCreditnumber.Text = "Please enter a Valid Credit Card Number";
}
if (txtCardExpiration.Text.Length < 5)
{
lblExpiry.Text = "Please enter a Valid Expiry Date";
}
if (txtCardCvv.Text.Length < 3)
{
lblCvv.Text = "Please enter a Valid CVV Number)";
}
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
string ins = "SELECT * FROM Products where Product_ID='" + item.ItemID + "'";
SqlConnection con = new SqlConnection(lines);
SqlCommand com = new SqlCommand(ins, con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
left = int.Parse(dr["Stock_Level"].ToString());
int stock = left - item.Quantity;
string queryStr = "UPDATE Products SET" +
" Stock_Level = @ProductStock " +
" WHERE Product_ID = '" + item.ItemID + "'";
SqlConnection conn = new SqlConnection(lines);
SqlCommand cmd1 = new SqlCommand(queryStr, conn);
cmd1.Parameters.AddWithValue("@ProductStock", stock);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
}
con.Close();
}
Server.Transfer("receipt.aspx?paymentmethod=CreditCard");
}
else
{
//paymentmethod = "Bank Transfer [Please Email transfer details to [email protected]]";
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
string ins = "SELECT * FROM Products where Product_ID='" + item.ItemID + "'";
SqlConnection con = new SqlConnection(lines);
SqlCommand com = new SqlCommand(ins, con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
left = int.Parse(dr["Stock_Level"].ToString());
int stock = left - item.Quantity;
string queryStr = "UPDATE Products SET" +
" Stock_Level = @ProductStock " +
" WHERE Product_ID = '" + item.ItemID + "'";
SqlConnection conn = new SqlConnection(lines);
SqlCommand cmd1 = new SqlCommand(queryStr, conn);
cmd1.Parameters.AddWithValue("@ProductStock", stock);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
}
con.Close();
}
Server.Transfer("receipt.aspx?paymentmethod=BankTransfer");
}
//Response.Redirect("receipt.aspx");
}
else
{
usercountry = billing_country.SelectedIndex;
userfirstname = billing_first_name.Text;
userlastname = billing_last_name.Text;
usercompany = billing_company.Text;
useraddress1 = billing_address_1.Text;
useraddress2 = billing_address_2.Text;
usercity = billing_city.Text;
userstate = billing_state.Text;
userpostcode = int.Parse(billing_postcode.Text);
useremail = billing_email.Text;
userphone = int.Parse(billing_phone.Text);
UserDetails dt = new UserDetails(usercountry, userfirstname, userlastname, usercompany, useraddress1, useraddress2, usercity,
userstate, userpostcode, useremail, userphone);
DetailsManager.GetInstance().AddDetails(dt);
//Database////////////////////////////////////////////////////////////////////////
int TQuantity = 0;
string Product = "", quantity = "";
string date = DateTime.Now.ToString();
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
Product = Product + item.ItemID.ToString() + ",";
quantity = quantity + item.Quantity + ",";
TQuantity = TQuantity + item.Quantity;
}
string Query = "insert into [Receipt] (Product_Name, Product_Quantity, Billing_Firstname, Billing_Lastname, Billing_Company, Billing_Address_Line1, Billing_Address_Line2, Billing_City, Billing_State, Billing_Postcode, Billing_Email, Billing_Phone, Shipping_Firstname, Shipping_Lastname, Shipping_Company, Shipping_Address_Line1, Shipping_Address_Line2, Shipping_City, Shipping_State, Shipping_Postcode, UserEmail, TQuantity, Date) values('" + Product + "','" + quantity + "','" + billing_first_name.Text + "','" + billing_last_name.Text + "','" + billing_company.Text + "','" + billing_address_1.Text + "','" + billing_address_2.Text + "','" + billing_city.Text + "','" + billing_state.Text + "','" + billing_postcode.Text + "','" + billing_email.Text + "','" + billing_phone.Text + "','" + shipping_first_name.Text + "','" + shipping_last_name.Text + "','" + shipping_company.Text + "','" + shipping_address_1.Text + "','" + shipping_address_2.Text + "','" + shipping_city.Text + "','" + shipping_state.Text + "','" + shipping_postcode.Text + "','" + (string)Session["Email"] + "','" + TQuantity.ToString() + "','" + date + "')";
string strConnectionString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
SqlConnection myConnect = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand(Query, myConnect);
myConnect.Open();
cmd.ExecuteNonQuery();
myConnect.Close();
if (RdoCredit.Checked == true)
{
if (txtCardno.Text.Length < 16)
{
lblCreditnumber.Text = "Please enter a Valid Credit Card Number";
}
if (txtCardExpiration.Text.Length < 5)
{
lblExpiry.Text = "Please enter a Valid Expiry Date";
}
if (txtCardCvv.Text.Length < 3)
{
lblCvv.Text = "Please enter a Valid CVV Number)";
}
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
string ins = "SELECT * FROM Products where Product_ID='" + item.ItemID + "'";
SqlConnection con = new SqlConnection(lines);
SqlCommand com = new SqlCommand(ins, con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
left = int.Parse(dr["Stock_Level"].ToString());
int stock = left - item.Quantity;
string queryStr = "UPDATE Products SET" +
" Stock_Level = @ProductStock " +
" WHERE Product_ID = '" + item.ItemID + "'";
SqlConnection conn = new SqlConnection(lines);
SqlCommand cmd1 = new SqlCommand(queryStr, conn);
cmd1.Parameters.AddWithValue("@ProductStock", stock);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
}
con.Close();
}
Server.Transfer("receipt.aspx?paymentmethod=CreditCard");
}
else
{
//paymentmethod = "Bank Transfer [Please Email transfer details to [email protected]]";
foreach (ShoppingCartItem item in ShoppingCart.Instance.Items)
{
string ins = "SELECT * FROM Products where Product_ID='" + item.ItemID + "'";
SqlConnection con = new SqlConnection(lines);
SqlCommand com = new SqlCommand(ins, con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
left = int.Parse(dr["Stock_Level"].ToString());
int stock = left - item.Quantity;
string queryStr = "UPDATE Products SET" +
" Stock_Level = @ProductStock " +
" WHERE Product_ID = '" + item.ItemID + "'";
SqlConnection conn = new SqlConnection(lines);
SqlCommand cmd1 = new SqlCommand(queryStr, conn);
cmd1.Parameters.AddWithValue("@ProductStock", stock);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
}
con.Close();
}
Server.Transfer("receipt.aspx?paymentmethod=BankTransfer");
}
// Response.Redirect("receipt.aspx");
}
}
public void SendMessageToClientChangeSwapCost(float newSwapCost, GameClient client)
{
// TO-D0: Send command to client to change the U.I. with the new swap cost
DetailsManager.ChangeSwapCostTo(newSwapCost);
}
