public void SaveOrEdit()
{
try
{
if (txtJournalName.Text == string.Empty)
{
MessageBox.Show("Enter a journal name");
}
else if (txtAbbreviation.Text == string.Empty)
{
MessageBox.Show("Enter an abbreviation");
}
else
{
JournalTypeInfo journalTypeInfo = new JournalTypeInfo();
JournalSP spJournal = new JournalSP();
journalTypeInfo.JournalTypeName = txtJournalName.Text.Trim();
journalTypeInfo.Abbreviation = txtAbbreviation.Text.Trim();
journalTypeInfo.Narration = txtNarration.Text.Trim();
journalTypeInfo.Heading1 = txtHeading1.Text.Trim();
journalTypeInfo.Heading2 = txtHeading2.Text.Trim();
journalTypeInfo.IsActive = cbxActive.Checked ? true : false;
if (btnSave.Text == "Save")
{
if (Messages.SaveConfirmation())
{
spJournal.JournalTypeAdd(journalTypeInfo);
Messages.SavedMessage();
ClearFunction();
}
}
else
{
if (Messages.UpdateMessage())
{
journalTypeInfo.JournalTypeId = journalId;
spJournal.JournalTypeUpdate(journalTypeInfo);
Messages.UpdatedMessage();
ClearFunction();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void FillControls()
{
try
{
JournalTypeInfo journalTypeInfo = new JournalTypeInfo();
JournalSP spJournal = new JournalSP();
journalTypeInfo = spJournal.JournalTypeViewOne(journalId);
txtJournalName.Text = journalTypeInfo.JournalTypeName;
txtAbbreviation.Text = journalTypeInfo.Abbreviation;
cbxActive.Checked = Convert.ToBoolean(journalTypeInfo.IsActive) ? true : false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///<summary>
///Function to get values from tblJournalType based on parameters
/// </summary>
/// <param name="journalId"></param>
public JournalTypeInfo JournalTypeViewOne(decimal journalId)
{
JournalTypeInfo journalTypeInfo = new JournalTypeInfo();
MySqlDataReader sqlreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sqlcmd = new MySqlCommand("JournalTypeViewOne", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sqlparam = new MySqlParameter();
sqlparam = sqlcmd.Parameters.Add("journalId", MySqlDbType.Int32);
sqlparam.Value = journalId;
sqlreader = sqlcmd.ExecuteReader();
while (sqlreader.Read())
{
journalTypeInfo.JournalTypeName = sqlreader["journalTypeName"].ToString();
journalTypeInfo.Abbreviation = sqlreader["abbreviation"].ToString();
journalTypeInfo.IsActive = bool.Parse(sqlreader["isActive"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcon.Close();
}
return(journalTypeInfo);
}
///<summary>
///Function to update values to tblJournalType
/// </summary>
public void JournalTypeUpdate(JournalTypeInfo journalTypeInfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sqlcmd = new MySqlCommand("JournalTypeUpdate", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sqlparam = new MySqlParameter();
sqlparam = sqlcmd.Parameters.Add("?journalId", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.JournalTypeId;
sqlparam = sqlcmd.Parameters.Add("?journalName", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.JournalTypeName;
sqlparam = sqlcmd.Parameters.Add("?abbreviation", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.Abbreviation;
sqlparam = sqlcmd.Parameters.Add("?isActive", MySqlDbType.Bit);
sqlparam.Value = journalTypeInfo.IsActive;
sqlparam = sqlcmd.Parameters.Add("?narration", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.Narration;
sqlparam = sqlcmd.Parameters.Add("?heading1", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.Heading1;
sqlparam = sqlcmd.Parameters.Add("?heading2", MySqlDbType.VarChar);
sqlparam.Value = journalTypeInfo.Heading2;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcon.Close();
}
}
