protected void lnkAdd_Click(object sender, EventArgs e)
{
using (CocaDataContext ctx = new CocaDataContext())
{
var school = ctx.Schools.Where(s => s.Id == _school).SingleOrDefault();
var year = school.SchoolYears.Where(y => y.Year.Name == _year).SingleOrDefault();
StudentGroup group = year.StudentGroups.Where(g => g.Id == _groupId && g.Surveys.Any(sg => sg.Season.Name == _season || string.IsNullOrEmpty(_season))).SingleOrDefault();
Student student = new Student() { FirstName="", LastName = "", ClassRoom = "", StudentGroup = group};
ctx.Students.InsertOnSubmit(student);
ctx.SubmitChanges();
}
StudentGrid.EditIndex = 0;
FillGrid();
}
protected void btnSave_Click(object sender, EventArgs e)
{
CocaDataContext ctx = new CocaDataContext();
School sch = new School();
sch.Name = txtSchool.Text;
sch.Address1 = txtAddress1.Text;
sch.Address2 = txtAddress2.Text;
sch.Address3 = txtAddress3.Text;
sch.City = txtCity.Text;
sch.StateId = Convert.ToInt32(ddlStates.SelectedValue);
sch.Zip = txtZip.Text;
ctx.Schools.InsertOnSubmit(sch);
ctx.SubmitChanges();
MsgText.Text = "School successfully created!.";
MsgText.Visible = true;
}
protected void FinishedId_Click(object sender, EventArgs e)
{
using (CocaDataContext ctx = new CocaDataContext())
{
AnonStudent loggedInStudent = (from AnonStudent a in ctx.AnonStudents where a.Id == this.anonStudentId select a).FirstOrDefault();
List<SurveyStudent> ssds = (from SurveyStudent ssd in ctx.SurveyStudents
where ssd.Survey.Equals(loggedInStudent.Survey)
select ssd).ToList();
foreach (GridViewRow row in gvStudentSurveyList.Rows)
{
long ssdId = (long)gvStudentSurveyList.DataKeys[row.RowIndex].Value;
SurveyStudent ssd = (from s in ssds where s.Id == ssdId select s).FirstOrDefault();
TextBox commentText = (TextBox)row.FindControl("txtComment");
DropDownList bullyAmount = (DropDownList)row.FindControl("ddlBullyTimes");
DropDownList targetAmount = (DropDownList)row.FindControl("ddlTargetTimes");
StudentSurveyRating rating = new StudentSurveyRating();
rating.AnonStudent = loggedInStudent;
rating.SurveyStudent = ssd;
int timesBully;
int timesTarget;
if(!string.IsNullOrEmpty(bullyAmount.SelectedValue) && int.TryParse(bullyAmount.SelectedValue,out timesBully ))
rating.IsBullyValue = timesBully;
if(!string.IsNullOrEmpty(targetAmount.SelectedValue) && int.TryParse(targetAmount.SelectedValue, out timesTarget))
rating.IsTargetValue = timesTarget;
rating.Comment = commentText.Text;
ctx.StudentSurveyRatings.InsertOnSubmit(rating);
}
loggedInStudent.SavedDate = DateTime.Today;
loggedInStudent.LoggedInDate = DateTime.Now;
Session.Remove(KEY_AnonStudent);
ctx.SubmitChanges();
Session.Clear();
ReturnToLogin();
}
}
protected void StudentGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string firstName = ((TextBox)((GridView)sender).Rows[e.RowIndex].FindControl("fnameEdit")).Text;
string lastName = ((TextBox)((GridView)sender).Rows[e.RowIndex].FindControl("lnameEdit")).Text;
string classroom = ((TextBox)((GridView)sender).Rows[e.RowIndex].FindControl("classroomEdit")).Text;
long id = (long)((GridView)sender).DataKeys[e.RowIndex].Value;
using (CocaDataContext ctx = new CocaDataContext())
{
Student student = (from s in ctx.Students where s.Id == id select s).FirstOrDefault();
if (student != null)
{
student.FirstName = firstName;
student.LastName = lastName;
student.ClassRoom = classroom;
ctx.SubmitChanges();
}
}
StudentGrid.EditIndex = -1;
FillGrid();
}
protected void StudentGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
long id = (long)((GridView)sender).DataKeys[e.RowIndex].Value;
using (CocaDataContext ctx = new CocaDataContext())
{
Student student = (from s in ctx.Students where s.Id == id select s).FirstOrDefault();
if (student != null)
{
ctx.Students.DeleteOnSubmit(student);
ctx.SubmitChanges();
}
}
StudentGrid.EditIndex = -1;
FillGrid();
}