private void BindQuestionTypeCheckboxList() { BOQuestionType _boqtype = new BOQuestionType(); BAQuestionType _baqtype = new BAQuestionType(); DataTable _datatable1 = new DataTable(); _datatable1 = _baqtype.SelectQuestionType("GETALL"); foreach (DataRow row in _datatable1.Rows) { ListItem item = new ListItem(); item.Text = row["QuestionType"].ToString(); item.Value = row["QuestionTypeId"].ToString(); item.Selected = Convert.ToBoolean(row["DefaultPermission"]); item.Enabled = !Convert.ToBoolean(row["DefaultPermission"]); chkQuestionType.Items.Add(item); } }
public int IUDQuestionType(BOQuestionType bqtype) { int returnvalue = default(int); using (SqlConnection _sqlconnection = ConnectionInfo.GetConnection()) { _sqlcommand = new SqlCommand(); _sqlcommand.Connection = _sqlconnection; _sqlcommand.CommandText = "SP_IUDQuestionType"; _sqlcommand.CommandType = CommandType.StoredProcedure; _sqlconnection.Open(); _sqlcommand.Parameters.AddWithValue("@QuestionTypeId", bqtype.QuestionTypeId); _sqlcommand.Parameters.AddWithValue("@QuestionType", bqtype.QuestionType); _sqlcommand.Parameters.AddWithValue("@DefaultPermission", bqtype.DefaultPermission); _sqlcommand.Parameters.AddWithValue("@IsActive", bqtype.IsActive); _sqlcommand.Parameters.AddWithValue("@IsDelete", bqtype.IsDelete); _sqlcommand.Parameters.AddWithValue("@CreatedBy", bqtype.CreatedBy); _sqlcommand.Parameters.AddWithValue("@CreatedDate", bqtype.CreatedDate); _sqlcommand.Parameters.AddWithValue("@UpdateBy", bqtype.UpdateBy); _sqlcommand.Parameters.AddWithValue("@UpdateDate", bqtype.UpdateDate); _sqlcommand.Parameters.AddWithValue("@Event", bqtype.Event); _sqlcommand.Parameters.AddWithValue("@returnValue", 0).Direction = System.Data.ParameterDirection.InputOutput; try { _sqlcommand.ExecuteNonQuery(); returnvalue = Convert.ToInt32(_sqlcommand.Parameters["@returnValue"].Value); } catch (Exception ex) { Common.LogError(ex); } finally { _sqlconnection.Close(); _sqlcommand.Dispose(); } } return(returnvalue); }
private void dgvQuestionType_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (headval) { if (dgvQuestionType.Columns[e.ColumnIndex].Name == "Edit") { QTypeId = Convert.ToInt32(dgvQuestionType.Rows[e.RowIndex].Cells[0].Value.ToString()); txtQuestionType.Text = dgvQuestionType.Rows[e.RowIndex].Cells[1].Value.ToString(); btnAdd.Text = "Update"; } else if (dgvQuestionType.Columns[e.ColumnIndex].Name == "Delete") { DialogResult result = MessageBox.Show("Are you sure you want delete\nrecord " + dgvQuestionType.Rows[e.RowIndex].Cells[1].Value.ToString() + " ?", "Warning", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { QTypeId = Convert.ToInt32(dgvQuestionType.Rows[e.RowIndex].Cells[0].Value.ToString()); BOQuestionType _boqtype = new BOQuestionType(); _boqtype.QuestionTypeId = QTypeId; _boqtype.QuestionType = txtQuestionType.Text; _boqtype.IsActive = true; _boqtype.IsDelete = true; _boqtype.CreatedBy = loginID; _boqtype.CreatedDate = DateTime.UtcNow; _boqtype.UpdateBy = loginID; _boqtype.UpdateDate = DateTime.UtcNow; _boqtype.Event = "Delete"; MessageBox.Show(Common.Message(dgvQuestionType.Rows[e.RowIndex].Cells[1].Value.ToString(), _baqtype.Delete(_boqtype))); ClearControl(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataTable SelectQuestionType(BOQuestionType bqtype) { SqlCommand _sqlcommand; SqlDataAdapter _sqlDataAdapter; using (SqlConnection _con = ConnectionInfo.GetConnection()) { _sqlcommand = new SqlCommand(); _sqlcommand.CommandText = "SP_GetQuestionType"; _sqlcommand.CommandType = System.Data.CommandType.StoredProcedure; _sqlcommand.Connection = _con; _con.Open(); _sqlcommand.Parameters.AddWithValue("@Event", bqtype.Event); _sqlDataAdapter = new SqlDataAdapter(_sqlcommand); DataTable _dataTable = new DataTable(); _sqlDataAdapter.Fill(_dataTable); _con.Close(); return(_dataTable); } }
public int Delete(BOQuestionType _boqtype) { return(_daqtype.IUDQuestionType(_boqtype)); }
public int Insert(BOQuestionType _boqtype) { return(_daqtype.IUDQuestionType(_boqtype)); }
public DataTable SelectQuestionType(BOQuestionType _boqtyp) { return(_daqtype.SelectQuestionType(_boqtyp)); }