private Address fillAddress(User user, Enums.ADDRESS_TYPE addrType) { Address addr = new Address { Deleted = false, AddressFull = GetFullAddress(), AddressNo = addressno.Text, AddressLine1 = addressline1.Text, AddressLine2 = addressline2.Text, AddressLine3 = addressline3.Text, AddressLine4 = addressline4.Text, AddressLine5 = addressline5.Text, PostalCode = postalcode.Text, Telephone1 = telephone1.Text, Telephone2 = telephone2.Text, Fax = fax.Text, Mobile = mobile.Text, Town = town.Text, County = County.Text, Country = country.Text, UserId = user.UserID, SameAsCustomer = false, SameAsBilling = false, MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), addrType), CreationDate = DateTime.Now, LastAmendmentDate = DateTime.Now, AddressName = null, CreatedBy = user.UserID, LastAmendedBy = null }; return addr; }
private void SetAddresses(ref Address accountAddress, ref Address billingAddress, ref Address shippingAddress) { var query = from c in DatabaseContext.Addresses where c.UserId == LoggedIsUser.UserID select c; foreach (var n in query) { if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.PERSONAL))) { accountAddress = n; } else if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING))) { billingAddress = n; } else if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING))) { shippingAddress = n; } } }
protected void userSubmitButton_Click(object sender, ImageClickEventArgs e) { //var allUsersofCompany = (from UserTable in DatabaseContext.Users where UserTable.CompanyID == LoggedIsUser.CompanyID && UserTable.Enabled == true select UserTable); //int totalEnabledUsers = allUsersofCompany.Count(); //if(totalEnabledUsers == allUsersofCompany.) SelectedTabElement = 4; newUserPanel.Visible = false; addUser.Visible = true; List<User> checkuser = (from UserTable in DatabaseContext.Users where UserTable.Email == userEmailField.Text select UserTable).ToList(); if (checkuser.Any()) { SetErrorMessage("Email address already resgistered with Simplicity"); } else { Address Companyaddress = (from addr in LoggedIsUser.Addresses where addr.MultiAddressType == "COMPANY" select addr).FirstOrDefault(); User user = new User { FullName = userSurNameField.Text + ", " + userFirstNameField.Text, Surname = userSurNameField.Text, Forename = userFirstNameField.Text, JobTitle = userJobTitle.Text, Email = userEmailField.Text, Password = Utility.GetMd5Sum(userPasswordField.Text), ReminderQuestionID = byte.Parse(userlistForgotPasswordQuestion.SelectedValue), ReminderQuestion = userlistForgotPasswordQuestion.SelectedItem.Text, ReminderAnswer = Utility.GetMd5Sum(usertxtForgotPasswordAnswer.Text), CreationDate = DateTime.Now, LastAmendmentDate = DateTime.Now, Type = Enum.GetName(typeof(Enums.ENTITY_TYPE), Enums.ENTITY_TYPE.USER), Deleted = false, OnHold = false, Verified = false, Enabled = true, UserUID = Guid.NewGuid().ToString(), VerificationCode = Guid.NewGuid().ToString(), Approved = 0, PaymentType = 0, LoginAttempts = 0 }; Address address = new Address { Deleted = Companyaddress.Deleted, AddressFull = Companyaddress.AddressFull, AddressNo = Companyaddress.AddressNo, AddressLine1 = Companyaddress.AddressLine1, AddressLine2 = Companyaddress.AddressLine2, AddressLine3 = Companyaddress.AddressLine3, AddressLine4 = Companyaddress.AddressLine4, AddressLine5 = Companyaddress.AddressLine5, PostalCode = Companyaddress.PostalCode, Telephone1 = Companyaddress.Telephone1, Telephone2 = Companyaddress.Telephone2, Fax = Companyaddress.Fax, Mobile = Companyaddress.Mobile, Town = Companyaddress.Town, County = Companyaddress.County, Country = Companyaddress.Country, UserId = user.UserID, SameAsCustomer = Companyaddress.SameAsCustomer, SameAsBilling = Companyaddress.SameAsBilling, MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.PERSONAL), CreationDate = DateTime.Now, LastAmendmentDate = DateTime.Now, AddressName = Companyaddress.AddressName, CreatedBy = LoggedIsUser.UserID, LastAmendedBy = Companyaddress.LastAmendedBy }; Address companyAddress = new Address { Deleted = Companyaddress.Deleted, AddressFull = Companyaddress.AddressFull, AddressNo = Companyaddress.AddressNo, AddressLine1 = Companyaddress.AddressLine1, AddressLine2 = Companyaddress.AddressLine2, AddressLine3 = Companyaddress.AddressLine3, AddressLine4 = Companyaddress.AddressLine4, AddressLine5 = Companyaddress.AddressLine5, PostalCode = Companyaddress.PostalCode, Telephone1 = Companyaddress.Telephone1, Telephone2 = Companyaddress.Telephone2, Fax = Companyaddress.Fax, Mobile = Companyaddress.Mobile, Town = Companyaddress.Town, County = Companyaddress.County, Country = Companyaddress.Country, UserId = user.UserID, SameAsCustomer = Companyaddress.SameAsCustomer, SameAsBilling = Companyaddress.SameAsBilling, MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.COMPANY), CreationDate = DateTime.Now, LastAmendmentDate = DateTime.Now, AddressName = Companyaddress.AddressName, CreatedBy = LoggedIsUser.UserID, LastAmendedBy = Companyaddress.LastAmendedBy }; user.Addresses.Add(address); user.Addresses.Add(companyAddress); user.CompanyID = LoggedIsUser.CompanyID; DatabaseContext.AddToUsers(user); DatabaseContext.SaveChanges(); //call health and safety stored procedure over here to insert company there as well addCompanyToHS(user); EmailUtility.SendUserAccountCreationEmail(user, userPasswordField.Text,usertxtForgotPasswordAnswer.Text); Response.Redirect("~/SignUp.aspx?SelectedTabElement="+SelectedTabElement); } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { Address accountAddress = null; Address billingAddress = null; Address shippingAddress = null; SetAddresses(ref accountAddress, ref billingAddress, ref shippingAddress); if (BillingCheck.Checked) { if (billingAddress != null) { billingAddress.Deleted = false; billingAddress.UserId = LoggedIsUser.UserID; billingAddress.SameAsCustomer = true; billingAddress.SameAsBilling = false; billingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING); billingAddress.AddressName = null; billingAddress.AddressNo = null; billingAddress.AddressLine1 = null; billingAddress.AddressLine2 = null; billingAddress.AddressLine3 = null; billingAddress.AddressLine4 = null; billingAddress.AddressLine5 = null; billingAddress.PostalCode = null; billingAddress.AddressFull = null; billingAddress.Telephone1 = null; billingAddress.Telephone2 = null; billingAddress.Fax = null; billingAddress.Mobile = null; billingAddress.CreatedBy = LoggedIsUser.UserID; billingAddress.CreationDate = DateTime.Now; billingAddress.LastAmendedBy = LoggedIsUser.UserID; billingAddress.LastAmendmentDate = DateTime.Now; billingAddress.Town = null; billingAddress.County = null; billingAddress.Country = null; billingAddress.AddressID = billingAddress.AddressID; DatabaseContext.SaveChanges(); } else { billingAddress = new Address(); billingAddress.Deleted = false; billingAddress.UserId = LoggedIsUser.UserID; billingAddress.SameAsCustomer = true; billingAddress.SameAsBilling = false; billingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING); billingAddress.AddressName = null; billingAddress.AddressNo = null; billingAddress.AddressLine1 = null; billingAddress.AddressLine2 = null; billingAddress.AddressLine3 = null; billingAddress.AddressLine4 = null; billingAddress.AddressLine5 = null; billingAddress.PostalCode = null; billingAddress.AddressFull = null; billingAddress.Telephone1 = null; billingAddress.Telephone2 = null; billingAddress.Fax = null; billingAddress.Mobile = null; billingAddress.CreatedBy = LoggedIsUser.UserID; billingAddress.CreationDate = DateTime.Now; billingAddress.LastAmendedBy = LoggedIsUser.UserID; billingAddress.LastAmendmentDate = DateTime.Now; billingAddress.Town = null; billingAddress.County = null; billingAddress.Country = null; DatabaseContext.AddToAddresses(billingAddress); DatabaseContext.SaveChanges(); } } else { if (billingAddress != null) { billingAddress.Deleted=false; billingAddress.UserId = LoggedIsUser.UserID; billingAddress.SameAsCustomer = true; billingAddress.SameAsBilling=false; billingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING); billingAddress.AddressName=null; billingAddress.AddressNo= txtBillingAddressNo.Text; billingAddress.AddressLine1=txtBillingAddressLine1.Text; billingAddress.AddressLine2=txtBillingAddressLine2.Text; billingAddress.AddressLine3=txtBillingAddressLine3.Text; billingAddress.AddressLine4=txtBillingAddressLine4.Text; billingAddress.AddressLine5=txtBillingAddressLine5.Text; billingAddress.PostalCode=txtBillingPostCode.Text; billingAddress.AddressFull=null; billingAddress.Telephone1= txtBillingTele1.Text; billingAddress.Telephone2= txtBillingTele2.Text; billingAddress.Fax=txtBillingFax.Text; billingAddress.Mobile= txtBillingMobile.Text; billingAddress.CreatedBy= LoggedIsUser.UserID; billingAddress.CreationDate= DateTime.Now; billingAddress.LastAmendedBy = LoggedIsUser.UserID; billingAddress.LastAmendmentDate = DateTime.Now; billingAddress.Town= txtBillingTown.Text; billingAddress.County=txtBillingCounty.Text; billingAddress.Country=txtBillingCountry.Text; billingAddress.AddressID = billingAddress.AddressID; DatabaseContext.SaveChanges(); } else { billingAddress = new Address(); billingAddress.Deleted = false; billingAddress.UserId = LoggedIsUser.UserID; billingAddress.SameAsCustomer = true; billingAddress.SameAsBilling = false; billingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING); billingAddress.AddressName = null; billingAddress.AddressNo = txtBillingAddressNo.Text; billingAddress.AddressLine1 = txtBillingAddressLine1.Text; billingAddress.AddressLine2 = txtBillingAddressLine2.Text; billingAddress.AddressLine3 = txtBillingAddressLine3.Text; billingAddress.AddressLine4 = txtBillingAddressLine4.Text; billingAddress.AddressLine5 = txtBillingAddressLine5.Text; billingAddress.PostalCode = txtBillingPostCode.Text; billingAddress.AddressFull = null; billingAddress.Telephone1 = txtBillingTele1.Text; billingAddress.Telephone2 = txtBillingTele2.Text; billingAddress.Fax = txtBillingFax.Text; billingAddress.Mobile = txtBillingMobile.Text; billingAddress.CreatedBy = LoggedIsUser.UserID; billingAddress.CreationDate = DateTime.Now; billingAddress.LastAmendedBy = LoggedIsUser.UserID; billingAddress.LastAmendmentDate = DateTime.Now; billingAddress.Town = txtBillingTown.Text; billingAddress.County = txtBillingCounty.Text; billingAddress.Country = txtBillingCountry.Text; billingAddress.AddressID = billingAddress.AddressID; DatabaseContext.AddToAddresses(billingAddress); DatabaseContext.SaveChanges(); } } if (ShippingCheck.Checked) { if (shippingAddress != null) { shippingAddress.Deleted = false; shippingAddress.UserId = LoggedIsUser.UserID; shippingAddress.SameAsCustomer = true; shippingAddress.SameAsBilling = false; shippingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING); shippingAddress.AddressName = null; shippingAddress.AddressNo = null; shippingAddress.AddressLine1 = null; shippingAddress.AddressLine2 = null; shippingAddress.AddressLine3 = null; shippingAddress.AddressLine4 = null; shippingAddress.AddressLine5 = null; shippingAddress.PostalCode = null; shippingAddress.AddressFull = null; shippingAddress.Telephone1 = null; shippingAddress.Telephone2 = null; shippingAddress.Fax = null; shippingAddress.Mobile = null; shippingAddress.CreatedBy = LoggedIsUser.UserID; shippingAddress.CreationDate = DateTime.Now; shippingAddress.LastAmendedBy = LoggedIsUser.UserID; shippingAddress.LastAmendmentDate = DateTime.Now; shippingAddress.Town = null; shippingAddress.County = null; shippingAddress.Country = null; shippingAddress.AddressID = shippingAddress.AddressID; DatabaseContext.SaveChanges(); } else { shippingAddress = new Address(); shippingAddress.Deleted = false; shippingAddress.UserId = LoggedIsUser.UserID; shippingAddress.SameAsCustomer = true; shippingAddress.SameAsBilling = false; shippingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING); shippingAddress.AddressName = null; shippingAddress.AddressNo = null; shippingAddress.AddressLine1 = null; shippingAddress.AddressLine2 = null; shippingAddress.AddressLine3 = null; shippingAddress.AddressLine4 = null; shippingAddress.AddressLine5 = null; shippingAddress.PostalCode = null; shippingAddress.AddressFull = null; shippingAddress.Telephone1 = null; shippingAddress.Telephone2 = null; shippingAddress.Fax = null; shippingAddress.Mobile = null; shippingAddress.CreatedBy = LoggedIsUser.UserID; shippingAddress.CreationDate = DateTime.Now; shippingAddress.LastAmendedBy = LoggedIsUser.UserID; shippingAddress.LastAmendmentDate = DateTime.Now; shippingAddress.Town = null; shippingAddress.County = null; shippingAddress.Country = null; DatabaseContext.AddToAddresses(shippingAddress); DatabaseContext.SaveChanges(); } } else { if (shippingAddress != null) { shippingAddress.Deleted = false; shippingAddress.UserId = LoggedIsUser.UserID; shippingAddress.SameAsCustomer = true; shippingAddress.SameAsBilling = false; shippingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING); shippingAddress.AddressName = null; shippingAddress.AddressNo = txtShippingAddressNo.Text; shippingAddress.AddressLine1 = txtShippingAddressLine1.Text; shippingAddress.AddressLine2 = txtShippingAddressLine2.Text; shippingAddress.AddressLine3 = txtShippingAddressLine3.Text; shippingAddress.AddressLine4 = txtShippingAddressLine4.Text; shippingAddress.AddressLine5 = txtShippingAddressLine5.Text; shippingAddress.PostalCode = txtShippingPostCode.Text; shippingAddress.AddressFull = null; shippingAddress.Telephone1 = txtShippingTele1.Text; shippingAddress.Telephone2 = txtShippingTele2.Text; shippingAddress.Fax = txtShippingFax.Text; shippingAddress.Mobile = txtShippingMobile.Text; shippingAddress.CreatedBy = LoggedIsUser.UserID; shippingAddress.CreationDate = DateTime.Now; shippingAddress.LastAmendedBy = LoggedIsUser.UserID; shippingAddress.LastAmendmentDate = DateTime.Now; shippingAddress.Town = txtShippingTown.Text; shippingAddress.County = txtShippingCounty.Text; shippingAddress.Country = txtShippingCountry.Text; shippingAddress.AddressID = shippingAddress.AddressID; DatabaseContext.SaveChanges(); } else { shippingAddress = new Address(); shippingAddress.Deleted = false; shippingAddress.UserId = LoggedIsUser.UserID; shippingAddress.SameAsCustomer = true; shippingAddress.SameAsBilling = false; shippingAddress.MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING); shippingAddress.AddressName = null; shippingAddress.AddressNo = txtShippingAddressNo.Text; shippingAddress.AddressLine1 = txtShippingAddressLine1.Text; shippingAddress.AddressLine2 = txtShippingAddressLine2.Text; shippingAddress.AddressLine3 = txtShippingAddressLine3.Text; shippingAddress.AddressLine4 = txtShippingAddressLine4.Text; shippingAddress.AddressLine5 = txtShippingAddressLine5.Text; shippingAddress.PostalCode = txtShippingPostCode.Text; shippingAddress.AddressFull = null; shippingAddress.Telephone1 = txtShippingTele1.Text; shippingAddress.Telephone2 = txtShippingTele2.Text; shippingAddress.Fax = txtShippingFax.Text; shippingAddress.Mobile = txtShippingMobile.Text; shippingAddress.CreatedBy = LoggedIsUser.UserID; shippingAddress.CreationDate = DateTime.Now; shippingAddress.LastAmendedBy = LoggedIsUser.UserID; shippingAddress.LastAmendmentDate = DateTime.Now; shippingAddress.Town = txtShippingTown.Text; shippingAddress.County = txtShippingCounty.Text; shippingAddress.Country = txtShippingCountry.Text; DatabaseContext.AddToAddresses(shippingAddress); DatabaseContext.SaveChanges(); } } Response.Redirect("~/ConfirmCheckout.aspx"); }
private void SetAddresses(ref Address accountAddress, ref Address billingAddress, ref Address shippingAddress) { int UserId = Int32.Parse(Session["selectedUserValue"].ToString()); var query = from c in DatabaseContext.Addresses where c.UserId == UserId select c; foreach (var n in query) { if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.PERSONAL))) { accountAddress = n; } else if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.BILLING))) { billingAddress = n; } else if (n.MultiAddressType.Equals(Enum.GetName(typeof(Enums.ADDRESS_TYPE), Enums.ADDRESS_TYPE.SHIPPING))) { shippingAddress = n; } } }
/// <summary> /// Create a new Address object. /// </summary> /// <param name="addressID">Initial value of the AddressID property.</param> /// <param name="deleted">Initial value of the Deleted property.</param> /// <param name="userId">Initial value of the UserId property.</param> /// <param name="sameAsCustomer">Initial value of the SameAsCustomer property.</param> /// <param name="sameAsBilling">Initial value of the SameAsBilling property.</param> /// <param name="multiAddressType">Initial value of the MultiAddressType property.</param> /// <param name="creationDate">Initial value of the CreationDate property.</param> public static Address CreateAddress(global::System.Int32 addressID, global::System.Boolean deleted, global::System.Int32 userId, global::System.Boolean sameAsCustomer, global::System.Boolean sameAsBilling, global::System.String multiAddressType, global::System.DateTime creationDate) { Address address = new Address(); address.AddressID = addressID; address.Deleted = deleted; address.UserId = userId; address.SameAsCustomer = sameAsCustomer; address.SameAsBilling = sameAsBilling; address.MultiAddressType = multiAddressType; address.CreationDate = creationDate; return address; }
/// <summary> /// Deprecated Method for adding a new object to the Addresses EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToAddresses(Address address) { base.AddObject("Addresses", address); }
private Address fillAddressUser(User user, Enums.ADDRESS_TYPE addrType) { Address addr = new Address { Deleted = false, AddressFull = GetFullAddressCompanyTab(), AddressNo = CompanyTabAddressNo.Text, AddressLine1 = CompanyTabAddressLine1.Text, AddressLine2 = CompanyTabAddressLine2.Text, AddressLine3 = CompanyTabAddressLine3.Text, AddressLine4 = CompanyTabAddressLine4.Text, AddressLine5 = CompanyTabAddressLine5.Text, PostalCode = CompanyTabPostalCode.Text, Telephone1 = CompanyTabTelephone1.Text, Telephone2 = CompanyTabTelephone2.Text, Fax = CompanyTabFax.Text, Mobile = CompanyTabMobile.Text, Town = CompanyTabTown.Text, County = CompanyTabCounty.Text, Country = CompanyTabCountry.Text, UserId = user.UserID, SameAsCustomer = false, SameAsBilling = false, MultiAddressType = Enum.GetName(typeof(Enums.ADDRESS_TYPE), addrType), CreationDate = DateTime.Now, LastAmendmentDate = DateTime.Now, AddressName = null, CreatedBy = LoggedIsAdmin.UserID, LastAmendedBy = LoggedIsAdmin.UserID }; return addr; }