public string Load(string lang)
{
try {
List <NewActivity> xx = new List <NewActivity>();
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase))) {
connection.Open();
string sql = @"SELECT rowid, activity, factorKcal, isSport FROM activities ORDER BY activity ASC";
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
string[] translations = T.Translations(lang);
using (SQLiteDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
NewActivity x = new NewActivity()
{
id = reader.GetValue(0) == DBNull.Value ? 0 : reader.GetInt32(0),
activity = reader.GetValue(1) == DBNull.Value ? "" : T.Tran(reader.GetString(1), translations, string.IsNullOrEmpty(lang) ? "hr" : lang),
factorKcal = reader.GetValue(2) == DBNull.Value ? 0.0 : Convert.ToDouble(reader.GetString(2)),
isSport = reader.GetValue(3) == DBNull.Value ? 0 : reader.GetInt32(3)
};
xx.Add(x);
}
}
}
connection.Close();
}
return(JsonConvert.SerializeObject(xx, Formatting.None));
} catch (Exception e) { return(JsonConvert.SerializeObject(e.Message, Formatting.None)); }
}
public ActionResult CreateActivity(int ID)
{
NewActivity model = new NewActivity();
model.Pacient = PacientServices.ClassObject.GetPacient(ID);
return(PartialView(model));
}
public IActionResult NewActivity(NewActivity form)
{
if (!IsUserInSession())
{
return(RedirectToAction("Index", "User"));
}
System.Console.WriteLine(form.Duration);
System.Console.WriteLine(form.ActivityTime);
System.Console.WriteLine(form.ActivityDate);
System.Console.WriteLine(form.Duration == 0);
if (form.Duration == 0)
{
ModelState.AddModelError("Duration", "Invalid User");
return(View("NewActivity"));
}
// if(ModelState.IsValid){
// int? UserID = HttpContext.Session.GetInt32("UserID");
// DojoActivity activity = new DojoActivity(form);
// activity.CreatedBy = (int)UserID;
// User user = dbContext.Users.FirstOrDefault(u => u.UserId == UserID);
// activity.User = user;
// dbContext.Add(activity);
// dbContext.SaveChanges();
// return RedirectToAction("GetActivities");
// }
return(View("NewActivity"));
}
public IActionResult NewActivity(NewActivity addActivity)
{
int UserId = Loginuser.GetUserID(HttpContext);
if (UserId == 0)
{
ViewBag.message = " Session time out. Need Register or login first!";
return(View("Warning"));
}
if (!ModelState.IsValid)
{
return(View("NewActivity"));
}
DateTime startTime = addActivity.GetStartTime();
DateTime now = DateTime.Now;
if (DateTime.Compare(startTime, now) < 0)
{
ModelState.AddModelError("StartDate", "The Activity must be start in the future!");
return(View("NewActivity"));
}
Activity NewActivity = GetNewActivity(addActivity);
dbContext.Activitys.Add(NewActivity);
dbContext.SaveChanges();
return(Redirect("/dashboard"));
}
public IActionResult delete(int actid)
{
NewActivity a = dbContext.NewActivitys.FirstOrDefault(web => web.ActivityId == actid);
dbContext.Remove(a);
dbContext.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public ActionResult CreateActivity(NewActivity model)
{
var newActivity = new ActivityJournal();
newActivity.IDPacient = model.IDPacient;
newActivity.Data = model.Data;
newActivity.Activitate = model.Activitate;
DoctorServices.ClassObject.SaveActivity(newActivity);
return(RedirectToAction("PacientsTable"));
}
public string Init()
{
NewActivity x = new NewActivity();
x.id = 0;
x.activity = "";
x.factorKcal = 0.0;
x.isSport = 1;
string json = JsonConvert.SerializeObject(x, Formatting.None);
return(json);
}
public void PostsToTheCorrectUrl()
{
var connection = Substitute.For <IApiConnection>();
var client = new ActivitiesClient(connection);
var newActivity = new NewActivity("subject", "type");
client.Create(newActivity);
connection.Received().Post <Activity>(Arg.Is <Uri>(u => u.ToString() == "activities"),
Arg.Is <NewActivity>(nc => nc.Subject == "subject" &&
nc.Type == "type"));
}
public Activity GetNewActivity(NewActivity addActivity)
{
Activity NewActivity = new Activity();
NewActivity.Title = addActivity.Title;
NewActivity.Description = addActivity.Description;
NewActivity.Duration = addActivity.Duration;
NewActivity.DurationInc = addActivity.DurationInc;
NewActivity.StartTime = addActivity.GetStartTime();
NewActivity.EndTime = addActivity.GetEndTime(NewActivity.StartTime);
NewActivity.UserId = Loginuser.GetUserID(HttpContext);
return(NewActivity);
}
public IActionResult DetailAct(int id)
{
NewActivity a = dbContext.NewActivitys
.FirstOrDefault(pro => pro.ActivityId == id);
ViewBag.ActDetail = a;
NewActivity getnewact = dbContext.NewActivitys.Include(c => c.ActtoUser).ThenInclude(b => b.User).FirstOrDefault(c => c.ActivityId == id);
ViewBag.act = getnewact;
ViewBag.Userid = HttpContext.Session.GetInt32("UserID");
int num = getnewact.UserId;
ViewBag.theuser = dbContext.Users.SingleOrDefault(u => u.UserId == num);
return(View("ActivityDetail"));
}
public async Task <IActionResult> CreateAsync([FromBody] NewActivity newActivity)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var successful = await _activityService.AddActivityAsync(newActivity);
if (!successful)
{
return(BadRequest(new { error = "Could not add item." }));
}
return(Ok(successful));
}
private async Task <int> SaveActivity(NewActivity newActivity)
{
var entity = new Activity
{
Title = newActivity.Title,
Description = newActivity.Description,
DateTime = newActivity.DateTime,
Location = newActivity.Location,
ActivityTypeCode = newActivity.ActivityTypeCode,
DepartmentCode = newActivity.DepartmentCode
};
_context.Activities.Add(entity);
var result = await _context.SaveChangesAsync();
return(entity.ActivityId);
}
public async Task CanCreate()
{
var pipedrive = Helper.GetAuthenticatedClient();
var fixture = pipedrive.Activity;
var newActivity = new NewActivity("new-subject", "call");
var activity = await fixture.Create(newActivity);
Assert.NotNull(activity);
var retrieved = await fixture.Get(activity.Id);
Assert.NotNull(retrieved);
// Cleanup
await fixture.Delete(activity.Id);
}
public async Task CanDelete()
{
var pipedrive = Helper.GetAuthenticatedClient();
var fixture = pipedrive.Activity;
var newActivity = new NewActivity("new-subject", "email");
var activity = await fixture.Create(newActivity);
var createdActivity = await fixture.Get(activity.Id);
Assert.NotNull(createdActivity);
await fixture.Delete(createdActivity.Id);
var deletedActivity = await fixture.Get(createdActivity.Id);
Assert.False(deletedActivity.ActiveFlag);
}
public async Task CanCreate()
{
var pipedrive = Helper.GetAuthenticatedClient();
var fixture = pipedrive.Activity;
var newActivity = new NewActivity("new-subject", "call");
newActivity.DueDate = DateTime.UtcNow.AddDays(2);
var activity = await fixture.Create(newActivity);
Assert.NotNull(activity);
var retrieved = await fixture.Get(activity.Id);
Assert.NotNull(retrieved);
Assert.Equal(DateTime.UtcNow.Date.AddDays(2), retrieved.DueDate.Value.Date);
// Cleanup
await fixture.Delete(activity.Id);
}
public async Task <bool> AddActivityAsync(NewActivity newActivity)
{
bool result = false;
int actId = 0;
using (var transaction = _context.Database.BeginTransaction())
{
try
{
actId = await SaveActivity(newActivity);
result = await SaveActAttendance(newActivity.NewAcitivityAttendances, actId);
transaction.Commit();
}
catch (Exception)
{
}
}
return(result && actId != 0);
}
public async Task CanEdit()
{
var pipedrive = Helper.GetAuthenticatedClient();
var fixture = pipedrive.Activity;
var newActivity = new NewActivity("new-subject", "meeting");
var activity = await fixture.Create(newActivity);
var editActivity = activity.ToUpdate();
editActivity.Subject = "updated-subject";
editActivity.Type = "lunch";
var updatedActivity = await fixture.Edit(activity.Id, editActivity);
Assert.Equal("updated-subject", updatedActivity.Subject);
Assert.Equal("lunch", updatedActivity.Type);
// Cleanup
await fixture.Delete(updatedActivity.Id);
}
public IActionResult btAddAct(NewActivity newAct)
{
Console.WriteLine("//abbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbsssssss");
Console.WriteLine(newAct.Title);
Console.WriteLine(newAct.Time);
Console.WriteLine(newAct.ActDate);
Console.WriteLine(newAct.Duration);
Console.WriteLine(newAct.Description);
Console.WriteLine(newAct.UserId);
if (ModelState.IsValid)
{
if (Request.Form["dura"] == "minutes")
{
newAct.Duration = newAct.Duration;
}
if (Request.Form["dura"] == "hours")
{
newAct.Duration = newAct.Duration * 60;
}
if (Request.Form["dura"] == "days")
{
newAct.Duration = newAct.Duration * 1440;
}
newAct.Created_at = DateTime.Now;
newAct.Updated_at = DateTime.Now;
Console.WriteLine("///////////////////////////////////////////////////////");
dbContext.Add(newAct);
dbContext.SaveChanges();
//return RedirectToAction("DetailAct", new { id = newAct.ActivityId });
return(RedirectToAction("Dashboard"));
}
else
{
Console.WriteLine("//aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasssssssssssssssssssss");
return(View("Newactivity"));
}
}
public IActionResult btAddAct(NewActivity newAct)
{
Console.WriteLine("<============== Activity Submitted (Start) ============>");
Console.WriteLine(newAct.Title);
Console.WriteLine(newAct.Time);
Console.WriteLine(newAct.ActivityDate);
Console.WriteLine(newAct.Duration);
Console.WriteLine(newAct.Description);
Console.WriteLine(newAct.UserId);
Console.WriteLine("<============== Activity Submitted (End) ============>");
if (ModelState.IsValid)
{
if (Request.Form["dura"] == "minutes")
{
newAct.Duration = newAct.Duration;
}
if (Request.Form["dura"] == "hours")
{
newAct.Duration = newAct.Duration * 60;
}
if (Request.Form["dura"] == "days")
{
newAct.Duration = newAct.Duration * 1440;
}
newAct.Created_at = DateTime.Now;
newAct.Updated_at = DateTime.Now;
Console.WriteLine("<--------- BUTTON MASH 2 ----------->");
dbContext.Add(newAct);
dbContext.SaveChanges();
return(RedirectToAction("Dashboard"));
}
else
{
Console.WriteLine("<--------- BUTTON MASH 3 -----------> ");
return(View("NewActivity"));
}
}
public IActionResult joinact(int actid, int userid)
{
NewActivity newAct = dbContext.NewActivitys.Include(c => c.ActtoUser).ThenInclude(b => b.User).FirstOrDefault(wed => wed.ActivityId == actid);
User newUser = dbContext.Users.Include(c => c.UsertoAct).ThenInclude(b => b.Activity).FirstOrDefault(us => us.UserId == userid);
foreach (var thisact in newUser.UsertoAct)
{
if (thisact.Activity.ActDate.Date == newAct.ActDate.Date)
{
ModelState.AddModelError("ActDate", "You have already planned on going to another activity on that day already! Please UN-RSVP to the previous event to RSVP to this one!");
ViewBag.samedayrs = "You have already planned on going to another activity on that day already! Please UN-RSVP to the previous event to RSVP to this one!";
return(RedirectToAction("Dashboard"));
}
}
ActConnect acjoin = new ActConnect();
acjoin.ActivityId = actid;
acjoin.UserId = userid;
dbContext.Add(acjoin);
dbContext.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public IActionResult joinact(int actid, int userid)
{
NewActivity newAct = dbContext.NewActivitys.Include(c => c.ActtoUser).ThenInclude(b => b.User).FirstOrDefault(wed => wed.ActivityId == actid);
User newUser = dbContext.Users.Include(c => c.UsertoAct).ThenInclude(b => b.Activity).FirstOrDefault(us => us.UserId == userid);
foreach (var currentactivity in newUser.UsertoAct)
{
if (currentactivity.Activity.ActivityDate.Date == newAct.ActivityDate.Date)
{
ModelState.AddModelError("ActivityDate", "You gotta pick 1 activity at a time bro.");
ViewBag.samedayrs = "You only can attend 1 event";
return(RedirectToAction("Dashboard"));
}
}
ActConnect acjoin = new ActConnect();
acjoin.ActivityId = actid;
acjoin.UserId = userid;
dbContext.Add(acjoin);
dbContext.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public IActionResult joinact(int actid, int userid)
{
NewActivity newAct = dbContext.NewActivitys.Include(c => c.ActtoUser).ThenInclude(b => b.User).FirstOrDefault(wed => wed.ActivityId == actid);
User newUser = dbContext.Users.Include(c => c.UsertoAct).ThenInclude(b => b.Activity).FirstOrDefault(us => us.UserId == userid);
foreach (var thisact in newUser.UsertoAct)
{
if (thisact.Activity.ActDate.Date == newAct.ActDate.Date)
{
ModelState.AddModelError("ActDate", "Sorry Homie one activity at once");
ViewBag.samedayrs = "You cant join two at the same time!!";
return(RedirectToAction("Dashboard"));
}
}
ActConnect acjoin = new ActConnect();
acjoin.ActivityId = actid;
acjoin.UserId = userid;
dbContext.Add(acjoin);
dbContext.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public IActionResult Create(NewActivity model)
{
if (HttpContext.Session.GetInt32("UserId") != null)
{
if (dbContext.users.Any(u => u.UsersId == (int)HttpContext.Session.GetInt32("UserId")))
{
if (ModelState.IsValid)
{
if (DateTime.Compare(model.Date.Date.Add(model.Time.TimeOfDay), DateTime.Now) > 0)
{
if (!dbContext.activities.Any(a => a.Title == model.Title && a.CreatorId == (int)HttpContext.Session.GetInt32("UserID") && a.DateTime == model.Date.Date.Add(model.Time.TimeOfDay)))
{
Activities new_activity = new Activities
{
Title = model.Title,
DateTime = model.Date.Date.Add(model.Time.TimeOfDay),
Duration = model.Duration,
DurationUnit = model.DurationUnit,
Description = model.Description,
CreatorId = (int)HttpContext.Session.GetInt32("UserId"),
};
dbContext.Add(new_activity);
dbContext.SaveChanges();
int activityid = dbContext.activities.FirstOrDefault(a => a.Title == model.Title).ActivitiesId;
return(RedirectToAction("Activity", new { activity_id = activityid }));
}
ModelState.AddModelError("Title", "This activity already exists");
}
ModelState.AddModelError("Date", "This date and time have already passed.");
}
return(View("New", model));
}
return(RedirectToAction("Logout", "LoginReg"));
}
return(RedirectToAction("LoginReg", "LoginReg"));
}
private void MessengerMessageReceived(NewActivityRequest message)
{
_log.Info("New Activity: " + message.ActivityType);
NewActivity?.Invoke(_creator[message.ActivityType.ID].Invoke());
}
public IActionResult AddActivity(NewActivity newActivity)
{
if (HttpContext.Session.GetInt32("id") == null)
{
return(RedirectToAction("Index", "User"));
}
// insert part 1 here
// part 1 begin
var ParticipatingActivities = mycontext.Participate.Where(p => p.UserId == ActiveUser.UserId).Select(u => u.ParticipatingActivities).ToList();
foreach (var activity in ParticipatingActivities)
{
Console.WriteLine(activity.Date);
DateTime start_date = activity.Date;
DateTime end_date = start_date.AddMinutes((double)activity.Duration);
Console.WriteLine(end_date);
DateTime activity_date = newActivity.Date;
DateTime activity_end_date = activity_date.AddMinutes((double)newActivity.Duration);
// if(activity_date < start_date && activity_end_date < start_date)
// {
// newActivity.Date = newActivity.Date;
// newActivity.Duration = newActivity.Duration;
// }
// else if (activity_date > start_date && activity_date > end_date )
// {
// newActivity.Date = newActivity.Date;
// newActivity.Duration = newActivity.Duration;
// }
// else
// {
// ModelState.AddModelError("Date", "Activity conflicts with another activity");
// }
}
var CreatedActivities = mycontext.Activities.Where(u => u.UserId == ActiveUser.UserId).Include(a => a.Coordinator).ToList();
foreach (var activity in CreatedActivities)
{
DateTime start_date = activity.Date;
DateTime end_date = start_date.AddMinutes((double)activity.Duration);
Console.WriteLine(end_date);
DateTime activity_date = newActivity.Date;
DateTime activity_end_date = activity_date.AddMinutes((double)newActivity.Duration);
// if(activity_date < start_date && activity_end_date < start_date)
// {
// newActivity.Date = newActivity.Date;
// newActivity.Duration = newActivity.Duration;
// }
// else if (activity_date > start_date && activity_date > end_date )
// {
// newActivity.Date = newActivity.Date;
// newActivity.Duration = newActivity.Duration;
// }
// else
// {
// ModelState.AddModelError("Date", "Activity conflicts with another activity");
// }
}
if (Request.Form["dur"] == "minutes")
{
newActivity.Duration = newActivity.Duration;
}
if (Request.Form["dur"] == "hours")
{
newActivity.Duration = newActivity.Duration * 60;
}
if (Request.Form["dur"] == "days")
{
newActivity.Duration = newActivity.Duration * 1440;
}
// end part 1
if (ModelState.IsValid)
{
Activity theActivity = new Activity()
{
Title = newActivity.Title,
Date = newActivity.Date,
Time = newActivity.Time,
Duration = newActivity.Duration,
Description = newActivity.Description,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
UserId = ActiveUser.UserId,
};
mycontext.Add(theActivity);
mycontext.SaveChanges();
Activity currentActivity = mycontext.Activities.Where(a => a.UserId == ActiveUser.UserId).Last();
int currentActivityId = currentActivity.ActivityId;
return(Redirect($"ActivityDetails/{currentActivityId}"));
}
return(View("NewActivity"));
}
