public bool Save(Project project, HttpPostedFileBase image, HttpPostedFileBase document, string userName) { bool result = true; try { var dbItem = new Project(); var isNew = false; var check = _db.Projects.Where(p => p.Id == project.Id && p.IsDeleted == false).ToList(); if (check.Count > 0) { dbItem = check.First(); _db.Entry(dbItem).State = EntityState.Modified; dbItem.ModifiedBy = userName; dbItem.DateModified = DateTime.UtcNow; } else { dbItem.DateAdded = DateTime.UtcNow; dbItem.AddedBy = userName; isNew = true; } var target = new MemoryStream(); image.InputStream.CopyTo(target); dbItem.DisplayImage = target.ToArray(); dbItem.PdfPath = project.PdfPath; dbItem.Title = project.Title; dbItem.CategoryId = project.CategoryId; dbItem.Office = project.Office; dbItem.Description = project.Description; dbItem.IsDeleted = false; if (isNew) { _db.Entry(dbItem).State = EntityState.Added; _db.Projects.Add(dbItem); } _db.SaveChanges(); } catch (Exception) { result = false; } return(result); }
public bool Save(User item, string userName) { bool result = true; try { var dbItem = new User(); var isNew = false; var check = _db.Users.Where(p => p.Id == item.Id && p.IsDeleted == false).ToList(); if (check.Count > 0) { dbItem = check.First(); _db.Entry(dbItem).State = EntityState.Modified; dbItem.ModifiedBy = userName; dbItem.DateModified = DateTime.UtcNow; } else { dbItem.DateAdded = DateTime.UtcNow; dbItem.AddedBy = userName; isNew = true; } dbItem.FirstName = item.FirstName; dbItem.LastName = item.LastName; dbItem.Email = item.Email; dbItem.Password = item.Password; dbItem.Role = item.Role; dbItem.IsDeleted = false; if (isNew) { _db.Entry(dbItem).State = EntityState.Added; _db.Users.Add(dbItem); } _db.SaveChanges(); } catch (Exception) { result = false; } return(result); }
public bool Save(Result item, string userName) { bool result = true; try { var dbItem = new Result(); var isNew = false; var check = _db.Results.Where(p => p.Id == item.Id && p.IsDeleted == false).ToList(); if (check.Count > 0) { dbItem = check.First(); _db.Entry(dbItem).State = EntityState.Modified; dbItem.ModifiedBy = userName; dbItem.DateModified = DateTime.UtcNow; } else { dbItem.DateAdded = DateTime.UtcNow; dbItem.AddedBy = userName; isNew = true; } dbItem.ProjectId = item.ProjectId; dbItem.CategoryId = item.CategoryId; dbItem.UserId = item.UserId; dbItem.CategoryName = item.CategoryName; dbItem.ProjectName = item.ProjectName; dbItem.IsDeleted = false; if (isNew) { _db.Entry(dbItem).State = EntityState.Added; _db.Results.Add(dbItem); } _db.SaveChanges(); } catch (Exception) { result = false; } return(result); }
public bool Save(HttpPostedFileBase httpPostedFileBases, string name, string userName) { bool result = true; try { var dbItem = new Category(); var isNew = false; var check = _db.Categories.Where(p => p.CategoryName == name && p.IsDeleted == false).ToList(); if (check.Count > 0) { dbItem = check.First(); _db.Entry(dbItem).State = EntityState.Modified; dbItem.ModifiedBy = userName; dbItem.DateModified = DateTime.UtcNow; } else { dbItem.DateAdded = DateTime.UtcNow; dbItem.AddedBy = userName; isNew = true; } var target = new MemoryStream(); httpPostedFileBases.InputStream.CopyTo(target); dbItem.Image = target.ToArray(); dbItem.CategoryName = name; dbItem.IsDeleted = false; if (isNew) { _db.Entry(dbItem).State = EntityState.Added; _db.Categories.Add(dbItem); } _db.SaveChanges(); } catch (Exception) { result = false; } return(result); }