public string Add(DocumentInfoModel item) { using (ScorelinkEntities db = new ScorelinkEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = db.Database.BeginTransaction()) { try { var docInfo = new DocumentInfo { FileUID = item.FileUID, FileName = item.FileName, FilePath = item.FilePath, CreateBy = item.CreateBy, CreateDate = DateTime.Parse(item.CreateDate) }; db.DocumentInfoes.Add(docInfo); db.SaveChanges(); //var lastuser = db.Users.Select(x => x.UserId).Max(); dbTran.Commit(); return("OK"); } catch (Exception ex) { dbTran.Rollback(); return(ex.ToString()); } } } }
public string Delete(string id) { using (ScorelinkEntities db = new ScorelinkEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = db.Database.BeginTransaction()) { try { var user = db.DocumentInfoes.Where(x => x.DocId.ToString() == id).First(); db.DocumentInfoes.Remove(user); db.SaveChanges(); dbTran.Commit(); return("OK"); } catch (Exception ex) { dbTran.Rollback(); return(ex.ToString()); } } } }