public ActionResult AddRole(RoleViewModel item)
{
try
{
Role r = item.ToModel();
r.Accesses = item.GetAccessList(item.Accesses);
r.Users = item.GetUserList(item.Users);
r.CreatedDate = DateTime.Now;
db.Roles.Add(r);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert role " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteSurvey(SurveyViewModel s)
{
try
{
Survey item = db.Surveys.Find(s.ToModel().Id);
if (item != null)
{
item.DeletionDate = DateTime.Now;
item.IsDeleted = true;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete survey from " + this.UserName + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdateCountry(CountryViewModel item)
{
try
{
Country c = db.Countries.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.DeletionDate = item.DeletionDate;
c.IsDeleted = item.IsDeleted;
c.DeletionUserId = item.DeletionUserId;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.Name = item.Name;
c.Cities = item.GetCityList(item.Cities);
//c.CreatedDate = item.CreatedDate;
c.CreatedUserId = item.CreatedUserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update country " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteRole(RoleViewModel item)
{
try
{
Role c = db.Roles.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
foreach (var i in db.Accesses)
{
if (i.RoleId == c.Id)
{
i.IsDeleted = true;
}
}
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete role " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdatePermission(PermissionViewModel item)
{
try
{
Permission c = db.Permissions.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.DeletionDate = item.DeletionDate;
c.DeletionUserId = item.DeletionUserId;
c.IsDeleted = item.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.Name = item.Name;
c.Accesses = item.GetAccessList(item.Accesses);
c.CreatedUserId = item.CreatedUserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update permission " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteCountry(CountryViewModel item)
{
try
{
Country c = db.Countries.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
//foreach (var i in db.Cities)
//{
// if (i.CountryId == c.Id)
// {
// i.IsDeleted = true;
// }
//}
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete country " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteImageType(ImageTypeViewModel item)
{
try
{
ImageType c = db.ImageTypes.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete image type " + this.Type + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(200));
}
}
public ActionResult UpdatQuestionType(QuestionTypeViewModel item)
{
try
{
QuestionType c = db.QuestionTypes.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.DeletionDate = item.DeletionDate;
c.IsDeleted = item.IsDeleted;
c.DeletionUserId = item.DeletionUserId;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.Questions = item.GetQuestionList(item.Questions);
c.Type = item.Type;
//c.CreatedDate = item.CreatedDate;
c.CreatedUserId = item.CreatedUserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update question type " + this.Type + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteSender(NotificationViewModel item)
{
try
{
Notification c = db.Notifications.Find(item.ToModel().Id);
if (c != null)
{
if (c.ReceiverDeleted == true)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
}
c.SenderDeleted = true;
c.SenderDeletedDate = DateTime.Now;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete mail to " + this.ToUsername
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteQuestionAnswer(QuestionAnswerViewModel item)
{
try
{
QuestionAnswer c = db.QuestionAnswers.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete question answer " + this.Answer + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteAnimate()
{
try
{
Animate c = db.Animates.Find(this.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
db.SaveChanges();
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete access to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult UpdateUser(UserViewModel item)
{
try
{
User c = db.Users.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.IsDeleted = item.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.DeletionDate = item.DeletionDate;
c.DeletionUserId = item.DeletionUserId;
c.Birthdate = item.Birthdate;
c.City = db.Cities.Find(item.CityId);
c.CityId = item.CityId;
c.Email = item.Email;
c.FirstName = item.FirstName;
c.Gender = item.Gender.ToString();
c.IsActive = item.IsActive;
c.IsBlocked = item.IsBlocked;
c.IsComplete = item.IsComplete;
c.LastLogin = item.LastLogin;
c.LastName = item.LastName;
c.Password = item.Password;
c.PhoneNumber = item.PhoneNumber;
c.Responses = item.GetResponseList(item.Responses);
c.Role = db.Roles.Find(item.RoleId);
c.RoleId = item.RoleId;
c.Surveys = item.GetSurveyList(item.Surveys);
c.Username = item.Username;
c.CreatedUserId = item.CreatedUserId;
// c.CreatedDate = item.CreatedDate;
c.PasswordTokenExpired = item.PasswordTokenExpired;
c.PasswordToken = item.PasswordToken;
c.TokenActivated = item.TokenActivated;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update user from " + this.CityName + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdateSurvey(SurveyViewModel s)
{
try
{
Survey item = db.Surveys.Find(s.ToModel().Id);
if (item != null)
{
item.IsBlock = s.IsBlock;
item.IsDeleted = s.IsDeleted;
item.ModifiedDate = DateTime.Now;
item.ModifiedUserId = s.ModifiedUserId;
item.SurveyTypeId = s.SurveyTypeId;
item.Title = s.Title;
item.DeletionDate = s.DeletionDate;
item.DeletionUserId = s.DeletionUserId;
//item.CreatedDate = s.CreatedDate;
item.CreatedUserId = s.CreatedUserId;
item.Description = s.Description;
//item.Id = s.Id;
item.Questions = s.GetQuestionList(s.Questions);
item.SurveyType = db.SurveyTypes.Find(s.SurveyTypeId);
item.User = db.Users.Find(s.UserId);
//item.UserId = s.UserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = message
};
l.AddLog(l);
db.SaveChanges();
// raise a new exception nesting
// the current instance as InnerException
}
}
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdateQuestion(QuestionViewModel item)
{
try
{
Question c = db.Questions.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.IsDeleted = item.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.DeletionDate = item.DeletionDate;
c.DeletionUserId = item.DeletionUserId;
c.Animates = item.GetAnimateList(item.Animates);
c.Content = item.Content;
c.IsFreeText = item.IsFreeText;
c.Number = item.Number;
c.QuestionAnswers = item.GetQuestionAnswerList(item.QuestionAnswers);
c.QuestionType = db.QuestionTypes.Find(item.QuestionTypeId);
c.QuestionTypeId = item.QuestionTypeId;
c.Responses = item.GetResponseList(item.Responses);
c.Survey = db.Surveys.Find(item.SurveyId);
c.SurveyId = item.SurveyId;
c.TimeLength = item.TimeLength;
//c.CreatedDate = item.CreatedDate;
c.CreatedUserId = item.CreatedUserId;
c.Count = item.Count;
c.IsScale = item.IsScale;
c.FontColor = item.FontColor;
c.FontSize = item.FontSize;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update question " + this.Content + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteQuestion(QuestionViewModel item)
{
try
{
Question c = db.Questions.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
foreach (var i in db.Animates)
{
if (i.QuestionId == c.Id)
{
i.IsDeleted = true;
}
}
foreach (var i in db.QuestionAnswers)
{
if (i.QuestionId == c.Id)
{
i.IsDeleted = true;
}
}
foreach (var i in db.Responses)
{
if (i.QuestionId == c.Id)
{
i.IsDeleted = true;
}
}
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete question " + this.Content + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddRespondent(RespondentViewModel item)
{
try
{
Respondent r = item.ToModel();
r.CreatedDate = DateTime.Now;
db.Respondents.Add(r);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = message
};
l.AddLog(l);
db.SaveChanges();
// raise a new exception nesting
// the current instance as InnerException
}
}
return(new HttpStatusCodeResult(400));
}
//catch
//{
// LogViewModel l = new LogViewModel
// {
// Id = Guid.NewGuid(),
// CreatedDate = DateTime.Now,
// Type = "Insertion",
// Message = "failed to insert response from" + this.IPAdress + " to database"
// };
// l.AddLog(l);
// return new HttpStatusCodeResult(400);
//}
}
public ActionResult AddAnimate()
{
try
{
Animate a = this.ToModel();
a.CreatedDate = DateTime.Now;
db.Animates.Add(a);
db.SaveChanges();
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = message
};
l.AddLog(l);
db.SaveChanges();
// raise a new exception nesting
// the current instance as InnerException
}
}
return(new HttpStatusCodeResult(400));
//catch
//{
// LogViewModel l = new LogViewModel
// {
// Id = Guid.NewGuid(),
// CreatedDate = DateTime.Now,
// Type = "Insertion",
// Message = "failed to insert animation to database"
// };
// l.AddLog(l);
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
}
public ActionResult UpdateAnimate()
{
try
{
Animate c = db.Animates.Find(this.ToModel().Id);
if (c != null)
{
c.Id = this.Id;
c.IsDeleted = this.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = this.ModifiedUserId;
c.DeletionDate = this.DeletionDate;
c.DeletionUserId = this.DeletionUserId;
c.Depth = this.Depth;
c.Height = this.Height;
c.ImageId = this.ImageId;
c.Image = db.Images.Find(this.ImageId);
c.PosX = this.PosX;
c.PosY = this.PosY;
c.Question = db.Questions.Find(this.QuestionId);
c.QuestionId = this.QuestionId;
c.TimeEnd = this.TimeEnd;
c.TimeStart = this.TimeStart;
c.Width = this.Width;
//c.CreatedDate = this.CreatedDate;
c.CreatedUserId = this.CreatedUserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update animation to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult UpdateImage(ImageViewModel item)
{
try
{
Image c = db.Images.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.IsDeleted = item.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.DeletionDate = item.DeletionDate;
c.DeletionUserId = item.DeletionUserId;
item.GetAnimateList(item.Animates, c.Animates);
c.ImageType = db.ImageTypes.Find(item.ImageTypeId);
c.Location = item.Location;
//c.CreatedDate = item.CreatedDate;
c.CreatedUserId = item.CreatedUserId;
c.ImageTypeId = item.ImageTypeId;
c.Name = item.Name;
c.Name = item.Name;
c.Height = item.Height;
c.Width = item.Width;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update image " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult DeleteUser(UserViewModel item)
{
try
{
User c = db.Users.Find(item.ToModel().Id);
if (c != null)
{
c.IsDeleted = true;
c.DeletionDate = DateTime.Now;
//foreach (var i in db.Responses)
//{
// //if (i.UserId == c.Id)
// //{
// // i.IsDeleted = true;
// //}
//}
foreach (var i in db.Surveys)
{
if (i.UserId == c.Id)
{
i.IsDeleted = true;
}
}
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Deletion",
Message = "failed to delete user from " + this.CityName + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddQuestionAnswer(QuestionAnswerViewModel item)
{
try
{
QuestionAnswer q = item.ToModel();
q.CreatedDate = DateTime.Now;
db.QuestionAnswers.Add(q);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert question answer " + this.Answer + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddNotification(NotificationViewModel item)
{
try
{
Notification n = item.ToModel();
n.CreatedDate = DateTime.Now;
db.Notifications.Add(n);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to sent mail to " + this.ToUsername
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddPermission(PermissionViewModel item)
{
try
{
Permission p = item.ToModel();
p.CreatedDate = DateTime.Now;
db.Permissions.Add(p);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert permission " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddImageType(ImageTypeViewModel item)
{
try
{
ImageType i = item.ToModel();
i.CreatedDate = DateTime.Now;
db.ImageTypes.Add(i);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert image type " + this.Type + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
//ko, kalau pakai actionresult bgmn? Boleh g?
public ActionResult AddAccess()
{
try
{
Access a = this.ToModel();
a.CreatedDate = DateTime.Now;
db.Accesses.Add(a);
db.SaveChanges();
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert access to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult AddSurvey(SurveyViewModel s)
{
try
{
var item = s.ToModel();
item.CreatedDate = DateTime.Now;
db.Surveys.Add(item);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert survey from " + this.UserName + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddCountry(CountryViewModel item)
{
try
{
Country c = item.ToModel();
c.Cities = item.GetCityList(item.Cities);
db.Countries.Add(c);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert country " + this.Name + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdateQuestionAnswer(QuestionAnswerViewModel item)
{
try
{
QuestionAnswer c = db.QuestionAnswers.Find(item.ToModel().Id);
if (c != null)
{
c.Id = item.Id;
c.IsDeleted = item.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = item.ModifiedUserId;
c.DeletionDate = item.DeletionDate;
c.DeletionUserId = item.DeletionUserId;
c.Answer = item.Answer;
c.OrderNumber = item.OrderNumber;
c.Question = db.Questions.Find(item.QuestionId);
c.QuestionId = item.QuestionId;
c.CreatedUserId = item.CreatedUserId;
//c.CreatedDate = item.CreatedDate;
db.SaveChanges();
}
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update question answer " + this.Answer + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public ActionResult UpdateAccess()
{
try
{
Access c = db.Accesses.Find(this.ToModel().Id);
if (c != null)
{
c.Id = this.Id;
c.IsDeleted = this.IsDeleted;
c.ModifiedDate = DateTime.Now;
c.ModifiedUserId = this.ModifiedUserId;
c.DeletionDate = this.DeletionDate;
c.DeletionUserId = this.DeletionUserId;
c.IsGranted = this.IsGranted;
c.Permission = db.Permissions.Find(this.PermissionId);
c.PermissionId = this.PermissionId;
c.Role = db.Roles.Find(this.RoleId);
c.RoleId = this.RoleId;
//c.CreatedDate = this.CreatedDate;
c.CreatedUserId = this.CreatedUserId;
db.SaveChanges();
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Update",
Message = "failed to update access to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult AddUser(UserViewModel item)
{
try
{
User u = item.ToModel();
u.CreatedDate = DateTime.Now;
u.LastLogin = DateTime.Now;
db.Users.Add(u);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
LogViewModel l = new LogViewModel
{
Id = Guid.NewGuid(),
CreatedDate = DateTime.Now,
Type = "Insertion",
Message = "failed to insert user from " + this.CityName + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}