public void AddNewRecord(string userID, int weekNumber, TimeEntry newEntry) { Connect(); Entity TEDetail = new Entity("gsc_timeentry"); //Get Entity of Staff Entity staff = GetStaff(service, userID); TEDetail.Attributes["gsc_userid"] = new EntityReference("systemuser", new Guid(userID)); TEDetail.Attributes["gsc_projectsoid"] = new EntityReference("salesorder", new Guid(newEntry.ProjectID)); TEDetail.Attributes["gsc_activitytypeid"] = new EntityReference("gsc_activity", new Guid(newEntry.ActivityTypeID)); TEDetail.Attributes["gsc_stafftypeid"] = new EntityReference("gsc_stafftype", new Guid(newEntry.StaffTypeID)); TEDetail.Attributes["gsc_practiceid"] = new EntityReference("gsc_practice", new Guid(newEntry.PracticeID)); TEDetail.Attributes["gsc_week"] = weekNumber; TEDetail.Attributes["gsc_businessunitid"] = staff.Attributes["businessunitid"]; TEDetail.Attributes["gsc_billability"] = newEntry.Billability; TEDetail.Attributes["gsc_onsite"] = newEntry.OnSite; TEDetail.Attributes["gsc_activitydescription"] = newEntry.Description; TEDetail.Attributes["gsc_monday"] = newEntry.MondayHours; TEDetail.Attributes["gsc_tuesday"] = newEntry.TuesdayHours; TEDetail.Attributes["gsc_wednesday"] = newEntry.WednesdayHours; TEDetail.Attributes["gsc_thursday"] = newEntry.ThursdayHours; TEDetail.Attributes["gsc_friday"] = newEntry.FridayHours; TEDetail.Attributes["gsc_saturday"] = newEntry.SaturdayHours; TEDetail.Attributes["gsc_sunday"] = newEntry.SundayHours; TEDetail.Attributes["gsc_totalentryhours"] = TotalWeekHours(newEntry); service.Create(TEDetail); }
public ActionResult Edit(TimeEntry entry, string tid) { /* Update Entry.. */ base.dbEntry.Update(entry, tid); return RedirectToAction("Index", new { notify = "true" }); }
public ActionResult Edit(TimeEntry entry, string tid) { /* * An ActionResult that process the updating of an entry */ base.dbEntry.Update(entry, tid, true); return RedirectToAction("Index", new { notify = "true" }); }
// A Method Helper that fills a Model protected TimeEntryViewModel FillViewModel(TimeEntry entry = null) { TimeEntryViewModel vm = new TimeEntryViewModel { Entries = dbEntry.FetchForUser(new Guid(User.Identity.Name), Session["week"].ToInteger()).ToList(), Entry = entry }; return vm; }
// Creates a Select list item <option></option> in html // and pre selects it before rendering in the view protected void SelectDropDowns(TimeEntry entry) { ViewBag.Project = new SelectList(dbProject.FetchAll(), "ProjectID", "ProjectName", entry.ProjectID); ViewBag.Activity = new SelectList(dbActivity.FetchAll(), "ActivityTypeID", "ActivityTypeName", entry.ActivityTypeID); ViewBag.StaffType = new SelectList(dbStaff.FetchAll(), "StaffTypeID", "StaffTypeName", entry.StaffTypeID); ViewBag.Practice = new SelectList(dbPractice.FetchAll(), "PracticeID", "PracticeName", entry.PracticeID); }
private decimal? TotalWeekHours(TimeEntry entry) { return entry.MondayHours + entry.TuesdayHours + entry.WednesdayHours + entry.ThursdayHours + entry.FridayHours + entry.SaturdayHours + entry.SundayHours; }
private TimeEntry FetchSetter(TimeEntry entry, Entity rd) { entry.ID = rd["gsc_timeentryid"].ToString(); entry.ProjectID = ((AliasedValue)rd["Project.name"]).Value.ToString(); entry.ActivityTypeID = ((AliasedValue)rd["ActivityType.gsc_name"]).Value.ToString(); entry.StaffTypeID = ((AliasedValue)rd["StaffType.gsc_name"]).Value.ToString(); entry.PracticeID = ((AliasedValue)rd["Practice.gsc_name"]).Value.ToString(); entry.Description = rd["gsc_activitydescription"].ToString(); entry.Billability = Convert.ToBoolean(rd["gsc_billability"]); entry.OnSite = Convert.ToBoolean(rd["gsc_onsite"]); entry.MondayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_monday"])); entry.TuesdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_tuesday"])); entry.WednesdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_wednesday"])); entry.ThursdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_thursday"])); entry.FridayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_friday"])); entry.SaturdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_saturday"])); entry.SundayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_sunday"])); entry.TotalWeekHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_totalentryhours"])); entry.isValidBillability = Convert.ToBoolean(rd["gsc_isvalidbillability"]); entry.isValidInfo = Convert.ToBoolean(rd["gsc_isvalidinfo"]); //entry.EntryRemarks = GetNotesForEntry(entry.ID); //-- Get User Reference Guid userID = ((EntityReference)rd["gsc_userid"]).Id; entry.StaffFullname = this.dbUser.GetFullNameForUser(userID).Fullname; entry.EntryRemarks = this.dbAnnotation.GetNotesForEntry(entry.ID); return entry; }
public void Update(TimeEntry entry, string detailID, bool isTimekeeper = false) { Connect(); Entity TEDetail = getTimeEntryDetailEntityId(service, new Guid(detailID)); TEDetail.Attributes["gsc_projectsoid"] = new EntityReference("salesorder", new Guid(entry.ProjectID)); TEDetail.Attributes["gsc_activitytypeid"] = new EntityReference("gsc_activity", new Guid(entry.ActivityTypeID)); TEDetail.Attributes["gsc_stafftypeid"] = new EntityReference("gsc_stafftype", new Guid(entry.StaffTypeID)); TEDetail.Attributes["gsc_practiceid"] = new EntityReference("gsc_practice", new Guid(entry.PracticeID)); TEDetail.Attributes["gsc_onsite"] = entry.OnSite; TEDetail.Attributes["gsc_activitydescription"] = entry.Description; TEDetail.Attributes["gsc_monday"] = entry.MondayHours.ToDecimal(); TEDetail.Attributes["gsc_tuesday"] = entry.TuesdayHours.ToDecimal(); TEDetail.Attributes["gsc_wednesday"] = entry.WednesdayHours.ToDecimal(); TEDetail.Attributes["gsc_thursday"] = entry.ThursdayHours.ToDecimal(); TEDetail.Attributes["gsc_friday"] = entry.FridayHours.ToDecimal(); TEDetail.Attributes["gsc_saturday"] = entry.SaturdayHours.ToDecimal(); TEDetail.Attributes["gsc_sunday"] = entry.SundayHours.ToDecimal(); TEDetail.Attributes["gsc_totalentryhours"] = TotalWeekHours(entry).ToDecimal(); TEDetail.Attributes["gsc_isvalidinfo"] = true; if (isTimekeeper == true) { TEDetail.Attributes["gsc_isvalidbillability"] = true; TEDetail.Attributes["gsc_billability"] = entry.Billability; } service.Update(TEDetail); }
public TimeEntry FetchRecordDetails(Guid recordID) { Connect(); QueryExpression qe = LinkEntities(); qe.Criteria = new FilterExpression(); qe.Criteria.AddCondition("gsc_timeentryid", ConditionOperator.Equal, recordID); EntityCollection ec = service.RetrieveMultiple(qe); TimeEntry entry = new TimeEntry(); foreach (Entity rd in ec.Entities) { entry.ID = rd["gsc_timeentryid"].ToString(); entry.ProjectID = ((AliasedValue)rd["Project.salesorderid"]).Value.ToString(); entry.ActivityTypeID = ((AliasedValue)rd["ActivityType.gsc_activityid"]).Value.ToString(); entry.StaffTypeID = ((AliasedValue)rd["StaffType.gsc_stafftypeid"]).Value.ToString(); entry.PracticeID = ((AliasedValue)rd["Practice.gsc_practiceid"]).Value.ToString(); entry.Description = rd["gsc_activitydescription"].ToString(); entry.Billability = Convert.ToBoolean(rd["gsc_billability"]); entry.OnSite = Convert.ToBoolean(rd["gsc_onsite"]); entry.MondayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_monday"])); entry.TuesdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_tuesday"])); entry.WednesdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_wednesday"])); entry.ThursdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_thursday"])); entry.FridayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_friday"])); entry.SaturdayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_saturday"])); entry.SundayHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_sunday"])); entry.TotalWeekHours = Convert.ToDecimal(string.Format("{0:0.00}", rd["gsc_totalentryhours"])); entry.EntryRemarks = this.dbAnnotation.GetNotesForEntry(entry.ID); entry.isValidBillability = Convert.ToBoolean(rd["gsc_isvalidbillability"]); entry.isValidInfo = Convert.ToBoolean(rd["gsc_isvalidinfo"]); //-- Get User Reference Guid userID = ((EntityReference)rd["gsc_userid"]).Id; entry.StaffFullname = this.dbUser.GetFullNameForUser(userID).Fullname; return entry; } return entry; }
public IQueryable<TimeEntry> FetchPartialDetails(List<string> projectIDs, int? weekNumber, string searchText = null) { Connect(); QueryExpression qe = LinkEntities(); qe = ConditionHelper(qe, "gsc_projectsoid", projectIDs); if (weekNumber != null) { qe.Criteria = new FilterExpression(); qe.Criteria.AddCondition("gsc_week", ConditionOperator.Equal, weekNumber); } EntityCollection ec = service.RetrieveMultiple(qe); List<TimeEntry> entries = new List<TimeEntry>(); foreach (Entity rd in ec.Entities) { TimeEntry entry = new TimeEntry(); entries.Add(FetchSetter(entry, rd)); } var Iqueryable = entries.AsQueryable(); return Iqueryable; }
public TimeEntry ExtractFormCollection(FormCollection formData) { TimeEntry newEntry = new TimeEntry(); newEntry.ProjectID = formData["Entry.ProjectID"]; newEntry.ActivityTypeID = formData["Entry.ActivityTypeID"]; newEntry.StaffTypeID = formData["Entry.StaffTypeID"]; newEntry.PracticeID = formData["Entry.PracticeID"]; newEntry.Billability = formData["Entry.Billability"].CbxToBoolean(); newEntry.OnSite = formData["Entry.OnSite"].CbxToBoolean(); newEntry.Description = formData["Entry.Description"]; // ------------ newEntry.MondayHours = formData["Entry.MondayHours"].ToDecimal(); newEntry.TuesdayHours = formData["Entry.TuesdayHours"].ToDecimal(); newEntry.WednesdayHours = formData["Entry.WednesdayHours"].ToDecimal(); newEntry.ThursdayHours = formData["Entry.ThursdayHours"].ToDecimal(); newEntry.FridayHours = formData["Entry.FridayHours"].ToDecimal(); newEntry.SaturdayHours = formData["Entry.SaturdayHours"].ToDecimal(); newEntry.SundayHours = formData["Entry.SundayHours"].ToDecimal(); newEntry.TotalWeekHours = TotalWeekHours(newEntry); return newEntry; }