public async Task <ActionResult <SubjectClass> > PostSubjectClass(SubjectClass subjectClass)
{
_context.SubjectClass.Add(subjectClass);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSubjectClass", new { id = subjectClass.SubjectClassID }, subjectClass));
}
public SubjectCalculatorModel()
{
for (int i = 0; i < 4; i++)
{
_subjects[i] = new SubjectClass("Subject", 0, 6);
}
}
public async Task <IActionResult> PutSubjectClass(int id, SubjectClass subjectClass)
{
if (id != subjectClass.SubjectClassID)
{
return(BadRequest());
}
_context.Entry(subjectClass).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubjectClassExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private async void YY_Picker_SelectedIndexChanged(object sender, EventArgs e)
{
List <SubjectClass> lsc = new List <SubjectClass>();
try
{
var client = new HttpClient();
client.DefaultRequestHeaders.UserAgent.ParseAdd("Mozilla/5.0 (compatible; AcmeInc/1.0)");
var uri = $"https://api.medmee.in/Subject/Get_All_Subjects?BNAME={Branch_Picker.SelectedItem.ToString()}&YY={YY_Picker.SelectedItem.ToString()}";
var result = await client.GetStringAsync(uri);
var JSON_DATA = JsonConvert.DeserializeObject <List <SubjectClass> >(result);
var COUNT = JSON_DATA.Count;
for (int i = 0; i < COUNT; i++)
{
SubjectClass SC = new SubjectClass()
{
SNAME = JSON_DATA[i].SNAME,
};
//lsc.Add(SC);
Subject_Picker.Items.Add(SC.SNAME);
}
//Subject_Picker.ItemsSource = lsc;
}
catch (Exception ee)
{
await DisplayAlert("Message", "No Data To Show", "Ok");
}
}
public ActionResult DeleteConfirmed(int id)
{
SubjectClass subjectClass = db.SubjectClasses.Find(id);
db.SubjectClasses.Remove(subjectClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(SubjectClass subjectClass)
{
if (ModelState.IsValid)
{
db.Entry(subjectClass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LevelID = new SelectList(db.Classes, "LevelID", "ClassName", subjectClass.LevelID);
ViewBag.SubId = new SelectList(db.Subjects, "SubId", "SubName", subjectClass.SubId);
return(View(subjectClass));
}
public SubjectClass GetSubjectClass(int subjectClassID)
{
try
{
string query = "select * from SubjectClass where ID = " + subjectClassID;
SubjectClass subjectClass = connect.Query <SubjectClass>(query).FirstOrDefault();
return(subjectClass);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public SubjectClass GetBySubjectAndClass(int subjectID, int classInfoID)
{
try
{
string query = String.Format("select * from SubjectClass where SubjectID = {0} and ClassInfoID = {1}", subjectID, classInfoID);
SubjectClass subject = connect.Query <SubjectClass>(query).FirstOrDefault <SubjectClass>();
return(subject);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
// GET: SubjectClasses/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectClass subjectClass = db.SubjectClasses.Find(id);
if (subjectClass == null)
{
return(HttpNotFound());
}
return(View(subjectClass));
}
public SubjectClass GetByPrimaryKey(int id)
{
try
{
string query = "select * from SubjectClass where ID = " + id;
SubjectClass subject = connect.Query <SubjectClass>(query).FirstOrDefault <SubjectClass>();
return(subject);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public async Task <IActionResult> AddSubject(int?id, [Bind("StartTime,EndTime,IntendTime,SubjectId,ClassId")] SubjectClass sClass)
{
//return new JsonResult(sClass);
if (ModelState.IsValid)
{
_context.Add(sClass);
await _context.SaveChangesAsync();
return(Redirect("/Classes/Details/" + id));
return(RedirectToAction(nameof(Index)));
}
return(new JsonResult("ok"));
}
// GET: SubjectClasses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectClass subjectClass = db.SubjectClasses.Find(id);
if (subjectClass == null)
{
return(HttpNotFound());
}
ViewBag.LevelID = new SelectList(db.Classes, "LevelID", "ClassName", subjectClass.LevelID);
ViewBag.SubId = new SelectList(db.Subjects, "SubId", "SubName", subjectClass.SubId);
return(View(subjectClass));
}
public async Task GetGradesForSubject_WithExistentSubjectIdAndStudentIdAndZeroData_ShouldReturnZeroResults()
{
string errorMessagePrefix = "GradeService GetGradesForSubject() does not work properly.";
var context = NetBookDbContextInMemoryFactory.InitializeContext();
await this.SeedData(context);
this.gradeService = new GradeService(context);
var student = new Student {
Id = "TestStudentWithNoGrades", FullName = "TestStudentWithZeroGrades", Grades = new List <Grade>()
};
var testClass = new Class
{
Id = "TestClass",
Subjects = new List <SubjectClass>(),
};
var testSubject = new SubjectClass
{
Id = "TestSubjectWithNoGrades",
Subject = new Subject
{
Name = "TestSubject",
},
};
testClass.Subjects.Add(testSubject);
student.ClassId = "TestClass";
student.Class = testClass;
await context.Students.AddAsync(student);
await context.Classes.AddAsync(testClass);
await context.SubjectClasses.AddAsync(testSubject);
await context.SaveChangesAsync();
var actualResult = await this.gradeService.GetGradesForSubject("TestStudentWithNoGrades", "TestSubjectWithNoGrades").ToListAsync();
var expectedResult = 0;
Assert.True(actualResult.Count == expectedResult, errorMessagePrefix);
}
//删除课程，返回布尔值，是否删除成功
public bool deleteSubject(SubjectClass subject)
{
bool flag = false;
using (SqlConnection con = new SqlConnection(Dbhelper.dbsr))
{
Dbhelper helper = new Dbhelper(con);
SqlParameter pID = new SqlParameter {
ParameterName = "@sID", SqlDbType = System.Data.SqlDbType.Int, Value = subject.ID
};
if (helper.ExecuteSQL("delete from Subjects where sID=@sID ", pID) > 0)
{
flag = true;
}
con.Close();
}
return(flag);
}
//添加课程,返回课程id
public int addSubject(ref SubjectClass suject)
{
int ID = 0;
using (SqlConnection con = new SqlConnection(Dbhelper.dbsr))
{
Dbhelper helper = new Dbhelper(con);
SqlParameter pSubject = new SqlParameter {
ParameterName = "@sSubject", SqlDbType = System.Data.SqlDbType.VarChar, Value = suject.sSubject
};
if (helper.ExecuteSQL("insert into Subjects (sSubject) values(@sSubject)", pSubject) > 0)
{
ID = helper.GetScalar("select top 1 sID from Subjects order by sID desc");
}
con.Close();
}
return(ID);
}
//更新课程(根据课程iid更新课程名)
public bool updateSubject(SubjectClass subject)
{
bool flag = false;
using (SqlConnection con = new SqlConnection(Dbhelper.dbsr))
{
Dbhelper helper = new Dbhelper(con);
SqlParameter pID = new SqlParameter {
ParameterName = "@sID", SqlDbType = System.Data.SqlDbType.Int, Value = subject.ID
};
SqlParameter pSubject = new SqlParameter {
ParameterName = "@sSubject", SqlDbType = System.Data.SqlDbType.VarChar, Value = subject.sSubject
};
if (helper.ExecuteSQL("update Subjects set sSubject=@sSubject where sID=@sID", pSubject, pID) > 0)
{
flag = true;
}
}
return(flag);
}
public bool Update(SubjectClass subject)
{
try
{
string query = "update SubjectClass set SubjectID = @SubjectID,ClassInfoID = @ClassInfoID,Description = @Description " +
" where ID = @ID ";
return(0 < connect.Execute(query, new
{
subject.SubjectID,
subject.ClassInfoID,
subject.Description,
subject.ID
}));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public int Insert(SubjectClass subject)
{
try
{
string query = "insert into SubjectClass(" +
" SubjectID,ClassInfoID,Description)" +
" values (@SubjectID,@ClassInfoID,@Description)" +
" SELECT @@IDENTITY";
int id = connect.Query <int>(query, new
{
subject.SubjectID,
subject.ClassInfoID,
subject.Description
}).Single();
return(id);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public ActionResult Create(SubjectClass subjectClass)
{
if (ModelState.IsValid)
{
if (db.SubjectClasses.Any(x => x.LevelID == subjectClass.LevelID) && db.SubjectClasses.Any(y => y.SubId == subjectClass.SubId))
{
ViewBag.ErrorMsg = "this course is already Exist , enter anthor class or anthor subject";
ViewBag.LevelID = new SelectList(db.Classes, "LevelID", "ClassName", subjectClass.LevelID);
ViewBag.SubId = new SelectList(db.Subjects, "SubId", "SubName", subjectClass.SubId);
return(View(subjectClass));
}
//var s = db.Classes.Where(x=>x.LevelID==subjectClass.LevelID).Select(x=>x.ClassName)+" "+db.Subjects.Where(y=>y.SubId==subjectClass.SubId).Select(z=>z.SubName);
// subjectClass.SubLevelName = s;
subjectClass.Date = DateTime.Now;
db.SubjectClasses.Add(subjectClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LevelID = new SelectList(db.Classes, "LevelID", "ClassName", subjectClass.LevelID);
ViewBag.SubId = new SelectList(db.Subjects, "SubId", "SubName", subjectClass.SubId);
return(View(subjectClass));
}
public void GetSubjectDetail()
{
List <SubjectClass> subjects = new List <SubjectClass>();
using (SqlCommand cmd = new SqlCommand("FetchAllSubject", db.DbConnect()))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
SubjectClass subject = new SubjectClass();
subject.subject_id = Convert.ToInt32(rdr["subject_id"]);
subject.subject_name = rdr["subject_name"].ToString();
subject.subject_code = Convert.ToInt32(rdr["sub_code"]);
subject.dept_name = subject.FetchDeptById(rdr["dept_id"].ToString());
subject.sem_id = Convert.ToInt16(rdr["sem_id"]);
subject.total_exam_taken = rdr["total_exam_taken"].ToString();
subjects.Add(subject);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(subjects));
}
public ExamSubject(SubjectClass subject, List <Exam> marks)
{
this.subject = subject;
this.marks = marks;
}
public void AddOrUpdateSubject(SentenceElement subject, SubjectClass @class, ObjectSubstantivatorType subtype, int? aId, int? bId)
{
var subjectPartElement = All.Find(x => x.WordId == subject.Id);
if (subjectPartElement != null)
{
Log.DebugFormat($"Актуализация: Обновление ОЧ с Id = {subjectPartElement.WordId}, Текст = {subjectPartElement.Text}");
subjectPartElement.GUID = subject.GUID;
subjectPartElement.WordId = subject.Id;
subjectPartElement.Class = @class;
subjectPartElement.Subtype = subtype;
subjectPartElement.Text = subject.Text;
var normalAId = aId ?? (subjectPartElement.AId == -1 ? -1 : subjectPartElement.AId);
var normalBId = bId ?? (subjectPartElement.BId == -1 ? -1 : subjectPartElement.BId);
subjectPartElement.AId = normalAId;
subjectPartElement.BId = normalBId;
}
else
{
var normalAId = aId ?? -1;
var normalBId = bId ?? -1;
subjectPartElement = new SubjectFinalResult()
{
GUID = subject.GUID
, AId = normalAId
, BId = normalBId
, WordId = subject.Id
, Class = @class
, Subtype = subtype
, Text = subject.Text
};
All.Add(subjectPartElement);
}
}