public async Task <FileResult> Report(int Id) { try { this._logger.Information($"Start {nameof(Report)} Id = {Id}"); ISession session = _services.GetRequiredService <IHttpContextAccessor>()?.HttpContext.Session; SessionLogIn ses = session.GetJson <SessionLogIn>("ses"); Employee employee = await _plinovodiDutyDataRead.GetEmployee(ses.EmployeeId); Duty duty = await _plinovodiDutyDataRead.GetDuty(Id); IEnumerable <Intervention> interventionList = await _plinovodiDutyDataRead.GetInterventions(Id); var stream = PlinovodiDezurstvaUtils.GenerateReport(employee, duty, interventionList); Response.Headers.Append("content-disposition", "inline; filename=file.pdf"); this._logger.Information($"End {nameof(Report)}"); return(File(stream.ToArray(), "application/pdf", $"{employee.Name}{employee.Surname}{duty.From.ToString("d.M.yy")}.pdf")); } catch (Exception ex) { this._logger.Error($"Error {nameof(Report)} {ex.Message} {ex.StackTrace}"); throw ex; } }
private void buttonRemoveDuty_Click(object sender, EventArgs e) { if (!_currentEmployee.IsAdmin()) { return; } if (dutyList.SelectedItems.Count == 0) { MessageBox.Show( "You have not selected any duty to delete!", "Something went wrong...", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } Duty duty = HospitalStructure.Duties[int.Parse(dutyList.SelectedItems[0].Tag.ToString())]; Employee user = HospitalStructure.Employees .Where(em => em.Id == duty.EmployeeId) .FirstOrDefault(); if (MessageBox.Show( $"Are you sure that you want delete duty of {user.Name} {user.Surname}. Date: {duty.Date.ToShortDateString()}?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { HospitalStructure.Duties.Remove(duty); loadDuties(); } }
public Result <bool> AddDuty(Duty duty) { Result <bool> rlt = new Result <bool>(); try { var old = Db.Duties.FirstOrDefault(p => p.Code == duty.Code); if (old != null) { rlt.HasError = true; rlt.Msg = "职务编码重复!"; } else { Db.Duties.Add(duty); Db.SaveChanges(); } } catch (Exception ex) { LogUtil.WriteLog(ex); rlt.HasError = true; rlt.Msg = ex.Message; } return(rlt); }
public async Task <IActionResult> Create(CreateViewModel model) { var user = await GetCurrentUser(); if (ModelState.IsValid) { var subject = await _subjectManager.GetSubjectAsync(model.Subject); var duty = new Duty() { ClassRoomId = user.ClassRoomId, ForDate = model.ForDate, Content = model.Content, Color = model.Color, Subject = subject, UserId = user.Id }; if (await _dutyManager.CreateAsync(duty)) { await Push(user, duty, "Un devoir a été ajouté sur l'agenda.", new List <EmbedFieldBuilder>()); } return(RedirectToAction("Index")); } ViewBag.Subjects = await _subjectManager.ToListAsync(user.ClassRoomId); return(View(model)); }
public async Task <RedirectToActionResult> LogIn(int employeeId, int dutyId) { try { this._logger.Information($"Start {nameof(LogIn)} employeeId = {employeeId} dutyId = {dutyId}"); Duty duty = await _plinovodiDutyDataRead.GetDuty(dutyId); ISession session = _services.GetRequiredService <IHttpContextAccessor>()?.HttpContext.Session; SessionLogIn ses = new SessionLogIn(); ses.EmployeeId = employeeId; ses.DutyId = dutyId; DateTime day = duty.From; ses.DaysOfDuty.Add(day); for (int i = 0; i < 7; i++) { day = day.AddDays(1); ses.DaysOfDuty.Add(day); } session.SetJson("ses", ses); this._logger.Information($"End {nameof(LogIn)}"); return(RedirectToAction("Index", "Duty")); } catch (Exception ex) { this._logger.Error($"Error {nameof(LogIn)} {ex.Message} {ex.StackTrace}"); throw ex; } }
public async Task <IActionResult> Edit(int id, [Bind("Id,EmployeeId,DutyDate")] Duty duty) { if (id != duty.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(duty); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DutyExists(duty.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(duty)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="sql"></param> public bool Update(Duty model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DutyID", model.DutyID)); parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode))); parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName))); parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode))); parameters.Add(new QfParameter("Array", model.Array)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string setStr = ""; foreach (var item in parameters) { if (item.Value != null && ValueConvert.ToString(item.Value) != "''") { setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value); } } setStr = setStr.Substring(0, setStr.LastIndexOf(",")); string sql = string.Format("update t_duty set {0} where DutyID = {1}", setStr, model.DutyID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public static void AddDuty(Duty duty) { if (!DutyExist(duty)) { duties.Add(duty); } }
public async Task ExpireDuty() { var locationId = await CreateLocation(); var startDate = DateTimeOffset.UtcNow.AddYears(5); var addDuty = new Duty { Id = 1, StartDate = startDate, EndDate = startDate.AddDays(5), LocationId = locationId }; await Db.Duty.AddAsync(addDuty); await Db.SaveChangesAsync(); HttpResponseTest.CheckForNoContentResponse(await _controller.ExpireDuties(new List <int> { 1 })); var controllerResult = await _controller.GetDuties(locationId, startDate, startDate.AddDays(1)); var getDuties = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult); Assert.Empty(getDuties); }
public async Task GetDuties() { var locationId = await CreateLocation(); var startDate = DateTimeOffset.UtcNow; var addDuty = new Duty { Id = 1, StartDate = startDate, EndDate = startDate.AddDays(5), LocationId = locationId }; var addDutyExpiryDate = new Duty { Id = 2, StartDate = startDate, EndDate = startDate.AddDays(5), ExpiryDate = startDate, LocationId = locationId }; await Db.Duty.AddAsync(addDuty); await Db.Duty.AddAsync(addDutyExpiryDate); await Db.SaveChangesAsync(); var controllerResult = await _controller.GetDuties(locationId, startDate, startDate.AddDays(1)); var response = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult); Assert.Single(response); Assert.Equal(1, response.First().Id); }
public async Task <IActionResult> Edit(int id, [Bind("DutyID,ExperienceID,Priority,Description")] Duty duty) { if (id != duty.DutyID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(duty); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DutyExists(duty.DutyID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index), "Duties", new { id = duty.ExperienceID })); } ViewData["ExperienceID"] = new SelectList(_context.Experiences, "ExperienceID", "ExperienceID", duty.ExperienceID); return(View(duty)); }
public static bool insertDuty(Duty item) { OracleCommand cmd = new OracleCommand(); cmd.Connection = DatabaseHelper.GetInstance().conn; cmd.Transaction = DatabaseHelper.GetInstance().conn.BeginTransaction(); string sqlStr = @"insert into duty values (null, :Proom_num, :Pmon, Ptue, Pwed, Pthu, Pfri, Psat, Psun)"; cmd.CommandText = sqlStr; cmd.Parameters.Add("Proom_num", item.room_num); cmd.Parameters.Add("Pmon", item.Monday); cmd.Parameters.Add("Ptue", item.Tuesday); cmd.Parameters.Add("Pwed", item.Wednesday); cmd.Parameters.Add("Pthu", item.Thursday); cmd.Parameters.Add("Pfri", item.Friday); cmd.Parameters.Add("Psat", item.Saturday); cmd.Parameters.Add("Psun", item.Sunday); if (cmd.ExecuteNonQuery() == 0) { cmd.Transaction.Rollback(); return(false); } else { cmd.Transaction.Commit(); return(true); } }
/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private Duty EntityGet() { Duty entity = new Duty(); entity.ID = HTDataID; return(entity); }
public async Task ExpireDuty() { var location = new Location { Id = 1, AgencyId = "5555", Name = "dfd" }; await Db.Location.AddAsync(location); var startDate = DateTimeOffset.UtcNow.AddYears(5); var addDuty = new Duty { Id = 1, StartDate = startDate, EndDate = startDate.AddDays(5), LocationId = 1 }; await Db.Duty.AddAsync(addDuty); await Db.SaveChangesAsync(); HttpResponseTest.CheckForNoContentResponse(await _controller.ExpireDuty(1)); var controllerResult = await _controller.GetDuties(1, startDate, startDate.AddDays(1)); var getDuties = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult); Assert.Empty(getDuties); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(Duty model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DutyID", model.DutyID)); parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode))); parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName))); parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode))); parameters.Add(new QfParameter("Array", model.Array)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_duty({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public TriggerEventForDutyModel(Duty duty, string eventName, string Payload, bool passFullSerializedModel = false) { this.Duty = duty; this.eventName = eventName; this.Payload = Payload; this.passFullSerializedModel = passFullSerializedModel; }
public void Equals_ReturnsTrueIfDutyDescriptionsAreSame_Duty() { Duty firstDuty = new Duty("swab the decks"); Duty secondDuty = new Duty("swab the decks"); Assert.AreEqual(firstDuty, secondDuty); }
public static void LoadDuties() { int employeeID; DateTime startTime; DateTime endTime; int dateID; int dutyID; DBConnection.DatabaseName = "CANE"; if (DBConnection.IsConnected()) { string query = "SELECT * FROM Duty"; SqlCommand cmd = new SqlCommand(query, DBConnection.Connection); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { employeeID = (int)reader["EmployeeID"]; dateID = (int)reader["DateID"]; dutyID = (int)reader["DutyID"]; startTime = (DateTime)reader["StartTime"]; endTime = (DateTime)reader["EndTime"]; Duty duty = new Duty(dutyID, employeeID, dateID, startTime, endTime); DutyRepository.AddDuty(duty); } } DBConnection.Close(); } }
public async Task <IActionResult> Edit(int id, [Bind("DutyID,DutiesPerformed,JobID")] Duty duty) { if (id != duty.DutyID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(duty); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DutyExists(duty.DutyID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["JobID"] = new SelectList(_context.Jobs, "JobID", "CompanyName", duty.JobID); return(View(duty)); }
private void InitTestStatistics() { Random rnd = new Random(); Statistics = new ObservableCollection <DutyWrapper>(); List <DutyGroup> listGroup = new List <DutyGroup>(); listGroup.Add(new DutyGroup() { Name = "Programiranje" }); listGroup.Add(new DutyGroup() { Name = "Support" }); listGroup.Add(new DutyGroup() { Name = "Testiranje" }); listGroup.Add(new DutyGroup() { Name = "Dokumentacija" }); List <DutyWrapper> listDuties = new List <DutyWrapper>(); for (int i = 0; i < 100; i++) { Duty dut = new Duty("Task " + i); dut.TimeFrames.Clear(); DutyTimeFrame frame = new DutyTimeFrame(); frame.From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 20, 0, 0); frame.To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 21, 0, 0); dut.TimeFrames.Add(frame); int r = rnd.Next(4); dut.Group = listGroup[r]; int s = rnd.Next(5); listDuties.Add(new DutyWrapper() { Duty = dut, Number = s, Display = dut.Group.Name }); //dut.TotalTimeSpent } foreach (DutyWrapper dutWrap in listDuties) { DutyWrapper realWrapper = Statistics.FirstOrDefault(a => a.Display == dutWrap.Duty.Group.Name); if (realWrapper != null) { realWrapper.Number += dutWrap.Number; } else { Statistics.Add(dutWrap); } } }
private void putInDataArray(Duty duty) { int row = duty.time; int col = duty.day - 1; dataArray[row][col].Add(duty.Assistants.name); }
public ResponseJson Create(Duty model) { ResponseJson resJson; resJson = new ResponseJson(ResponseStatus.Success, now); try { Int32 id; id = GetDuId(); model.Du_Id = id; model.Du_Sort = id; olsEni.Duties.Add(model); olsEni.SaveChanges(); } catch (Exception ex) { resJson.status = ResponseStatus.Error; resJson.message = ex.Message; resJson.detail = StaticHelper.GetExceptionMessageAndRecord(ex); } return(resJson); }
/// <summary> /// 插入职责信息 /// </summary> /// <param name="duty">职责对象</param> /// <returns></returns> public static string InsertDuty(Duty duty) { string result = "0"; DBOperate db = new DBOperate("DADB"); try { string DutyId = Guid.NewGuid().ToString(); string strSql = "insert into Duty(DutyId,DutyCode,DutyName,Describe) values(@DutyId,@DutyCode,@DutyName,@Describe)"; db.RunSqlNonQuery(strSql, new SqlParameter[] { new SqlParameter("@DutyId", DutyId), new SqlParameter("@DutyCode", duty.DutyCode), new SqlParameter("@DutyName", duty.DutyName), new SqlParameter("@Describe", duty.Describe) }); result = "1"; } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { db.Despose(); } return(result); }
public async Task <IActionResult> PutDuty(int id, Duty duty) { if (id != duty.EmployeeId) { return(BadRequest()); } _context.Entry(duty).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DutyExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public HttpResponseMessage SetDutyTime(dynamic obj) { HttpResponseMessage response = new HttpResponseMessage(); var employee = JsonConvert.DeserializeObject(JsonObjectConverter.ObjectToJson(obj)) as JObject; string emp_id = employee.GetValue("employee_id").ToString(); string room_num = employee.GetValue("clinic_num").ToString(); string Monday = employee.GetValue("Monday").ToString(); string Tuesday = employee.GetValue("Tuesday").ToString(); string Wednesday = employee.GetValue("Wednesday").ToString(); string Thursday = employee.GetValue("Thursday").ToString(); string Friday = employee.GetValue("Friday").ToString(); string Saturday = employee.GetValue("Saturday").ToString(); string Sunday = employee.GetValue("Sunday").ToString(); Duty item = new Duty(room_num, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday); // 插入数据 try { ManagementHelper.SetDuty(item, emp_id); } catch (Exception e) { response.Content = new StringContent(e.Message); response.StatusCode = HttpStatusCode.BadRequest; } // duty表生成id // 设置room_num // max_limit设置成随机数 // 日期随便设置了 上下午。。。 return(response); }
/// <summary> /// 删除 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Delete(BaseEntity p_Entity) { try { Duty MasterEntity = (Duty)p_Entity; if (MasterEntity.ID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM Data_Duty WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(Sql); } else { AffectedRows = sqlTrans.ExecuteNonQuery(Sql); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E); } }
public async Task <IActionResult> PutDuty([FromRoute] int id, [FromBody] Duty duty) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != duty.Id) { return(BadRequest()); } _context.Entry(duty).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DutyExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// 删除 /// </summary> public override void EntityDelete() { DutyRule rule = new DutyRule(); Duty entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 绑定文本 /// </summary> private void BindText(Duty model) { txt_DutyCode.EditValue = model.DutyCode; txt_DutyName.EditValue = model.DutyName; txt_MnemonicCode.EditValue = model.MnemonicCode; txt_Note.EditValue = model.Note; }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { DutyRule rule = new DutyRule(); Duty entity = EntityGet(); rule.RAdd(entity); return(entity.ID); }