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