/// <summary>
/// Function to Edit values in Subject Table
/// </summary>
/// <param name="subjectinfo"></param>
public void SubjectUpdate(SubjectsInfo subjectinfo, decimal subjectid)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sqlcmd = new MySqlCommand("SubjectUpdate", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sqlparam = new MySqlParameter();
sqlparam = sqlcmd.Parameters.Add("?subject", MySqlDbType.VarChar);
sqlparam.Value = subjectinfo.SubjectName;
sqlparam = sqlcmd.Parameters.Add("?description", MySqlDbType.VarChar);
sqlparam.Value = subjectinfo.SubjectDescription;
sqlparam = sqlcmd.Parameters.Add("?subjectid", MySqlDbType.VarChar);
sqlparam.Value = subjectid;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcon.Close();
}
}
public void FillControls()
{
SubjectSP subjectsp = new SubjectSP();
SubjectsInfo subjectinfo = new SubjectsInfo();
subjectinfo = subjectsp.SubjectViewOne(subjectid);
txtSubjectName.Text = subjectinfo.SubjectName;
txtDescription.Text = subjectinfo.SubjectDescription;
}
public IEnumerable <Specialty> GetSpecialtyBySubjects([FromBody] SubjectsInfo subjectInfo)
{
if (this.User.Identity.IsAuthenticated)
{
return(this.specialtyProvider.GetSpecialtyBySubjects(this.User.FindFirstValue(ClaimTypes.NameIdentifier), subjectInfo.ListSubjects, subjectInfo.District, subjectInfo.Page));
}
else
{
return(this.specialtyProvider.GetSpecialtyBySubjects(string.Empty, subjectInfo.ListSubjects, subjectInfo.District, subjectInfo.Page));
}
}
public void EditFunction()
{
SubjectSP subjectsp = new SubjectSP();
SubjectsInfo subjectinfo = new SubjectsInfo();
subjectinfo.SubjectName = txtSubjectName.Text.Trim();
subjectinfo.SubjectDescription = txtDescription.Text.Trim();
subjectsp.SubjectUpdate(subjectinfo, subjectid);
Messages.UpdatedMessage();
FillSubjectGrid();
ClearFunction();
}
public void SaveFunction()
{
SubjectSP subjectsp = new SubjectSP();
SubjectsInfo subjectinfo = new SubjectsInfo();
subjectinfo.SubjectName = txtSubjectName.Text.Trim();
subjectinfo.SubjectDescription = txtDescription.Text.Trim();
subjectsp.SubjectAdd(subjectinfo);
Messages.SavedMessage();
FillSubjectGrid();
ClearFunction();
}
public SubjectsInfo SubjectViewOne(decimal subjectid)
{
SubjectsInfo subjectinfo = new SubjectsInfo();
MySqlDataReader sqlreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sqlcmd = new MySqlCommand("SubjectViewOne", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sqlparam = new MySqlParameter();
sqlparam = sqlcmd.Parameters.Add("?subjectid", MySqlDbType.Int32);
sqlparam.Value = subjectid;
sqlreader = sqlcmd.ExecuteReader();
while (sqlreader.Read())
{
subjectinfo.SubjectName = sqlreader[1].ToString();
subjectinfo.SubjectDescription = sqlreader[2].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcon.Close();
sqlreader.Close();
}
return(subjectinfo);
}
public Count GetCountBySubjects([FromBody] SubjectsInfo subjectInfo)
{
return(this.specialtyProvider.GetCountBySubjects(subjectInfo.ListSubjects, subjectInfo.District));
}
