public string AddLevel(StudentLevel newLevel) { try { using (var context = new BASContext()) { if (context.Levels.Any(a => a.Level == newLevel.Level && !a.IsDeleted)) { return("Level already exists"); } //if (context.Levels.Any(a => a.LevelRank == newLevel.LevelRank && !a.IsDeleted)) // return "A Level already exist for this Level rank"; context.Levels.Add(newLevel); if (context.SaveChanges() > 0) { return(""); } return("Level could not be added"); } } catch (Exception ex) { throw ex; } }
public string UpdateLevel(StudentLevel level) { using (var context = new BASContext()) { var oldLevel = context.Levels.SingleOrDefault(a => a.Id == level.Id && !a.IsDeleted); if (oldLevel == null) { return("Level not found"); } if (context.Levels.Any(a => a.Level == level.Level && !a.IsDeleted && a.Id != level.Id)) { return("Level already exist"); } //if (context.Levels.Any(a => a.LevelRank == level.LevelRank && !a.IsDeleted && a.Id != level.Id)) // return "Rank already exist for another level"; oldLevel.Level = level.Level; if (context.SaveChanges() > 0) { return(""); } return("Level details could not be updated"); } }
/// <summary> /// Function for Update Student Classes /// </summary> public void UpdateStudentClass(StudentLevel studenClass, decimal studentid) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand cmd = new MySqlCommand("StudentClassUpdate", sqlcon); cmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = cmd.Parameters.Add("?classNo", MySqlDbType.Int32); sqlparam.Value = studenClass.ClassNo; sqlparam = cmd.Parameters.Add("?classSection", MySqlDbType.VarChar); sqlparam.Value = studenClass.ClassSection; sqlparam = cmd.Parameters.Add("?classid", MySqlDbType.Int32); sqlparam.Value = studentid; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); } }
/// <summary> /// Function for Fill Controls /// </summary> public void FillControls() { StudentLevel studLevel = new StudentLevel(); StudentClassSP studentClassSp = new StudentClassSP(); studLevel = studentClassSp.StudentClassView(classid); txtClassNo.Text = Convert.ToString(studLevel.ClassNo); txtClassSection.Text = studLevel.ClassSection; }
// PUT: api/Books/5 public bool Put(StudentLevel b) { try { return(unitOfWork.StdLevelManager.UpdateEntity(b)); } catch { return(false); } }
public void EditFuntion() { StudentLevel studLevel = new StudentLevel(); StudentClassSP studentClassSp = new StudentClassSP(); studLevel.ClassNo = Convert.ToInt32(txtClassNo.Text.Trim()); studLevel.ClassSection = txtClassSection.Text.Trim(); studentClassSp.UpdateStudentClass(studLevel, classid); Messages.UpdatedMessage(); GridFill(); ClearFunction(); }
/// <summary> /// Function for Save StudentInformation /// </summary> public void Save() { StudentLevel studLevel = new StudentLevel(); StudentClassSP studentClassSp = new StudentClassSP(); studLevel.ClassNo = Convert.ToInt32(txtClassNo.Text.Trim()); studLevel.ClassSection = txtClassSection.Text.Trim(); studentClassSp.InsertClass(studLevel); Messages.SavedMessage(); GridFill(); ClearFunction(); }
private void AddOrUpdate(StudentLevel item) { var saveItem = _id == "" ? _repo.AddLevel(item) : _repo.UpdateLevel(item); if (saveItem == string.Empty) { Base.ShowSuccess("Success", "Level saved successfully"); this.Close(); } else { Base.ShowError("Failed", saveItem); } }
private void btnSave_Click(object sender, EventArgs e) { var item = new StudentLevel { Id = _id, Level = txtLevel.Text.ToUpper(), }; var validate = ValidateForm(); if (validate == string.Empty) { AddOrUpdate(item); } else { Base.ShowInfo("Validation Failed", validate); } }
// POST: api/Books public bool Post(StudentLevel b) { try { var id = unitOfWork.StdLevelManager.MaxId(b); for (int i = 0; true; i++) { if (unitOfWork.StdLevelManager.GetByID(id) == null) { b.id = id; return(unitOfWork.StdLevelManager.AddEntity(b)); } id++; } } catch { return(false); } }
public string UpdateLevel(StudentLevel level) { var oldLevel = _context.Levels.SingleOrDefault(a => a.Id == level.Id && !a.IsDeleted); if (oldLevel == null) { return("Level not found"); } if (_context.Levels.Any(a => a.Level == level.Level && !a.IsDeleted && a.Id != level.Id)) { return("Level already exist"); } //if (_context.Levels.Any(a => a.LevelRank == level.LevelRank && !a.IsDeleted && a.Id != level.Id)) // return "Rank already exist for another level"; oldLevel.Level = level.Level; return(_context.SaveChanges() > 0 ? "" : "Level could not be updated"); }
public string AddLevel(StudentLevel newLevel) { try { if (_context.Levels.Any(a => a.Level == newLevel.Level && !a.IsDeleted)) { return("Level already exists"); } //if (_context.Levels.Any(a => a.LevelRank == newLevel.LevelRank && !a.IsDeleted)) // return "A Level already exist for this Level rank"; newLevel.Id = Guid.NewGuid().ToString(); _context.Levels.Add(newLevel); return(_context.SaveChanges() > 0 ? "" : "Level could not be added"); } catch (Exception ex) { throw ex; } }
/// <summary> /// Function for Update Student Classes /// </summary> public StudentLevel StudentClassView(decimal classid) { StudentLevel studentclass = new StudentLevel(); MySqlDataReader sqlreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand cmd = new MySqlCommand("StudentClassViewOne", sqlcon); cmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = cmd.Parameters.Add("?classNo", MySqlDbType.Int32); sqlparam.Value = classid; sqlreader = cmd.ExecuteReader(); while (sqlreader.Read()) { studentclass.ClassNo = Convert.ToInt32(sqlreader[0].ToString()); studentclass.ClassSection = sqlreader[1].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); sqlreader.Close(); } return(studentclass); }
public Student(string firstName, string lastName, int age, StudentLevel level) : base(firstName, lastName, age) { Level = level; }
public Student(string fName, string lName, int age, StudentLevel level) : base(fName, lName, age) { Level = level; }