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