public async Task <IActionResult> Edit(int id, [Bind("Id,BusinessCentreId,PersonId,WorkStarted,WorkEnded,TimeWorked,PaymentPerHour,TotalPayment,WorkNote,Paid,AmountPaid,DueToPay")] WorkReport workReport)
{
if (id != workReport.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(workReport);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!WorkReportExists(workReport.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["PersonId"] = new SelectList(_context.Person, "Id", "Id", workReport.PersonId);
ViewData["BusinessCentreId"] = new SelectList(_context.BusinessCentre, "Id", "Id", workReport.BusinessCentreId);
return(View(workReport));
}
private void MakeReport()
{
var report = new WorkReport();
report.AddEntry(new Classes.WorkReportEntry {
ProjectCode = codigo.Text, ProjectName = nombre_projecto.Text, SpectHours = Int32.Parse(hora.Text)
});
/*report.AddEntry(new Classes.WorkReportEntry { ProjectCode = "175EEE", ProjectName = "Name Test 2", SpectHours = 25 });
* report.AddEntry(new Classes.WorkReportEntry { ProjectCode = "858EWW", ProjectName = "Name Test 3", SpectHours = 35 });*/
var scheduler = new Scheduler();
scheduler.AddEntry(new Classes.ScheduleTask {
TaskId = 1, Content = "Something todo", ExecuteON = DateTime.Now
});
scheduler.AddEntry(new Classes.ScheduleTask {
TaskId = 2, Content = "Something todo againg", ExecuteON = DateTime.Now.AddDays(2)
});
Console.WriteLine(report.ToString());
Console.WriteLine(scheduler.ToString());
//TODO --> Separarlo add de save
var saver = new FileSaver();
saver.SaveToFile(@"Reports", "WorkReport.txt", report);
saver.SaveToFile(@"Schedulers", "Schedule.txt", scheduler);
}
private void MakeReport()
{
var report = new WorkReport();
report.AddEntry(new Classes.WorkReportEntry {
ProjectCode = TIPOPLACA.Text + NUMEROPLACA.Text, ProjectName = LUGARINFRACCION.Text, SpectHours = Int32.Parse(HORA.Text)
});
var scheduler = new Scheduler();
scheduler.AddEntry(new Classes.ScheduleTask {
TaskId = 1, Content = "Something todo", ExecuteON = DateTime.Now
});
scheduler.AddEntry(new Classes.ScheduleTask {
TaskId = 2, Content = "Something todo againg", ExecuteON = DateTime.Now.AddDays(2)
});
Console.WriteLine(report.ToString());
Console.WriteLine(scheduler.ToString());
//TODO --> Separarlo add de save
var saver = new FileSaver();
saver.SaveToFile(@"Reports", "RegistroMultas.txt", report);
saver.SaveToFile(@"Schedulers", "Schedule.txt", scheduler);
}
public static void SaveHistory(List <EditableWorkReport> editableWorkReports)
{
FileStream stream = new FileStream(FILE_NAME, FileMode.Create, FileAccess.Write, FileShare.Write);
if (stream != null)
{
try
{
History history = new History();
WorkReport[] workReports = new WorkReport[editableWorkReports.Count];
XmlSerializer serializer = new XmlSerializer(typeof(History));
for (int i = 0; i < workReports.Length; i++)
{
workReports[i] = editableWorkReports[i].WrappedInstance;
}
// Assign work reports to the serializable object.
history.WorkReports = workReports;
serializer.Serialize(stream, history);
}
finally
{
stream.Close();
}
}
}
public string GetPerformanceDetail(string callType, string xmlMessage)
{
string result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<" + callType + ">" +
"<Result>False</Result>" +
"<Description></Description></" + callType + ">";
string logID = Guid.NewGuid().ToString();
try
{
FileLogger.WriteLog(logID + "|Start:" + xmlMessage, 1, "", callType);
if (Helper.CheckAuthCode(callType, xmlMessage))//数据校验通过
{
WorkReport w = new WorkReport();
result = w.GetPerformanceDetail(xmlMessage);
}
}
catch (Exception err)
{
result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<" + callType + ">" +
"<Result>False</Result>" +
"<Description>" + err.Message + "</Description></" + callType + ">";
}
FileLogger.WriteLog(logID + "|End:" + result, 1, "", callType);;
return(result);
}
public string GetMonthReportListByIndex(string callType, string xmlMessage)
{
string result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<GetWorkReportList>" +
"<Result>False</Result>" +
"<Description></Description></GetWorkReportList>";
string logID = Guid.NewGuid().ToString();
FileLogger.WriteLog(logID + "|Start:" + xmlMessage, 1, "", callType);
try
{
if (Helper.CheckAuthCode("GetWorkReportListByIndex", xmlMessage))//数据校验通过
{
WorkReport wr = new WorkReport();
result = wr.GetMonthListByIndex(xmlMessage);
}
}
catch (Exception err)
{
result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<GetWorkReportList>" +
"<Result>False</Result>" +
"<Description>" + err.Message + "</Description></GetWorkReportList>";
}
FileLogger.WriteLog(logID + "|End:" + result, 1, "", callType);
return(result);
}
public Rtn <WorkReport> addOaWorkReportInfo([FromForm] CreateWorkReportInput input)
{
var tokenUser = this.userService.getUserFromAuthcationHeader();
var newWorkreport = new WorkReport
{
type = input.type,
title = input.title,
subTime = DateUtil.getNowSeconds(),
subPersonId = tokenUser.id,
noticePersonIds = input.noticePersonIds,
workorderDetailedId = input.workorderDetailedId,
content = input.content,
ccPersonIds = input.ccPersonIds
};
if (input.enclosure != null)
{
var enclosures = input.enclosure.Split(";");
foreach (var enclosureId in enclosures)
{
var enclusure = this.oaContext.enclosures.Find(enclosureId);
if (enclusure != null)
{
enclusure.fjId = newWorkreport.id;
}
}
this.oaContext.SaveChanges();
}
this.oaContext.workreports.Add(newWorkreport);
this.oaContext.SaveChanges();
return(Rtn <WorkReport> .Success(newWorkreport));
}
public void WorkReportScheduler()
{
//Arrange
var report = new WorkReport();
report.AddEntry(new WorkReportEntry {
ProjectCode = "123Ds", ProjectName = "Project1", SpentHours = 5
});
report.AddEntry(new WorkReportEntry {
ProjectCode = "987Fc", ProjectName = "Project2", SpentHours = 3
});
var scheduler = new Scheduler();
scheduler.AddEntry(new ScheduleTask {
TaskId = 1, Content = "Do something now.", ExecuteOn = DateTime.Now.AddDays(5)
});
scheduler.AddEntry(new ScheduleTask {
TaskId = 2, Content = "Don't forget to...", ExecuteOn = DateTime.Now.AddDays(2)
});
//Act
Console.WriteLine(report.ToString());
Console.WriteLine(scheduler.ToString());
var saver = new FileSaver();
saver.SaveToFile(@"Reports", "WorkReport.txt", report);
saver.SaveToFile(@"Schedulers", "Schedule.txt", scheduler);
//Assert
Assert.True(File.Exists(@"Reports/WorkReport.txt"));
Assert.True(File.Exists(@"Schedulers/Schedule.txt"));
}
protected override void DeleteWorkReportAction()
{
if (WorkReport_DGW.CurrentRow == null)
{
return;
}
if (WorkReport_DGW.CurrentRow.Index < 0)
{
return;
}
if (WorkReport_DGW.CurrentRow.DataBoundItem == null)
{
return;
}
if (PgMng.ShowDeleteConfirmation() == DialogResult.Yes)
{
WorkReportInfo item = (WorkReportInfo)WorkReport_DGW.CurrentRow.DataBoundItem;
WorkReport.Delete(item.Oid);
_work_reports.Remove(item);
WorkReport_BS.ResetBindings(false);
UpdateWorkReportsTotals();
LoadCategoriesExpenses(true);
}
}
public CommonRtn addOaWorkReportInfo([FromBody] WorkReport workReport)
{
this.oaContext.workreports.Add(workReport);
this.oaContext.SaveChanges();
return(new CommonRtn {
success = true, message = ""
});
}
private void OnCommandRunnerOnWorkCompleted(WorkReport wr)
{
UpstatusFromReport(wr);
if (_completeCallBack != null)
{
_completeCallBack();
}
_commandRunner.WorkCompleted -= OnCommandRunnerOnWorkCompleted;
}
public override void CopyObjectAction(long oid)
{
WorkReportAddForm form = new WorkReportAddForm(WorkReport.CloneAsNew(ActiveItem), this);
AddForm(form);
if (form.ActionResult == DialogResult.OK)
{
_entity = form.Entity;
}
}
public override void OpenAddForm()
{
WorkReportAddForm form = new WorkReportAddForm(this);
AddForm(form);
if (form.ActionResult == DialogResult.OK)
{
_entity = form.Entity;
}
}
public override void UpdateList()
{
switch (_current_action)
{
case molAction.Add:
case molAction.Copy:
if (_entity == null)
{
return;
}
if (List.GetItem(_entity.Oid) != null)
{
return;
}
List.AddItem(_entity.GetInfo(false));
if (FilterType == IFilterType.Filter)
{
WorkReportList listA = WorkReportList.GetList(_filter_results);
listA.AddItem(_entity.GetInfo(false));
_filter_results = listA.GetSortedList();
}
break;
case molAction.Edit:
case molAction.Lock:
case molAction.Unlock:
if (_entity == null)
{
return;
}
ActiveItem.CopyFrom(_entity);
break;
case molAction.Delete:
if (ActiveItem == null)
{
return;
}
List.RemoveItem(ActiveOID);
if (FilterType == IFilterType.Filter)
{
WorkReportList listD = WorkReportList.GetList(_filter_results);
listD.RemoveItem(ActiveOID);
_filter_results = listD.GetSortedList();
}
break;
}
RefreshSources();
if (_entity != null)
{
Select(_entity.Oid);
}
_entity = null;
}
public IActionResult Index(WorkReport workReport)
{
var applicationContext = _context.WorkReport.Include(w => w.AssignedFE).Include(w => w.BusinessCentre);
workReport.TotalPayment = workReport.TimeWorked
* workReport.PaymentPerHour;
workReport.DueToPay = workReport.TimeWorked
* workReport.PaymentPerHour
- workReport.AmountPayed;
return(View(workReport));
}
internal string AddWorkReportBaseInfo(WorkReport workReport)
{
if (string.IsNullOrWhiteSpace(workReport.ID))
{
workReport.ID = Guid.NewGuid().ToString();
}
var insertStr = $@"INSERT INTO workreport(id, wrtypeid, dateoffilling,location, creator, createdtime, lastmodifier, lastmodifiedtime, tenantid) VALUES ('{workReport.ID}', '{workReport.WorkReportType.ID}', '{workReport.DateOfFilling.ToString("yyyy-MM-dd HH:mm:ss")}','{workReport.Location}', '{Utils.GetUserId()}', {db.DBDataTimeFunc}, '{Utils.GetUserId()}', {db.DBDataTimeFunc}, '{Utils.GetTenantId()}')";
//新增一条数据
db.ExecSqlStatement(insertStr);
return(workReport.ID);
}
public async Task <IActionResult> Create([Bind("Id,BusinessCentreId,PersonId,WorkStarted,WorkEnded,TimeWorked,PaymentPerHour,TotalPayment,WorkNote,Paid,AmountPaid,DueToPay")] WorkReport workReport)
{
if (ModelState.IsValid)
{
_context.Add(workReport);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PersonId"] = new SelectList(_context.Person, "Id", "Id", workReport.PersonId);
ViewData["BusinessCentreId"] = new SelectList(_context.BusinessCentre, "Id", "Id", workReport.BusinessCentreId);
return(View(workReport));
}
public WorkReport GetWorkReportByID(string workReportID)
{
var qeuryStr = $@"SELECT a.id, a.wrtypeid, a.dateoffilling,a.location, a.creator, a.createdtime, a.lastmodifier, a.lastmodifiedtime, a.tenantid, b.Code as wrtypecode, b.NAME as wrtypename, b.tenantid FROM workreport AS a JOIN wrtype AS b ON a.wrtypeid = b.id and b.tenantid='{Utils.GetTenantId()}' where a.id = '{workReportID}' and a.tenantid='{Utils.GetTenantId()}' ";
WorkReport wr = null;
using (var dbReader = db.ExecuteReader(qeuryStr))
{
//将数据库信息封装到实体类
dbReader.Read();
wr = AssemblyWorkReport(dbReader);
}
return(wr);
}
static void Main(string[] args)
{
//Example.1 wrong
wrong.EmployeeService employeeService = new wrong.EmployeeService
{
FirstName = "John",
LastName = "Deo"
};
employeeService.EmployeeRegistration(employeeService);
//Example.1 right
right.Employee employee =
new right.Employee("pesho", "mitkov", "*****@*****.**");
right.EmployeeServices.EmployeeService newEmplpoyeeRegistration =
new right.EmployeeServices.EmployeeService();
newEmplpoyeeRegistration.RegistrationEmployee(employee);
//Example.2 right
var report = new WorkReport();
report.AddEntry(new WorkReportEntry {
ProjectCode = "123Ds", ProjectName = "Project1", SpentHours = 5
});
report.AddEntry(new WorkReportEntry {
ProjectCode = "987Fc", ProjectName = "Project2", SpentHours = 3
});
var saver = new FileSaver();
//след тези подобрение може лесно да се добавят нови ф-сти. Например класа ScheduleTask
var scheduler = new SingleResponsiblilityExample.RightVersion.WorkReport.Schedular();
scheduler.AddEntry(new ScheduleTask
{
TaskId = 1, Content = "Do something now.", ExecuteOn = DateTime.Now.AddDays(5)
});
scheduler.AddEntry(new ScheduleTask
{
TaskId = 2, Content = "Don't forget to...", ExecuteOn = DateTime.Now.AddDays(2)
});
Console.WriteLine(report.ToString());
Console.WriteLine(scheduler.ToString());
saver.SaveToFile(@"Reports", "WorkReport.txt", report);
saver.SaveToFile(@"Scheduler", "Scheduler.txt", scheduler);
}
static void Main(string[] args)
{
var report = new WorkReport();
report.AddEntry(new WorkReportEntry {
ProjectCode = "123Ds", ProjectName = "Project1", SpentHours = 5
});
report.AddEntry(new WorkReportEntry {
ProjectCode = "987Fc", ProjectName = "Project2", SpentHours = 3
});
Console.WriteLine(report.ToString());
var saver = new FileSaver();
saver.SaveToFile(@"D:/", "WorkReport.txt", report);
}
public override void OpenEditForm()
{
if (ActiveItem.EStatus == moleQule.Base.EEstado.Closed)
{
PgMng.ShowInfoException("No es posible modificar un parte de trabajo cerrado.");
_action_result = DialogResult.Ignore;
return;
}
WorkReportEditForm form = new WorkReportEditForm(ActiveOID, this);
if (form.Entity != null)
{
AddForm(form);
_entity = form.Entity;
}
}
protected override void GetFormSourceData(object[] parameters)
{
if (parameters[0] == null)
{
_entity = WorkReport.New();
_entity.BeginEdit();
if (parameters.Length >= 2)
{
Expedient expedient = (Expedient)parameters[1];
_entity.OidExpedient = expedient.Oid;
}
}
else
{
_entity = (WorkReport)parameters[0];
_entity.BeginEdit();
}
}
private WorkReport AssemblyWorkReport(IDataReader reader)
{
WorkReport wr = new WorkReport
{
ID = reader["id"].ToString(),
WorkReportType = new WRType()
{
ID = reader["wrtypeid"].ToString(), Name = reader["wrtypename"].ToString(), Code = reader["wrtypecode"].ToString()
},
DateOfFilling = Convert.ToDateTime(reader["dateoffilling"].ToString()),
Location = reader["location"].ToString(),
Creator = reader["creator"].ToString(),
CreatedTime = Convert.ToDateTime(reader["createdtime"].ToString()),
LastModifier = reader["lastmodifier"].ToString(),
LastModifiedTime = Convert.ToDateTime(reader["lastmodifiedtime"].ToString())
};
return(wr);
}
public async Task <IActionResult> Create([Bind("Id,BusinessCentreId,PersonId,WorkStarted,WorkEnded,TimeWorked,PaymentPerHour,TotalPayment,WorkNote,Payed,AmountPayed,DueToPay,DWorkinTicketNumber")] WorkReport workReport)
{
if (ModelState.IsValid)
{
var applicationContext = _context.WorkReport.Include(w => w.AssignedFE).Include(w => w.BusinessCentre);
workReport.TotalPayment = workReport.TimeWorked
* workReport.PaymentPerHour;
workReport.DueToPay = workReport.TimeWorked
* workReport.PaymentPerHour
- workReport.AmountPayed;
_context.Add(workReport);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PersonId"] = new SelectList(_context.Person, "Id", "FullName", workReport.PersonId);
ViewData["BusinessCentreId"] = new SelectList(_context.BusinessCentre, "Id", "CwName", workReport.BusinessCentreId);
return(View(workReport));
}
private void UpstatusFromReport(WorkReport wr)
{
switch (wr.Status)
{
case WorkStatus.Success:
UpdateFeedBack("Completed successfully");
break;
case WorkStatus.UserCancelled:
UpdateFeedBack("User cancelled");
break;
case WorkStatus.CommandFailWithException:
UpdateFeedBack("Operation failed");
break;
case WorkStatus.UndoFailWithException:
UpdateFeedBack("Undo failed");
break;
}
}
public void WorkReportEntries()
{
//Arrange
var report = new WorkReport();
report.AddEntry(new WorkReportEntry {
ProjectCode = "123Ds", ProjectName = "Project1", SpentHours = 5
});
report.AddEntry(new WorkReportEntry {
ProjectCode = "987Fc", ProjectName = "Project2", SpentHours = 3
});
//Act
Console.WriteLine(report.ToString());
var saver = new FileSaver();
saver.SaveToFile(@"Reports", "WorkReport.txt", report);
//Assert
Assert.True(File.Exists(@"Reports/WorkReport.txt"));
}
public List <WorkReport> GetWorkReportList(WRQueryFilter filterCondition)
{
if (filterCondition == null)
{
return(null);
}
PlanDac planDac = new PlanDac();
List <WorkReport> reports = planDac.GetWorkReportList(filterCondition);
if (reports != null && reports.Count > 0)
{
for (int i = 0; i < reports.Count; i++)
{
WorkReport wr = reports[i];
if (!string.IsNullOrEmpty(wr.Creator))
{
SysUser user = userService.GetUserByID(wr.Creator);
wr.CreatorName = user == null? "某某" : user.Name;
}
}
}
return(reports);
}
public string UpdateWeekReport(string callType, string xmlMessage)
{
string result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<" + callType + ">" +
"<Result>False</Result>" +
"<Description></Description></" + callType + ">";
string logID = Guid.NewGuid().ToString();
try
{
FileLogger.WriteLog(logID + "|Start:" + xmlMessage, 1, "", callType);
if (Helper.CheckAuthCode("UpdateWorkReport", xmlMessage))//数据校验通过
{
WorkReport wr = new WorkReport();
result = wr.UpdateWeek(xmlMessage);
if (result != "-1")
{
result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<" + callType + ">" +
"<Result>True</Result>" +
"<ID>" + result + "</ID>" +
"<Description></Description></" + callType + ">";
}
}
}
catch (Exception err)
{
result = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<" + callType + ">" +
"<Result>False</Result>" +
"<Description>" + err.Message + "</Description></" + callType + ">";
}
FileLogger.WriteLog(logID + "|End:" + result, 1, "", callType);
return(result);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,BusinessCentreId,PersonId,WorkStarted,WorkEnded,TimeWorked,PaymentPerHour,TotalPayment,WorkNote,Payed,AmountPayed,DueToPay,DWorkinTicketNumber")] WorkReport workReport)
{
if (id != workReport.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var applicationContext = _context.WorkReport.Include(w => w.AssignedFE).Include(w => w.BusinessCentre);
workReport.TotalPayment = workReport.TimeWorked
* workReport.PaymentPerHour;
workReport.DueToPay = workReport.TimeWorked
* workReport.PaymentPerHour
- workReport.AmountPayed;
_context.Update(workReport);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!WorkReportExists(workReport.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["PersonId"] = new SelectList(_context.Person, "Id", "FullName", workReport.PersonId);
ViewData["BusinessCentreId"] = new SelectList(_context.BusinessCentre, "Id", "CwName", workReport.BusinessCentreId);
return(View(workReport));
}
protected override bool SaveObject()
{
this.Datos.RaiseListChangedEvents = false;
// do the save
try
{
PgMng.Reset(5, 1, Library.Store.Resources.Messages.ACTUALIZANDO_STOCKS, this);
WorkReport temp = _entity.Clone();
temp.ApplyEdit();
PgMng.Grow();
_entity = temp.Save();
_entity.ApplyEdit();
PgMng.Grow();
return(true);
}
finally
{
this.Datos.RaiseListChangedEvents = true;
}
}
