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