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(); }
public void UpdateTrial( string companyId, string companyName, bool isActive, int maxUsers, int maxExternalUsers, int maxDiskSpace, string contactName, string contactPhone, string contactEmail, DateTime trialStartDate, DateTime trialEndDate ) { IConfigurator config = Configurator.Create(); ICompanyInfo company = config.GetCompanyInfo(companyId); int tariffId = -1; decimal balance = 0m; int discount = 0; decimal creditLimit = 0m; bool sendSpam = true; using (IDataReader reader = CManage.GetCompany(new Guid(companyId))) { if (reader.Read()) { if (reader["tariffId"] != DBNull.Value) { tariffId = (int)reader["tariffId"]; } balance = (decimal)reader["balance"]; discount = (int)reader["discount"]; creditLimit = (decimal)reader["creditLimit"]; sendSpam = (bool)reader["send_spam"]; } } CManage.UpdateTrialCompany(new Guid(companyId), companyName, company.Host, company.Scheme, company.Port, 1, trialStartDate, trialEndDate, isActive, contactName, contactPhone, contactEmail, maxUsers, maxExternalUsers, maxDiskSpace, sendSpam, false); }
private void BindData() { string companyId = CompanyUid.ToString(); IConfigurator config = Configurator.Create(); ICompanyInfo company = config.GetCompanyInfo(companyId); int dbSize = company.DatabaseSize; int maxDbSize = int.Parse(config.GetCompanyPropertyValue(companyId, CManage.keyCompanyDatabaseSize)); lblOccupiedDiskSpace.Text = dbSize.ToString(); lblMaxDiskSpace.Text = maxDbSize.ToString(); if (maxDbSize == -1) { lblMaxDiskSpace.Text = LocRM.GetString("unlimited"); } else if (dbSize >= maxDbSize) { lblOccupiedDiskSpace.CssClass = "ibn-error"; } BindUsersCount(lblActiveUsers, lblAllowedUsers, company.InternalUsersCount, CManage.keyCompanyMaxUsers, companyId, config); BindUsersCount(lblActiveExternalUsers, lblAllowedExternalUsers, company.ExternalUsersCount, CManage.keyCompanyMaxExternalUsers, companyId, config); int port = (string.IsNullOrEmpty(company.Port) ? -1 : int.Parse(company.Port, CultureInfo.InvariantCulture)); UriBuilder uriBuilder = new UriBuilder(company.Scheme, company.Host, port); PortalLink.Text = uriBuilder.ToString(); PortalLink.NavigateUrl = PortalLink.Text; if (company.IsActive) { lblIsActive.Text = string.Concat("<img alt='' src='../layouts/images/accept.gif'/> ", LocRM.GetString("Yes")); } else { lblIsActive.Text = LocRM.GetString("No"); } DatabaseLabel.Text = company.Database; using (IDataReader reader = CManage.GetCompany(CompanyUid)) { if (reader.Read()) { lblCompanyName.Text = reader["company_name"].ToString(); if (reader["contact_name"] != DBNull.Value) { ContactNameLabel.Text = reader["contact_name"].ToString(); } if (reader["contact_phone"] != DBNull.Value) { ContactPhoneLabel.Text = reader["contact_phone"].ToString(); } if (reader["contact_email"] != DBNull.Value && reader["contact_email"].ToString() != string.Empty) { ContactEmailLabel.Text = String.Format(CultureInfo.InvariantCulture, "<a href=\"mailto:{0}\">{0}</a>", reader["contact_email"].ToString()); } if ((bool)reader["send_spam"]) { SendSpamLabel.Text = string.Concat("<img alt='' src='../layouts/images/accept.gif'/> ", LocRM.GetString("Yes")); } else { SendSpamLabel.Text = LocRM.GetString("No"); } if (config.GetCompanyPropertyValue(companyId, CManage.keyCompanyType) == ((byte)CompanyType.Trial).ToString()) { lblType.Text = "Trial"; string endDateString = config.GetCompanyPropertyValue(companyId, CManage.keyCompanyEndDate); if (!String.IsNullOrEmpty(endDateString)) { lblDateTo.Text = DateTime.Parse(endDateString, CultureInfo.InvariantCulture).ToShortDateString(); } TariffDelimiterRow.Visible = false; TariffRow.Visible = false; BalanceRow.Visible = false; DiscountRow.Visible = false; PaidTillRow.Visible = false; CreditLimitRow.Visible = false; AlertThresholdRow.Visible = false; } else { lblType.Text = "Billable"; trStart.Visible = false; trEnd.Visible = false; lblDateTo.Text = ""; if (reader["tariffName"] != DBNull.Value) { TariffValue.Text = reader["tariffName"].ToString(); TariffValue.NavigateUrl = "~/Pages/TariffEdit.aspx?TariffId=" + reader["tariffId"].ToString(); BalanceValue.Text = ((decimal)reader["Balance"]).ToString("f"); DiscountValue.Text = reader["Discount"].ToString(); CreditLimitValue.Text = ((decimal)reader["CreditLimit"]).ToString("f"); AlertThresholdValue.Text = ((decimal)reader["AlertThreshold"]).ToString("f"); decimal credit = (decimal)reader["CreditLimit"]; decimal balance = (decimal)reader["balance"]; decimal dailyCost = (decimal)reader["dailyCost30"]; int discount = (int)reader["discount"]; try { int daysBeforeEnd = (int)((credit + balance) / (dailyCost - dailyCost * discount / 100m)); PaidTillValue.Text = DateTime.Now.AddDays(daysBeforeEnd).ToShortDateString(); if (daysBeforeEnd < 0) { PaidTillValue.Text = String.Concat("<span class='ibn-alerttext'>", PaidTillValue.Text, "</span>"); } } catch (Exception) { } if (reader["symbol"] != DBNull.Value) { BalanceValue.Text = String.Concat(BalanceValue.Text, " ", reader["symbol"].ToString()); CreditLimitValue.Text = String.Concat(CreditLimitValue.Text, " ", reader["symbol"].ToString()); AlertThresholdValue.Text = String.Concat(AlertThresholdValue.Text, " ", reader["symbol"].ToString()); } } else { TariffValue.Text = LocRM.GetString("NoTariff"); BalanceRow.Visible = false; DiscountRow.Visible = false; PaidTillRow.Visible = false; CreditLimitRow.Visible = false; AlertThresholdRow.Visible = false; } } if (reader["start_date"] != DBNull.Value) { lblDateFrom.Text = ((DateTime)reader["start_date"]).ToShortDateString(); } } } }
private void BindData() { ListItem li; AspSettings settings = AspSettings.Load(); string companyId = CompanyUid.ToString(); IConfigurator config = Configurator.Create(); ICompanyInfo info = config.GetCompanyInfo(companyId); txtOccupiedDiskSpace.Text = info.DatabaseSize.ToString(CultureInfo.CurrentUICulture); MaxDiskSpaceValue.Text = config.GetCompanyPropertyValue(companyId, CManage.keyCompanyDatabaseSize); txtActiveInternalUsers.Text = info.InternalUsersCount.ToString(CultureInfo.CurrentUICulture); MaxUsersValue.Text = config.GetCompanyPropertyValue(companyId, CManage.keyCompanyMaxUsers); txtActiveExternalUsers.Text = info.ExternalUsersCount.ToString(CultureInfo.CurrentUICulture); MaxExternalUsersValue.Text = config.GetCompanyPropertyValue(companyId, CManage.keyCompanyMaxExternalUsers); txtDomain.Text = info.Host; IsActive.Checked = info.IsActive; li = SchemeList.Items.FindByValue(info.Scheme); if (li != null) { li.Selected = true; } PortValue.Text = info.Port; using (IDataReader reader = CManage.GetCompany(CompanyUid)) { if (reader.Read()) { txtCompanyName.Text = reader["company_name"].ToString(); if (reader["contact_name"] != DBNull.Value) { txtContactName.Text = reader["contact_name"].ToString(); } if (reader["contact_phone"] != DBNull.Value) { txtContactPhone.Text = reader["contact_phone"].ToString(); } if (reader["contact_email"] != DBNull.Value) { txtContactEmail.Text = reader["contact_email"].ToString(); } bool showTariffInfo = true; if (config.GetCompanyPropertyValue(companyId, CManage.keyCompanyType) == ((byte)CompanyType.Trial).ToString()) { TypeList.Items.FindByValue(((byte)CompanyType.Trial).ToString()).Selected = true; txtDateFrom.Text = ((DateTime)reader["start_date"]).ToShortDateString(); string endDateString = config.GetCompanyPropertyValue(companyId, CManage.keyCompanyEndDate); if (!String.IsNullOrEmpty(endDateString)) { txtDateTo.Text = DateTime.Parse(endDateString, CultureInfo.InvariantCulture).ToShortDateString(); } TariffRow.Visible = false; showTariffInfo = false; } else { TypeList.Items.FindByValue(((byte)CompanyType.Billable).ToString()).Selected = true; txtDateFrom.Text = DateTime.Now.Date.ToShortDateString(); txtDateTo.Text = DateTime.Now.Date.AddDays(settings.TrialPeriod).ToShortDateString(); DateFromRow.Visible = false; DateToRow.Visible = false; } SendSpamCheckBox.Checked = (bool)reader["send_spam"]; if (reader["tariffId"] != DBNull.Value) { li = TariffList.Items.FindByValue(reader["tariffId"].ToString()); if (li != null) { li.Selected = true; } } else { showTariffInfo = false; } BalanceValue.Text = ((decimal)reader["Balance"]).ToString("f"); DiscountValue.Text = reader["Discount"].ToString(); CreditLimitValue.Text = ((decimal)reader["CreditLimit"]).ToString("f"); AlertThresholdValue.Text = ((decimal)reader["AlertThreshold"]).ToString("f"); if (!showTariffInfo) { BalanceRow.Visible = false; DiscountRow.Visible = false; CreditLimitRow.Visible = false; AlertThresholdRow.Visible = false; } } } }