public void AddEvaluation(Entities.Recommendations r1)
{
using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertEvaluation]"))
{
s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, r1.studentId);
s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, r1.teacher);
s1.AddParameter("@Adate", System.Data.SqlDbType.Date, r1.Adate);
s1.AddParameter("@appitude", System.Data.SqlDbType.NVarChar, r1.appitude);
s1.AddParameter("@attitude", System.Data.SqlDbType.NVarChar, r1.attitude);
s1.AddParameter("@recommendation", System.Data.SqlDbType.NVarChar, r1.recommendation);
s1.Execute();
}
}
protected void ADDEvaluation(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Evaluation')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Recommendations r1 = new Entities.Recommendations()
{
studentId = EDropDown.SelectedValue,
teacher = Session["School"].ToString(),
Adate = DateTime.Now.ToShortDateString(),
appitude = EAptitude.Value,
attitude = EAttitude.Value,
recommendation = ERecommendation.Value,
};
db.AddEvaluation(r1);
Label1.Text = "Student Evaluated Successfully";
}
}
