Beispiel #1
0
    private void InitData()
    {
        var Filters = Populator.GetFilter();

        Filters.Add("TypeCode", "GenderTypeID");
        var arrType = ParamsManager.GetParamssByFilter(Filters);

        ddlGender.BindData(arrType, "TypeName", "ObjectValue");

        Filters.Clear();
        var arrCustomers = CustomerManager.GetAllCustomers();

        ddlCustomerID.BindData(arrCustomers, "Name", "CustomerID");

        if (ContactID > 0)
        {
            Contact oContact = ContactManager.GetContactByID(ContactID);
            if (oContact != null)
            {
                //this.txtContactCode.Text = oContact.ContactCode;
                //this.ddlMemberID.Select(oContact.MemberID);
                this.txtName.Text    = oContact.Name;
                this.txtSurname.Text = oContact.Surname;
                this.txtTitle.Text   = oContact.Title;
                this.txtPhone.Text   = oContact.Phone;
                this.txtGSM.Text     = oContact.GSM;
                this.ddlCustomerID.Select(oContact.CustomerID);
                //this.ddlAddressID.Select(oContact.AddressID);
                this.ddlGender.Select(oContact.Gender);
                this.txtEmail.Text       = oContact.Email;
                this.txtDescription.Text = oContact.Description;
            }
        }
    }
Beispiel #2
0
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        if (!string.IsNullOrEmpty(txtOrderNo.Text))
        {
            filter.Add("OrderCode", txtOrderNo.Text);
        }
        if (!string.IsNullOrEmpty(txtContactName.Text))
        {
            filter.Add("ContactName LIKE '%" + txtContactName.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtCustomerName.Text))
        {
            filter.Add("CustomerName LIKE '%" + txtCustomerName.Text + "%' AND 1", 1);
        }
        if (ddlType.SelectedIndex > 0)
        {
            filter.Add("OrderTypeID", ddlType.SelectedValue);
        }
        if (ddlStatus.SelectedIndex > 0)
        {
            filter.Add("OrderStatusID", ddlStatus.SelectedValue);
        }
        if (dt1.HasDate)
        {
            filter.Add("OrderDate>", dt1.SelectedDate.ToDBDate());
        }
        if (dt2.HasDate)
        {
            filter.Add("OrderDate<", dt2.SelectedDate.ToDBDate());
        }

        return(filter);
    }
Beispiel #3
0
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        if (!string.IsNullOrEmpty(txtContactCode.Text))
        {
            filter.Add("ContactCode", txtContactCode.Text);
        }
        if (!string.IsNullOrEmpty(txtName.Text))
        {
            filter.Add("Name LIKE '%" + txtName.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtSurname.Text))
        {
            filter.Add("Surname LIKE '%" + txtSurname.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtTitle.Text))
        {
            filter.Add("Title LIKE '%" + txtTitle.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtCompany.Text))
        {
            filter.Add("CustomerName LIKE '%" + txtCompany.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtEmail.Text))
        {
            filter.Add("Email", txtEmail.Text);
        }
        if (!string.IsNullOrEmpty(txtGSM.Text))
        {
            filter.Add("GSM", txtGSM.Text);
        }

        return(filter);
    }
Beispiel #4
0
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        if (!string.IsNullOrEmpty(txtOrderNo.Text))
        {
            filter.Add("OrderCode", txtOrderNo.Text);
        }
        if (!string.IsNullOrEmpty(txtActivityNo.Text))
        {
            filter.Add("ActivityCode", txtActivityNo.Text);
        }
        if (!string.IsNullOrEmpty(txtName.Text))
        {
            filter.Add("Name LIKE '%" + txtName.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtCustomerName.Text))
        {
            filter.Add("CustomerName LIKE '%" + txtCustomerName.Text + "%' AND 1", 1);
        }
        if (ddlType.SelectedIndex > 0)
        {
            filter.Add("ActivityTypeID", ddlType.SelectedValue);
        }
        if (ddlStatus.SelectedIndex > 0)
        {
            filter.Add("ActivityStatusID", ddlStatus.SelectedValue);
        }

        return(filter);
    }
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        //if (dt1.HasDate) filter.Add("CreateDate>", dt1.SelectedDate.ToDBDate());
        //if (dt2.HasDate) filter.Add("CreateDate<", dt2.SelectedDate.ToDBDate());

        return(filter);
    }
Beispiel #6
0
    private Dictionary<string, object> GetFilter()
    {
        var filter = Populator.GetFilter();
        if (!string.IsNullOrEmpty(txtProductCode.Text)) filter.Add("ProductCode", txtProductCode.Text);
        if (!string.IsNullOrEmpty(txtReferenceNo.Text)) filter.Add("ReferenceNo", txtReferenceNo.Text);
        if (!string.IsNullOrEmpty(txtName.Text)) filter.Add("ProductName LIKE '%" + txtName.Text + "%' AND 1", 1);
        if (!string.IsNullOrEmpty(txtGroup.Text)) filter.Add("ProductGroup LIKE '%" + txtGroup.Text + "%' AND 1", 1); ;

        return filter;
    }
Beispiel #7
0
    private void InitForm()
    {
        var Filters = Populator.GetFilter();

        Filters.Add("TypeCode", "MemberTypeID");
        var arrType = ParamsManager.GetParamssByFilter(Filters);

        ddlType.BindData(arrType, "TypeName", "ObjectValue");
        ddlType.InsertChooseItem();
        grdData.Visible = false;
    }
Beispiel #8
0
    private void InitForm()
    {
        //dt1.SelectedDate = DateTime.Today.AddDays(-7d);
        //dt2.SelectedDate = DateTime.Today;
        var Filters = Populator.GetFilter();

        Filters.Add("TypeCode", "ActivityTypeID");
        var arrType = ParamsManager.GetParamssByFilter(Filters);

        ddlType.BindData(arrType, "TypeName", "ObjectValue");
        ddlType.InsertChooseItem();

        Filters = Populator.GetFilter();
        Filters.Add("TypeCode", "ActivityStatusID");
        var arrStatus = ParamsManager.GetParamssByFilter(Filters);

        ddlStatus.BindData(arrStatus, "TypeName", "ObjectValue");
        ddlStatus.InsertChooseItem();

        grdData.Visible = false;
    }
Beispiel #9
0
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        if (!string.IsNullOrEmpty(txtName.Text))
        {
            filter.Add("Name LIKE '%" + txtName.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtSurname.Text))
        {
            filter.Add("Surname LIKE '%" + txtSurname.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtEmail.Text))
        {
            filter.Add("Email LIKE '%" + txtEmail.Text + "%' AND 1", 1);
        }
        if (ddlType.SelectedIndex > 0)
        {
            filter.Add("MemberTypeID", ddlType.SelectedValue);
        }

        return(filter);
    }
Beispiel #10
0
    private Dictionary <string, object> GetFilter()
    {
        var filter = Populator.GetFilter();

        if (!string.IsNullOrEmpty(txtCustomerCode.Text))
        {
            filter.Add("CustomerCode", txtCustomerCode.Text);
        }
        if (!string.IsNullOrEmpty(txtReference.Text))
        {
            filter.Add("ReferenceNo", txtReference.Text);
        }
        if (!string.IsNullOrEmpty(txtName.Text))
        {
            filter.Add("Name LIKE '%" + txtName.Text + "%' AND 1", 1);
        }
        if (!string.IsNullOrEmpty(txtPhone.Text))
        {
            filter.Add("ReferenceNo", txtReference.Text);
        }

        return(filter);
    }
Beispiel #11
0
    private void InitData()
    {
        var Filters = Populator.GetFilter();

        Filters.Add("TypeCode", "MemberTypeID");
        var arrType = ParamsManager.GetParamssByFilter(Filters);

        ddlMemberTypeID.BindData(arrType, "TypeName", "ObjectValue");

        if (MemberID > 0)
        {
            Member oMember = MemberManager.GetMemberByID(MemberID);
            if (oMember != null)
            {
                this.txtName.Text           = oMember.Name;
                this.txtSurname.Text        = oMember.Surname;
                this.txtEmail.Text          = oMember.Email;
                this.txtPasswordHashed.Text = oMember.PasswordHashed.Decrypt();
                this.ddlMemberTypeID.Select(oMember.MemberTypeID);
                this.chkStatus.Checked = oMember.Status;
                //this.dtLastUpdate.SelectedDate = oMember.LastUpdate;
            }
        }
    }