private void button1_Click(object sender, EventArgs e) { if (txtmk.Text != "" && txttk.Text != "" && checkMaK1.ErrorMessage == null && checkTenK1.ErrorMessage == null) { ClassDTO kl = new ClassDTO(txtmk.Text, txttk.Text); HSB.InsertKL(kl); HSB.Loadkl(); MessageBox.Show("successfull"); } else { MessageBox.Show("vui lòng nhập đúng và đủ "); } }
public async Task <IActionResult> CreateClass(ClassDTO classDTO) { if (RequiredArgs(classDTO)) { Class createdClass = await CreatingClass(classDTO); if (createdClass != null) { var classMapped = _mapper.Map <ClassDefaultInformationsDTO>(createdClass); return(Ok(classMapped)); } } return(ResponeError()); }
private bool RequiredArgs(ClassDTO c) { var flag = true; if (c.LecurerID == null) { errorsList.Add("Brak prowadzącego zajęcia"); flag = false; } if (c.SubjectID == null) { errorsList.Add("Brak nazwy zajęć"); flag = false; } if (c.RoomID == null) { errorsList.Add("Brak klasy dla zajęć"); flag = false; } if (c.TotalHours == null) { errorsList.Add("Brak całkowitej ilości godzin"); flag = false; } if (c.TotalHours < 1) { errorsList.Add("Liczba godzin nie może być 0 lub ujemna"); flag = false; } if (c.Start == null) { errorsList.Add("Brak określenia daty rozpoczęcia zajęć"); flag = false; } if (c.Start < TimeSpan.Zero) { errorsList.Add("Rozpoczęcie zajęć nie może być ujemne"); flag = false; } if (c.Duration == null) { errorsList.Add("Brak długości zajęć"); flag = false; } if (c.Duration < TimeSpan.Zero) { errorsList.Add("Długość zajęć nie może być ujemna"); flag = false; } if (c.Recurrence == null) { errorsList.Add("Nie określono powtarzalności"); flag = false; } if (c.Recurrence <= (TimeSpan.Zero + new TimeSpan(TimeSpan.TicksPerHour) * 0.75)) { errorsList.Add("Powtarzalność zajęć nie może być mniejsza niż 45 minut"); flag = false; } return(flag); }
public override int ActualizarUsuario(ClassDTO usuario, Int32 id) { try { // abrimos una session con la base de datos session = factory.OpenSession(); // obtenemos el usuario del id 12 y lo modificamos EjercicioNHibernate.Usuario Antonio = (EjercicioNHibernate.Usuario)session.Load(typeof(EjercicioNHibernate.Usuario), id); Antonio.Nif = usuario.getNif(); Antonio.Nombre = usuario.getNombre(); Antonio.Clave = usuario.getClave(); Antonio.Rol = (int)usuario.getRol(); Antonio.Email = usuario.getEmail(); Antonio.Direccion = usuario.getDireccion(); Antonio.Ciudad = usuario.getCiudad(); Antonio.Provincia = usuario.getProvincia(); Antonio.Telefono = usuario.getTelefono(); Antonio.CodigoPostal = usuario.getCodigoPostal(); Antonio.Saldo = usuario.getSaldo(); // actualizamos la session con la base de datos session.Flush(); } catch (Exception ex) { throw ex; } finally { if (session != null) { //Cerrar la sesión session.Close(); } session = null; } return(1); }
public override List <ClassDTO> ObtenerUsuario(string criterio) { List <ClassDTO> Users = new List <ClassDTO>(); try { // abrimos la session en la base de datos session = factory.OpenSession(); //buscamos los usuarios que tengan como ciudad algo que contenga Madrid IList recentUsuarios = session.CreateCriteria(typeof(EjercicioNHibernate.Usuario)) //.Add(Expression.Like("Nombre", "%deri%")) .Add(Expression.Sql(criterio)) //.Add(Expression.Like("Nombre", "%mart%")) para añadir otra restricción con "and" .List(); foreach (EjercicioNHibernate.Usuario usuario in recentUsuarios) { ClassDTO usr = new ClassDTO(); usr.setUsuarioID(usuario.UsuarioID); usr.setNif(usuario.Nif); usr.setClave(usuario.Clave); usr.setRol(usuario.Rol); usr.setNombre(usuario.Nombre); usr.setTelefono(usuario.Telefono); usr.setEmail(usuario.Email); usr.setDireccion(usuario.Direccion); usr.setCiudad(usuario.Ciudad); usr.setProvincia(usuario.Provincia); usr.setCodigoPostal(usuario.CodigoPostal); usr.setSaldo(usuario.Saldo); Users.Add(usr); } } catch (Exception ex) { throw ex; } finally { if (session != null) { //Cerrar la sesión session.Close(); } session = null; } return(Users); }
public async Task <ActionResult> CreateEntity(int teacherId, int subjectId, [FromBody] ClassDTO classDto) { //if (HttpContext.Request.ContentType != "application/json") // return StatusCode(415); try { ClassDTO created = await _classService.CreateEntity(teacherId, subjectId, classDto); return(Ok(created)); } catch (Exception e) { return(BadRequest(e.Message)); } }
public async Task <ActionResult> UpdateEntity(int classId, [FromBody] ClassDTO classDto) { //if (HttpContext.Request.ContentType != "application/json") // return StatusCode(415); try { ClassDTO result = await _classService.UpdateEntity(classId, classDto); return(Ok(result)); } catch (Exception e) { return(BadRequest(e.Message)); } }
public void Update(ClassDTO classDTO) { ClassEntity classEntity = _classRepository.Read().Include(x => x.Languages).FirstOrDefault(x => x.Id == classDTO.Id); ClassLanguage classLanguage = _classLanguageRepository.Read().FirstOrDefault(x => x.ClassId == classDTO.Id); classEntity = _mapper.Map <ClassEntity>(classDTO); classLanguage = _mapper.Map <ClassLanguage>(classDTO); _unitOfWork.BeginTransaction(); _classRepository.Update(classEntity, classEntity.Id); _classLanguageRepository.Update(classLanguage, classLanguage.Id); _unitOfWork.SaveChanges(); _unitOfWork.Commit(); }
public bool UpdateClass(ClassDTO _class) { this.ConnectToDatabase(); string Query = "update CLASS set CLASS_NAME = '" + _class.ClassName + "',START_HOUR = '" + _class.StartHour + "',START_DATE = '" + _class.StartDate.ToString("yyyy'-'MM'-'dd") + "',END_DATE = '" + _class.EndDate.ToString("yyyy'-'MM'-'dd") + "'" + ",PROGRAM_ID=" + "'" + _class.ProgramId + "'" + "where CLASS_ID=" + "'" + _class.ClassId + "'"; //This is command class which will handle the query and connection object. MySqlCommand command = new MySqlCommand(Query, mySQLConnection); command.ExecuteNonQuery(); this.Close(); return(true); }
public void Add(ClassDTO classDTO) { ClassEntity classEntity = new ClassEntity(); ClassLanguage classLanguage = new ClassLanguage(); classEntity = _mapper.Map <ClassEntity>(classDTO); classLanguage = _mapper.Map <ClassLanguage>(classDTO); classEntity.Languages.Add(classLanguage); _unitOfWork.BeginTransaction(); _classRepository.Create(classEntity); _unitOfWork.SaveChanges(); _unitOfWork.Commit(); }
public ReportDetailForm(ClassDTO _class) { InitializeComponent(); SignupDAL signupDAL = new SignupDAL(); signupDAL.ConnectToDatabase(); List <SignupDTO> signupDTOs = signupDAL.GetAllSignupClass(_class.ClassId); dgvReport.DataSource = signupDTOs; ProgramDAL programDAL = new ProgramDAL(); programDAL.ConnectToDatabase(); TotalFee = (programDAL.GetProgram(_class.ProgramId).Fee *signupDTOs.Count).ToString(); labelType.Text = "Tổng số tiền thu được (USD): "; labelInfo.Text = TotalFee; }
public static @class ClassToDAL(ClassDTO c) { //var students = e.users.OfType<student>(); //var teachers = e.users.OfType<teacher>(); var cls = new @class() { class_id = c.class_id, class_name = c.class_name, //students = e.students.Where(s => s.class_id == c.class_id).ToList(), //teacher = e.teachers.FirstOrDefault(t => t.teacher_id == c.teacher_id), teacher_id = c.teacher_id //class_test = e.class_test.Where(ct => ct.class_id == c.class_id).ToList() }; return(cls); }
public ClassDetail(string id) { InitializeComponent(); this.CenterToScreen(); classToEdit = ClassDTO.getClassById(new Dictionary <string, string> { { "id", id } }); this.radioControl.Add("dig", classToEdit.Dif_dig); this.radioControl.Add("lei", classToEdit.Dif_lei); this.radioControl.Add("rec", classToEdit.Dif_rec); this.radioControl.Add("atv", classToEdit.Dif_atv); this.radioControl.Add("int", classToEdit.Dif_atv); setFields(); setLabels(); }
public ActionResult Edit(ClassEditVM classEditVM, IFormFile uploadfile) { try { if (!ModelState.IsValid) { var model = new ClassEditVM(); return(View(model)); } //Yeni image var mı? string combineFileName = null; if (uploadfile != null) { //Önceki resmi silelim. if (System.IO.File.Exists("Uploads/Class/" + classEditVM.Image)) { System.IO.File.Delete("Uploads/Class/" + classEditVM.Image); } string fileName = Guid.NewGuid().ToString(); string fileType = System.IO.Path.GetExtension(uploadfile.FileName); combineFileName = fileName + fileType; classEditVM.Image = combineFileName; using (var localFile = System.IO.File.OpenWrite("Uploads/Class/" + combineFileName)) using (var uploadedFile = uploadfile.OpenReadStream()) { uploadedFile.CopyTo(localFile); } } ClassDTO classDTO = _mapper.Map <ClassDTO>(classEditVM); _classService.Update(classDTO); TempData["Statu"] = "ok"; return(RedirectToAction("index")); } catch (Exception) { return(View()); throw; } }
public Result <ClassDTO> CreateClass(ClassDTO model) { try { var check = userDAL.Get(w => w.ID == model.UserID && w.UserType == Entity.Concrete.UserType.Teacher); if (check == null) { return(new Result <ClassDTO>(false, "boyle bir egitmen yok", null)); } Class_ class_ = model.Adapt <Class_>(); classDAL.Add(class_); return(new Result <ClassDTO>(false, "islem basarili sekilde tamamlanmistir", null)); } catch (Exception ex) { return(new Result <ClassDTO>(true, ex.Message, null)); } }
public ActionResult Index(ClassDTO clas) { if (clas.ClassData.Id == 0) { db.Classes.Add(clas.ClassData); db.SaveChanges(); } else { var dataCla = db.Classes.FirstOrDefault(a => a.Id == clas.ClassData.Id); dataCla.Name = clas.ClassData.Name; dataCla.Description = clas.ClassData.Description; db.SaveChanges(); } return(RedirectToAction("Index")); }
public IHttpActionResult AddClass([FromBody] ClassDTO cls) { try { if (ModelState.IsValid) { return(Ok(ClassLogic.AddClass(cls))); } var errors = ModelState.Select(x => x.Value.Errors) .Where(y => y.Count > 0) .ToList(); return(BadRequest(errors.ToString())); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
private void btnConfirm_Click(object sender, EventArgs e) { ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem; ClassDAL classDAL = new ClassDAL(); classDAL.ConnectToDatabase(); try { if (classDAL.DeleteClass(currentObject.ClassId)) { MessageBox.Show("Xoá lớp thành công!!!"); } } catch (Exception) { MessageBox.Show("Xoá lớp thất bại!!!"); } }
public PlayerCharacterDTO() { PlayerClass = new ClassDTO(); Archetype = new ArchetypeDTO(); Background = new BackgroundDTO(); Race = new RaceDTO(); Alignment = new AlignmentDTO(); AbilityScores = new List <PcAbilityScoreDTO>(); SavingThrows = new List <PcSavingThrowDTO>(); Skills = new List <PcSkillDTO>(); Player = new PlayerDTO(); SpellLevels = new List <PcSpellLevelDTO>(); Spells = new List <PcSpellDTO>(); Traits = new List <TraitDTO>(); Equipment = new List <PcEquipmentDTO>(); Treasure = new List <PcTreasureDTO>(); Features = new List <FeatureDTO>(); }
public void AddNewClass() { var newClass = new ClassDTO { Title = "test", }; try { var chronicles = this.Post(this.url, newClass); } catch (Exception) { Assert.Fail("Posting class via API failed!"); return; } }
public ClassDTO GetStudentsByClass(int classId) { Class classFromDb = db.ClassRepository.GetByID(classId); ClassDTO classs = new ClassDTO(); classs.ClassName = classFromDb.Name.ToString(); foreach (Student s in classFromDb.Students) { StudentFNLNDTO student = new StudentFNLNDTO(); student.FirstName = s.FirstName; student.LastName = s.LastName; classs.Students.Add(student); } return(classs); }
public bool InsertKL(ClassDTO kl) { try { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); KHOILOP KL = new KHOILOP { MaKhoiLop = kl.MaK1, TenKhoiLop = kl.TenK1 }; hdb.KHOILOPs.InsertOnSubmit(KL); hdb.SubmitChanges(); return(true); } catch { return(false); } }
public static ClassDTO AddClass(ClassDTO cls) { using (Entities e = new Entities()) { var c = e.teachers.FirstOrDefault(t => t.teacher_id == cls.teacher_id); if (c == null) { throw new Exception("teacher id is not exists"); } var cl = e.classes.FirstOrDefault(cc => cc.teacher_id == cls.teacher_id && cc.class_name == cls.class_name); if (cl != null) { throw new Exception("class name is exists"); } var added = e.classes.Add(ClassCasting.ClassToDAL(cls)); e.SaveChanges(); return(ClassCasting.ClassToDTO(added)); } }
public ActionResult Delete(List <int> ids) { try { foreach (var id in ids) { ClassDTO classDTO = new ClassDTO(); classDTO.Id = id; _classService.Delete(classDTO); } } catch (Exception) { throw; } TempData["Statu"] = "ok"; return(RedirectToAction("index")); }
private void btnDelete_Click(object sender, EventArgs e) { //xoa lop hoc //if (this.dgvListClass.SelectedRows.Count > 0) //{ // ClassDAL classDAL = new ClassDAL(); // classDAL.ConnectToDatabase(); // ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem; // if(classDAL.DeleteClass(currentObject.ClassId)) // { // classDAL = new ClassDAL(); // classDAL.ConnectToDatabase(); // dgvListClass.DataSource = classDAL.GetAllClass(); // dgvListClass.Update(); // dgvListClass.Refresh(); // } //} //DeleteClassForm f = new DeleteClassForm(); //this.Hide(); //f.ShowDialog(); //this.Show(); ClassDAL classDAL = new ClassDAL(); SignupDAL signupDAL = new SignupDAL(); classDAL.ConnectToDatabase(); ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem; nameClass = currentObject.ClassId.ToUpperInvariant(); DialogResult dialogResult = MessageBox.Show("Bạn có chắc xoá lớp học: " + nameClass, "Thông báo", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { signupDAL.DeleteSignup(nameClass); classDAL.DeleteClass(nameClass); MessageBox.Show("Xoá lớp học thành công!!!"); this.Close(); ClassForm f = new ClassForm(); f.Show(); } ; }
public async Task <ClassDTO> UpdateEntity(int id, ClassDTO data) { var entityList = await _baseRepository.QueryAsync <Class>(); var result = entityList.FirstOrDefault(x => x.Id == id); if (result != null) { data.Id = id; result.Abbreviation = data.Abbreviation; result.Name = data.Name; await _baseRepository.UpdateAsync(id, result); await _hubContext.Clients.All.SendAsync(PushTypesEnum.lessonUpdated.ToString(), data); return(data); } throw new Exception($"Entity with id: {id} not found."); }
public IHttpActionResult GetClass(int id) { var c = _db.class_tb.FirstOrDefault((s) => s.class_id == id); ClassDTO Class = new ClassDTO(); Class.class_id = c.class_id; Class.@class = c.@class; Class.school_id = c.school_id; Class.section = c.section; Class.date_created = c.date_created; if (Class == null) { return(NotFound()); } return(Json(Class)); }
public override List <ClassDTO> ObtenerUsuarios() { List <ClassDTO> res = new List <ClassDTO>(); int i = 0; ClassDTO usuario = new ClassDTO(); try { // comando sql a ejecutar string sql = "SELECT nif,clave,rol,nombre,telefono,email,direccion,ciudad,provincia,codigopostal,saldo FROM usuarios"; // instanciamos la base de datos y ejecutamos el comando sql Database dataBase = DatabaseFactory.CreateDatabase(); IDataReader fila = dataBase.ExecuteReader(CommandType.Text, sql); while (fila.Read()) { usuario.setUsuarioID(Convert.ToInt32(fila[0])); usuario.setNif(fila[1].ToString()); usuario.setClave(fila[2].ToString()); usuario.setRol(Convert.ToInt32(fila[3])); usuario.setNombre(fila[4].ToString()); usuario.setTelefono(fila[5].ToString()); usuario.setEmail(fila[6].ToString()); usuario.setDireccion(fila[7].ToString()); usuario.setCiudad(fila[8].ToString()); usuario.setProvincia(fila[9].ToString()); usuario.setCodigoPostal(Convert.ToDecimal(fila[10])); usuario.setSaldo(Convert.ToDecimal(fila[11])); i++; res.Add(usuario); } } catch (System.Exception ex) { throw ex; } return(res); }
public void GetClassById() { try { var classInfo = new ClassDTO { Id = 1, Title = "test", }; var url = this.url + this.prefix + classInfo.Id; var fetchedclassInfo = this.Get <ClassDTO>(url, true); Assert.NotNull(fetchedclassInfo); Assert.AreEqual(classInfo.Title, fetchedclassInfo.Title); } catch { Assert.Fail("Reading class via API failed!"); return; } }
public ClassReportForm(ClassDTO _classDTO) { InitializeComponent(); ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtClassId"]).Text = "Mã lớp: " + _classDTO.ClassId; ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtClassName"]).Text = "Tên lớp: " + _classDTO.ClassName; ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtStartHour"]).Text = "Giờ học: " + _classDTO.StartHour; ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtProgramId"]).Text = "Mã chương trình học: " + _classDTO.ProgramId; ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtStartDate"]).Text = "Ngày bắt đầu: " + _classDTO.StartDate.ToLongDateString(); ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtEndDate"]).Text = "Ngày kết thúc: " + _classDTO.EndDate.ToLongDateString(); SignupDAL signupDAL = new SignupDAL(); signupDAL.ConnectToDatabase(); List <SignupDTO> signupDTOs = signupDAL.GetAllSignupClass(_classDTO.ClassId); ProgramDAL programDAL = new ProgramDAL(); programDAL.ConnectToDatabase(); string TotalFee = (programDAL.GetProgram(_classDTO.ProgramId).Fee *signupDTOs.Count).ToString(); ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtStudentCount"]).Text = "Tổng số học sinh: " + signupDTOs.Count.ToString(); ((TextObject)ClassInfoReport1.Section4.ReportObjects["txtMoney"]).Text = "Tổng số tiền thu được (USD): " + TotalFee; }