public void UpdateFinalScore(int id, int fnlTtl, int dtlsID, string typ)
        {
            var sheet = new ScoringSheet()
            {
                ID         = id,
                FinalTotal = fnlTtl,
                DetailsID  = dtlsID,
                Type       = typ
            };

            dbConn.Update(sheet);
        }
        public int InsertScoringSheet(int dtlsID, string typ)
        {
            var sheet = new ScoringSheet()
            {
                Type      = typ,
                DetailsID = dtlsID
            };

            dbConn.Insert(sheet);
            var detail = dbConn.Get <Details>(dtlsID);

            sheet.details = detail; //for ref integ
            dbConn.UpdateWithChildren(sheet);
            var scrShtID = sheet.ID;

            return(scrShtID);
        }