public string GetDailyActivity(DailyActivity dailyActivity)
{
string dA = null;
switch (dailyActivity)
{
case Models.DailyActivity.None:
dA = this.dailyActivity[0];
break;
case Models.DailyActivity.NoActivity:
dA = this.dailyActivity[1];
break;
case Models.DailyActivity.LightActivity:
dA = this.dailyActivity[2];
break;
case Models.DailyActivity.MediumActivity:
dA = this.dailyActivity[3];
break;
case Models.DailyActivity.HighActivity:
dA = this.dailyActivity[4];
break;
case Models.DailyActivity.ExtremeActivity:
dA = this.dailyActivity[5];
break;
}
return(dA);
}
public Result Update(DailyActivity model)
{
Result res = new Result(false);
try
{
DateTime TranDate = model.TranDate;
int SalesMgId = model.SalesMgId;
int CreatedBy = model.CreatedBy;
DateTime CreatedDate = DateTime.Now;
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"DELETE FROM DailyActivity WHERE SalesMgId=@SalesMgId AND TranDate=@TranDate";
connection.Execute(sql, model);
foreach (var item in model.DailyActivityItems)
{
sql = @"INSERT INTO DailyActivity
(TranDate,SalesMgId,DailyActivityDate,DailyActivityTime,DailyActivityCompany,DailyActivityContactNo,DailyActivityContactPerson,DailyActivityEmail,DailyActivityType,DailyActivityRemarks,CreatedBy,CreatedDate)
VALUES('" + TranDate + "'," + SalesMgId + ",@DailyActivityDate,@DailyActivityTime,@DailyActivityCompany,@DailyActivityContactNo,@DailyActivityContactPerson,@DailyActivityEmail,@DailyActivityType,@DailyActivityRemarks," + CreatedBy + ",'" + CreatedDate + "'); SELECT CAST(SCOPE_IDENTITY() as int);";
}
int id = connection.Execute(sql, model.DailyActivityItems);
if (id > 0)
{
return(new Result(true));
}
}
}
catch (Exception ex)
{
return(new Result(false, ex.InnerException == null ? ex.Message : ex.InnerException.Message));
}
return(res);
}
public void SetUserDailyActivity(int id, DailyActivity dailyActivity)
{
User user = FindUserById(id);
user.DailyActivity = dailyActivity;
SetUserData(id, user);
}
public bool AddDailyActivity(DailyActivity activityForAdd)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["KMDaycare"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("AddDailyActivity", con))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StartDatetime", activityForAdd.StartDateTime);
cmd.Parameters.AddWithValue("@EndDateTime", activityForAdd.EndDateTime);
cmd.Parameters.AddWithValue("@Notes", activityForAdd.Notes);
cmd.Parameters.AddWithValue("@DescriptionOfActivity", activityForAdd.DescriptionofActivity);
cmd.Parameters.AddWithValue("@ClassID", activityForAdd.ClassID);
con.Open();
SqlDataReader sqldr = cmd.ExecuteReader();
con.Close();
return(true);
}
catch
{
return(false);
}
}
}
}
public void OnClick(View v)
{
if (v.Tag != null)
{
DailyActivity.Start(context, v.Tag.ToString());
}
}
public DailyActivity ParseDailyActivity(string item)
{
DailyActivity activity = Models.DailyActivity.None;
int objectIndex = dailyActivity.FindIndex(i => i == item);
if (objectIndex > 0)
{
switch (objectIndex)
{
case 1:
activity = Models.DailyActivity.NoActivity;
break;
case 2:
activity = Models.DailyActivity.LightActivity;
break;
case 3:
activity = Models.DailyActivity.MediumActivity;
break;
case 4:
activity = Models.DailyActivity.HighActivity;
break;
case 5:
activity = Models.DailyActivity.ExtremeActivity;
break;
}
}
return(activity);
}
public async Task <ActionResult <DailyActivity> > PostDailyActivity(DailyActivity dailyActivity)
{
_context.DailyActivity.Add(dailyActivity);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDailyActivity", new { id = dailyActivity.DailyActivityId }, dailyActivity));
}
public User(int age, int weight, int height, DailyActivity dailyActivity)
{
Age = age;
Weight = weight;
Height = height;
DailyActivity = DailyActivity;
}
public void IgnoreAProcessEndedEventForAUnkownProcess()
{
Guid guid = Guid.NewGuid();
Guid guid2 = Guid.NewGuid();
Guid processType = ProcessGuids.ProcessA;
ProcessStarted worEvent = new ProcessStarted(guid, processType);
ProcessEnded worcEvent = new ProcessEnded(guid2, DateTime.UtcNow, false);
IRepository <DailyActivity> repo = GetRepositoryForTest();
DailyActivityEventProcessor processor = new DailyActivityEventProcessor(
repo
);
processor.Handle(worEvent);
processor.Handle(worcEvent);
DailyActivity activity = repo.Get(GetIdForFirstActivityPersisted(repo));
Assert.IsNotNull(activity);
Assert.AreEqual(1, activity.ActiveProcesses);
Assert.AreEqual(1, activity.TotalProcessCount);
Assert.AreEqual(0, activity.CompletionCount);
Assert.AreEqual(0, activity.CompletedWithErrorCount);
}
public IHttpActionResult Post([FromBody] DailyActivity entity)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
entity.UserID = this.GetUserID();
try
{
ServiceProvider.EntityContext.DailyActivity.Add(entity);
}
catch (DbUpdateException)
{
if (IsExists(entity.ActivityID))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(entity));
}
public async Task <IActionResult> PutDailyActivity(int id, DailyActivity dailyActivity)
{
if (id != dailyActivity.DailyActivityId)
{
return(BadRequest());
}
_context.Entry(dailyActivity).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DailyActivityExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Edit(DailyActivity entity)
{
using (var Context = GetContext())
{
Context.Entry(entity).State = EntityState.Modified;
Context.SaveChanges();
}
}
public void Add(DailyActivity entity)
{
using (var Context = GetContext())
{
Context.DailyActivities.Add(entity);
Context.SaveChanges();
}
}
public void CanCreateInstanceOfDailyActivity()
{
string id = DateTime.UtcNow.ToString("yyyy-MM-dd");
DailyActivity instance = new DailyActivity(id);
Assert.IsNotNull(instance);
Assert.IsInstanceOf <Entity>(instance);
}
public void Handle(ProcessStarted @event)
{
string id = DailyActivity.GetIdFrom(@event.CreatedAt);
DailyActivity activity = GetOrCreateActivityEntity(id);
//execute change / update
activity.AddProcess(@event.ProcessId, @event.CreatedAt);
//save - persist?
repository.Save(activity);
}
public IHttpActionResult Get(int id)
{
DailyActivity entety = ServiceProvider.EntityContext.DailyActivity.Get(id);
if (entety == null)
{
return(NotFound());
}
return(Ok(entety));
}
private DailyActivity GetOrCreateActivityEntity(string id)
{
DailyActivity activity = repository.Get(id);
if (activity == null)
{
activity = new DailyActivity(id);
repository.Save(activity);
}
return(activity);
}
public async Task <IActionResult> Create([Bind("DailyActivityId,DateStart,DateEnd,Act_typeId,StaffId,RowVersion")] DailyActivity dailyActivity)
{
if (ModelState.IsValid)
{
_context.Add(dailyActivity);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Act_typeId"] = new SelectList(_context.Act_Types, "Act_typeId", "ActivityName", dailyActivity.Act_typeId);
ViewData["StaffId"] = new SelectList(_context.Staffs, "StaffId", "FirstName", dailyActivity.StaffId);
return(View(dailyActivity));
}
public IHttpActionResult Delete([FromUri] int id)
{
DailyActivity entity = ServiceProvider.EntityContext.DailyActivity.Get(id);
if (entity == null || entity.UserID != this.GetUserID())
{
return(NotFound());
}
ServiceProvider.EntityContext.DailyActivity.Remove(entity);
return(Ok(entity));
}
public void Handle(ProcessEnded @event)
{
string id = DailyActivity.GetIdFrom(@event.CreatedAt);
DailyActivity activity = repository.Get(id); //should exist for this event
if (activity != null)
{
//execute change / update
activity.EndProcess(@event.ProcessId, @event.EndTime, @event.WithError);
//save - persist?
repository.Save(activity);
}
}
public void AddingAProcessIncrementsActiveCounter()
{
string id = DailyActivity.GetIdFrom(DateTime.UtcNow);
DailyActivity activity = new DailyActivity(id);
Guid processId = Guid.NewGuid();
DateTime startedAt = DateTime.UtcNow;
activity.AddProcess(processId, startedAt);
Assert.AreEqual(1, activity.ActiveProcesses);
Assert.AreEqual(1, activity.TotalProcessCount);
Assert.AreEqual(0, activity.CompletionCount);
Assert.AreEqual(0, activity.CompletedWithErrorCount);
}
public bool CreateActivity(DateTime startTime, DateTime endTime, string descriptionofactivity, string notes, int Classid)
{
DailyActivityTimes activityTimes = new DailyActivityTimes();
DailyActivity activityForAdd = new DailyActivity();
activityForAdd.StartDateTime = startTime;
activityForAdd.EndDateTime = endTime;
activityForAdd.DescriptionofActivity = descriptionofactivity;
activityForAdd.Notes = notes;
activityForAdd.ClassID = Classid;
bool success = activityTimes.AddDailyActivity(activityForAdd);
return(success);
}
public async Task <IActionResult> Delete(DailyActivity dailyActivity)
{
try
{
if (await _context.DailyActivities.AnyAsync(m => m.DailyActivityId == dailyActivity.DailyActivityId))
{
_context.DailyActivities.Remove(dailyActivity);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateConcurrencyException)
{
return(RedirectToAction(nameof(Delete), new { concurrencyError = true, id = dailyActivity.DailyActivityId }));
}
}
public ActionResult Edit(DailyActivity model)
{
if (!ModelState.IsValid)
{
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(View(model));
}
Result res = new DailyActivityRepository().Update(model);
if (res.Value)
{
TempData["Success"] = "Updated Successfully!";
}
else
{
}
return(RedirectToAction("Create"));
}
public ActionResult Create(DailyActivity Model)
{
Model.CreatedBy = UserID;
if (!ModelState.IsValid)
{
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(View(Model));
}
Result res = new DailyActivityRepository().Insert(Model);
if (res.Value)
{
TempData["Success"] = "Saved Successfully!";
}
else
{
}
return(RedirectToAction("Index"));
}
public void CompletingAnExistingProcessDecrementsActiveCounter_ErrorCountIsNotZero()
{
string id = DailyActivity.GetIdFrom(DateTime.UtcNow);
DailyActivity activity = new DailyActivity(id);
Guid processId = Guid.NewGuid();
DateTime startedAt = DateTime.UtcNow.AddSeconds(-10);
activity.AddProcess(processId, startedAt);
DateTime endedAt = DateTime.UtcNow;
activity.EndProcess(processId, endedAt, true);
Assert.AreEqual(0, activity.ActiveProcesses);
Assert.AreEqual(1, activity.TotalProcessCount);
Assert.AreEqual(1, activity.CompletionCount);
Assert.AreEqual(1, activity.CompletedWithErrorCount);
}
public ActionResult Create(DailyActivity daily)
{
try
{
daily.id = db.DailyActivities.OrderByDescending(x => x.id).FirstOrDefault().id + 1;
}
catch (Exception)
{
daily.id = 1;
}
if (ModelState.IsValid)
{
daily.Managerid = Convert.ToInt32(Session["ID"]);
daily.date = DateTime.Now.Date;
db.DailyActivities.Add(daily);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public void Remove(DailyActivity entity)
{
using (var Context = GetContext())
{
var dailyActivities = Context.DailyActivities.FirstOrDefault(c => c.ActivityID == entity.ActivityID);
if (dailyActivities != null)
{
try
{
Context.DailyActivities.Remove(dailyActivities);
Context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
}
public ActionResult AssignActivity(int DeptActivityId, int DeptId, int HeadId, int UserId)
{
if (DeptId > 0 && DeptActivityId > 0 && UserId > 0 && HeadId > 0)
{
DailyActivity dailyActivity = new DailyActivity();
dailyActivity.DeptActivityId = DeptActivityId;
dailyActivity.DeptId = DeptId;
dailyActivity.HeadId = HeadId;
dailyActivity.UserId = UserId;
dailyActivity.Parcent = 1;
db.DailyActivities.Add(dailyActivity);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index", "Home"));
}
private void Consume(PlayerActionResponse data)
{
var needSignal = false;
if (data.oddJobs != null)
{
needSignal = true;
if (OddJobs == null)
{
OddJobs = data.oddJobs;
}
else
{
foreach (var oddJob in data.oddJobs)
{
Update(oddJob);
}
}
}
if (data.oddJobDone != null)
{
needSignal = true;
var idx = OddJobs.FindIndex(o => o.id == data.oddJobDone);
if (idx >= 0)
{
OddJobs.RemoveAt(idx);
}
}
if (data.dailyActivity != null)
{
needSignal = true;
DailyActivity = data.dailyActivity;
}
if (needSignal)
{
signalBus.Fire <ActivitySignal>();
}
}
