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 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 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 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 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 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 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 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 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 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 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 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 UpdateCase(int tchRoutineID, string caseName)
{
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();
}
SharedCasePool.GetCasePool().ReloadRoutine(tchRoutineID);
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}