public ActionResult ListProject(int major = -1, string title = "", string listSkill = "", bool space = false, int page = 1)
{
if (!User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Account"));
}
var accID = int.Parse(User.Identity.Name);
var acc = new AccountDao().FindAccountById(accID);
var proDao = new ProjectDao();
var model = new ModelProject();
var arr = listSkill.Split('-');
var list = new List <int>();
if (listSkill != "")
{
foreach (var item in arr)
{
list.Add(int.Parse(item));
}
}
ViewBag.ListMajor = new JobMajorDao().ListJobMain();
ViewBag.ListSkill = new JobMajorDao().ListJobSub();
ViewBag.UserID = acc.UserId;
model.ListFull = proDao.FindBySearch(major, title, list, space);
model.ListUserCreate = proDao.ListByUserCreate(acc.UserId);
model.ListUserJoin = proDao.ListByUserJoin(acc.UserId);
return(View(model));
}
public async Task <IActionResult> Edit(int id, [Bind("ModelProjectId,ModelName,ModelDescription")] ModelProject modelProject)
{
if (id != modelProject.ModelProjectId)
{
ModelState.AddModelError("", "Invalid ID, please try again.");
}
if (ModelState.IsValid)
{
try
{
_context.Update(modelProject);
await _context.SaveChangesAsync();
TempData["message"] = "The record has been successfully updated";
}
catch (DbUpdateConcurrencyException)
{
if (!ModelProjectExists(modelProject.ModelProjectId))
{
ModelState.AddModelError("", "The record does not exist, try again");
}
else
{
ModelState.AddModelError("", "This record has already been updated");
}
}
catch (Exception e)
{
ModelState.AddModelError("", $"Error on Edit: {e.GetBaseException().Message}");
}
return(RedirectToAction(nameof(Index)));
}
return(View(modelProject));
}
public List <ModelCategory> GetAllCategory(ModelProject selectedProject)
{
List <ModelCategory> aryResult = new List <ModelCategory>();
DataTable tbResult = null;
UDataQuerySet set = new UDataQuerySet("SP_CAT_SELECT", CommandType.StoredProcedure);
set.AddParam("@PRJID", selectedProject.ID);
try
{
tbResult = m_agent.GetDataTable(set);
foreach (DataRow row in tbResult.Rows)
{
ModelCategory category = new ModelCategory();
category.WriteData(row);
aryResult.Add(category);
}
}
catch (Exception ex)
{
log.Error(ex);
}
finally
{
if (tbResult != null)
{
tbResult.Dispose();
}
}
return(aryResult);
}
public async Task <IActionResult> Edit(int id, [Bind("ModelProjectId,ModelName,ModelDescription")] ModelProject modelProject)
{
if (id != modelProject.ModelProjectId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(modelProject);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ModelProjectExists(modelProject.ModelProjectId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(modelProject));
}
public List <ModelProject> GetAllProject()
{
List <ModelProject> aryResult = new List <ModelProject>();
UDataQuerySet set = new UDataQuerySet("SELECT ID ,PRJNM,DESCRPT ,ENABLED FROM TB_PROJECTS WHERE ENABLED = 'Y'");
DataTable tbResult = null;
try
{
tbResult = m_agent.GetDataTable(set);
foreach (DataRow row in tbResult.Rows)
{
ModelProject project = new ModelProject();
project.WriteData(row);
aryResult.Add(project);
}
}
catch (Exception ex)
{
}
finally
{
if (tbResult != null)
{
tbResult.Dispose();
}
}
return(aryResult);
}
private static string GenerateModelProjectFileContent(bool includeLightGbmPackage, bool includeMklComponentsPackage, bool includeFastTreePackage)
{
ModelProject modelProject = new ModelProject()
{
IncludeLightGBMPackage = includeLightGbmPackage, IncludeMklComponentsPackage = includeMklComponentsPackage, IncludeFastTreePackage = includeFastTreePackage
};
return(modelProject.TransformText());
}
public void Load()
{
ModelProject selectedProject = m_parent.SelectedProject;
if (selectedProject != null)
{
m_aryAllRequirements = DacFactory.Current.Requiremnt.GetAllRequirements(selectedProject, m_parent.Category.AllCategories);
}
}
public void Load()
{
ModelProject selectedProject = m_parent.SelectedProject;
if (selectedProject != null)
{
AllCategories = DacFactory.Current.Category.GetAllCategory(selectedProject);
MakeHeirachy();
}
}
internal List <ModelReqmnt> GetAllRequirements(ModelProject selectedProject, List <ModelCategory> aryAllCategory)
{
List <ModelReqmnt> aryResult = new List <ModelReqmnt>();
DataTable tbResult = null;
DataTable tbResultRemark = null;
UDataQuerySet set = new UDataQuerySet("SP_REQ_SELECT", CommandType.StoredProcedure);
set.AddParam("@PRJID", selectedProject.ID);
UDataQuerySet setRemark = new UDataQuerySet("SP_REQ_REMARK_SELECT", CommandType.StoredProcedure);
setRemark.AddParam("@PRJID", selectedProject.ID);
try
{
tbResult = m_agent.GetDataTable(set);
tbResultRemark = m_agent.GetDataTable(setRemark);
foreach (DataRow row in tbResult.Rows)
{
ModelReqmnt req = new ModelReqmnt();
req.WriteData(row);
req.Category = aryAllCategory.Find(m => m.Id == req.CategoryIdFromDB);
aryResult.Add(req);
DataRow[] aryRemarks = tbResultRemark.Select(string.Format("REQID = {0}", req.Id));
foreach (DataRow rowRemark in aryRemarks)
{
ModelRemark remark = new ModelRemark();
remark.WriteData(rowRemark);
req.AllRemark.Add(remark);
}
}
}
catch (Exception ex)
{
log.Error(ex);
}
finally
{
if (tbResult != null)
{
tbResult.Dispose();
}
if (tbResultRemark != null)
{
tbResultRemark.Dispose();
}
}
return(aryResult);
}
private void btnOpen_Click(object sender, EventArgs e)
{
int nSelectedIndex = cmbProjects.SelectedIndex;
if (nSelectedIndex > -1)
{
ModelProject selectedProject = cmbProjects.Items[nSelectedIndex] as ModelProject;
DataManager.Current.SetProject(selectedProject);
Application.UserAppDataRegistry.SetValue("LASTDBNAME", txtConnectionString.Text);
Application.UserAppDataRegistry.SetValue("LASTPROJECT", selectedProject.ID);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
private static string GenerateModelProjectFileContent(bool includeLightGbmPackage,
bool includeMklComponentsPackage, bool includeFastTreePackage, bool includeImageTransformerPackage,
bool includeImageClassificationPackage, bool includeRecommenderPackage,
string stablePackageVersion, string unstablePackageVersion)
{
ModelProject modelProject = new ModelProject()
{
IncludeLightGBMPackage = includeLightGbmPackage,
IncludeMklComponentsPackage = includeMklComponentsPackage,
IncludeFastTreePackage = includeFastTreePackage,
IncludeImageTransformerPackage = includeImageTransformerPackage,
IncludeImageClassificationPackage = includeImageClassificationPackage,
IncludeRecommenderPackage = includeRecommenderPackage,
StablePackageVersion = stablePackageVersion,
UnstablePackageVersion = unstablePackageVersion
};
return(modelProject.TransformText());
}
private void RefreshProject()
{
List<ModelProject> aryProject = DacFactory.Current.Project.GetAllProject();
if (aryProject.Count > 0)
{
cmbProjects.DataSource = aryProject;
cmbProjects.DisplayMember = "ProjectName";
ModelProject prevProject = aryProject.Find(m => m.ID == m_nSelectedProjectID);
if (prevProject != null)
{
int nIndex = aryProject.IndexOf(prevProject);
cmbProjects.SelectedIndex = nIndex;
}
btnConnect.Enabled = false;
btnOpen.Enabled = true;
btnCancel.Enabled = true;
cmbProjects.Enabled = true;
}
}
private string GenerateModelProjectFileContent(bool includeLightGbmPackage,
bool includeMklComponentsPackage, bool includeFastTreePackage, bool includeImageTransformerPackage,
bool includeImageClassificationPackage, bool includeRecommenderPackage, bool includeOnnxModel,
string stablePackageVersion, string unstablePackageVersion, GenerateTarget target)
{
ModelProject modelProject = new ModelProject()
{
IncludeLightGBMPackage = includeLightGbmPackage,
IncludeMklComponentsPackage = includeMklComponentsPackage,
IncludeFastTreePackage = includeFastTreePackage,
IncludeImageTransformerPackage = includeImageTransformerPackage,
IncludeImageClassificationPackage = includeImageClassificationPackage,
IncludeOnnxModel = includeOnnxModel,
IncludeRecommenderPackage = includeRecommenderPackage,
StablePackageVersion = stablePackageVersion,
UnstablePackageVersion = unstablePackageVersion,
OnnxRuntimePackageVersion = _settings.OnnxRuntimePacakgeVersion,
Target = target,
};
return(modelProject.TransformText());
}
public void SetProject(ModelProject project)
{
SelectedProject = project;
Reload();
}
