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