public virtual CloudAccountDA.FAQMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.FAQMasterDataTable dataTable = new CloudAccountDA.FAQMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.FAQMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void ViewRecord(string i) { this.objFAQMasterDT = this.objFAQMasterBll.GetDataByFAQID(int.Parse(i)); if (this.objFAQMasterDT.Rows.Count <= 0) { return; } this.hfFAQ.Value = this.objFAQMasterDT.Rows[0]["FAQID"].ToString(); this.lblFAQQuestion.Text = this.objFAQMasterDT.Rows[0]["Question"].ToString(); this.lblFAQAnswer.Text = this.objFAQMasterDT.Rows[0]["Answer"].ToString(); this.lblStatus.Text = this.objFAQMasterDT.Rows[0]["Status"].ToString() == "True" ? "True" : "False"; this.lblFAQCategory.Text = this.objFAQMasterDT.Rows[0]["FAQCategoryID"].ToString(); this.objFAQCategoryMasterDT = this.objFAQCategoryMasterBll.GetDataByFAQCategoryID(int.Parse(this.lblFAQCategory.Text)); this.lblFAQCategory.Text = this.objFAQCategoryMasterDT.Rows[0]["FAQCategoryName"].ToString(); }
public virtual CloudAccountDA.FAQMasterDataTable GetDataByFAQID(int?FAQID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (FAQID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = FAQID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.FAQMasterDataTable dataTable = new CloudAccountDA.FAQMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void SetRecord(string iD) { this.objFAQMasterDT = this.objFAQMasterBll.GetDataByFAQID(int.Parse(iD)); if (this.objFAQMasterDT.Rows.Count <= 0) { return; } this.hfFAQ.Value = this.objFAQMasterDT.Rows[0]["FAQID"].ToString(); this.txtFAQQuestion.Text = this.objFAQMasterDT.Rows[0]["Question"].ToString(); this.txtFAQAnswer.Text = this.objFAQMasterDT.Rows[0]["Answer"].ToString(); this.chkStatus.Checked = this.objFAQMasterDT.Rows[0]["Status"].ToString() == "True"; this.objFAQCategoryMasterDT = this.objFAQCategoryMasterBll.GetDataByFAQCategoryID(int.Parse(this.objFAQMasterDT.Rows[0]["FAQCategoryID"].ToString())); if (this.objFAQCategoryMasterDT.Rows.Count <= 0) { return; } this.ddlFAQCategory.Items.Add(this.objFAQCategoryMasterDT.Rows[0]["FAQCategoryID"].ToString()); this.ddlFAQCategory.SelectedValue = this.objFAQCategoryMasterDT.Rows[0]["FAQCategoryID"].ToString(); }
public virtual int Update(CloudAccountDA.FAQMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }