/// <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);
}
}
