Пример #1
0
        public static WarrantyNoteList GetInternalNotes(int userID, int employeeID, int recordID)
        {
            QueryOutput queryOutput;
            var         list = new WarrantyNoteList();

            list.Data = Query <WarrantyNote>(new DbQuery(userID, employeeID, DbAction.Warranty.View, InternalNoteQuery(recordID)), out queryOutput).ToList();
            return(list);
        }
Пример #2
0
        public static WarrantyNoteList SaveInternalNote(int userID, int employeeID, WarrantyNote note)
        {
            QueryOutput queryOutput;
            var         query = String.Format(
                @"insert into WarrantyInternalNote(WarrantyID, EmployeeID, SubmitDate, Message)
                values ({0}, {1}, {2}, N'{3}') {4}", note.WarrantyID, employeeID, DateTime.Now.DbValue(), note.Message, InternalNoteQuery(note.WarrantyID));
            var list = new WarrantyNoteList();

            list.Data = Query <WarrantyNote>(new DbQuery(userID, employeeID, DbAction.Warranty.View, query), out queryOutput).ToList();
            return(list);
        }
Пример #3
0
        public static WarrantyNoteList RemoveInternalNote(int userID, int employeeID, int noteID)
        {
            QueryOutput queryOutput;
            var         query = String.Format(
                @"declare @recordID int = (select top 1 WarrantyID from WarrantyInternalNote where ID = {0})
                delete WarrantyInternalNote where ID = {0} {1}",
                noteID, InternalNoteQuery("@recordID"));
            var list = new WarrantyNoteList();

            list.Data = Query <WarrantyNote>(new DbQuery(userID, employeeID, DbAction.Warranty.View, query), out queryOutput).ToList();
            return(list);
        }