private DataView GetDataView()
{
/* DataTable dt = new DataTable();
* dt.Locale = CultureInfo.InvariantCulture;
* dt.Columns.Add("company_uid", typeof(string));
* dt.Columns.Add("company_name", typeof(string));
* dt.Columns.Add("domain", typeof(string));
* dt.Columns.Add("company_type", typeof(byte));
* dt.Columns.Add("is_active", typeof(bool));
* dt.Columns.Add("creation_date", typeof(DateTime));
* dt.Columns.Add("start_date", typeof(DateTime));
* dt.Columns.Add("end_date", typeof(DateTime));
*
* ICompanyInfo[] companies = Configurator.Create().ListCompanies();
* foreach (ICompanyInfo company in companies)
* {
* DataRow row = dt.NewRow();
* row["company_uid"] = company.Id;
* row["company_name"] = company.;
*
* dt.Rows.Add(row);
* }
*/
DataView view = CManage.GetCompaniesDataTable().DefaultView;
view.Sort = Session[SortColumn_key].ToString();
string filter = string.Empty;
if (ddType.SelectedItem.Value != "0")
{
filter = "company_type='" + ddType.SelectedItem.Value + "'";
}
if (ddActivity.SelectedItem.Value == "1")
{
if (filter.Length > 0)
{
filter += " AND ";
}
filter += "Is_Active='True'";
}
if (ddActivity.SelectedItem.Value == "-1")
{
if (filter.Length > 0)
{
filter += " AND ";
}
filter += "Is_Active='False'";
}
if (filter.Length > 0)
{
view.RowFilter = filter;
}
return(view);
}
private void BindValues()
{
DataView dv = CManage.GetCompaniesDataTable().DefaultView;
dv.Sort = "Company_Name";
ddCompanies.DataSource = dv;
ddCompanies.DataTextField = "Company_Name";
ddCompanies.DataValueField = "Company_Uid";
ddCompanies.DataBind();
txtAmount.Text = "0";
txtBonus.Text = "0";
PaymentDate.Text = DateTime.Today.ToShortDateString();
}
