/// <summary> /// Creates a new Member entity in Database. /// </summary> /// <param name="memberCL">General Details of new member to be added in the Database.</param> /// <returns>Class of Member which contains created data.</returns> /// public MemberCL createMember(MemberCL memberCL) { Member memBer = dbcontext.Members.Add(new Member { DateCreated = DateTime.Now, DateModified = DateTime.Now, Id = memberCL.id, AddressId = memberCL.addressId, Email = memberCL.email, Gender = memberCL.gender, IsDeleted = memberCL.isDeleted, IsGuest = memberCL.isGuest, MobileNumber = memberCL.mobNo, Name = memberCL.name, Password = memberCL.password, }); dbcontext.SaveChanges(); MemberCL memberCLchanged = new MemberCL() { id = memBer.Id, addressId = memBer.AddressId, email = memBer.Email, gender = memBer.Gender, isDeleted = memBer.IsDeleted, isGuest = memBer.IsGuest, mobNo = memBer.MobileNumber, name = memBer.Name, password = memBer.Password }; return(memberCLchanged); }
protected void btnRegister_Click(object sender, EventArgs e) { bool checkUsrname = memberBLL.chkUserName(txtEmail.Text.ToLower()); if (checkUsrname) { pnlForgotPwd.Visible = true; //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Email Address Already Exists.')", true); } else { addressCL.addressLine1 = txtHouseNo.Text; addressCL.addressLine2 = txtStrtNo.Text; addressCL.addressLine3 = txtLandmark.Text; addressCL.addressTypeId = Convert.ToInt32(ddlAddType.SelectedValue); addressCL.cityId = Convert.ToInt32(ddlCity.SelectedValue); AddressCL address = memberBLL.createAddress(addressCL); memberCL.name = txtName.Text; memberCL.mobNo = txtMobNo.Text; memberCL.password = txtPassword.Text; memberCL.email = txtEmail.Text.ToLower(); memberCL.addressId = address.id; memberCL.isGuest = false; memberCL.gender = rbtnMale.Checked ? true : false; MemberCL memberCl = memberBLL.createMember(memberCL); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully Registered. Check Email for activation.')", true); } }
/// <summary> /// Updates the Entity of Member in the Database. /// </summary> /// <param name="memberCL">Member Entity to be changed.</param> /// <param name="addressCL">Address Entitiy to be changed.</param> /// <param name="addressTypeCL">AddressType Entitiy to be changed.</param> /// <returns>Updated Member Entity.</returns> public MemberCL updateMember(MemberCL memberCL) { Member query = (from type in dbcontext.Members where type.Id == memberCL.id && type.IsDeleted == false && type.Password != memberCL.password select type).FirstOrDefault(); Member newMember = query; newMember.AddressId = memberCL.addressId; newMember.Email = memberCL.email; newMember.Gender = memberCL.gender; newMember.IsDeleted = memberCL.isDeleted; newMember.IsGuest = memberCL.isGuest; newMember.MobileNumber = memberCL.mobNo; newMember.Name = memberCL.name; newMember.Password = memberCL.password; dbcontext.SaveChanges(); MemberCL updateddata = new MemberCL() { email = newMember.Email, gender = newMember.Gender, id = newMember.Id, isDeleted = newMember.IsDeleted, isGuest = newMember.IsGuest, mobNo = newMember.MobileNumber, name = newMember.Name, password = newMember.Password, addressId = newMember.AddressId, dateModified = DateTime.Now }; return(updateddata); }
protected void btnUpdateAccnt_Click(object sender, EventArgs e) { bool chkpass = memberBLL.chkPassword(new MemberCL { password = memberCL.password }); if (chkpass) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('password do not match !!')", true); } else { addressCL.addressLine1 = txtHouseNo.Text; addressCL.addressLine2 = txtMobileNo.Text; addressCL.addressLine3 = txtLandmark.Text; addressCL.addressTypeId = Convert.ToInt32(ddlAddType.SelectedValue); addressCL.cityId = Convert.ToInt32(ddlCity.SelectedValue); AddressCL address = memberBLL.updateAddress(addressCL); memberCL.name = txtName.Text; memberCL.dateModified = DateTime.Now; memberCL.isGuest = false; memberCL.gender = rbtnMale.Checked ? true : false; memberCL.password = txtNewPwd.Text; memberCL.id = memberId; memberCL.addressId = address.id; MemberCL newMemberCL = memberBLL.updateMember(memberCL); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('successfully updated. !!')", true); } }
/// <summary> /// Checks if the Password is correct or not. /// </summary> /// <param name="memberCL">Pasword entered By the User.</param> /// <returns>Returns a member class instance checking whether password is correct or not. </returns> public bool chkPassword(MemberCL memberCL) { Member query = (from x in dbcontext.Members where x.Id == memberCL.id && x.IsDeleted == false select x).FirstOrDefault(); if (query.Password == memberCL.password) { return(false); } else { return(true); } }
protected void btnOk_Click(object sender, EventArgs e) { MemberBLL memberBLL = new MemberBLL(); MemberCL memberCL = new MemberCL(); bool chkEmailId = memberBLL.chkUserName((txtUserName.Text.ToLower())); if (chkEmailId) { generatePassword(memberBLL.getMemberByUserName(txtUserName.Text.ToLower()).id.ToString()); } else { lblAlert.Text = ("This email id does not exist !!"); } }
/// <summary> /// Deletes the Member User Id with reference to Member Primary Key Id. /// </summary> /// <param name="memberCL">Member Id</param> /// <returns>Deleted Member Communication Layer Class.</returns> public MemberCL deleteMember(MemberCL memberCL) { Member query = (from x in dbcontext.Members where x.Id == memberCL.id select x).FirstOrDefault(); query.IsDeleted = true; dbcontext.SaveChanges(); memberCL.addressId = query.AddressId; memberCL.email = query.Email; memberCL.gender = query.Gender; memberCL.isDeleted = query.IsDeleted; memberCL.isGuest = query.IsGuest; memberCL.mobNo = query.MobileNumber; memberCL.name = query.Name; memberCL.password = query.Password; return(memberCL); }
private void generatePassword(string userId) { MemberBLL memberBLL = new MemberBLL(); MemberCL memberCL = memberBLL.getMember().Where(e => e.email == userId).FirstOrDefault(); if (memberCL != null) { string password = memberCL.name.Substring(0, 3); Random rand = new Random(); int randomNo = rand.Next(7777); password = password + randomNo; MemberCL memberUpdated = memberBLL.updateMember(new MemberCL() { addressId = memberCL.addressId, password = password, name = memberCL.name, gender = memberCL.gender, mobNo = memberCL.mobNo, isGuest = memberCL.isGuest, isDeleted = memberCL.isDeleted }); //Email the content of new password //SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587); //smtpClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "defaultpassword"); //smtpClient.UseDefaultCredentials = true; //smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; //smtpClient.EnableSsl = true; //MailMessage mail = new MailMessage(); ////Setting From , To and CC //mail.From = new MailAddress("info@MyWebsiteDomainName", "MyWeb Site"); //mail.To.Add(new MailAddress(memberCL.email)); //mail.Body = "Your new password for www.MyWebsiteDomainName.com is" + password; //smtpClient.Send(mail); //memberUpdated.password; } else { lblAlert.Text = ("This Email Id does not exist!!"); } }
/// <summary> /// Gets the Member by username. /// </summary> /// <param name="userName">User name for fetching meber From dtabase.</param> /// <returns>Instance of member Class with Username.</returns> public MemberCL getMemberByUserName(string userName) { Member username = (from x in dbcontext.Members where x.Email == userName && x.IsDeleted == false select x).FirstOrDefault(); MemberCL memberCL = new MemberCL() { name = username.Name, email = username.Email, addressId = username.AddressId, gender = username.Gender, mobNo = username.MobileNumber, isDeleted = username.IsDeleted, isGuest = username.IsGuest, password = username.Password, id = username.Id }; return(memberCL); }
/// <summary> /// Get the Member by Member Id. /// </summary> /// <param name="memberId">Fetching Members by member Id.</param> /// <returns>Member class Instance from member ID.</returns> public MemberCL getMemberById(int memberId) { Member query = (from x in dbcontext.Members where x.Id == memberId select x).FirstOrDefault(); MemberCL memberCL = new MemberCL() { addressId = query.AddressId, dateCreated = query.DateCreated, dateModified = query.DateModified, email = query.Email, gender = query.Gender, id = query.Id, isDeleted = query.IsDeleted, isGuest = query.IsGuest, mobNo = query.MobileNumber, name = query.Name, password = query.Password, }; return(memberCL); }
/// <summary> /// Checks the login authentication of the user. /// </summary> /// <param name="memberCL">Username and Password inputed by the user.</param> /// <returns>Boolean value whether user is authenticated or not.</returns> public bool login(MemberCL memberCL) { IQueryable <Member> check = from type in dbcontext.Members where type.Email == memberCL.email && type.Password == memberCL.password select type; //where type.Email.Contains(memberCL.email) bool flag = false; foreach (Member item in check) { if (item.Email == memberCL.email) { if (item.Password == memberCL.password) { flag = true; } } } ; return(flag); }
public MemberCL getMemberbyCartId(int cartId) { Cart cartQuery = (from y in dbcontext.Carts where y.Id == cartId select y).FirstOrDefault(); Member memberQuery = (from x in dbcontext.Members where x.Id == cartQuery.MemberId select x).FirstOrDefault(); MemberCL memberCL = new MemberCL() { addressId = memberQuery.AddressId, email = memberQuery.Email, gender = memberQuery.Gender, id = memberQuery.Id, isDeleted = memberQuery.IsDeleted, isGuest = memberQuery.IsGuest, mobNo = memberQuery.MobileNumber, name = memberQuery.Name, password = memberQuery.Password, dateCreated = memberQuery.DateCreated, dateModified = memberQuery.DateModified }; return(memberCL); }
private Collection <AddedInCartCL> ConvertCartToGrid(Collection <CartProductCL> cartProductCL) { Collection <AddedInCartCL> addedInCart = new Collection <AddedInCartCL>(); foreach (CartProductCL item in cartProductCL) { MemberCL fetchDetailsFromMember = memberBLL.getMemberById(cartBLL.getCartbyId(item.cartId).memberId); addedInCart.Add(new AddedInCartCL { id = orderBLL.getOrderByCartId(item.cartId).id, cartId = item.id, dateAdded = cartBLL.getCartbyId(item.cartId).dateAdded, dateModified = cartBLL.getCartbyId(item.cartId).dateModified, isDeleted = cartBLL.getCartbyId(item.cartId).isDeleted, shippingCharge = cartBLL.getCartbyId(item.cartId).shippingCost, memberDetails = fetchDetailsFromMember.name + " , " + fetchDetailsFromMember.email, productDetails = productBLL.getProduct(item.productId).name + " -> " + categoryBLL.getCategory(productBLL.getProduct(item.productId).categoryId).name, cartTotalPrice = (Convert.ToInt32(productBLL.getProduct(item.productId).price) * item.quantity).ToString(), }); } return(addedInCart); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] != null) { string userId = Session["UserId"].ToString(); } else { //If the session value for userid is not set, redirect the user to the loginpage //see the ReturnUrl querystring value, it will be the page, that the ASP.NEt //infrastructure will redirect to after successful validation of the user //See the <Authentication node in web.config FormsAuthentication.RedirectToLoginPage(); } MemberCL memberCL = new MemberCL(); if (!IsPostBack) { Collection <MemberCL> members = memberBLL.getMember(); Collection <MemberAddressCL> memberWithAddress = fetchMembers(members); if (memberWithAddress.Count() > 0) { grdExistingMembers.DataSource = memberWithAddress; grdExistingMembers.DataBind(); } else { DataTable dt = new DataTable(); ShowNoResultFound(memberWithAddress, grdExistingMembers); } ddlState.DataSource = addressBLL.getAllState().OrderBy(x => x.name); ddlState.DataValueField = "id"; ddlState.DataTextField = "name"; ddlState.DataBind(); } }