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);
}
