/// <summary>
/// Creates a new address entity for each member in the database
/// </summary>
/// <param name="addCL">Address Details of new member to be added in the Database.</param>
/// <returns>Returns the class containing the created address. </returns>
public AddressCL createAddress(AddressCL addCL)
{
Address address = dbcontext.Addresses.Add(new Address
{
AddressLine1 = addCL.addressLine1,
AddressLine2 = addCL.addressLine2,
AddressLine3 = addCL.addressLine2,
AddressTypeId = addCL.addressTypeId,
CityId = addCL.cityId,
Id = 0,
});
dbcontext.SaveChanges();
AddressCL addressCl = new AddressCL()
{
id = address.Id,
cityId = address.CityId,
addressTypeId = address.AddressTypeId,
addressLine1 = address.AddressLine1,
addressLine2 = address.AddressLine2,
addressLine3 = address.AddressLine3
};
return(addressCl);
}
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);
}
}
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);
}
}
private Collection <MemberAddressCL> fetchMembers(Collection <MemberCL> members)
{
Collection <MemberAddressCL> memberWithAddress = new Collection <MemberAddressCL>();
foreach (MemberCL item in members)
{
AddressCL addressCL = addressBLL.getAddressById(item.addressId);
AddressLocationCL cityCL = addressBLL.getCityById(addressCL.cityId);
if (addressCL.addressTypeId == 0)
{
memberWithAddress.Add(new MemberAddressCL
{
id = item.id,
name = item.name,
password = item.password,
mobNo = item.mobNo,
isGuest = item.isGuest.ToString(),
isDelete = item.isDeleted.ToString(),
email = item.email,
gender = item.gender ? "Male" : "Female",
shippingAddress = addressCL.addressLine1 + ", " + addressCL.addressLine2 + ", " + addressCL.addressLine3 + ", " + cityCL.cityName + ", " + cityCL.stateName + ", " + cityCL.countryName,
});
}
else if (addressCL.addressTypeId == 1)
{
memberWithAddress.Add(new MemberAddressCL
{
id = item.id,
name = item.name,
password = item.password,
mobNo = item.mobNo,
isGuest = item.isGuest.ToString(),
isDelete = item.isDeleted.ToString(),
email = item.email,
gender = item.gender ? "Male" : "Female",
billingAddress = addressCL.addressLine1 + ", " + addressCL.addressLine2 + ", " + addressCL.addressLine3 + ", " + cityCL.cityName + ", " + cityCL.stateName + ", " + cityCL.countryName,
});
}
else if (addressCL.addressTypeId == 2)
{
memberWithAddress.Add(new MemberAddressCL
{
id = item.id,
name = item.name,
password = item.password,
mobNo = item.mobNo,
isGuest = item.isGuest.ToString(),
isDelete = item.isDeleted.ToString(),
email = item.email,
gender = item.gender ? "Male" : "Female",
permanentAddress = addressCL.addressLine1 + ", " + addressCL.addressLine2 + ", " + addressCL.addressLine3 + ", " + cityCL.cityName + ", " + cityCL.stateName + ", " + cityCL.countryName,
});
}
}
return(memberWithAddress);
}
/// <summary>
/// Gets the Address Entity in the Database by addressId.
/// </summary>
/// <param name="addressId">AddressId for Address Entry to be fetched</param>
/// <returns>Address Communication Layer Class queried by the input.</returns>
public AddressCL getAddressById(int addressId)
{
Address query = (from x in dbcontext.Addresses where x.Id == addressId select x).FirstOrDefault();
AddressCL addressCL = new AddressCL()
{
addressLine1 = query.AddressLine1,
addressLine2 = query.AddressLine2,
addressLine3 = query.AddressLine3,
addressTypeId = query.AddressTypeId,
cityId = query.CityId,
id = query.Id
};
return(addressCL);
}
/// <summary>
/// Update the Member's address in the Database.
/// </summary>
/// <param name="addCL">Address entity to be changed.</param>
/// <returns>Returns Updated Address entity.</returns>
public AddressCL updateAddress(AddressCL addCL)
{
Address address = (from type in dbcontext.Addresses where type.Id == addCL.id select type).FirstOrDefault();
Address newAddress = address;
newAddress.AddressLine1 = addCL.addressLine1;
newAddress.AddressLine2 = addCL.addressLine2;
newAddress.AddressLine3 = addCL.addressLine3;
newAddress.AddressTypeId = addCL.addressTypeId;
newAddress.CityId = addCL.cityId;
dbcontext.SaveChanges();
AddressCL updatedAddress = new AddressCL()
{
addressLine1 = newAddress.AddressLine1,
addressLine2 = newAddress.AddressLine2,
addressLine3 = newAddress.AddressLine3,
addressTypeId = newAddress.AddressTypeId,
cityId = newAddress.CityId
};
return(updatedAddress);
}
