//Delete a province from file
private void buttonDelete_Click(object sender, EventArgs e)
{
labelDisplay.Text = "";
DAProvince province = new DAProvince();
province.ProvinceCode = textBoxPrvCd.Text;
province.Name = textBoxName.Text;
province.CountryCode = textBoxCntryCd.Text;
province.TaxCode = textBoxTaxCd.Text;
province.TaxRate = Convert.ToDouble(textBoxTaxRate.Text);
province.IncludesFederalTax = checkBoxFedTax.Checked;
try
{
province.DADelete();
UpdateListBoxDisplay();
textBoxPrvCd.Text = "";
textBoxName.Text = "";
textBoxCntryCd.Text = "";
textBoxTaxCd.Text = "";
textBoxTaxRate.Text = "";
checkBoxFedTax.Checked = false;
labelDisplay.Text += "Province deleted\n";
}
catch (Exception ex)
{
labelDisplay.Text += ex.Message;
}
}
//Update list box after deleting or saving province
private void UpdateListBoxDisplay(DAProvince province = null)
{
listBoxDisplay.Items.Clear();
List <DAProvince> provinceList = new List <DAProvince>();
if (province != null)
{
provinceList = province.DAGetProvinces();
foreach (DAProvince item in provinceList)
{
listBoxDisplay.Items.Add(item.ProvinceCode);
}
listBoxDisplay.SelectedItem = province.ProvinceCode;
}
else
{
province = new DAProvince();
provinceList = province.DAGetProvinces();
foreach (DAProvince item in provinceList)
{
listBoxDisplay.Items.Add(item.ProvinceCode);
}
listBoxDisplay.SelectedIndex = -1;
}
}
override protected Boolean LoadData()
{
try
{
// Load Data For Page.
DAProvince daProvince = new DAProvince();
daProvince.USP_Province_GetFullID(this.KeyID);
//
fProvince.Value = daProvince.fProvince.ToString();
fIsAllowShipping.Checked = daProvince.fIsAllowShipping;
fIsAllowBilling.Checked = daProvince.fIsAllowBilling;
//
// Khi cần enabled cột nào
//if (this.KeyID > 0)
//{
// if (mode != Act.Clone)
// fUserName.Enabled = false;
// else
// fUserName.Text = "";
//}
}
catch (Exception e)
{
ShowErrorMes("Lỗi hệ thống: " + e.ToString());
return(false);
}
return(true);
}
override protected Boolean GetDataComboBox()
{
try
{
DAOrderStatus daOrderStatus = new DAOrderStatus();
fOrderStatusID.DataSource = daOrderStatus.USP_OrderStatus_GetDataForComboBox();
fOrderStatusID.DataBind();
DAPayment daPayment = new DAPayment();
fPaymentID.DataSource = daPayment.USP_Payment_GetDataForComboBox();
fPaymentID.DataBind();
DAShipping daShipping = new DAShipping();
fShippingID.DataSource = daShipping.USP_Shipping_GetDataForComboBox();
fShippingID.DataBind();
DAProvince daProvinceBilling = new DAProvince();
fBillProvinceID.DataSource = daProvinceBilling.USP_Province_GetDataForComboBox();
fBillProvinceID.DataBind();
DADistrict daDistrictBilling = new DADistrict();
fBillDistrictID.DataSource = daDistrictBilling.USP_District_GetDataForComboBox_ByProvinceID(int.Parse(fBillProvinceID.SelectedValue));
fBillDistrictID.DataBind();
DAProvince daProvinceShipping = new DAProvince();
fShipProvinceID.DataSource = daProvinceShipping.USP_Province_GetDataForComboBox();
fShipProvinceID.DataBind();
DADistrict daDistrictShipping = new DADistrict();
fShipDistrictID.DataSource = daDistrictShipping.USP_District_GetDataForComboBox_ByProvinceID(int.Parse(fShipProvinceID.SelectedValue));
fShipDistrictID.DataBind();
DACustomer daCustomer = new DACustomer();
fCustomerID.DataSource = daCustomer.USP_Customer_GetDataForComboBox();
fCustomerID.DataBind();
DAProvince daProvince = new DAProvince();
fProvinceID.DataSource = daProvince.USP_Province_GetDataForComboBox();
fProvinceID.DataBind();
DACustomerGroup daCustomerGroup = new DACustomerGroup();
fCustomerGroupID.DataSource = daCustomerGroup.USP_CustomerGroup_GetDataForComboBox();
fCustomerGroupID.DataBind();
//LoadCategory();
return(true);
}
catch (Exception ex)
{
ShowErrorMes("Lỗi hệ thống: " + ex.Message);
return(false);
}
}
override protected int DeleteByID(int pID)
{
try
{
DAProvince DAProvince = new DAProvince();
DAProvince.USP_Province_Delete(pID);
return(1);
}
catch { return(0); }
}
//When selectedIndex changes, fill the fields with the info from province selected
private void listBoxDisplay_SelectedIndexChanged(object sender, EventArgs e)
{
DAProvince province = new DAProvince();
province = province.DAGetByProvinceCode
(listBoxDisplay.SelectedItem.ToString());
textBoxPrvCd.Text = province.ProvinceCode;
textBoxName.Text = province.Name;
textBoxCntryCd.Text = province.CountryCode;
textBoxTaxCd.Text = province.TaxCode;
textBoxTaxRate.Text = province.TaxRate.ToString();
checkBoxFedTax.Checked = province.IncludesFederalTax;
}
override protected int ExecUpdate()
{
// Update with ID = this.ID
try
{
DAProvince DAProvince = CreateObjectFromPage();
DAProvince.fID = this.KeyID;
DAProvince.USP_Province_Update();
return(1);
}
catch { return(0); }
}
private DAProvince CreateObjectFromPage()
{
// check
DAProvince daProvince = new DAProvince();
//
daProvince.fProvince = fProvince.Value.Trim();
daProvince.fIsAllowShipping = fIsAllowShipping.Checked;
daProvince.fIsAllowBilling = fIsAllowBilling.Checked;
//
return(daProvince);
}
override protected Boolean GetDataComboBox()
{
try
{
DAProvince daProvince = new DAProvince();
fProvinceID.DataSource = daProvince.USP_Province_GetDataForComboBox();
fProvinceID.DataBind();
return(true);
}
catch (Exception ex)
{
ShowErrorMes("Lỗi hệ thống: " + ex.Message);
return(false);
}
}
override protected int ExecInsert()
{
try
{
DAProvince DAProvince = CreateObjectFromPage();
if (this.mode == ActParam.New)
{
DAProvince.fID = DAProvince.USP_GetKey();
this.KeyID = DAProvince.fID; // --> Update new SessionID for continue edit.
}
else
{
DAProvince.fID = 0;
}
DAProvince.USP_Province_Insert();
return(1);
}
catch { return(0); }
}
//Save a new province, or save an updated province
private void buttonSave_Click(object sender, EventArgs e)
{
DAProvince province = new DAProvince();
province.ProvinceCode = textBoxPrvCd.Text;
province.Name = textBoxName.Text;
province.CountryCode = textBoxCntryCd.Text;
province.TaxCode = textBoxTaxCd.Text;
province.TaxRate = Convert.ToDouble(textBoxTaxRate.Text);
province.IncludesFederalTax = checkBoxFedTax.Checked;
//If the province does not exist on file, create new
if (province.DAGetByProvinceCode(province.ProvinceCode) == null)
{
try
{
province.DAAdd();
UpdateListBoxDisplay(province);
}
catch (Exception ex)
{
labelDisplay.Text += ex.Message;
}
}
//If province exist on file, update changes
else
{
try
{
province.DAUpdate();
}
catch (Exception ex)
{
labelDisplay.Text += ex.Message;
}
}
}