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