public async Task <IActionResult> Edit(int id, [Bind("ExerciseID,ExerciseName,Details,Duration,NumberOfSet,ExerciseTypeID")] ExerciseInfo exerciseInfo)
{
if (id != exerciseInfo.ExerciseID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(exerciseInfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ExerciseInfoExists(exerciseInfo.ExerciseID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ExerciseTypeID"] = new SelectList(_context.ExerciseTypes, "ExerciseTypeID", "ExerciseTypeName", exerciseInfo.ExerciseTypeID);
return(View(exerciseInfo));
}
public static ExerciseInfo ExerciseInfo_GetListen(int model)
{
var v = new ExerciseInfo();
v.ExerciseID = model;
return(new ExerciseBLL().ExerciseInfo_GetListen(v));
}
private static ExerciseInfo ExerciseBind(DataRow dr)
{
ExerciseInfo exercise = new ExerciseInfo()
{
exercisecommon = new ExerciseCommon()
{
exercise = new Exercise()
}
};
exercise.exercisecommon.exercise.CreateUserID = IES.Service.UserService.CurrentUser.UserID;
exercise.exercisecommon.exercise.CreateUserName = IES.Service.UserService.CurrentUser.UserName;
exercise.exercisecommon.exercise.Diffcult = Convert.ToInt32(dr["难易程度"]);
if (dr["适用范围"] != null)
{
exercise.exercisecommon.exercise.Scope = Convert.ToInt32(dr["适用范围"].ToString());
}
if (!string.IsNullOrEmpty(dr["关键字"].ToString().Trim()))
{
exercise.exercisecommon.exercise.Keys = dr["关键字"].ToString().Replace(",", "wshgkjqbwhfbxlfrh");
exercise.exercisecommon.exercise.Keys += "wshgkjqbwhfbxlfrh";
}
if (!string.IsNullOrEmpty(dr["知识点"].ToString()))
{
exercise.exercisecommon.exercise.Keys = dr["知识点"].ToString().Replace(",", "wshgkjqbwhfbxlfrh");
exercise.exercisecommon.exercise.Keys += "wshgkjqbwhfbxlfrh";
}
return(exercise);
}
public static ExerciseInfo Exercise_Line_S_Edit(string model)
{
ExerciseInfo v = Newtonsoft.Json.JsonConvert.DeserializeObject <ExerciseInfo>(model);
v.exercisecommon.exercise.CreateUserID = IES.Service.UserService.CurrentUser.UserID;
v.exercisecommon.exercise.CreateUserName = IES.Service.UserService.CurrentUser.UserName;
return(new ExerciseBLL().Exercise_Line_S_Edit(v));
}
private static DataTable ExerciseImportC(DataTable dt, int ocid, int courseId, int exerciseType)
{
DataTable resultTable = BuildResultTable();
if (dt.Rows.Count == 0)
{
return(resultTable);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var newRow = resultTable.NewRow();
resultTable.Rows.Add(newRow);
try
{
string content = "";
ExerciseInfo exercise = ExerciseBind(dt.Rows[i]);
exercise.exercisecommon.exercise.OCID = ocid;
exercise.exercisecommon.exercise.CourseID = courseId;
exercise.exercisecommon.exercise.Conten = dt.Rows[i]["习题内容"].ToString();
exercise.exercisecommon.exercise.Analysis = dt.Rows[i]["习题解析"].ToString();
exercise.exercisecommon.exercise.ExerciseType = exerciseType;
exercise.exercisecommon.exercise.ExerciseTypeName = GetExerciseTypeName(exerciseType);
for (int n = 0; n < 6; n++)
{
if (string.IsNullOrEmpty(dt.Rows[i]["答案" + (n + 1)].ToString()))
{
continue;
}
string alternative = dt.Rows[i]["答案" + (n + 1) + "（备选）"].ToString() == "" ? ((char)32).ToString() : dt.Rows[i]["答案" + (n + 1) + "（备选）"].ToString();
//判断下一题是不是空
if (!string.IsNullOrEmpty(dt.Rows[i]["答案" + (n + 2)].ToString()))
{
content += "0wshgkjqbwhfbxlfrh_b" + dt.Rows[i]["答案" + (n + 1)].ToString()
+ "wshgkjqbwhfbxlfrh_c" + alternative + "wshgkjqbwhfbxlfrh_a";
}
else
{
content += "0wshgkjqbwhfbxlfrh_b" + dt.Rows[i]["答案" + (n + 1)].ToString()
+ "wshgkjqbwhfbxlfrh_c" + alternative;
//if (!string.IsNullOrEmpty(alternative.Trim()))
}
}
exercise.exercisecommon.exercise.Content = content;
Exercise_FillInBlanks_M_Edit(Newtonsoft.Json.JsonConvert.SerializeObject(exercise));
newRow["Message"] = "导入成功";
newRow["Status"] = "1";
}
catch (Exception ex)
{
newRow["Message"] = ex.Message;
newRow["Status"] = "-2";
}
newRow["RowNumber"] = i.ToString();
}
return(resultTable);
}
public static ExerciseInfo Exercise_Model_Info_Get()
{
ExerciseInfo info = new ExerciseInfo();
info.exercisechoicelist = new List <ExerciseChoice>();
info.exercisecommon = new ExerciseCommon()
{
kenlist = new List <Ken>(),
keylist = new List <Key>(),
exercise = new IES.Resource.Model.Exercise(),
attachmentlist = new List <Attachment>()
};
//单选
info.Children = new List <ExerciseInfo>();
info.Children.Add(new ExerciseInfo()
{
exercisechoicelist = new List <ExerciseChoice>(),
exercisecommon = new ExerciseCommon()
{
kenlist = new List <Ken>(),
keylist = new List <Key>(),
exercise = new IES.Resource.Model.Exercise(),
attachmentlist = new List <Attachment>()
}
});
//多选
info.ChildrenMultiple = new List <ExerciseInfo>();
info.ChildrenMultiple.Add(new ExerciseInfo()
{
exercisechoicelist = new List <ExerciseChoice>(),
exercisecommon = new ExerciseCommon()
{
kenlist = new List <Ken>(),
keylist = new List <Key>(),
exercise = new IES.Resource.Model.Exercise(),
attachmentlist = new List <Attachment>()
}
});
//填空
info.ChildrenFillBlank = new List <ExerciseInfo>();
info.ChildrenFillBlank.Add(new ExerciseInfo()
{
exercisechoicelist = new List <ExerciseChoice>(),
exercisecommon = new ExerciseCommon()
{
kenlist = new List <Ken>(),
keylist = new List <Key>(),
exercise = new IES.Resource.Model.Exercise(),
attachmentlist = new List <Attachment>()
}
});
return(info);
}
public async Task <IActionResult> Create([Bind("ExerciseID,ExerciseName,Details,Duration,NumberOfSet,ExerciseTypeID")] ExerciseInfo exerciseInfo)
{
if (ModelState.IsValid)
{
_context.Add(exerciseInfo);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ExerciseTypeID"] = new SelectList(_context.ExerciseTypes, "ExerciseTypeID", "ExerciseTypeName", exerciseInfo.ExerciseTypeID);
return(View(exerciseInfo));
}
public ExerciseInfo Exercise_Custom_M_Edit(ExerciseInfo model)
{
try
{
ExerciseDAL.Exercise_Custom_M_Edit(model);
return(model);
}
catch (Exception e)
{
return(null);
}
}
public static ExerciseInfo Exercise_Custom_M_Edit(string model)
{
ExerciseInfo v = Newtonsoft.Json.JsonConvert.DeserializeObject <ExerciseInfo>(model);
v.exercisecommon.exercise.CreateUserID = IES.Service.UserService.CurrentUser.UserID;
v.exercisecommon.exercise.CreateUserName = IES.Service.UserService.CurrentUser.UserName;
ExerciseInfo exerciseRs = new ExerciseBLL().Exercise_Custom_M_Edit(v);
if (exerciseRs != null)
{
foreach (var item in v.Children)
{
if (item.exercisecommon.exercise.ExerciseType != 0)
{
item.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
new ExerciseBLL().Exercise_MultipleChoice_M_Edit(item);
}
}
foreach (var item in v.ChildrenMultiple)
{
if (item.exercisecommon.exercise.ExerciseType != 0)
{
item.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
new ExerciseBLL().Exercise_MultipleChoice_M_Edit(item);
}
}
foreach (var item in v.ChildrenFillBlank)
{
if (item.exercisecommon.exercise.ExerciseType != 0)
{
item.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
new ExerciseBLL().Exercise_Writing_M_Edit(item);
}
}
//if (v.Children.exercisecommon.exercise.ExerciseType != 0)
//{
// v.Children.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
// new ExerciseBLL().Exercise_MultipleChoice_M_Edit(v.Children);
//}
//if (v.ChildrenMultiple.exercisecommon.exercise.ExerciseType != 0)
//{
// v.ChildrenMultiple.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
// new ExerciseBLL().Exercise_MultipleChoice_M_Edit(v.ChildrenMultiple);
//}
//if (v.ChildrenFillBlank.exercisecommon.exercise.ExerciseType != 0)
//{
// v.ChildrenFillBlank.exercisecommon.exercise.ParentID = v.exercisecommon.exercise.ExerciseID;
// new ExerciseBLL().Exercise_Writing_M_Edit(v.ChildrenFillBlank);
//}
}
return(exerciseRs);
}
public ExerciseInfo Exercise_MultipleChoice_M_Edit(ExerciseInfo model)
{
try
{
ExerciseDAL.Exercise_MultipleChoice_M_Edit(model);
ExerciseDAL.Exercise_MultipleChoice_S_Edit(model);
return(model);
}
catch (Exception e)
{
return(null);
}
}
public ExerciseInfo Exercise_Analysis_M_Edit(ExerciseInfo model)
{
try
{
ExerciseDAL.Exercise_Analysis_M_Edit(model);
ExerciseDAL.Exercise_Analysis_S_Edit(model);
return(model);
}
catch (Exception e)
{
return(null);
}
}
private string getExerciseName(int id)
{
if (id < 1000)
{
var json = new WebClient().DownloadString("https://wger.de/api/v2/exerciseinfo/" + id);
ExerciseInfo ex = JsonConvert.DeserializeObject <ExerciseInfo>(json);
return(ex.name);
}
else
{
var ex = _context.UserEx.FirstOrDefault(x => x.id == id);
return(ex.name);
}
}
public ExerciseInfo Exercise_Judge_M_Edit(ExerciseInfo model)
{
try
{
ExerciseDAL.Exercise_Judge_M_Edit(model);
if (model.exercisecommon.exercise.ExerciseType != 1)
{
ExerciseDAL.Exercise_MultipleChoice_S_Edit(model);
}
return(model);
}
catch (Exception e)
{
return(null);
}
}
private static bool LoadExercise(Dictionary <int, ExerciseInfo> Exercise)
{
using (PlayerBussiness playerBussiness = new PlayerBussiness())
{
ExerciseInfo[] allExercise = playerBussiness.GetAllExercise();
ExerciseInfo[] array = allExercise;
for (int i = 0; i < array.Length; i++)
{
ExerciseInfo exerciseInfo = array[i];
if (!Exercise.ContainsKey(exerciseInfo.Grage))
{
Exercise.Add(exerciseInfo.Grage, exerciseInfo);
}
}
}
return(true);
}
private static ExerciseInfo ExerciseBind(DataRow dr)
{
ExerciseInfo exercise;
string[] Keys;
string[] Kens;
int scope = 0;
string key = "";
string ken = "";
exercise = new ExerciseInfo();
exercise.exercisecommon.exercise.CreateUserID = IES.Service.UserService.CurrentUser.UserID;
exercise.exercisecommon.exercise.CreateUserName = IES.Service.UserService.CurrentUser.UserName;
exercise.exercisecommon.exercise.Diffcult = Convert.ToInt32(dr["难易程度"]);
//exercise.exercisecommon.exercise.ShareRange = Convert.ToInt32(dr["ShareRange"]);
//exercise.exercisecommon.exercise.OCID = Convert.ToInt32(dr["OCID"]);
//exercise.exercisecommon.exercise.CourseID = Convert.ToInt32(dr["CourseID"]);
//exercise.exercisecommon.exercise.Chapter = Convert.ToInt32(dr["Chapter"]);
if (dr["适用范围"] != null)
{
scope += Convert.ToInt32(dr["适用范围"].ToString());
}
if (dr["关键字"] != null)
{
Keys = dr["关键字"].ToString().Split(',');
for (int i = 0; i < Keys.Length; i++)
{
key += Keys.GetValue(i).ToString() + "wshgkjqbwhfbxlfrh";
}
}
if (dr["知识点"] != null)
{
Kens = dr["知识点"].ToString().Split(',');
for (int i = 0; i < Kens.Length; i++)
{
ken += Kens.GetValue(i).ToString() + "wshgkjqbwhfbxlfrh";
}
}
return(exercise);
}
/// <summary>
/// 问答题、写作题信息维护(线下作业添加为简答题)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Exercise_Writing_M_Edit(ExerciseInfo model)
{
try
{
using (var conn = DbHelper.ResourceService())
{
var p = new DynamicParameters();
p.Add("@ExerciseID", dbType: DbType.Int32, direction: ParameterDirection.InputOutput, value: model.exercisecommon.exercise.ExerciseID);
p.Add("@OCID", model.exercisecommon.exercise.OCID);
p.Add("@CourseID", model.exercisecommon.exercise.CourseID);
p.Add("@OwnerUserID", model.exercisecommon.exercise.OwnerUserID);
p.Add("@CreateUserID", model.exercisecommon.exercise.CreateUserID);
p.Add("@CreateUserName", model.exercisecommon.exercise.CreateUserName);
p.Add("@ExerciseType", model.exercisecommon.exercise.ExerciseType);
p.Add("@ExerciseTypeName", model.exercisecommon.exercise.ExerciseTypeName);
p.Add("@Diffcult", model.exercisecommon.exercise.Diffcult);
p.Add("@Scope", model.exercisecommon.exercise.Scope);
p.Add("@ShareRange", model.exercisecommon.exercise.ShareRange);
p.Add("@Keys", model.exercisecommon.exercise.Keys);
p.Add("@Kens", model.exercisecommon.exercise.Kens);
p.Add("@Conten", model.exercisecommon.exercise.Conten);
p.Add("@Analysis", model.exercisecommon.exercise.Analysis);
p.Add("@Answer", model.exercisecommon.exercise.Answer);
p.Add("@ScorePoint", model.exercisecommon.exercise.ScorePoint);
p.Add("@ParentID", model.exercisecommon.exercise.ParentID);
conn.Execute("Exercise_Writing_M_Edit", p, commandType: CommandType.StoredProcedure);
model.exercisecommon.exercise.ExerciseID = p.Get<int>("ExerciseID");
return model.exercisecommon.exercise.ExerciseID;
}
}
catch (Exception)
{
return 0;
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
Boolean isCountable = true;
string info, label;
int setsAmount = 0;
trainingDone newDone = new trainingDone();
List <string> setDetails = new List <string>();
foreach (FlowLayoutPanel flp in panelBig.Controls)
{
info = "";
label = "";
setDetails.Clear();
foreach (Control ctrl in flp.Controls)
{
if (ctrl is TextBox)
{
if (ctrl.Text != "")
{
//info += ctrl.Text + "|";
setDetails.Add(ctrl.Text);
setsAmount++;
}
}
if (ctrl is Label)
{
label = ctrl.Text;
}
}
IQueryable <Exercise> exName =
from ex in FPdatabase.Exercise
where ex.name == label
select ex;
IQueryable <TE> exercise =
from te in FPdatabase.TE
where te.trainingID == training.trainingID && te.exerciseID == exName.FirstOrDefault().exerciseID
select te;
if (setDetails.Count() != 0)
{
for (int i = 0; i < setDetails.Count(); i++)
{
info += setDetails[i] + "|";
}
var exerciseToUpdate = exName.SingleOrDefault();
exerciseToUpdate.lastInfo = info;
FPdatabase.SubmitChanges();
ExerciseInfo exInfo = new ExerciseInfo
{
setsAmount = setsAmount
};
exInfo.trainingDone = newDone;
exInfo.TE = exercise.AsEnumerable().LastOrDefault();
FPdatabase.ExerciseInfo.InsertOnSubmit(exInfo);
FPdatabase.SubmitChanges();
for (int i = 0; i < setDetails.Count(); i++)
{
ExerciseDetail exDetail = new ExerciseDetail
{
setNumber = i + 1,
ExerciseInfo = exInfo,
setInfo = setDetails[i]
};
FPdatabase.ExerciseDetail.InsertOnSubmit(exDetail);
FPdatabase.SubmitChanges();
}
isCountable = true;
}
}
if (isCountable)
{
string comment = textBox1.Text;
newDone.date = DateTime.Today;
newDone.trainingID = training.trainingID;
//newDone.Training = training;
if (comment == "" || comment == "Type here...")
{
newDone.comment = "none";
}
else
{
newDone.comment = comment;
}
FPdatabase.SubmitChanges();
MessageBox.Show("Congratulations! You have succesfully finished training!", "Congrats!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("You didn't do anything!", "??", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
Boolean isCountable = true;
string info, label;
//int counter;
foreach (FlowLayoutPanel flp in panelBig.Controls)
{
info = "";
label = "";
//counter = 0;
foreach (Control ctrl in flp.Controls)
{
if (ctrl is TextBox)
{
//counter++;
if (ctrl.Text != "")
{
info += ctrl.Text + "|";
}
}
if (ctrl is Label)
{
label = ctrl.Text;
}
}
IQueryable <Exercise> exName =
from ex in FPdatabase.Exercise
where ex.name == label
select ex;
IQueryable <TE> exercise =
from te in FPdatabase.TE
where te.trainingID == training.trainingID && te.exerciseID == exName.FirstOrDefault().exerciseID
select te;
if (info != "")
{
var exerciseToUpdate = exName.SingleOrDefault();
exerciseToUpdate.lastInfo = info;
FPdatabase.SubmitChanges();
ExerciseInfo exInfo = new ExerciseInfo
{
info = info,
randomPK = exercise.AsEnumerable().LastOrDefault().randomPK,
};
var lastDone = (from ld in FPdatabase.trainingDone select ld).AsEnumerable().LastOrDefault();
if (lastDone == null)
{
exInfo.doneID = 1;
}
else
{
exInfo.doneID = lastDone.doneID + 1;
}
FPdatabase.ExerciseInfo.InsertOnSubmit(exInfo);
FPdatabase.SubmitChanges();
isCountable = true;
}
}
if (isCountable)
{
string comment = Microsoft.VisualBasic.Interaction.InputBox("Please add a comment to your training!", "comment", "");
trainingDone newDone = new trainingDone();
FPdatabase.trainingDone.InsertOnSubmit(newDone);
newDone.date = DateTime.Now.Date;
newDone.trainingID = training.trainingID;
if (comment == "")
{
newDone.comment = "none";
}
else
{
newDone.comment = comment;
}
FPdatabase.SubmitChanges();
MessageBox.Show("Congratulations! You have succesfully finished training!", "Congrats!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("You didn't do anything!", "??", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 问答题、写作题信息维护(线下作业添加为简答题)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Exercise_Writing_M_Edit(ExerciseInfo model)
{
return TestDAL.Exercise_Writing_M_Edit(model);
}
public ExerciseInfo ExerciseInfo_GetListen(ExerciseInfo model)
{
return(ExerciseDAL.ExerciseInfo_GetListen(model));
}
/// <summary>
/// 线下作业
/// </summary>
/// <param name="TestID">测试id</param>
/// <param name="PaperName">试卷名称</param>
/// <param name="OCID"></param>
/// <param name="UserID">创建人id</param>
/// <param name="content">内容</param>
/// <param name="answer">答案</param>
/// <returns></returns>
public int Paper_OfflineTest_Edit(int TestID, string PaperName, int OCID, int UserID, string content, string answer, int PaperID)
{
ExerciseInfo model = new ExerciseInfo();
ExerciseCommon exerciseCommon = new ExerciseCommon();
Exercise exercise = new Exercise();
PaperGroup pg = new PaperGroup();
exercise.ExerciseID = 0;
exercise.OCID = OCID;
exercise.CourseID = 0;
exercise.OwnerUserID = UserID;
exercise.CreateUserID = UserID;
exercise.ExerciseType = 10;
exercise.ExerciseTypeName = "问答题";
exercise.Scope = 0;
exercise.Diffcult = 0;
exercise.ShareRange = 0;
exercise.Keys = "";
exercise.Kens = "";
exercise.Conten = content;
exercise.Analysis = "";
exercise.Answer = answer;
exercise.ScorePoint = "";
exercise.ParentID = 0;
exerciseCommon.ExerciseType = 10;
exerciseCommon.ExerciseID = 0;
exerciseCommon.exercise = exercise;
model.exercisecommon = exerciseCommon;
pg.GroupID = 0;
pg.PaperID = PaperID;
pg.GroupName = "第1部分";
pg.Orde = 1;
pg.Brief = "";
pg.Timelimit = 0;
int ExerciseID = Exercise_Writing_M_Edit(model); //线下作业，添加一个简答题。
int PaperGroupID = PaperDAL.PaperGroup_ADD(pg); //试卷添加分组。
PaperDAL.PaperExercise_ADD(PaperID, PaperGroupID, ExerciseID, 100, 1,0); //习题添加到试卷
return TestDAL.Paper_OfflineTest_Edit(TestID, PaperName, OCID, UserID, content, answer, PaperID);
}
