public static RepairNoteList GetInternalNotes(int userID, int employeeID, int recordID) { QueryOutput queryOutput; var list = new RepairNoteList(); list.Data = Query <RepairNote>(new DbQuery(userID, employeeID, DbAction.Repair.View, InternalNoteQuery(recordID)), out queryOutput).ToList(); return(list); }
public static RepairNoteList SaveInternalNote(int userID, int employeeID, RepairNote note) { QueryOutput queryOutput; var query = String.Format( @"insert into RepairInternalNote(RepairID, EmployeeID, SubmitDate, Message) values ({0}, {1}, {2}, N'{3}') {4}", note.RepairID, employeeID, DateTime.Now.DbValue(), note.Message, InternalNoteQuery(note.RepairID)); var list = new RepairNoteList(); list.Data = Query <RepairNote>(new DbQuery(userID, employeeID, DbAction.Repair.View, query), out queryOutput).ToList(); return(list); }
public static RepairNoteList RemoveInternalNote(int userID, int employeeID, int noteID) { QueryOutput queryOutput; var query = String.Format( @"declare @recordID int = (select top 1 RepairID from RepairInternalNote where ID = {0}) delete RepairInternalNote where ID = {0} {1}", noteID, InternalNoteQuery("@recordID")); var list = new RepairNoteList(); list.Data = Query <RepairNote>(new DbQuery(userID, employeeID, DbAction.Repair.View, query), out queryOutput).ToList(); return(list); }