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;
}
}
}
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);
}
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);
}
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);
}
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;
}
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;
}
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;
}
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);
}
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);
}
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;
}
}
}