private bool Insert(Comment entComment) { TCRepositoryDataContext context = DataBaseUtils.GetContext(); try { tbl_Comments dbComment = new tbl_Comments() { Comment = entComment.CommentSuggestion, CreatedOn = DateTime.Now, Email = entComment.Email, Name = entComment.Name, SupervisorRating = entComment.SupervisorRating, CompanyOpinionRating = entComment.CompanyOpinionRating, WorkEnviromentRating = entComment.WorkEnviromentRating, CompanyWorking = entComment.CompanyWorking, GroupDirectorRating = entComment.GroupDirectorRating, SecurityRating = entComment.SecurityRating, Subject = entComment.Subject, IsRead = false }; context.tbl_Comments.InsertOnSubmit(dbComment); context.SubmitChanges(); return true; } catch { } return false; }
public Comment GetCommentByID(int IdComment) { TCRepositoryDataContext context = DataBaseUtils.GetContext(); tbl_Comments dbComment = context.tbl_Comments.Where(c => c.IdComment == IdComment).FirstOrDefault(); if (dbComment != null) { Comment EntComment = new Comment() { IdComment = dbComment.IdComment, Name = dbComment.Name, Email = dbComment.Email, CommentSuggestion = dbComment.Comment, CreatedOn = dbComment.CreatedOn, Subject = dbComment.Subject, SupervisorRating = dbComment.SupervisorRating, CompanyOpinionRating = dbComment.CompanyOpinionRating, WorkEnviromentRating = dbComment.WorkEnviromentRating, CompanyWorking = dbComment.CompanyWorking, GroupDirectorRating = dbComment.GroupDirectorRating, SecurityRating = dbComment.SecurityRating, IsRead = dbComment.IsRead }; return EntComment; } return new Comment(); }
public bool Save(Comment entComment) { if (entComment != null) { if (entComment.IdComment == 0) return Insert(entComment); } return false; }