public int Fullify(ModelProfession prof)
{
MySqlDB mySql = new MySqlDB();
string command = "INSERT INTO jeloltek (nev,email,telefon,reg_date" +
(!prof.szuldatum.Equals("") ? ",szuldatum" : "") +
(!prof.lakhely.Equals("") ? ",lakhely" : "") +
(!prof.neme.Equals(9999) ? ",neme": "") +
(!prof.vegzettseg.Equals(9999) ? ",vegz_terulet" : "") +
(!prof.nyelvtudas.Equals(9999) ? ",nyelvtudas" : "") +
(!prof.ertesult.Equals(9999) ? ",ertesult" : "")
+ ") VALUES ('" + prof.name + "','" + prof.email + "','" + prof.telephone + "','" + prof.reg_date + "'" +
(!prof.szuldatum.Equals("") ? ",'" + prof.szuldatum.ToString() + "'" : "") +
(!prof.lakhely.Equals("") ? ",'" + prof.lakhely.ToString() + "'" : "") +
(!prof.neme.Equals(9999) ? "," + prof.neme.ToString() : "") +
(!prof.vegzettseg.Equals(9999) ? "," + prof.vegzettseg.ToString() : "") +
(!prof.nyelvtudas.Equals(9999) ? "," + prof.nyelvtudas.ToString() : "") +
(!prof.ertesult.Equals(9999) ? "," + prof.ertesult.ToString() : "")
+ ")";
mySql.Execute(command);
mySql.Close();
ModelFullApplicant udata = Applicant.GetFullApplicantByEmail(prof.email);
DirectoryInfo profession = new DirectoryInfo(Files.GetStatisticsUrl() + prof.id);
DirectoryInfo newID = new DirectoryInfo(Files.GetApplicantUrl() + udata.id);
Files.CopyAll(profession, newID);
Delete(prof.id);
return(udata != null ? udata.id : 0);
}
protected ModelProfessionOperateModel PrepareOperateModel(ModelProfession modelProfession, List <Role> roles)
{
if (!roles.Contains(Role.Checker) && !roles.Contains(Role.Reviewer))
{
return(null);
}
if (modelProfession.EngineerFile.Engineering.Project.FileTime.HasValue)
{
return(null);
}
ModelProfessionOperateModel model = new ModelProfessionOperateModel();
model.ModelProfessionId = modelProfession.Id;
model.Status = modelProfession.Status;
model.Roles = roles;
if (roles.Contains(Role.Checker) && (modelProfession.Status == FlowCode.Pre_AuditCompany_ProjectManager_ConformComplate || modelProfession.Status == FlowCode.AuditCompany_ProfessionReaudit_Reject_ProfessionAudit || modelProfession.Status == FlowCode.AuditCompany_ProjectManager_Sign_BuildCompany))
{
model.CanCheckerSubmit = !new CommentService().HasAuditorNoAuditComment(modelProfession.ProfessionId, modelProfession.EngineeringFileId);
}
if (roles.Contains(Role.Reviewer) && modelProfession.Status == FlowCode.AuditCompany_ProfessionAudit_Submit)
{
model.CanReviewerSubmit = new CommentService().HasReaudorCanSubmitToProjectManagerComment(modelProfession.ProfessionId, modelProfession.EngineeringFileId);
model.CanReviewerReturn = !new CommentService().ReaudorHasNoOperationToProfessionAudit(modelProfession.ProfessionId, modelProfession.EngineeringFileId);
}
if (roles.Contains(Role.Reviewer) && modelProfession.Status == FlowCode.DesignCompany_Submit_AuditCompany_ProfessionReaudit)
{
model.CanReviewerSubmit = new CommentService().HasReaudorCanSubmitToProjectManagerComment(modelProfession.ProfessionId, modelProfession.EngineeringFileId);
}
return(model);
}
public ProfessionDataSheet(Grid grid, ModelProfession data)
{
this.data = data;
this.grid = grid;
this.DataContext = data;
InitializeComponent();
LoadUp();
}
public ActionResult GetBulkOperationButton(int modelVersionId, int professionId = 0)
{
var modelVersion = new FileVersionService().GetById(modelVersionId);
if (modelVersion == null)
{
throw new ArgumentNullException(nameof(modelVersion));
}
ModelProfession modelProfession = null;
if (professionId != 0)
{
modelProfession = modelVersion.ModelProfessions.OrderByDescending(e => e.Id).FirstOrDefault();
}
var model = new CommentBulkOperationButtonModel()
{
ModelStatus = modelVersion.Status,
ProfessionStatus = modelProfession?.Status,
};
if (CurrentCustomer.Organization.OrganizationType == OrganizationType.DesignCompany)
{
model.CustomerRole = Role.DesignCompanyManager;
}
else
{
if (professionId != 0)
{
model.CustomerRole = CurrentCustomer.CustomerRoles.FirstOrDefault(e => e.EngineeringId == modelVersion.EngineeringFile.EngineeringId && e.ProfessionId == professionId)?.Role;
}
}
return(Json(new { htmlStr = this.RenderPartialViewToString("_BulkOperationButton", model) }, JsonRequestBehavior.AllowGet));
}
