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;
}
