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