public virtual CloudAccountDA.PackageFeatureMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.PackageFeatureMasterDataTable dataTable = new CloudAccountDA.PackageFeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.PackageFeatureMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void SetRecord(string iD) { this.objPackageFeatureMasterDT = this.objPackageFeatureMasterBll.GetDataByPackageFeatureID(int.Parse(iD)); if (this.objPackageFeatureMasterDT.Rows.Count <= 0) { return; } this.hfPackageFeature.Value = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureID"].ToString(); this.ddlPackageModule.SelectedValue = this.objPackageFeatureMasterDT.Rows[0]["PackageModuleID"].ToString(); this.txtName.Text = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureName"].ToString(); this.txtDesc.Text = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureDesc"].ToString(); this.chkStatus.Checked = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureStatus"].ToString() == "True"; }
private void ViewRecord(string i) { this.objPackageFeatureMasterDT = this.objPackageFeatureMasterBll.GetDataByPackageFeatureID(int.Parse(i)); if (this.objPackageFeatureMasterDT.Rows.Count <= 0) { return; } this.hfPackageFeature.Value = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureID"].ToString(); this.lblName.Text = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureName"].ToString(); this.lblDesc.Text = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureDesc"].ToString(); this.lblStatus.Text = this.objPackageFeatureMasterDT.Rows[0]["PackageFeatureStatus"].ToString() == "True" ? "True" : "False"; this.objPackageModuleMasterDT = this.objPackageModuleMasterBll.GetDataByPackageModuleID(int.Parse(this.objPackageFeatureMasterDT.Rows[0]["PackageModuleID"].ToString())); this.lblPackageModule.Text = this.objPackageModuleMasterDT.Rows[0]["PackageModuleName"].ToString(); }
public virtual CloudAccountDA.PackageFeatureMasterDataTable GetDataByPackageFeatureID(int?PackageFeatureID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (PackageFeatureID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = PackageFeatureID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.PackageFeatureMasterDataTable dataTable = new CloudAccountDA.PackageFeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (!this.Page.IsValid) { return; } if (this.ddlPackageModule.SelectedIndex > 0 && this.txtName.Text.Trim().Length > 0) { this.objPackageFeatureMasterDT = this.objPackageFeatureMasterBll.GetDataByPackageFeatureName(int.Parse(this.ddlPackageModule.SelectedItem.Value), this.txtName.Text.Trim()); if (this.objPackageFeatureMasterDT.Rows.Count > 0) { this.DisplayAlert("Package Feature Already Exist.."); this.checkInDB = true; } if (!this.checkInDB) { int num = this.objPackageFeatureMasterBll.AddPackageFeature(int.Parse(this.ddlPackageModule.SelectedItem.Value), this.txtName.Text.Trim(), this.txtDesc.Text.Trim(), this.chkStatus.Checked); if (num != 0) { this.DisplayAlert("Details Added Successfully."); this.Response.Redirect("~/BillTransact/PackageFeatureMaster.aspx?cmd=view&ID=" + (object)num); } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Please Fill All Data...!"); } } catch (Exception ex) { this.DisplayAlert(ex.Message); throw; } }
public virtual CloudAccountDA.PackageFeatureMasterDataTable GetDataByPackageModuleIDAndName(int?PackageModuleID, string PackageFeatureName) { this.Adapter.SelectCommand = this.CommandCollection[3]; if (PackageModuleID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = PackageModuleID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (PackageFeatureName == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = PackageFeatureName; } CloudAccountDA.PackageFeatureMasterDataTable dataTable = new CloudAccountDA.PackageFeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Update(CloudAccountDA.PackageFeatureMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }