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 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 void SetSentDate(string email)
{
using (var context = new SurveyDataContext())
{
var found = context.EmailData.Where(x => x.EmailAddress == email).FirstOrDefault();
if (found != null)
{
found.SentDate = DateTime.Today;
context.SaveChanges();
}
}
}
public void SetStatus(string email)
{
using (var context = new SurveyDataContext())
{
var found = context.EmailData.Where(x => x.EmailAddress == email).FirstOrDefault();
if (found != null)
{
found.IsViewed = true;
context.SaveChanges();
}
}
}
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 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));
}
}
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 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));
}
}
//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 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 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 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));
}
}
public ActionResult AddLog(LogViewModel item)
{
try
{
Log i = item.ToModel();
i.CreatedDate = DateTime.Now;
db.Logs.Add(i);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
catch
{
return(new HttpStatusCodeResult(400));
}
}
public ActionResult AddSurveyType(SurveyTypeViewModel item)
{
try
{
SurveyType c = item.ToModel();
c.Surveys = item.GetSurveyList(item.Surveys);
c.CreatedDate = DateTime.Now;
db.SurveyTypes.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 survey type " + this.Type + " to database"
};
l.AddLog(l);
return(new HttpStatusCodeResult(400));
}
}
public IActionResult GenerateSurveys(int n)
{
//return View(Models.Survey.GetAll());
Random r = new Random();
for (int i = 0; i < n; i++)
{
var survey = new Survey {
Email = "[email protected]", Age = 22, Comments = "Idea Center Rocks!", Gender = r.Next(0, 2), Program = "WebDev",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
for (int i = 0; i < n; i++)
{
var survey = new Survey
{
Email = "[email protected]",
Age = 22,
Comments = "Idea Center Rocks!",
Gender = r.Next(0, 2),
Program = "Design for Miami",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
for (int i = 0; i < n; i++)
{
var survey = new Survey
{
Email = "[email protected]",
Age = 22,
Comments = "Idea Center Rocks!",
Gender = r.Next(0, 2),
Program = "CS50x Miami",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
for (int i = 0; i < n; i++)
{
var survey = new Survey
{
Email = "[email protected]",
Age = 22,
Comments = "Idea Center Rocks!",
Gender = r.Next(0, 2),
Program = "MarketHack",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
for (int i = 0; i < n; i++)
{
var survey = new Survey
{
Email = "[email protected]",
Age = 22,
Comments = "Idea Center Rocks!",
Gender = r.Next(0, 2),
Program = "Make1",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
for (int i = 0; i < n; i++)
{
var survey = new Survey
{
Email = "[email protected]",
Age = 22,
Comments = "Idea Center Rocks!",
Gender = r.Next(0, 2),
Program = "Innovation M",
Responses0 = r.Next(0, 2),
Responses1 = r.Next(0, 2),
Responses2 = r.Next(0, 2),
Responses3 = r.Next(0, 2),
Responses4 = r.Next(0, 2),
Responses5 = r.Next(0, 2),
Responses6 = r.Next(0, 2),
Responses7 = r.Next(0, 2),
Responses8 = r.Next(0, 2),
Responses9 = r.Next(0, 2),
};
_context.Add(survey);
}
_context.SaveChanges();
return(View("ViewSurveys", _context.Surveys));
}
