public virtual CloudAccountDA.PackageDetailsDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.PackageDetailsDataTable dataTable = new CloudAccountDA.PackageDetailsDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.PackageDetailsDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void SetRecord(string iD) { this.objPackageMasterDT = this.objPackageMasterBll.GetDataByPackageID(int.Parse(iD)); if (this.objPackageMasterDT.Rows.Count <= 0) { return; } this.hfPackage.Value = this.objPackageMasterDT.Rows[0]["PackageID"].ToString(); this.chkTrial.Checked = this.objPackageMasterDT.Rows[0]["FreeTrialPackage"].ToString() == "True"; this.chkTrial_CheckedChanged((object)null, (EventArgs)null); this.txtName.Text = this.objPackageMasterDT.Rows[0]["PackageName"].ToString(); this.txtAdminUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMin"].ToString(); this.txtAdminUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMax"].ToString(); this.txtStaffUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMin"].ToString(); this.txtStaffUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMax"].ToString(); this.txtPricePerMonth.Text = this.objPackageMasterDT.Rows[0]["PricePerMonth"].ToString(); this.txtPricePerYear.Text = this.objPackageMasterDT.Rows[0]["PricePerYear"].ToString(); this.txtDescription.Text = this.objPackageMasterDT.Rows[0]["Description"].ToString(); this.txtNoTrialDays.Text = this.objPackageMasterDT.Rows[0]["NoOfTrialDays"].ToString(); this.chkStatus.Checked = this.objPackageMasterDT.Rows[0]["Status"].ToString() == "True"; this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objPackageMasterDT.Rows[0]["MonthlyPriceCurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlMonthCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlMonthCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objPackageMasterDT.Rows[0]["YearlyPriceCurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlYearlyCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlYearlyCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } this.objPackageDetailsDT = this.objPackageDetailsBll.GetDataByPackageID(int.Parse(this.hfPackage.Value)); for (int index = 0; index < this.objPackageDetailsDT.Rows.Count; ++index) { Label label1 = (Label)this.gvPackageDetails.Rows[index].FindControl("lnkModuleID"); Label label2 = (Label)this.gvPackageDetails.Rows[index].FindControl("lnkModuleName"); CheckBox checkBox = (CheckBox)this.gvPackageDetails.Rows[index].FindControl("chkModuleStatus"); string str1 = this.objPackageDetailsDT.Rows[index]["ModuleID"].ToString(); string str2 = this.objPackageDetailsDT.Rows[index]["ModuleName"].ToString(); bool flag = Convert.ToBoolean(this.objPackageDetailsDT.Rows[index]["ModuleStatus"].ToString()); label1.Text = str1; label2.Text = str2; if (flag) { checkBox.Checked = true; } } }
public virtual CloudAccountDA.PackageDetailsDataTable DeleteByPackageID(int?PackageID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (PackageID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = PackageID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.PackageDetailsDataTable dataTable = new CloudAccountDA.PackageDetailsDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Update(CloudAccountDA.PackageDetailsDataTable dataTable) { return(this.Adapter.Update(dataTable)); }