/// <summary> /// Function to update values in tblfeeitem /// </summary> public void FeeItemUpdate(FeeItemInfo feeItemInfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand sqlcmd = new MySqlCommand("FeeItemUpdate", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = sqlcmd.Parameters.Add("?feeItemId", MySqlDbType.Int32); sqlparam.Value = feeItemInfo.FeeItemId; sqlparam = sqlcmd.Parameters.Add("?feeTitle", MySqlDbType.VarChar); sqlparam.Value = feeItemInfo.FeeTitle; sqlparam = sqlcmd.Parameters.Add("?classNo", MySqlDbType.Int32); sqlparam.Value = feeItemInfo.ClassId; sqlparam = sqlcmd.Parameters.Add("?termId", MySqlDbType.Int32); sqlparam.Value = feeItemInfo.TermId; sqlparam = sqlcmd.Parameters.Add("?active", MySqlDbType.Bit); sqlparam.Value = feeItemInfo.Active; sqlparam = sqlcmd.Parameters.Add("?amount", MySqlDbType.Decimal); sqlparam.Value = feeItemInfo.FeeAmount; sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void FillControls() { try { FeeItemInfo feeItemInfo = new FeeItemInfo(); FeeItemSp feeItemSp = new FeeItemSp(); feeItemInfo = feeItemSp.FillDataGridViewFeeItemOne(feeItemId); txtFeeType.Text = feeItemInfo.FeeTitle; cmbClass.SelectedValue = Convert.ToInt32(feeItemInfo.ClassId); cmbTerm.SelectedValue = Convert.ToInt32(feeItemInfo.TermId); txtAmount.Text = Convert.ToString(feeItemInfo.FeeAmount); if (feeItemInfo.Active) { cbxActive.Checked = true; } else { cbxActive.Checked = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// <summary> /// Function to fill datatable for dgvFeeItem /// </summary> public FeeItemInfo FillDataGridViewFeeItemOne(decimal feeItemid) { FeeItemInfo feeItemInfo = new FeeItemInfo(); MySqlDataReader sqlreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand sqlcmd = new MySqlCommand("FillDataGridViewFeeItemOne", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = sqlcmd.Parameters.Add("feeItemId", MySqlDbType.Int32); sqlparam.Value = feeItemid; sqlreader = sqlcmd.ExecuteReader(); while (sqlreader.Read()) { feeItemInfo.FeeTitle = sqlreader["feeTitle"].ToString(); feeItemInfo.ClassId = Convert.ToDecimal(sqlreader["classNo"].ToString()); feeItemInfo.TermId = Convert.ToDecimal(sqlreader["termId"].ToString()); feeItemInfo.Active = bool.Parse(sqlreader["active"].ToString()); feeItemInfo.FeeAmount = Convert.ToDecimal(sqlreader["feeAmount"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(feeItemInfo); }
public void SaveFunction() { try { if (txtFeeType.Text == string.Empty) { MessageBox.Show("Enter a fee type"); } else if (cmbClass.SelectedIndex == -1) { MessageBox.Show("Select a class"); } else if (cmbTerm.SelectedIndex == -1) { MessageBox.Show("Select a term"); } else if (txtAmount.Text == string.Empty) { MessageBox.Show("Enter amount"); } else { FeeItemInfo feeItemInfo = new FeeItemInfo(); FeeItemSp feeItemSp = new FeeItemSp(); feeItemInfo.FeeTitle = txtFeeType.Text.Trim(); feeItemInfo.ClassId = Convert.ToDecimal(cmbClass.SelectedValue); feeItemInfo.TermId = Convert.ToDecimal(cmbTerm.SelectedValue); feeItemInfo.FeeAmount = Convert.ToDecimal(txtAmount.Text); if (cbxActive.Checked) { feeItemInfo.Active = true; } else { feeItemInfo.Active = false; } if (btnSave.Text == "Save") { if (Messages.SaveConfirmation()) { feeItemSp.FeeItemAdd(feeItemInfo); Messages.SavedMessage(); ClearFunction(); } } else { if (Messages.UpdateMessage()) { feeItemInfo.FeeItemId = feeItemId; feeItemSp.FeeItemUpdate(feeItemInfo); Messages.UpdatedMessage(); ClearFunction(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }