//[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); }