public ActionResult StartRoutine(int teachingRoutineID) { DateTime currDate = DateTime.Now.Date; int currUserID = CurrentUser.GetUserID(); using (FATContainer dataContainer = new FATContainer()) { TeachingRoutine tchRoutine = SharedCasePool.GetCasePool().GetRoutine(teachingRoutineID); TeachingNode firstNode = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]]; StudentActivity activity = dataContainer.StudentActivity.FirstOrDefault(act => (act.UserID == currUserID) && (act.TimeMark >= currDate) && (act.TchRoutineID == teachingRoutineID)); if (activity == null) { activity = dataContainer.StudentActivity.Create(); } activity.TchNodeID = firstNode.Row_ID; activity.IsFinished = 0; activity.TchRoutineID = teachingRoutineID; activity.UserID = CurrentUser.GetUserID(); activity.TimeMark = DateTime.Now.Date; if (activity.Row_ID == 0) { dataContainer.StudentActivity.Add(activity); dataContainer.SaveChanges(); } else { dataContainer.Entry <StudentActivity>(activity).CurrentValues.SetValues(activity); dataContainer.SaveChanges(); } JsonResult result = new JsonResult(); result.Data = string.Format("{0}/{1}/{2}", firstNode.NodeType, firstNode.NodeTag, firstNode.Row_ID); return(result); } }
public ActionResult GetNextNode(int teachingRoutineID, int teachingNodeID) { using (FATContainer dataContainer = new FATContainer()) { TeachingNode nextNode = SharedCasePool.GetCasePool().NavigateToNextNode(teachingRoutineID, teachingNodeID); StudentActivity activity = dataContainer.StudentActivity.FirstOrDefault(act => act.UserID == CurrentUser.GetUserID() && act.TimeMark == DateTime.Now.Date && act.TchRoutineID == teachingRoutineID); if (activity == null) { activity = dataContainer.StudentActivity.Create(); } JsonResult result = new JsonResult(); if (nextNode == null) { CurrentUser.SetLastFinishedRoutineID(teachingRoutineID); result.Data = "/Teachings/TeachingInit/SelectT1Case"; if (activity.Row_ID == 0) { activity.TchNodeID = -1; activity.IsFinished = 1; activity.TchRoutineID = teachingRoutineID; activity.UserID = CurrentUser.GetUserID(); activity.TimeMark = DateTime.Now.Date; dataContainer.StudentActivity.Add(activity); dataContainer.SaveChanges(); } else { activity.TchNodeID = -1; activity.IsFinished = 1; dataContainer.Entry <StudentActivity>(activity).CurrentValues.SetValues(activity); dataContainer.SaveChanges(); } } else { TeachingRoutine routine = SharedCasePool.GetCasePool().GetRoutine(teachingNodeID); if (routine.NodeList.Keys.IndexOf(activity.TchNodeID) < routine.NodeList.Keys.IndexOf(nextNode.Row_ID)) { activity.TchNodeID = nextNode.Row_ID; activity.IsFinished = 0; //dataContainer.Entry<StudentActivity>(activity).CurrentValues.SetValues(activity); dataContainer.SaveChanges(); } result.Data = string.Format("{0}/{1}/{2}", nextNode.NodeType, nextNode.NodeTag, nextNode.Row_ID); } return(result); } }
public ActionResult InitIndividualSavingData() { using (FATContainer dataContainer = new FATContainer()) { int tchRoutineID = Convert.ToInt32(RouteData.Values["tchRoutineID"]); TeachingRoutine routine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID); //all tags: DWHQ_Deposit DWHQ_Withdraw DWHQ_Interest DWHQ_Clear DWZZ_Deposit DWZZ_Withdraw DWLZ_Deposit DWLZ_Withdraw DWZL_Deposit DWZL_Withdraw DWZL_Interest DWTI_Deposit DWTI_Interest DWTI_Withdraw //Section controls which section should be displayed and filled ViewBag.Section = routine.RelTmpRoutine.RoutineTag.Split('_')[1]; IndividualSaving info = dataContainer.IndividualSaving.FirstOrDefault(item => (item.TchRoutineID == tchRoutineID)); if (info == null) { info = dataContainer.IndividualSaving.Create(); info.TchRoutineID = tchRoutineID; info.AccountCreateTime = DateTime.Now; info.DepositTime = DateTime.Now; info.WithdrawTime = DateTime.Now; info.InterestTime = DateTime.Now; dataContainer.IndividualSaving.Add(info); dataContainer.SaveChanges(); } return(View("IndividualSaving", info)); } }
public ActionResult AppendSubjectItem(SubjectItem subject) { using (FATContainer dbContainer = new FATContainer()) { dbContainer.SubjectItem.Add(subject); dbContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = subject; return(result); } }
public ActionResult DetailedLedger_Insert(DetailedLedger info) { using (FATContainer dataContainer = new FATContainer()) { dataContainer.DetailedLedger.Add(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult OuterSubject_Insert(OuterSubject info) { using (FATContainer dataContainer = new FATContainer()) { dataContainer.OuterSubject.Add(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult CashJournal_Insert(CashJournal info) { using (FATContainer dataContainer = new FATContainer()) { dataContainer.CashJournal.Add(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult AppendCase(TeachingRoutine routine) { using (FATContainer dataContainer = new FATContainer()) { dataContainer.TeachingRoutine.Add(routine); dataContainer.SaveChanges(); } JsonResult result = new JsonResult(); result.Data = routine; return(result); }
public ActionResult DetailedLedger_Update(DetailedLedger info) { using (FATContainer dataContainer = new FATContainer()) { DetailedLedger existedInfo = dataContainer.DetailedLedger.FirstOrDefault(item => item.Row_ID == info.Row_ID); dataContainer.Entry <DetailedLedger>(existedInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult DetailedLedger_Delete(int glRowID) { using (FATContainer dataContainer = new FATContainer()) { DetailedLedger dlInfo = dataContainer.DetailedLedger.FirstOrDefault(item => item.Row_ID == glRowID); dataContainer.DetailedLedger.Remove(dlInfo); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult OuterSubject_Update(OuterSubject info) { using (FATContainer dataContainer = new FATContainer()) { OuterSubject existedInfo = dataContainer.OuterSubject.FirstOrDefault(item => item.Row_ID == info.Row_ID); dataContainer.Entry <OuterSubject>(existedInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult OuterSubject_Delete(int glRowID) { using (FATContainer dataContainer = new FATContainer()) { OuterSubject osInfo = dataContainer.OuterSubject.FirstOrDefault(item => item.Row_ID == glRowID); dataContainer.OuterSubject.Remove(osInfo); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult CashJournal_Update(CashJournal info) { using (FATContainer dataContainer = new FATContainer()) { CashJournal existedInfo = dataContainer.CashJournal.FirstOrDefault(item => item.Row_ID == info.Row_ID); dataContainer.Entry <CashJournal>(existedInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult CashJournal_Delete(int glRowID) { using (FATContainer dataContainer = new FATContainer()) { CashJournal cjInfo = dataContainer.CashJournal.FirstOrDefault(item => item.Row_ID == glRowID); dataContainer.CashJournal.Remove(cjInfo); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult GeneralLedger_Delete(int glRowID) { using (FATContainer dataContainer = new FATContainer()) { GeneralLedger glInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == glRowID); dataContainer.GeneralLedger.Remove(glInfo); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = glInfo; return(result); } }
public ActionResult SaveDebitTransferCheckData(TransferCheck info) { using (FATContainer dataContainer = new FATContainer()) { TransferCheck orgInfo = dataContainer.TransferCheck.Find(info.Row_ID); dataContainer.Entry <TransferCheck>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult SaveMoneyRemittanceData(MoneyRemittance info) { using (FATContainer dataContainer = new FATContainer()) { MoneyRemittance orgInfo = dataContainer.MoneyRemittance.Find(info.Row_ID); dataContainer.Entry <MoneyRemittance>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult SaveBankDraftData(BankDraft info) { using (FATContainer dataContainer = new FATContainer()) { BankDraft orgInfo = dataContainer.BankDraft.Find(info.Row_ID); dataContainer.Entry <BankDraft>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult SaveIndividualSavingData(IndividualSaving info) { using (FATContainer dataContainer = new FATContainer()) { IndividualSaving orgInfo = dataContainer.IndividualSaving.Find(info.Row_ID); dataContainer.Entry <IndividualSaving>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult SaveCollectAcceptData(CollectAccept info) { using (FATContainer dataContainer = new FATContainer()) { CollectAccept orgInfo = dataContainer.CollectAccept.Find(info.Row_ID); dataContainer.Entry <CollectAccept>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult SaveEntrustCorpPaymentData(EntrustCorpPayment info) { using (FATContainer dataContainer = new FATContainer()) { EntrustCorpPayment orgInfo = dataContainer.EntrustCorpPayment.Find(info.Row_ID); dataContainer.Entry <EntrustCorpPayment>(orgInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = string.Empty; return(result); } }
public ActionResult DoRegister(FATUser user, string valCode) { JsonResult result = new JsonResult(); using (FATContainer dbContainer = new FATContainer()) { valCode = valCode.Trim(); ActivationCode existedCode = dbContainer.ActivationCode.FirstOrDefault(n => n.ActivateCode == valCode && n.CurrStatus == ConstDefine.ActivationCode_Status_Unused); if (existedCode == null) { result.Data = "激活码不存在或者已被使用"; return(result); } existedCode.CurrStatus = ConstDefine.ActivationCode_Status_Used; FATUser existedUser = dbContainer.FATUser.FirstOrDefault(n => n.UserCode == user.UserCode && n.School == user.School); if (existedUser != null) { result.Data = "用户登录名已存在"; return(result); } if ((user.Password.Length < 6) || (user.Password.Length > 15)) { result.Data = "密码必须在6-15位之间"; return(result); } user.UserCode = user.UserCode.Trim(); if (string.IsNullOrEmpty(user.UserCode)) { result.Data = "登录名不能为空"; return(result); } FATUser newUser = dbContainer.FATUser.Create(); newUser.UserCode = user.UserCode; newUser.School = user.School; newUser.UserName = user.UserName; newUser.IsStudent = 1; newUser.IsAdmin = 0; newUser.IsTeacher = 0; newUser.Password = user.Password; newUser.CurrStatus = ConstDefine.UserStatus_Valid; newUser.CreatedDate = DateTime.Now; dbContainer.FATUser.Add(newUser); dbContainer.SaveChanges(); CurrentUser.UserLogin(newUser); result.Data = string.Empty; return(result); } }
public ActionResult ChangeCaseStatus(bool isEnabled, int tchRoutineID) { using (FATContainer dataContainer = new FATContainer()) { TeachingRoutine cachedRoutine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID); cachedRoutine.CurrStatus = Convert.ToInt16(isEnabled ? 1 : 0); TeachingRoutine dbRoutine = dataContainer.TeachingRoutine.Find(tchRoutineID); dbRoutine.CurrStatus = cachedRoutine.CurrStatus; dataContainer.SaveChanges(); } return(null); }
public ActionResult UpdateCase(int tchRoutineID, string caseName, string caseText) { using (FATContainer dataContainer = new FATContainer()) { TeachingRoutine cachedRoutine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID); cachedRoutine.CaseName = caseName; TeachingRoutine dbRoutine = dataContainer.TeachingRoutine.Find(tchRoutineID); dataContainer.Entry <TeachingRoutine>(dbRoutine).CurrentValues.SetValues(cachedRoutine); dataContainer.SaveChanges(); } return(null); }
public ActionResult SaveT2RoutineData(List <TransferCheck> tcList) { using (FATContainer dataContainer = new FATContainer()) { foreach (TransferCheck tc in tcList) { TransferCheck orgInfo = dataContainer.TransferCheck.Find(tc.Row_ID); dataContainer.Entry <TransferCheck>(orgInfo).CurrentValues.SetValues(tc); } dataContainer.SaveChanges(); JsonResult result = new JsonResult(); return(result); } }
public ActionResult ResetRoutine(int activityID) { using (FATContainer dataContainer = new FATContainer()) { StudentActivity activity = dataContainer.StudentActivity.First(act => act.Row_ID == activityID); TeachingRoutine tchRoutine = SharedCasePool.GetCasePool().GetRoutine(activity.TchRoutineID); activity.IsFinished = 0; activity.TchNodeID = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]].Row_ID; dataContainer.SaveChanges(); JsonResult result = new JsonResult(); TeachingNode firstNode = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]]; result.Data = string.Format("{0}/{1}/{2}", firstNode.NodeType, firstNode.NodeTag, firstNode.Row_ID); return(result); } }
public ActionResult ImportUserList(string inputStr) { JsonResult importResult = new JsonResult(); importResult.Data = string.Empty; using (FATContainer dbContainer = new FATContainer()) { bool isAllProcessed = true; using (StreamReader textReader = new StreamReader(new MemoryStream(Encoding.UTF8.GetBytes(inputStr ?? "")))) { string newLine = string.Empty; int lineCount = 0; while ((newLine = textReader.ReadLine()) != null) { lineCount++; string[] splitArr = newLine.Split('\t'); if (splitArr.Length != 3) { isAllProcessed = false; importResult.Data = "第" + lineCount + "行数据读取失败"; break; } string importUName = splitArr[0]; FATUser existedUser = dbContainer.FATUser.FirstOrDefault(n => n.UserName == importUName); if (existedUser != null) { isAllProcessed = false; importResult.Data = "第" + lineCount + "行数据中的登录名已存在"; break; } existedUser = dbContainer.FATUser.Create(); existedUser.UserName = splitArr[0]; existedUser.IsStudent = Convert.ToInt16(splitArr[1]); existedUser.IsTeacher = Convert.ToInt16(splitArr[2]); existedUser.IsAdmin = 0; existedUser.CreatedDate = DateTime.Now; existedUser.CurrStatus = 1; existedUser.Password = "******"; dbContainer.FATUser.Add(existedUser); } } if (isAllProcessed) { dbContainer.SaveChanges(); } } return(importResult); }
public ActionResult DeleteSubjectItem(int dbRowID) { using (FATContainer dbContainer = new FATContainer()) { SubjectItem existedItem = dbContainer.SubjectItem.FirstOrDefault(item => item.Row_ID == dbRowID); if (existedItem == null) { return(null); } dbContainer.SubjectItem.Remove(existedItem); dbContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = "SUCC"; return(result); } }
public ActionResult UpdateSubjectItem(SubjectItem subject) { using (FATContainer dbContainer = new FATContainer()) { SubjectItem existedItem = dbContainer.SubjectItem.FirstOrDefault(item => item.Row_ID == subject.Row_ID); if (existedItem == null) { return(null); } dbContainer.Entry <SubjectItem>(existedItem).CurrentValues.SetValues(subject); dbContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = "SUCC"; return(result); } }
public ActionResult InitEntrustBankPaymentData() { using (FATContainer dataContainer = new FATContainer()) { int tchRoutineID = Convert.ToInt32(RouteData.Values["tchRoutineID"]); EntrustBankPayment info = dataContainer.EntrustBankPayment.FirstOrDefault(item => (item.TchRoutineID == tchRoutineID)); if (info == null) { info = dataContainer.EntrustBankPayment.Create(); info.TchRoutineID = tchRoutineID; info.EntrustDate = DateTime.Now; info.PaymentDate = DateTime.Now; dataContainer.EntrustBankPayment.Add(info); dataContainer.SaveChanges(); } return(View("EntrustBankPayment", info)); } }