private void LoadData()
{
string supplierOpinionCode = Request.QueryString["SupplierOpinionCode"] + "";
string supplierCode = Request["SupplierCode"] + "";
this.SupplierName.Text = BLL.ProjectRule.GetSupplierName(supplierCode);
if (supplierOpinionCode == "")
{
this.btnDelete.Visible = false;
return;
}
try
{
EntityData entity = ProjectDAO.GetSupplierOpinionByCode(supplierOpinionCode);
if (entity.HasRecord())
{
OpinionPerson.Text = entity.GetString("OpinionPerson");
Event.Text = entity.GetString("Event");
Opinion.Text = entity.GetString("Opinion");
dtOpinionDate.Value = entity.GetDateTimeOnlyDate("OpinionDate");
}
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public override string BuildSingleStrategyString(Strategy strategy)
{
RoleStrategyName name = (RoleStrategyName)strategy.Name;
string projectUnitCode = "";
string unitFullCode = "";
if (strategy.Type == StrategyType.Other)
{
switch (name)
{
case RoleStrategyName.ProjectCode:
projectUnitCode = ProjectDAO.GetProjectUnitCode(strategy.GetParameter(0));
return(string.Format(" exists ( select * from userRole where userrole.RoleCode = Role.RoleCode and unitCode ='{0}' ) ", unitFullCode));
case RoleStrategyName.ProjectCodeEx:
unitFullCode = OBSDAO.GetUnitFullCode(ProjectDAO.GetProjectUnitCode(strategy.GetParameter(0)));
return(string.Format(" exists ( select * from userRole where userrole.RoleCode = Role.RoleCode and unitCode in ( select unitCode from unit where fullCode like '{0}%')) ", unitFullCode));
case RoleStrategyName.UnitCode:
unitFullCode = OBSDAO.GetUnitFullCode(strategy.GetParameter(0));
return(string.Format(" exists ( select * from userRole where userrole.RoleCode = Role.RoleCode and unitCode in ( select unitCode from unit where fullCode like '{0}%')) ", unitFullCode));
case RoleStrategyName.ModuleCode:
return(string.Format(" RoleCode in ( select RoleCode from RoleModule where ModuleCode='{0}' ) ", strategy.GetParameter(0)));
case RoleStrategyName.UserCode:
return(string.Format(" RoleCode in ( select RoleCode from UserRole where UserCode='{0}' ) ", strategy.GetParameter(0)));
}
return("");
}
return(StandardStrategyStringBuilder.BuildStrategyString(strategy));
}
public async Task <ActionResult <ProjectDAO> > PostProject(ProjectDAO project)
{
_context.Projects.Add(project);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProject", new { id = project.Id }, project));
}
void SelectStationImage()
{
try {
if (tvProject.SelectedNode.Tag.GetType() == _currentStation.GetType())
{
OpenFileDialog selectMainPictureDialog = new OpenFileDialog();
selectMainPictureDialog.Filter = "Jpeg files (*.jpg)|*.jpg|All files (*.*)|*.*";
selectMainPictureDialog.Title = "Select the main picture";
if (selectMainPictureDialog.ShowDialog() == DialogResult.OK)
{
ProjectDAO.InsertImage(_currentProject.Name, _currentStation.Guid, ConversionUtilities.ImageToBase64(Main_processing.ResizeImage(Image.FromFile(selectMainPictureDialog.FileName)), System.Drawing.Imaging.ImageFormat.Jpeg));
_currentStation.MetadataFromImage(selectMainPictureDialog.FileName);
pictureBox1.Image = CameratrapManager_db.ProjectDAO.GetCurrentImage(_currentProject.Name, _currentStation.Guid);
ProjectDAO.UpdateProject(_currentProject.Name, _currentProject);
//Must solve the update node after select station image
// UpdateCurrentNodeTree();
refreshViewData(_currentStation);
}
else
{
MessageBox.Show("You must select a Station node");
}
}
} catch (Exception ex) {
throw ex;
}
}
public void UpdatePage()
{
this.Dispatcher.Invoke(() =>
{
try
{
if (mainController.Project != null)
{
using (MySqlDataReader dataReader = new ProjectDAO().GetDashboardStats(mainController.Project.Id, mainController.User.Id))
{
if (dataReader.Read())
{
tasksLeft = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt16("TasksLeft");
tasksCompleted = dataReader.IsDBNull(3) ? 0 : dataReader.GetInt16("TasksCompleted");
yourTasks = dataReader.IsDBNull(4) ? 0 : dataReader.GetInt16("YourTasks");
daysLeft = dataReader.IsDBNull(5) ? "Ingen" : dataReader.GetInt16("DaysLeft") + " dage";
}
}
mySQLConnector.CloseConnections();
UpdateQuickStats();
UpdateCharts();
}
}
catch (Exception exception)
{
utilities.GetNotifier().ShowError(utilities.HandleException(exception));
}
});
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
EntityData entity = DAL.EntityDAO.OBSDAO.GetStandard_UnitByCode(Request.QueryString["UnitCode"]);
if (entity.HasRecord())
{
this.parentUnit.Value = entity.GetString("ParentUnitCode");
EntityData entityParent = DAL.EntityDAO.OBSDAO.GetStandard_UnitByCode(this.parentUnit.Value);
if (entityParent.HasRecord())
{
this.parentUnitName.Value = entityParent.GetString("UnitName");
}
entityParent.Dispose();
}
entity.Dispose();
EntityData projectds = ProjectDAO.GetProjectByCode(Request.QueryString["ProjectCode"].ToString());
RmsPM.BLL.PageFacade.LoadSubjectSetSelect(this.sltSubjectSet, "");
this.sltSubjectSet.Value = projectds.GetString("SubjectSetCode");
projectds.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "读取项目信息错误");
Response.Write(Rms.Web.JavaScript.Alert(true, "读取项目信息错误"));
}
}
}
public List <ProjectDepartmentDTO> GetProjectDepartmentDTO()
{
ProjectDAO dao = new ProjectDAO();
DepartmentDAO depdao = new DepartmentDAO();
List <Project> projectsModel = dao.GetAll();
List <ProjectDepartmentDTO> projDepDTO = new List <ProjectDepartmentDTO>();
List <string> mutualFileds = typeof(Project).GetProperties().Select(p => p.Name)
.Intersect(typeof(ProjectDepartmentDTO).GetProperties().Select(p => p.Name)).ToList();
for (int i = 0; i < projectsModel.Count; i++)
{
// Add new Element
projDepDTO.Add(new ProjectDepartmentDTO());
// Fill mutual fields
foreach (string f in mutualFileds)
{
typeof(ProjectDepartmentDTO).GetProperty(f).SetValue(projDepDTO[i],
typeof(Project).GetProperty(f).GetValue(projectsModel[i]));
}
// Add Department
projDepDTO[i].BelongsToDepartment = depdao.GetFiltered("id", projDepDTO[i].DepartmentID.ToString());
}
return(projDepDTO);
}
void ExitApplication()
{
try {
DialogResult result = MessageBox.Show("Would you like to save your changes?", "Save project?",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ProjectDAO.UpdateProject(_currentProject.Name, _currentProject);
ProjectDAO.RemoveOrphanImages(_currentProject);
tvProject.Dispose();
pictureBox1.Dispose();
_currentProject = null;
_currentStation = null;
_currentSample = null;
lstViewData.Dispose();
dgvSelectSpecies.Dispose();
}
else if (result == DialogResult.Cancel)
{
// Stop the closing and return to the form
// e.Cancel = true;
}
} catch (Exception ex) {
throw ex;
}
}
public async Task <IActionResult> PutProject(int id, ProjectDAO project)
{
if (id != project.Id)
{
return(BadRequest());
}
_context.Entry(project).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static string GetDevelopUnitByProject(string projectCode)
{
string text2;
try
{
string text = "";
if (projectCode == "")
{
return(text);
}
EntityData projectByCode = ProjectDAO.GetProjectByCode(projectCode);
if (projectByCode.HasRecord())
{
text = projectByCode.GetString("DevelopUnit");
}
projectByCode.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
void CloseProjectToolStripMenuItemClick(object sender, EventArgs e)
{
try {
DialogResult result = MessageBox.Show("Would you like to save your changes?", "Save project?",
MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ProjectDAO.UpdateProject(_currentProject.Name, _currentProject);
ProjectDAO.RemoveOrphanImages(_currentProject);
}
else if (result == DialogResult.Cancel)
{
// Stop the closing and return to the form
// e.Cancel = true;
}
else
{
tvProject.Nodes.Clear();
pictureBox1.Image = null;
_currentProject = null;
_currentStation = null;
_currentSample = null;
lstViewData.Clear();
dgvSelectSpecies.DataSource = null;
speciesList.Rows.Clear();
}
} catch (Exception ex) {
throw ex;
}
}
public static string GetSupplierName(string supplierCode)
{
string text2;
try
{
string text = "";
if (supplierCode == "")
{
return(text);
}
EntityData supplierByCode = ProjectDAO.GetSupplierByCode(supplierCode);
if (supplierByCode.HasRecord())
{
text = supplierByCode.GetString("SupplierName");
}
supplierByCode.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
public static bool IsUseShortNameByProjectCode(string projectCode)
{
bool flag2;
try
{
bool flag = false;
if (projectCode == "")
{
return(flag);
}
EntityData projectByCode = ProjectDAO.GetProjectByCode(projectCode);
if (projectByCode.HasRecord())
{
flag = projectByCode.GetString("IsUseShortName") == "1";
}
projectByCode.Dispose();
flag2 = flag;
}
catch (Exception exception)
{
throw exception;
}
return(flag2);
}
public static string GetAllSalProjectCode()
{
string text2;
try
{
string text = "";
EntityData allSalProjectCode = ProjectDAO.GetAllSalProjectCode();
if (allSalProjectCode.HasRecord())
{
if (text != "")
{
text = text + ",";
}
text = text + allSalProjectCode.GetString("SalProjectCode");
}
allSalProjectCode.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
public static string GetProjectShortName(string ProjectCode, bool WhenNullUseProjectName)
{
string text2;
try
{
string text = "";
if (ProjectCode == "")
{
return(text);
}
EntityData projectByCode = ProjectDAO.GetProjectByCode(ProjectCode);
if (projectByCode.HasRecord())
{
text = projectByCode.GetString("ProjectShortName");
if ((text == "") && WhenNullUseProjectName)
{
text = projectByCode.GetString("ProjectName");
}
}
projectByCode.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
private static string GetSupplierSubjectSetU8Code(string SupplierCode, string ProjectCode, string SubjectSetCode)
{
string text2;
try
{
string text = "";
if (SupplierCode == "")
{
return(text);
}
EntityData data = ProjectDAO.GetSupplierSubjectSetBySupplier(SupplierCode, ProjectCode, SubjectSetCode);
if (data.HasRecord())
{
text = data.GetString("U8Code");
}
data.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
public static string GetProjectSubjectSetU8Code(string ProjectCode, string SubjectSetCode)
{
string text2;
try
{
string text = "";
if (ProjectCode == "")
{
return(text);
}
EntityData projectSubjectSetByProject = ProjectDAO.GetProjectSubjectSetByProject(ProjectCode, SubjectSetCode);
if (projectSubjectSetByProject.HasRecord())
{
text = projectSubjectSetByProject.GetString("U8Code");
}
projectSubjectSetByProject.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
public NewTask(StackPanel currentSection)
{
InitializeComponent();
try
{
this.currentSection = currentSection;
string sectionName = currentSection.Name;
sectionID = int.Parse(sectionName.Remove(0, "Section".Length));
StackPanel projectUsers = (StackPanel)FindName("ProjectUsers");
section = new SectionDAO().Read(sectionID);
List <User> users = new ProjectDAO().GetProjectUsers(section.ProjectId);
foreach (User user in users)
{
UserAvatar userAvatar = new UserAvatar(this, user.Id);
userAvatar.Uid = user.Id.ToString();
userAvatar.UserImage.ImageSource = new BitmapImage(new Uri(user.Picture));
userAvatar.ToolTip = user.Firstname + " " + user.Lastname;
projectUsers.Children.Add(userAvatar);
}
}
catch (Exception exception)
{
utilities.GetNotifier().ShowError(utilities.HandleException(exception));
}
}
public IActionResult Delete(int ProjectID)
{
ProjectDAO dao = new ProjectDAO();
dao.Delete(ProjectID);
return(RedirectToAction("Index"));
}
public void PaySalary(MySqlConnection connection, Employee employee, int hours_worked, DateTime date)
{
Salary_payment salary_payment = new Salary_payment(0, DateTime.Now, hours_worked,
(decimal?)(hours_worked * employee.Qualification), employee.Id);
Salary_paymentDAO.InsertSalary_payments(connection, new List <Salary_payment> ()
{
salary_payment
});
List <Project> projects = ProjectDAO.GetProjects(connection);
string Query;
foreach (Project project in projects)
{
Query = "SELECT sum(Salary_payment.salary) as salary FROM Salary_payment, Employee, Team_member, Project" +
"WHERE Employee.Id=Salary_payment.Employee_id AND" +
"Employee.Id = Team_member.Employee_id AND Team_member.Project_id = Project.id " +
"AND Salary_payment.`date`='" + date + "' AND Project.id=" + project.Id + ";";
MySqlCommand command = connection.CreateCommand();
command.CommandText = Query;
MySqlDataReader data = command.ExecuteReader();
while (data.Read())
{
project.Expenditures += Convert.ToDecimal(data["salary"]);
}
this.Balance -= project.Expenditures;
PayUST(connection, project.Expenditures);
}
ProjectDAO.UpdateProjects(connection, projects);
}
public InviteUserToProject(Object openedBy)
{
this.openedBy = openedBy;
InitializeComponent();
userDAO = new UserDAO();
projectDAO = new ProjectDAO();
}
public HttpResponseMessage getDefectsGroupOriginIterations(HttpRequestMessage request, string subproject, string delivery, List <string> iterations)
{
var projectDAO = new ProjectDAO();
var list = projectDAO.getDefectsGroupOriginIterations(subproject, delivery, iterations);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, list));
}
public HttpResponseMessage getStatusLastDaysByProjectIterations(HttpRequestMessage request, string subproject, string delivery, List <string> iterations)
{
var projectDAO = new ProjectDAO();
var item = projectDAO.getStatusLastDaysByProjectIterations(subproject, delivery, iterations);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, item));
}
public HttpResponseMessage getProjectsByIds(HttpRequestMessage request, string ids)
{
var projectDAO = new ProjectDAO();
var projects = projectDAO.getProjectsByIds(ids);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, projects));
}
public HttpResponseMessage getDefectStatusByProject(HttpRequestMessage request, string subproject, string delivery)
{
var projectDAO = new ProjectDAO();
var list = projectDAO.getDefectStatusByProject(subproject, delivery);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, list));
}
public HttpResponseMessage getDetectableInDevByProject(HttpRequestMessage request, string subproject, string delivery)
{
var projectDAO = new ProjectDAO();
var detectableInDev = projectDAO.getDetectableInDevByProject(subproject, delivery);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, detectableInDev));
}
public HttpResponseMessage getDefectReopenedByProject(HttpRequestMessage request, string subproject, string delivery)
{
var projectDAO = new ProjectDAO();
var densityDefects = projectDAO.getDefectReopenedByProject(subproject, delivery);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, densityDefects));
}
public HttpResponseMessage getDefectsAverangeTimeGroupSeverityByProject(HttpRequestMessage request, string subproject, string delivery)
{
var projectDAO = new ProjectDAO();
var defectAverangeTimeGroupSeverity = projectDAO.getDefectAverangeTimeGroupSeverityByProject(subproject, delivery);
projectDAO.Dispose();
return(request.CreateResponse(HttpStatusCode.OK, defectAverangeTimeGroupSeverity));
}
public void Start(MySqlConnection connection)
{
this.State = 1;
List <Project> projects = new List <Project> ();
projects.Add(this);
ProjectDAO.UpdateProjects(connection, projects);
}
public async Task <IActionResult> CreateClientProject(ProjectDAO project, int clientId)
{
project.ClientId = clientId;
_context.Projects.Add(project);
await _context.SaveChangesAsync();
return(Created($"api/Projects/GetProject/{project.Id}", project));
}
public ResponseModel<string> CreateTemplate(List<CreateTemplateQuestionInfoModel> req,string username,TemplateInfoModel TemplateInfo)
{
var response = new ResponseModel<string>();
var keyInfo = _db.CreateTemplateQuestionInfoes.FirstOrDefault();
var refKey = _db.Users.SingleOrDefault(x=>x.Username == username).guid;
var digitKey = 0;
Random rnd = new Random();
int randomValue = rnd.Next(1, 10000);
if (keyInfo != null)
{
digitKey = _db.CreateTemplateQuestionInfoes.Max(x => x.Id) + 1;
}
else
{
digitKey = 1;
}
refKey += digitKey + randomValue;
if (TemplateInfo.type == Constants.type_Ads && TemplateInfo.subType == Constants.subType_facebookLike)
{
var facebookFindPageId = TemplateInfo.pageId.Split('/');
var createTemplateFacebookLikeInsert = new CreateTemplateFacebookLike
{
username = username,
title = req[0].title,
type = TemplateInfo.type,
subType = TemplateInfo.subType,
creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture),
referenceId = refKey,
totalThreads = TemplateInfo.totalThreads,
completed = Constants.NA,
verified = Constants.NA,
payPerUser = TemplateInfo.amountEachThread,
DateTime = DateTime.Now,
description = (req[3].textBoxQuestionsList[0].Question) == null ? Constants.NA : req[3].textBoxQuestionsList[0].Question,
pageId = facebookFindPageId[facebookFindPageId.Length-1],
pageUrl = TemplateInfo.pageUrl
};
_db.CreateTemplateFacebookLikes.Add(createTemplateFacebookLikeInsert);
try
{
_db.SaveChanges();
var signalRHub = new SignalRHub();
string totalProjects = new ProjectDAO().totalAvailableProjects();
string successRate = "";
string totalUsers = "";
string projectCategories = "";
var hubContext = GlobalHost.ConnectionManager.GetHubContext<SignalRHub>();
hubContext.Clients.All.updateBeforeLoginUserProjectDetails(totalProjects, successRate, totalUsers, projectCategories);
response.Status = 200;
response.Message = "success-" + digitKey;
response.Payload = refKey;
}
catch (DbEntityValidationException e)
{
DbContextException.LogDbContextException(e);
response.Status = 500;
response.Message = "Failed";
response.Payload = "Exception Occured";
}
}
else
{
var createTemplateQuestionsInfoInsert = new CreateTemplateQuestionInfo
{
description = TemplateInfo.description != null ? TemplateInfo.description : Constants.NA,
username = username,
title = req[0].title,
visible = Constants.NA,
type = TemplateInfo.type,
subType = TemplateInfo.subType,
creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture),
referenceId = refKey,
totalThreads = TemplateInfo.totalThreads,
completed = Constants.NA,
verified = Constants.NA,
payPerUser = TemplateInfo.amountEachThread
};
_db.CreateTemplateQuestionInfoes.Add(createTemplateQuestionsInfoInsert);
try
{
_db.SaveChanges();
CreateSubTemplateByRefKey CreateSubTemplateByRefKey = new CreateSubTemplateByRefKey();
CreateSubTemplateByRefKey.CreateSubTemplateByRefKeyService(req, username, refKey);
var signalRHub = new SignalRHub();
string totalProjects = new ProjectDAO().totalAvailableProjects();
string successRate = "";
string totalUsers = "";
string projectCategories = "";
var hubContext = GlobalHost.ConnectionManager.GetHubContext<SignalRHub>();
hubContext.Clients.All.updateBeforeLoginUserProjectDetails(totalProjects, successRate, totalUsers, projectCategories);
new SendNewTaskService().SendUserTaskNotificationToAllAsync(createTemplateQuestionsInfoInsert.title, "Total " + createTemplateQuestionsInfoInsert.totalThreads+" available",DateTime.Now);
response.Status = 200;
response.Message = "success-" + digitKey;
response.Payload = refKey;
}
catch (DbEntityValidationException e)
{
DbContextException.LogDbContextException(e);
response.Status = 500;
response.Message = "Failed";
response.Payload = "Exception Occured";
}
}
return response;
}
