public bool AddProjectNote(ProjectNotes note) { DatabaseHelper dh = new DatabaseHelper(); var CompletedDate = "0000-00-00"; try { dh.RunUpdateQuery($"INSERT INTO ProjectNote (projectId, message, sentDate, [from], [to]) VALUES('{note.ProjectId}', '{note.Message.Replace("'", "''")}', " + $"'{note.SentDate}', '{note.From}', '{note.To}');"); return(true); } catch (Exception e) { Debug.WriteLine(e.Message); return(false); } }
public ProjectNotes getSelectEditProjectNotes(int projectNoteId) { ProjectNotes modelList = new ProjectNotes(); using (SqlConnection connection = new SqlConnection(connString)) using (SqlCommand command = new SqlCommand("", connection)) { // Query with vals command.CommandText = "SELECT * FROM ProjectNote WHERE projectNoteId = @projectNoteId;"; command.Parameters.AddWithValue("@projectNoteId", projectNoteId); // Open connection connection.Open(); SqlDataReader reader = command.ExecuteReader(); // Multiple rows while (reader.Read()) { var model = new ProjectPageViewModel(); modelList.ProjectNoteId = Convert.ToInt32(reader["projectNoteId"]); modelList.ProjectId = Convert.ToInt32(reader["projectId"]); modelList.Message = reader["message"].ToString(); modelList.SentDate = Convert.ToDateTime(reader["sentDate"]); modelList.From = reader["from"].ToString(); modelList.To = reader["to"].ToString(); if (reader["completedDate"] != DBNull.Value) { modelList.CompletedDate = Convert.ToDateTime(reader["completedDate"]); } else { modelList.CompletedDate = DateTime.MinValue; } } reader.Close(); connection.Close(); } return(modelList); }
public ProjectNotes getProjectNotesDetails(int myNoteID) { ProjectNotes modelList = new ProjectNotes(); using (SqlConnection connection = new SqlConnection(connString)) using (SqlCommand command = new SqlCommand("", connection)) { try { // Query with vals command.CommandText = "SELECT * FROM ProjectNote WHERE projectNoteId = @projectNoteId;"; command.Parameters.AddWithValue("@projectNoteId", myNoteID); // Open connection connection.Open(); SqlDataReader reader = command.ExecuteReader(); // Multiple rows while (reader.Read()) { var model = new ProjectPageViewModel(); modelList.ProjectId = model.ProjectNotes.ProjectNoteId = Convert.ToInt32(reader["projectNoteId"]); modelList.Message = model.ProjectNotes.Message = reader["message"].ToString(); modelList.SentDate = model.ProjectNotes.SentDate = (DateTime)reader["sentDate"]; modelList.From = model.ProjectNotes.From = reader["from"].ToString(); modelList.To = model.ProjectNotes.To = reader["to"].ToString(); //modelList.CompletedDate = model.ProjectNotes.CompletedDate = (DateTime)reader["completedDate"]; } reader.Close(); connection.Close(); } catch (Exception e) { } } return(modelList); }
public bool updateProjectNotes(int projectNotesId, ProjectNotes projectNotes) { DatabaseHelper dh = new DatabaseHelper(); try { var message = projectNotes.Message; var completionDate = projectNotes.CompletedDate; var to = projectNotes.To; ///dh.RunUpdateQuery($"DELETE FROM ProjectNote WHERE projectNoteId='{projectNoteId}'"); dh.RunUpdateQuery($"UPDATE ProjectNote set message='{message.Replace("'", "''")}', completedDate='{completionDate}', [to]='{to}' WHERE projectNoteId = '{projectNotesId}'"); return(true); } catch (Exception e) { Debug.WriteLine(e.Message); return(false); } }