コード例 #1
0
        public static int UpdateDocumentDetails(UpdateReadFlag doc)
        {
            try
            {
                var docID           = new MySqlParameter("?docID", doc.docID);
                var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);

                var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
 public static int UpdateDocumentDetails(UpdateReadFlag doc)
 {
     try
     {
         var docID           = new MySqlParameter("?docID", doc.docID);
         var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);
         using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
         {
             context.Connection.Open();
             var Result = context.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
             return(Result);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #3
0
        public object UpdateDocumentIsRead(UpdateReadFlag doc)
        {
            dynamic TBDocumentUpdateResult;

            try
            {
                var Result = DocumentSafe.UpdateDocumentDetails(doc);

                if (Result > 0)
                {
                    TBDocumentUpdateResult = new { status = "0", message = "success" };
                }
                else
                {
                    TBDocumentUpdateResult = new { status = "0", message = "Record not found" };
                }
            }
            catch
            {
                TBDocumentUpdateResult = new { status = "1", message = "failed" };
            }

            return(new { TBDocumentUpdateResult });
        }