override protected Boolean LoadData() { try { // Load Data For Page. DADistrict daDistrict = new DADistrict(); daDistrict.USP_District_GetFullID(this.KeyID); // fDistrict.Value = daDistrict.fDistrict.ToString(); fProvinceID.Value = daDistrict.fProvinceID.ToString(); // // 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); }
protected void fBillProvinceID_SelectedIndexChanged(object sender, EventArgs e) { DADistrict daDistrictBilling = new DADistrict(); fBillDistrictID.DataSource = daDistrictBilling.USP_District_GetDataForComboBox_ByProvinceID(int.Parse(fBillProvinceID.SelectedValue)); fBillDistrictID.DataBind(); }
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 { DADistrict DADistrict = new DADistrict(); DADistrict.USP_District_Delete(pID); return(1); } catch { return(0); } }
private DADistrict CreateObjectFromPage() { // check DADistrict daDistrict = new DADistrict(); // daDistrict.fDistrict = fDistrict.Value.Trim(); daDistrict.fProvinceID = Convert.ToInt32(fProvinceID.Value.Trim()); // return(daDistrict); }
override protected int ExecUpdate() { // Update with ID = this.ID try { DADistrict DADistrict = CreateObjectFromPage(); DADistrict.fID = this.KeyID; DADistrict.USP_District_Update(); return(1); } catch { return(0); } }
override protected int ExecInsert() { try { DADistrict DADistrict = CreateObjectFromPage(); if (this.mode == ActParam.New) { DADistrict.fID = DADistrict.USP_GetKey(); this.KeyID = DADistrict.fID; // --> Update new SessionID for continue edit. } else { DADistrict.fID = 0; } DADistrict.USP_District_Insert(); return(1); } catch { return(0); } }