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