protected void Page_Load(object sender, EventArgs e)
{
System.Data.DataTable dsCustomers = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dsCustomers = client.GetCustomers(0);
gvCustomers.DataSource = dsCustomers;
gvCustomers.DataBind();
}
protected void gvCustomers_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
int CustomerID = 0;
int lErrorCode = 0;
Boolean bSuccess = false;
CustomerID = int.Parse(gvCustomers.DataKeys[e.RowIndex].Value.ToString());
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
bSuccess = client.DeleteCustomer(CustomerID, ref lErrorCode);
if (bSuccess)
{
Response.Redirect("~/Customer/Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
System.Data.DataTable dsCustomers = new System.Data.DataTable();
System.Data.DataTable dsCountry = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dsCustomers = client.GetCustomers(0);
dsCountry = client.GetCountries();
//CountryDD.DataSource = dsCountry;
//CountryDD.DataValueField = "CountryID";
//CountryDD.DataTextField = "CountryName";
//CountryDD.DataBind();
GridView1.DataSource = dsCustomers;
GridView1.DataBind();
}
private bool SaveAddressByCustomer(object sender, ref int lCustomerID, ref int lAddressID, ref int lErrorCode, string mode = "Edit")
{
Boolean bSuccess = false;
int CountryVal = 0;
int ProvinceVal = 0;
int CityVal = 0;
int AddressTypeVal = 0;
DataKey key = dvAddress.DataKey;
DropDownList ddCountry = (DropDownList)dvAddress.FindControl("ddCountry" + mode);
DropDownList ddProvince = (DropDownList)dvAddress.FindControl("ddProvince" + mode);
DropDownList ddCity = (DropDownList)dvAddress.FindControl("ddCity" + mode);
TextBox txtAddress = (TextBox)dvAddress.FindControl(mode + "AddressTextBox");
TextBox txtPostCode = (TextBox)dvAddress.FindControl(mode + "PostCodeTextBox");
RadioButtonList rblAddressTypes = (RadioButtonList)dvAddress.FindControl(mode + "AddressTypeRadio");
lCustomerID = Convert.ToInt32(CustomerIDValue.Value);
lAddressID = Convert.ToInt32(AddressIDValue.Value);
CountryVal = Convert.ToInt32(ddCountry.SelectedValue);
ProvinceVal = Convert.ToInt32(ddProvince.SelectedValue);
CityVal = Convert.ToInt32(ddCity.SelectedValue);
AddressTypeVal = Convert.ToInt32(rblAddressTypes.SelectedValue);
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
bSuccess = client.SaveAddress(ref lAddressID,CountryVal, ProvinceVal,CityVal, txtAddress.Text,txtPostCode.Text, ref lErrorCode);
if (bSuccess)
{
bSuccess = client.LinkAddressToCustomer(lCustomerID, lAddressID, AddressTypeVal, ref lErrorCode);
}
return bSuccess;
}
protected void Country_SelectedIndexChanged(object sender, EventArgs e)
{
if (dvAddress.CurrentMode == DetailsViewMode.Edit)
{
strCurrentMode = "Edit";
}
else if (dvAddress.CurrentMode == DetailsViewMode.Insert)
{
strCurrentMode = "Insert";
}
DropDownList ddCountry = (DropDownList)dvAddress.FindControl("ddCountry" + strCurrentMode);
DropDownList ddProvince = (DropDownList)dvAddress.FindControl("ddProvince" + strCurrentMode);
DropDownList ddCity = (DropDownList)dvAddress.FindControl("ddCity" + strCurrentMode);
ddProvince.Items.Clear();
ddProvince.Items.Add(new ListItem("--Select Province--", ""));
ddCity.Items.Clear();
ddCity.Items.Add(new ListItem("--Select City--", ""));
int CountryVal = 0;
if (ddCountry.SelectedItem.Value!="")
{
CountryVal = Convert.ToInt32(ddCountry.SelectedItem.Value);
}
ddProvince.AppendDataBoundItems = true;
try
{
System.Data.DataTable dsProvinces = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dsProvinces = client.GetProvinces(CountryVal);
ddProvince.DataSource = dsProvinces;
ddProvince.DataTextField = "ProvinceName";
ddProvince.DataValueField = "ProvinceID";
ddProvince.DataBind();
if (ddProvince.Items.Count > 1)
{
ddProvince.Enabled = true;
}
else
{
ddProvince.Enabled = false;
ddCity.Enabled = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void getAddresses(int CustomerID, int AddressID)
{
System.Data.DataTable dsCustomerAddress = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
if (CustomerID != 0 && AddressID!=0)
{
dsCustomerAddress = client.GetCustomerAddress(CustomerID, AddressID);
}
dvAddress.DataSource = dsCustomerAddress;
dvAddress.DataBind();
if (strCurrentMode=="Insert")
{
DropDownList ddCountry = (DropDownList)dvAddress.FindControl("ddCountry" + strCurrentMode);
DropDownList ddProvince = (DropDownList)dvAddress.FindControl("ddProvince" + strCurrentMode);
DropDownList ddCity = (DropDownList)dvAddress.FindControl("ddCity" + strCurrentMode);
ddCountry.AppendDataBoundItems = true;
try
{
System.Data.DataTable dsCountry = new System.Data.DataTable();
dsCountry = client.GetCountries();
ddCountry.DataSource = dsCountry;
ddCountry.DataTextField = "CountryName";
ddCountry.DataValueField = "CountryID";
ddCountry.DataBind();
ddProvince.Enabled = false;
ddCity.Enabled = false;
}
catch (Exception ex)
{
throw ex;
}
SetupAddressType();
}
}
protected void SetupProvinceDD(int SelectedProvinceVal = 0, int CountryID = 0)
{
DropDownList ddProvince = (DropDownList)dvAddress.FindControl("ddProvince" + strCurrentMode);
ddProvince.AppendDataBoundItems = true;
try
{
System.Data.DataTable dsProvince = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dsProvince = client.GetProvinces(CountryID);
ddProvince.DataSource = dsProvince;
ddProvince.DataTextField = "ProvinceName";
ddProvince.DataValueField = "ProvinceID";
ddProvince.DataBind();
ddProvince.SelectedValue = SelectedProvinceVal.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
protected void SetupCountryDD(int SelectCountryVal= 0)
{
DropDownList ddCountry = (DropDownList)dvAddress.FindControl("ddCountry" + strCurrentMode);
ddCountry.AppendDataBoundItems = true;
try
{
System.Data.DataTable dsCountry = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dsCountry = client.GetCountries();
ddCountry.DataSource = dsCountry;
ddCountry.DataTextField = "CountryName";
ddCountry.DataValueField = "CountryID";
ddCountry.DataBind();
ddCountry.SelectedValue = SelectCountryVal.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
protected void SetupAddressType(int SelectAddressTypeVal = 0)
{
System.Data.DataTable dtAddressTypes = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
dtAddressTypes = client.GetAddressTypes();
RadioButtonList rblAddressTypes = (RadioButtonList)dvAddress.FindControl(strCurrentMode + "AddressTypeRadio");
rblAddressTypes.DataSource = dtAddressTypes;
rblAddressTypes.DataTextField = "AddressTypeDesc";
rblAddressTypes.DataValueField = "AddressTypeID";
rblAddressTypes.DataBind();
try
{
if (SelectAddressTypeVal==0)
{
rblAddressTypes.SelectedIndex = 0;
}
else
{
rblAddressTypes.SelectedValue = SelectAddressTypeVal.ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void dvAddress_ModeChanging(object sender, DetailsViewModeEventArgs e)
{
if (e.NewMode != DetailsViewMode.Insert)
{
int CustID = Convert.ToInt32(dvAddress.DataKey["CustomerID"]);
int AddressID = Convert.ToInt32(dvAddress.DataKey["AddressID"]);
System.Data.DataTable dsCustomerAddress = new System.Data.DataTable();
WcfCustomersVB.ServiceCustomer client = new WcfCustomersVB.ServiceCustomer();
int CountryVal = 0;
int ProvinceVal = 0;
int CityVal = 0;
int AddressTypeVal = 0;
if (CustID != 0 && AddressID!=0)
{
dsCustomerAddress = client.GetCustomerAddress(CustID,AddressID);
foreach (System.Data.DataRow row in dsCustomerAddress.Rows)
{
CountryVal = int.Parse(row["CountryID"].ToString());
ProvinceVal = int.Parse(row["ProvinceID"].ToString());
CityVal = int.Parse(row["CityID"].ToString());
AddressTypeVal = int.Parse(row["AddressTypeID"].ToString());
}
}
dvAddress.DataSource = dsCustomerAddress;
dvAddress.DataBind();
if (e.NewMode == DetailsViewMode.Edit)
{
SetupCountryDD(CountryVal);
SetupProvinceDD(ProvinceVal, CountryVal);
SetupCityDD(CityVal, CountryVal, ProvinceVal);
SetupAddressType(AddressTypeVal);
}
}
else
{
SetupAddressType(0);
}
}
