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