public ActionResult ChangePassword(ViewModels.changePassword data) { if (data.Password != null) { if (data.Password == data.confirmPassword) { String username = ""; if (!AccountManager.IsUserInRole("student")) { int id = Int16.Parse(AccountManager.getId()); username = db.Teachers.Find(id).username; } else { String rollNo = AccountManager.getId(); username = db.Students.Find(rollNo).username; } Userinfo user = db.Userinfoes.Find(username); user.passwordHash = Cryptography.getMD5(data.Password); db.Set <Userinfo>().AddOrUpdate(user); db.SaveChanges(); return(RedirectToAction("index")); } else { ViewBag.warning = "Password Not Matched"; return(View()); } } else { ViewBag.warning = "Password can not be null"; return(View()); } }
// // GET: /AutoUI/TaskNoticeChang protected override void AfterGetData(DataTable dt, bool isNew, string upperVersionID) { if (isNew) { string ProjectInfoID = GetQueryString("ProjectInfoID"); if (!string.IsNullOrEmpty(ProjectInfoID)) { int maxNumber = 0; ProjectEntities epcentity = FormulaHelper.GetEntities <ProjectEntities>(); var ProjectInfo = epcentity.Set <T_CP_TaskNotice>().FirstOrDefault(a => a.ID == ProjectInfoID); var Projects = epcentity.Set <T_CP_TaskNoticeChange>().Where(c => c.ProjectInfoID == ProjectInfoID); if (Projects != null && Projects.Count() > 0) { maxNumber = Projects.ToList().Max(c => Convert.ToInt32(c.VersionNumber)); } maxNumber++; if (ProjectInfo != null) { Type tp = ProjectInfo.GetType(); var ps = tp.GetProperties(); DataRow dtr = dt.Rows[0]; foreach (PropertyInfo item in ps) { string cname = item.Name; string type = item.PropertyType.Name; if (type != "ICollection`1" && cname != "ProjectInfoID" && cname != "VersionNumber" && dt.Columns.Contains(cname)) { object value = item.GetValue(ProjectInfo, null); if (cname == "ID") { dtr.SetField("ProjectInfoID", value); } else { dtr.SetField(cname, value); } } } dtr.SetField("VersionNumber", maxNumber); } } } }
//supplementary method (not declared in interface) private void SaveDisbursementDetailsIntoDB(List <DisbursementDetail> tempDisbursementDetailList) { var q = tempDisbursementDetailList .GroupBy(ac => new { ac.DisbursementListId, ac.ItemNo, }) .Select(ac => new DisbursementDetail { DisbursementListId = (int)ac.Key.DisbursementListId, ItemNo = ac.Key.ItemNo, PreparedQuantity = ac.Sum(acs => acs.PreparedQuantity), DeliveredQuantity = ac.Sum(acs => acs.DeliveredQuantity) }); foreach (DisbursementDetail newDisbursementDetail in q.ToList()) { db.Set(typeof(DisbursementDetail)).Attach(newDisbursementDetail); db.DisbursementDetails.Add(newDisbursementDetail); db.SaveChanges(); } }
public virtual List <S_W_Activity> StartAuditFlow(T_AE_Audit auditForm, string auditFormUrl, List <S_E_Product> products, string wbsID) { var wbs = instanceEnitites.S_W_WBS.SingleOrDefault(d => d.ID == wbsID); if (wbs == null) { throw new Exception("未能找到ID为【" + wbsID + "】的WBS对象,无法执行校审"); } var project = instanceEnitites.S_I_ProjectInfo.SingleOrDefault(d => d.ID == wbs.ProjectInfoID); if (project == null) { throw new Exception("未能找到ID为【" + wbs.ProjectInfoID + "】的项目,无法执行校审"); } //为校审单设置默认值 SetAuditFormInfo(auditForm, wbs, project); //生成流程步骤及启动参数 var startParam = GetAuditFlowStartParam(auditForm, auditFormUrl, products, wbs, project); var service = AuditFlowServiceGenretor.CreateService(); List <S_W_Activity> list = service.StartAuditFlow(startParam); //设置校审单状态 auditForm.State = list[0].ActivityKey; var taskWork = wbs.S_W_TaskWork.FirstOrDefault(); //设置校审人员到表单 this.SetAuditUsers(auditForm, startParam.DefSteps, taskWork.DesignerUserID, taskWork.DesignerUserName); //设置成果属性 this.SetProductProperty(products, auditForm.ID, auditForm.State); instanceEnitites.T_AE_Audit.Add(auditForm); var designAct = list[0]; if (startParam.ExecNext) { var actType = ActivityType.Design.ToString(); designAct = instanceEnitites.Set <S_W_Activity>().FirstOrDefault(c => c.ActivityKey == actType && c.BusniessID == designAct.BusniessID); } SetAuditSignUser(designAct, products); return(list); }
public ActionResult Create(GuardianViewModel guardian) { if (ModelState.IsValid) { Guardian obj = new Guardian(); obj.guardianName = guardian.name; obj.mobileNumber = guardian.mobileNumber; obj.relationship = guardian.relationship; db.Guardians.Add(obj); db.SaveChanges(); int GuardianID = db.Guardians.Max(o => o.guardianID); Student std = db.Students.Find(guardian.rollNo); std.guardianID = GuardianID; db.Set <Student>().AddOrUpdate(std); db.SaveChanges(); return(RedirectToAction("index", "Students")); } return(View(guardian)); }
protected override void OnFlowEnd(T_CP_TaskNoticeChange ProjectInof, S_WF_InsTaskExec taskExec, S_WF_InsDefRouting routing) { ProjectEntities epcentity = FormulaHelper.GetEntities <ProjectEntities>(); string ProjectInfoID = ProjectInof.ProjectInfoID; var model = epcentity.Set <T_CP_TaskNotice>().FirstOrDefault(a => a.ID == ProjectInfoID); if (model != null) { model.FirstDesignManager = ProjectInof.FirstDesignManager; model.FirstDesignManagerName = ProjectInof.FirstDesignManagerName; model.FirstDesignManagerDept = ProjectInof.FirstDesignManagerDept; model.FirstDesignManagerDeptName = ProjectInof.FirstDesignManagerDeptName; model.SecondDesignManager = ProjectInof.SecondDesignManager; model.SecondDesignManagerName = ProjectInof.SecondDesignManagerName; model.ThirdDesignManager = ProjectInof.ThirdDesignManager; model.ThirdDesignManagerName = ProjectInof.ThirdDesignManagerName; model.DesignManagerAssistant = ProjectInof.DesignManagerAssistant; model.DesignManagerAssistantName = ProjectInof.DesignManagerAssistantName; epcentity.SaveChanges(); } }
public async Task <ActionResult> Edit(StudentViewModel student, HttpPostedFileBase upload) { if (ModelState.IsValid) { string un = ""; Student std = db.Students.Find(student.rollNo); if (std == null) { Userinfo user = new Userinfo(); if (db.Userinfoes.Find(student.username) != null) { ViewBag.userMsg = "Username already exist."; ViewBag.sessionID = new SelectList(db.Sessions, "sessionID", "name", student.sessionID); return(View(student)); } else if (student.password == null) { ViewBag.pswMsg = "Password can not be null"; ViewBag.sessionID = new SelectList(db.Sessions, "sessionID", "name", student.sessionID); return(View(student)); } else if (student.password != student.confirmPassword) { ViewBag.pswMsg = "Password are not same"; ViewBag.sessionID = new SelectList(db.Sessions, "sessionID", "name", student.sessionID); return(View(student)); } user.username = student.username; user.passwordHash = Cryptography.getMD5(student.password); user.token = Cryptography.getMD5(student.username) + Cryptography.getMD5(student.password); user.role = "student"; user.email = student.email; if (upload != null && upload.ContentLength > 0) { string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(student.rollNo + ".jpg")); upload.SaveAs(path); user.imagePath = "~/Images/" + student.rollNo + ".jpg"; } db.Userinfoes.Add(user); un = user.username; } else { Userinfo user = db.Userinfoes.Find(db.Students.Find(student.rollNo).username); if (student.password != null) { if (student.password != student.confirmPassword) { ViewBag.pswMsg = "Password are not same"; ViewBag.sessionID = new SelectList(db.Sessions, "sessionID", "name", student.sessionID); return(View(student)); } user.passwordHash = Cryptography.getMD5(student.password); user.token = Cryptography.getMD5(user.username) + Cryptography.getMD5(student.password); } user.email = student.email; if (upload != null && upload.ContentLength > 0) { string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(student.rollNo + ".jpg")); upload.SaveAs(path); user.imagePath = "~/Images/" + student.rollNo + ".jpg"; } un = user.username; db.Set <Userinfo>().AddOrUpdate(user); db.SaveChanges(); // db.Entry(user).State = EntityState.Modified; } std.rollNo = student.rollNo; std.fullName = student.firstName; std.username = un; std.fatherName = student.fatherName; std.sessionID = student.sessionID; db.Set <Student>().AddOrUpdate(std); //db.Entry(std).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.sessionID = new SelectList(db.Sessions, "sessionID", "name", student.sessionID); ViewBag.username = new SelectList(db.Userinfoes, "username", "password", student.username); return(View(student)); }
public GenericRepository(ProjectEntities context) { this.context = context; this.dbSet = context.Set <TEntity>(); }
public void Add(T entityToAdd) { _context.Set <T>().Add(entityToAdd); }