public ClassesModel InsertOrUpdate(ClassesModel model) { if (model.Id > 0) { var _class = dbcontext.Classes.Find(model.Id); if (_class != null) { var mappedClasses = mapper.Map <ClassesModel, Classes>(model, _class); dbcontext.Classes.Update(mappedClasses); dbcontext.SaveChanges(); return(model); } else { return(null); } } else { var mappedClasses = mapper.Map <Classes>(model); dbcontext.Classes.Add(mappedClasses); dbcontext.SaveChanges(); return(model); } }
public HttpResponseMessage GetClasses() { CustomDataResponseModel customResponseModel = new CustomDataResponseModel(); try { ClassesModel objClassesModel = new ClassesModel(); List <ClassesModel> objList = new List <ClassesModel>(); objList = _iClasses.GetAll(); if (objList.Count > 0) { customResponseModel.type = "success"; customResponseModel.message = ""; customResponseModel.data = objList; } else { customResponseModel.type = "error"; customResponseModel.message = "No records found!"; customResponseModel.data = objList; } } catch (Exception ex) { customResponseModel.type = "error"; customResponseModel.message = ex.Message; customResponseModel.data = null; return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, customResponseModel)); } return(Request.CreateResponse(HttpStatusCode.OK, customResponseModel)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,SchoolId,Name,Info")] ClassesModel classesModel) { if (id != classesModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(classesModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ClassesModelExists(classesModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SchoolId"] = new SelectList(_context.Schools, "Id", "Id", classesModel.SchoolId); return(View(classesModel)); }
protected override IUnitsModel GetModel() { IClassCollection collection = ProfilingViewModel.Application.ServiceContainer.Resolve <IClassCollection>(); ClassesModel model = new ClassesModel(collection); return(model); }
/// <summary> /// 根据专业查询学生信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable GetStudentsBySpec(ClassesModel model) { string sql = "select a.*, e.College_Name,c.Speciality_Name,d.SpeYears_Name from Students a join Classes b on a.StudentClass=b.Classes_ID join Speciality c on b.Classes_Speciality=c.Speciality_ID join SpeYears d on c.Speciality_Years=d.SpeYears_ID join Colleges e on c.Speciality_College=e.College_ID where b.Classes_Speciality=@0"; DataTable dt = SqlHelper.GetDataTable(sql, model.Classes_Speciality); return(dt); }
public int AddOrEditClasses(ClassesModel c, UserTokenModel curUser) { if (c.Id > 0) { goto editClass; } var ue = c.Adapt <Classes>(); ue.AddUserId = curUser.UserId; ue.EditUserId = curUser.UserId; ue.AddTime = DateTime.Now; ue.EditTime = DateTime.Now; db.Set <Classes>().Add(ue); return(db.SaveChanges()); editClass: var exist = db.Set <Classes>().Find(c.Id); exist.ClassName = c.ClassName; exist.ClassType = c.ClassType; exist.EditTime = DateTime.Now; exist.EditUserId = curUser.UserId; exist.IsValid = c.IsValid; db.Entry(exist).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); }
public ActionResult DeleteConfirmed(int id) { ClassesModel classesModel = db.Class.Find(id); db.Class.Remove(classesModel); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 检测班级编号 /// </summary> /// <param name="model">班级的实体对象</param> /// <returns>是否</returns> public bool SeleClasses(ClassesModel model) { string sql = "select * from Classes where Classes_ID=@0"; SqlDataReader dr = SqlHelper.ExReader(sql, model.Classes_ID); bool b = dr.Read(); dr.Close(); return(b); }
public ActionResult Edit(int id) { @ViewBag.Main = "Updation"; @ViewBag.Sub = "Classes"; ClassesModel model = new ClassesModel(); model = _rep.Get(id); return(View(model)); }
public ActionResult Edit([Bind(Include = "ClassId,ClassName")] ClassesModel classesModel) { if (ModelState.IsValid) { db.Entry(classesModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(classesModel)); }
private void benUPji_Click(object sender, EventArgs e) { ClassesBLL Class = new ClassesBLL(); ClassesModel model = new ClassesModel(); model.Classes_Name = this.txtjiname.Text; model.ClassHeadTeacher = Convert.ToInt32(this.cmbbanname.SelectedValue); model.Classes_ID = this.dataGridView1.SelectedRows[0].Cells["班级编号"].Value.ToString(); Class.UPClasses(model); GetAllClass(); }
public ActionResult Create([Bind(Include = "ClassId,ClassName")] ClassesModel classesModel) { if (ModelState.IsValid) { db.Class.Add(classesModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(classesModel)); }
public async Task <IActionResult> Create(int SchoolId, [Bind("Id,Name,Info")] ClassesModel classesModel) { if (ModelState.IsValid) { classesModel.SchoolId = SchoolId; _context.Add(classesModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(classesModel)); }
private void benDeleji_Click(object sender, EventArgs e) { ClassesBLL Class = new ClassesBLL(); ClassesModel model = new ClassesModel(); if (this.dataGridView1.SelectedRows.Count > 0) { model.Classes_ID = this.dataGridView1.SelectedRows[0].Cells["班级编号"].Value.ToString(); Class.DeleClasses(model); GetAllClass(); } }
public IActionResult add() { try { ClassesModel classesModel = new ClassesModel(); return(View(classesModel)); } catch (Exception ex) { AlertHelper.setMessage(this, ex.Message, messageType.error); return(RedirectToAction("index")); } }
// GET: Classes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClassesModel classesModel = db.Class.Find(id); if (classesModel == null) { return(HttpNotFound()); } return(View(classesModel)); }
/// <summary> /// 在班级内按单科排名 /// </summary> /// <param name="check">是否降序</param> /// <param name="classmodel">班级实体对象</param> /// <param name="submodel"></param> /// <returns></returns> public DataTable OrderBySingleClass(bool check, ClassesModel classmodel, SubjectsModel submodel) { string sql = ""; if (check == false) { sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_Name 姓名,a.ExamScore 成绩 from Examination a join Students b on a.StudentID=b.Student_ID join Subjects c on a.SubjectsID=c.Subjects_ID join Classes d on b.StudentClass=d.Classes_ID where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore asc"; } else { sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_Name 姓名,a.ExamScore 成绩 from Examination a join Students b on a.StudentID=b.Student_ID join Subjects c on a.SubjectsID=c.Subjects_ID join Classes d on b.StudentClass=d.Classes_ID where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore desc"; } return(SqlHelper.GetDataTable(sql, classmodel.Classes_ID, submodel.Subjects_ID)); }
/// <summary> /// 生成听课安排 /// </summary> /// <param name="sptlist"></param> /// <param name="model"></param> /// <param name="group"></param> private void WritePlacement(List <SpareTimeModel> sptlist, ClassesModel model, string group) { ArrageModel arragemodel = new ArrageModel(); arragemodel.Cid = model.Cid; arragemodel.SuperVisors = group.Substring(1); arragemodel.Stauts = 0; arragemodel.Pid = model.Cid.Trim() + sptlist[0].Week + sptlist[0].Day + sptlist[0].ClassNumber.ToString(); listarrage.Add(arragemodel); model.CheckNumber++; listmodfiyclass.Add(model); foreach (SpareTimeModel spt in sptlist) { UpdateCheckCount(spt.Tid); spt.Assign = 1; } listchange.AddRange(sptlist); }
private void benAddji_Click(object sender, EventArgs e) { ClassesBLL Class = new ClassesBLL(); ClassesModel model = new ClassesModel(); model.Classes_ID = lblyy.Text + txtjibian.Text; bool b = Class.SeleClasses(model); if (b == true) { MessageBox.Show("该班级编号已经存在,请重新输入"); txtjibian.Text = ""; return; } model.Classes_Name = txtjiname.Text; model.Classes_Speciality = cmbzhuan.SelectedValue.ToString(); model.ClassHeadTeacher = Convert.ToInt32(cmbbanname.SelectedValue); Class.AddClasses(model); GetAllClass(); }
public ActionResult Edit(ClassesModel model) { @ViewBag.Main = "Updation"; @ViewBag.Sub = "Classes"; if (ModelState.IsValid) { try { _rep.Edit(model); model = new ClassesModel(); ModelState.Clear(); TempData["Message"] = "success"; TempData["SuccessMessage"] = MessageNaming.SuccessDataUpdate; } catch (Exception ex) { TempData["Message"] = "error"; TempData["ErrorMessage"] = ex.Message; } } return(View(model)); }
public Tuple <List <ClassesModel>, int> Classes(ClassesModel model) { var where = new StringBuilder("1=1"); if (!string.IsNullOrWhiteSpace(model.KeyWord)) { where.Append($" and u.ClassName like '%{model.KeyWord}%' "); } if (model.IsValid == true) { where.Append($" and u.IsValid=1 "); } var cols = @"select * "; var sql = $@" from Classes u where {where} "; var cntSql = $"select count(1) {sql} "; var dataSql = $"{cols} {sql} order by u.EditTime desc OFFSET ({model.Skip}) ROW FETCH NEXT {model.PageSize} rows only "; var cnt = db.Database.SqlQuery <int>(cntSql).First(); var data = db.Database.SqlQuery <ClassesModel>(dataSql).ToList(); return(new Tuple <List <ClassesModel>, int>(data, cnt)); }
public Task <ClassesModel> UpdateAsync(ClassesModel entity) { throw new NotImplementedException(); }
public ClassesModel Update(ClassesModel entity) { throw new NotImplementedException(); }
public void Delete(ClassesModel entity) { throw new NotImplementedException(); }
/// <summary> /// 根据班级名称模糊搜索班级信息 /// </summary> /// <param name="model">班级实体对象</param> /// <returns>班级信息</returns> public DataTable GetClassesByClassName(ClassesModel model) { return(Class.GetClassesByClassName(model)); }
public DataTable GetClassesBySpeciality(ClassesModel model) { DataTable dt = Class.GetClassesBySpeciality(model); return(dt); }
/// <summary> /// 检测班级编号 /// </summary> /// <returns>是否</returns> public bool SeleClasses(ClassesModel model) { bool b = Class.SeleClasses(model); return(b); }
public Br <List <ClassesModel> > Classes(ClassesModel model) { var result = svc.Classes(model); return(new Br <List <ClassesModel> >(result.Item1, extData: result.Item2)); }
public Br <int> AddOrEditClasses(ClassesModel c) { var result = svc.AddOrEditClasses(c, CurUser); return(new Br <int>(result)); }
/// <summary> /// 修改班级 /// </summary> public void UPClasses(ClassesModel model) { Class.UPClasses(model); }