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);
}
protected void lbExport_Click(object sender, System.EventArgs e)
{
exportPanel.Visible = true;
dgExport.DataSource = GetDataView();
dgExport.DataBind();
CManage.ExportExcel(exportPanel, "SitesExport.xls");
exportPanel.Visible = false;
}
private void BindDefaultValues()
{
using (IDataReader rdr = CManage.GetCompany(Guid.Empty))
{
while (rdr.Read())
{
ddCompany.Items.Add(new ListItem(rdr["domain"].ToString() + " (" + rdr["company_name"].ToString() + ") ", rdr["company_uid"].ToString()));
}
}
SetViewState();
}
private void BindInfo()
{
using (IDataReader reader = CManage.ResellerGet(ResellerId))
{
reader.Read();
tbTitle.Text = reader["Title"].ToString();
tbContactName.Text = reader["ContactName"].ToString();
tbContactEmail.Text = reader["ContactEmail"].ToString();
tbContactPhone.Text = reader["ContactPhone"].ToString();
tbCommPerc.Text = reader["CommissionPercentage"].ToString();
}
}
private void BindValues()
{
using (IDataReader reader = CManage.ResellerGet(ResellerId))
{
reader.Read();
lbTitle.Text = reader["Title"].ToString();
lbContactName.Text = reader["ContactName"].ToString();
lbContactEmail.Text = reader["ContactEmail"].ToString();
lbContactPhone.Text = reader["ContactPhone"].ToString();
lblGuid.Text = reader["Guid"].ToString();
lblPercentage.Text = reader["CommissionPercentage"].ToString() + "%";
}
}
protected void Submit_Click(object sender, System.EventArgs e)
{
if (!Page.IsValid)
{
return;
}
try
{
CManage.CompanyCreate(
txtCompanyName.Text
, txtDomain.Text
, ddLanguage.SelectedItem.Value
, IsActive.Checked
, int.Parse(txtMaxUsers.Text)
, int.Parse(tbExternal.Text)
, int.Parse(txtDiskMax.Text)
, txtContactName.Text
, txtContactPhone.Text
, txtContactEmail.Text
, txtAdminFirstName.Text
, txtAdminLastName.Text
, txtAdminLogin.Text
, txtAdminPassword.Text
, txtAdminEMail.Text
, Demo.Checked
, DateTime.Parse(txtStartDate.Text)
, System.DateTime.Parse(txtDateTo.Text)
, ApplicationPoolList.SelectedValue
);
Response.Redirect("../Pages/sites.aspx");
}
catch (ConfigurationException ex)
{
cvErrorCreation.IsValid = false;
cvErrorCreation.ErrorMessage = ex.Message;
}
}
