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