// [Route("api/assignProject/Edit")]
public int UpdateAssignProject([FromBody] AssignProject assignProject)
{
AssignProjectContext context = HttpContext.RequestServices.GetService(typeof(RMG.Models.AssignProjectContext)) as AssignProjectContext;
context.UpdateAssignProject(assignProject);
return(1);
}
// remove assigned project
public int Remove(int assignedId)
{
AssignProject assignProject = unitOfWork.AssignProject.Find(x => x.Id == assignedId && x.State == 1);
assignProject.State = 0;
unitOfWork.AssignProject.Update(assignProject);
int rowsAffected = unitOfWork.Complete();
return(rowsAffected);
}
protected void btnLoad_Click(object sender, EventArgs e)
{
String F_ID = Request.Params["id"].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
AssignProject project = dc.AssignProject.SingleOrDefault(_ap => _ap.F_projectID.Equals(ddlHistory.SelectedValue));
project.F_ID = F_ID;
dc.AssignProject.InsertOnSubmit(project);
LinqDataSource1.WhereParameters[0].DefaultValue = F_ID;
SmartGridView1.DataBind();
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
bool isNew = false;
DataClassesDataContext dc = new DataClassesDataContext();
ProjectDetail pd = dc.ProjectDetail.SingleOrDefault(_pd => _pd.F_ID.Equals(Request["id"]));
if (pd == null)
{
isNew = true;
pd = new ProjectDetail();
pd.F_ID = Request["id"].ToString();
var units = from m in dc.ApplicantUnit select m;
List <AssignProject> assignProjects = new List <AssignProject>();
foreach (ApplicantUnit unit in units)
{
AssignProject ap = new AssignProject();
ap.F_ID = Guid.NewGuid().ToString();
ap.F_sciB = 0;
ap.F_sciImp = 0;
ap.F_sciIndustry = 0;
ap.F_sciNormal = 0;
ap.F_socialB = 0;
ap.F_socialImpA = 0;
ap.F_socialNorA = 0;
ap.F_socialProxy = 0;
ap.F_amount = 0;
ap.F_projectID = pd.F_ID;
ap.F_unitID = unit.F_ID;
ap.F_unitName = unit.F_name;
ap.F_authro = false;
assignProjects.Add(ap);
}
dc.AssignProject.InsertAllOnSubmit(assignProjects);
}
pd.F_code = txtCode.Text;
pd.F_content = txtContent.Text;
pd.F_endDate = DateTime.Parse(txtEndDate.Text);
pd.F_startDate = DateTime.Parse(txtStartDate.Text);
pd.F_name = txtName.Text;
pd.F_source = txtSource.Text;
pd.F_schoolDeadline = DateTime.Parse(txtDeadLineOfSchool.Text);
if (isNew)
{
dc.ProjectDetail.InsertOnSubmit(pd);
}
dc.SubmitChanges();
Response.Write("<script>window.opener.location.reload(); window.close()</script>");
}
public bool UpdateAssignProject(AssignProject assignProject)
{
_context.Entry(assignProject).Property(x => x.courseId).IsModified = true;
_context.Entry(assignProject).Property(x => x.sectionId).IsModified = true;
_context.Entry(assignProject).Property(x => x.projectId).IsModified = true;
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool AvailToApply(EducationV2.SocialProject sp)
{
DataClassesDataContext dc = new DataClassesDataContext();
AssignProject assignProject = dc.AssignProject.SingleOrDefault(_ap => _ap.F_projectID.Equals(sp.F_guideProjectID) &&
_ap.F_unitID.Equals(sp.F_unitID));
int usedProjectCount = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(sp.F_guideProjectID) &&
_vad.F_type.Equals(sp.F_type) && sp.F_unitID.Equals(_vad.F_unitID));
int assignCount = 0;
switch (sp.F_type)
{
case "A类重点项目": assignCount = assignProject.F_socialImpA.Value; break;
case "一般项目": assignCount = assignProject.F_socialNorA.Value; break;
case "B类项目": assignCount = assignProject.F_socialB.Value; break;
case "委托项目": assignCount = assignProject.F_socialProxy.Value; break;
}
if (assignCount == -1 || sp.F_type.Equals("B类项目")) //-1或B类表示不限项，令可用项为最大值
{
assignCount = int.MaxValue;
}
if (assignCount <= usedProjectCount) //没有可用的项数
{
return(false);
}
if (assignProject.F_amount == -1) //经费不限,否则检查经费
{
return(true);
}
decimal?sumOfSocial = (from m in dc.ViewAuditedBySchool
where m.F_projectType.Equals("社科项目") && m.F_type.Equals("B类项目") == false && m.F_guideProjectID.Equals(sp.F_guideProjectID) && sp.F_unitID.Equals(m.F_unitID)
select m.F_fund).Sum();
decimal?sumOfSci = (from m in dc.ViewAuditedBySchool
where m.F_projectType.Equals("科技项目") && m.F_type.Equals("B类") == false && m.F_guideProjectID.Equals(sp.F_guideProjectID) && sp.F_unitID.Equals(m.F_unitID)
select m.F_fund).Sum();
if (sumOfSci + sumOfSocial + sp.F_Fund <= assignProject.F_amount) //经费足够
{
return(true);
}
return(false);
}
public static bool AvailToApply(ScienceProject sp)
{
DataClassesDataContext dc = new DataClassesDataContext();
AssignProject assignProject = dc.AssignProject.SingleOrDefault(_ap => _ap.F_projectID.Equals(sp.F_guideProjectID) &&
_ap.F_unitID.Equals(sp.F_unitID));
int usedProjectCount = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(sp.F_guideProjectID) &&
_vad.F_type.Equals(sp.F_type) && sp.F_unitID.Equals(_vad.F_unitID));
int assignCount = 0;
switch (sp.F_type)
{
case "重点": assignCount = assignProject.F_sciImp.Value; break;
case "产学研": assignCount = assignProject.F_sciIndustry.Value; break;
case "一般": assignCount = assignProject.F_sciNormal.Value; break;
case "B类": assignCount = assignProject.F_sciB.Value; break;
}
if (assignCount == -1 || sp.F_type.Equals("B类")) //-1或B类表示不限项，令可用项为最大值
{
assignCount = int.MaxValue;
}
if (assignCount <= usedProjectCount)
{
return(false);
}
if (assignProject.F_amount == -1)
{
return(true);
}
decimal?sumOfSci = (from m in dc.ViewAuditedBySchool
where m.F_projectType.Equals("科技项目") && m.F_type.Equals("B类") == false && m.F_guideProjectID.Equals(sp.F_guideProjectID) && sp.F_unitID.Equals(m.F_unitID)
select m.F_fund).Sum();
decimal?sumOfSocial = (from m in dc.ViewAuditedBySchool
where m.F_projectType.Equals("社科项目") && m.F_type.Equals("B类项目") == false && m.F_guideProjectID.Equals(sp.F_guideProjectID) && sp.F_unitID.Equals(m.F_unitID)
select m.F_fund).Sum();
if (sumOfSci + sumOfSocial + sp.F_totalFund <= assignProject.F_amount)
{
return(true);
}
return(false);
}
public IActionResult AssignProject(AssignProject assignProject)
{
var authData = HttpContext.Session.GetString("userInfo");
if (authData != "")
{
User user = JsonConvert.DeserializeObject <User>(authData);
if (userAccess.HasAccess(user.Id, 3, user.DesignationId))
{
if (ModelState.IsValid)
{
assignProject.State = 1;
ViewData["Message"] = assignProjectManager.Save(assignProject);
ViewBag.Users = userManager.GetUsersForDropDownForAssignProject();
ViewBag.Projects = projectManager.GetProjectsForDropDown();
ViewBag.AssignedUsers = assignProjectManager.GetAssignedUsers();
return(View());
}
else
{
ViewData["Message"] = Alert.AlertGenerate("Failed", "Failed", "Fill up all fields correctly");
ViewBag.Users = userManager.GetUsersForDropDownForAssignProject();
ViewBag.Projects = projectManager.GetProjectsForDropDown();
ViewBag.AssignedUsers = assignProjectManager.GetAssignedUsers();
return(View());
}
}
else
{
return(RedirectToAction("AccessDenied", "Home"));
}
}
else
{
HttpContext.Session.SetString("userInfo", "");
return(RedirectToAction("Login", "LogIn"));
}
}
// assign project to user
public string Save(AssignProject assignProject)
{
if (unitOfWork.AssignProject.IsExists(x =>
x.UserId == assignProject.UserId && x.ProjectId == assignProject.ProjectId && x.State == 1))
{
return(Alert.AlertGenerate("Falied", "Failed", "Already Project Assigned to Another User"));
}
else
{
unitOfWork.AssignProject.Add(assignProject);
int rowsAffected = unitOfWork.Complete();
if (rowsAffected > 0)
{
return(Alert.AlertGenerate("Success", "Success", "Project Assigned Successfully"));
}
else
{
return(Alert.AlertGenerate("Falied", "Failed", "Failed to Assigned Project"));
}
}
}
public void InsertAssignProject(AssignProject assignProject)
{
_context.AssignProject.Add(assignProject);
_context.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["retu"] = Request.UrlReferrer.ToString();
String unitID = Request["unitID"];
if (unitID == null)
{
unitID = Session[SessionMgm.UnitID].ToString();
String guideID = Request["guideID"];
auditedSocialProjects.SelectParameters["unitID"].DefaultValue = unitID;
SqlDataSource1.SelectParameters["unitID"].DefaultValue = unitID;
DataClassesDataContext dc = new DataClassesDataContext();
AssignProject ap = dc.AssignProject.SingleOrDefault(_ap => _ap.F_projectID.Equals(guideID) &&
_ap.F_unitID.Equals(unitID));
if (ap != null)
{
decimal amount = ap.F_amount.Value;
int sciB = ap.F_sciB.Value;
int sciImp = ap.F_sciImp.Value;
int sciInd = ap.F_sciIndustry.Value;
int sciNor = ap.F_sciNormal.Value;
int socImp = ap.F_socialImpA.Value;
int socNor = ap.F_socialNorA.Value;
int socProxy = ap.F_socialProxy.Value;
int socB = ap.F_socialB.Value;
labAmount.Text = amount.ToString();
labSciB.Text = sciB.ToString();
labSciImp.Text = sciImp.ToString();
labSciInd.Text = sciInd.ToString();
labSciNor.Text = sciNor.ToString();
labSocB.Text = socB.ToString();
labSocImp.Text = socImp.ToString();
labSocNor.Text = socNor.ToString();
labSocProxy.Text = socProxy.ToString();
int usedsciImp = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("重点") && unitID.Equals(_sp.F_unitID));
int usedsciInd = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("产学研") && unitID.Equals(_sp.F_unitID));
int usedsciNor = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("一般") && unitID.Equals(_sp.F_unitID));
int usedsciB = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("B类") && unitID.Equals(_sp.F_unitID));
int usedsocImp = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("A类重点项目") && unitID.Equals(_sp.F_unitID));
int usedsocNor = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("一般项目") && unitID.Equals(_sp.F_unitID));
int usedsocB = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("B类项目") && unitID.Equals(_sp.F_unitID));
int usedsocProxy = dc.ViewAuditedBySchool.Count(_sp => _sp.F_guideProjectID.Equals(guideID) && _sp.F_type.Equals("委托项目") && unitID.Equals(_sp.F_unitID));
decimal?sumOfSci = (from m in dc.ViewAuditedBySchool
where m.F_guideProjectID.Equals(guideID) && unitID.Equals(m.F_unitID) && "科技项目".Equals(m.F_projectType)
select m.F_fund).Sum();
decimal value1 = 0;
if (sumOfSci != null)
{
value1 = sumOfSci.Value;
}
decimal?sumOfSocial = (from m in dc.ViewAuditedBySchool
where m.F_guideProjectID.Equals(guideID) && unitID.Equals(m.F_unitID) && "社科项目".Equals(m.F_projectType)
select m.F_fund).Sum();
decimal value2 = 0;
if (sumOfSocial != null)
{
value2 = sumOfSocial.Value;
}
decimal usedamount = value1 + value2;
labUseAmount.Text = usedamount.ToString();
labUseSciB.Text = usedsciB.ToString();
labUseSciImp.Text = usedsciImp.ToString();
labUseSciInd.Text = usedsciInd.ToString();
labUseSciNor.Text = usedsciNor.ToString();
labUseSocB.Text = usedsocB.ToString();
labUseSocImp.Text = usedsocImp.ToString();
labUseSocNor.Text = usedsocNor.ToString();
labUseSocProxy.Text = usedsocProxy.ToString();
labRemAmount.Text = (amount - usedamount).ToString();
labRemB.Text = (socB - usedsocB).ToString();
labRemNor.Text = (socNor - usedsocNor).ToString();
labRemProxy.Text = (socProxy - usedsocProxy).ToString();
labRemSocImp.Text = (socImp - usedsocImp).ToString();
labRemSciB.Text = (sciB - usedsciB).ToString();
labRemSciImp.Text = (sciImp - usedsciImp).ToString();
labRemSciInd.Text = (sciInd - usedsciInd).ToString();
labRemSciNor.Text = (sciNor - usedsciNor).ToString();
}
}
gvSocial.DataBind();
SmartGridView3.DataBind();
}
}
