public void SaveIndividualNote(IndividualNote note, out string errorMessage)
{
errorMessage = String.Empty;
using (SqlConnection connection = new SqlConnection(LoginCredentials.ConnectionString))
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
if (note.IndividualNoteID == 0)
{
cmd.CommandText = "dbo.IndividualNoteInsert";
cmd.Parameters.Add(new SqlParameter("@NewID", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
});
cmd.Parameters.AddWithValue("@IndividualID", note.IndividualID);
cmd.Parameters.AddWithValue("@Note", note.Note);
cmd.Connection = connection;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.ExecuteScalar();
if (note.IndividualNoteID == 0)
{
int returnID = Convert.ToInt32(cmd.Parameters["@NewID"].Value);
if (returnID > 0)
{
note.IndividualNoteID = returnID;
}
}
}
}
}
catch (Exception e)
{
errorMessage = "Error while saving Individual Note: " + e.Message;
}
finally
{
connection.Close();
}
}
}
public IndividualNote GetIndividualNote(IndividualNote note, out string errorMessage)
{
List <IndividualNote> returnList = new List <IndividualNote>();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@IndividualNoteID", note.IndividualNoteID));
SqlCommand cmd = new SqlCommand("dbo.IndividualNoteGetByID");
returnList = createConnection(cmd, out errorMessage, parameters);
if (returnList.Count > 0)
{
return(returnList[0]);
}
else
{
return(new IndividualNote());
}
}
private void AddNoteButton_Click(object sender, EventArgs e)
{
string errorMessage = String.Empty;
string note = noteText.Text.Trim();
if (String.IsNullOrEmpty(note))
{
MessageBox.Show("Please enter a new Note.");
}
else
{
Individual individual = (Individual)IndividualDataSource.DataSource;
if (individual != null && individual.IndividualID > 0)
{
IndividualNote idividualNote = new IndividualNote
{
IndividualID = individual.IndividualID,
Note = note
};
Controller.SaveIndividualNote(idividualNote, out errorMessage);
if (!String.IsNullOrEmpty(errorMessage))
{
MessageBox.Show(errorMessage);
}
else
{
getIndividualNotes();
noteText.Text = String.Empty;
}
}
else
{
MessageBox.Show("Please select an individual first.");
}
}
}
public void SaveIndividualNote(IndividualNote note, out string errorMessage)
{
IndividualNoteData.SaveIndividualNote(note, out errorMessage);
}
public IndividualNote GetIndividualNote(IndividualNote note, out string errorMessage)
{
return(IndividualNoteData.GetIndividualNote(note, out errorMessage));
}
