protected void AddNewTeacher_ActiveStepChanged(object sender, EventArgs e) { //Get the UserID for the just added user MembershipUser newUser = Membership.GetUser(AddNewTeacher.UserName); newUser.ChangePassword(AddNewTeacher.Password, "admin123"); Guid newUserId = (Guid)newUser.ProviderUserKey; // Have we JUST reached the Complete step? if (AddNewTeacher.ActiveStep.Title == "Complete") { //CreateUserWizardStep CustStep = AddNewStudent.FindControl("CreateUserWizardStep1") as CreateUserWizardStep; //TemplateControl CustStep = CreateUserWizardStep1.ContentTemplate as TemplateControl; TextBox FirstName = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("FirstName") as TextBox; TextBox Email = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("Email") as TextBox; TextBox UserName = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("UserName") as TextBox; // Programmatically reference the TextBox controls // TextBox FirstName = CreateUserWizardStep1.FindControl("FirstName") as TextBox; TextBox LastName = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("LastName") as TextBox; DropDownList Gender = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("Gender") as DropDownList; TextBox Contact = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("Contact") as TextBox; TextBox Education = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("Education") as TextBox; TextBox Designation = AddNewTeacher.CreateUserStep.ContentTemplateContainer.FindControl("Designation") as TextBox; // Insert a new record into student profiles string connectionString = ConfigurationManager.ConnectionStrings["EIMSConnectionString"].ConnectionString; //string insertSql = "INSERT INTO StudentProfiles(FirstName, LastName, Contact, Department, Batch, RollNo) VALUES(@FirstName, @LastName, @Contact, @Department, @Batch, @RollNo)"; string insertSql = "INSERT INTO TeacherProfiles(TeacherId, FirstName, LastName, Contact, Education, Designation, Gender) VALUES(@UserId, @FirstName, @LastName, @Contact, @Education, @Designation, @Gender)"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@FirstName", FirstName.Text.Trim()); myCommand.Parameters.AddWithValue("@LastName", LastName.Text.Trim()); myCommand.Parameters.AddWithValue("@Contact", Contact.Text.Trim()); myCommand.Parameters.AddWithValue("@Education", Education.Text.Trim()); myCommand.Parameters.AddWithValue("@Designation", Designation.Text.Trim()); myCommand.Parameters.AddWithValue("@Gender", Gender.SelectedItem.Text); myCommand.Parameters.AddWithValue("@UserId", newUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } Roles.AddUserToRole(AddNewTeacher.UserName, "teacher"); //Email EimsHelper.SendMail(Email.Text, "EIMS Registration.", "Hi Mr." + FirstName.Text + " " + LastName.Text + ".\nYou are added as a faculty member on Educational Institute Management System.\nYou can log in with these credentials:\nUsername: "******"\nPassword: "******"admin123" + "\nWe hope to provide you a great experience."); } }
protected void btnInsert_Click(object sender, ImageClickEventArgs e) { if (Request.QueryString["id"] != null) { TextBox TotalClasses = (TextBox)gvCrud.FooterRow.FindControl("TotalClassesInsert"); DropDownList AttendanceWeek = (DropDownList)gvCrud.FooterRow.FindControl("AttendanceWeekSelect"); TextBox ClassesAttended = (TextBox)gvCrud.FooterRow.FindControl("ClassesAttendedInsert"); TextBox ClassesMissed = (TextBox)gvCrud.FooterRow.FindControl("ClassesMissedInsert"); float attendancePercentage = (Convert.ToSingle(ClassesAttended.Text) / Convert.ToSingle(TotalClasses.Text)) * 100; sqlcon.Open(); using (sqlcom = new SqlCommand("insert into attendance values(@Week,@StudentId,@SemesterId,@TotalClasses,@ClassesAttended,@ClassesMissed,@AttendancePercentage)", sqlcon)) { sqlcom.CommandType = CommandType.Text; sqlcom.Parameters.AddWithValue("@Week", AttendanceWeek.SelectedValue); sqlcom.Parameters.AddWithValue("@StudentId", studentId); //TODO semester ID from drop down sqlcom.Parameters.AddWithValue("@SemesterId", 8); sqlcom.Parameters.AddWithValue("@TotalClasses", TotalClasses.Text); sqlcom.Parameters.AddWithValue("@ClassesAttended", ClassesAttended.Text); sqlcom.Parameters.AddWithValue("@ClassesMissed", ClassesMissed.Text); sqlcom.Parameters.AddWithValue("@AttendancePercentage", attendancePercentage); int rows = sqlcom.ExecuteNonQuery(); if (rows > 0) { DataView dvSql2 = (DataView)AssociationDataSource.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql2) { //checking if a record is present in the data view, then show the associated parent if (drvSql["ParentId"].ToString() != "") { parent = Membership.GetUser(drvSql["ParentId"]); //Email EimsHelper.SendMail(parent.Email, "EIMS Notification: Child Attendance Added.", "Hi Mr./Miss " + parent.UserName + ".\nYour child has a new attendance record. Take a look at the details:\nAttendance Week: " + AttendanceWeek.Text + " \nTotal Classes: " + TotalClasses.Text + "\nClasses Attended: " + ClassesAttended.Text + "\nClasses Missed: " + ClassesMissed.Text + "\nAttendance Percentage: " + attendancePercentage + "\nFor further information and reports you can always login to the EIMS with credentials you have been provided."); EimsHelper.SendMail(student.Email, "EIMS Notification: Child Attendance Added.", "Dear " + student.UserName + ".\nA new attendance record has been added to your profile and an email notification has been sent to your parent/guardian's email account. Take a look at the details:\nAttendance Week: " + AttendanceWeek.Text + " \nTotal Classes: " + TotalClasses.Text + "\nClasses Attended: " + ClassesAttended.Text + "\nClasses Missed: " + ClassesMissed.Text + "\nAttendance Percentage: " + attendancePercentage + "\nFor further information and reports you can always login to the EIMS with credentials you have been provided."); Session["Notice"] = "Attendance record has been added and Email has been sent to parent/guardian and the student!"; Response.Redirect("~/shared/StudentProfile.aspx?id=" + Request.QueryString["id"]); } } EimsHelper.SendMail(student.Email, "EIMS Notification: Child Attendance Added.", "Dear " + student.UserName + ".\nA new attendance record has been added to your profile and an email notification has been sent to your parent/guardian's email account. Take a look at the details:\nAttendance Week: " + AttendanceWeek.Text + " \nTotal Classes: " + TotalClasses.Text + "\nClasses Attended: " + ClassesAttended.Text + "\nClasses Missed: " + ClassesMissed.Text + "\nAttendance Percentage: " + attendancePercentage + "\nFor further information and reports you can always login to the EIMS with credentials you have been provided."); Session["Notice"] = "Attendance record has been added and Email has been sent to the student only because no guardian could be found!"; Response.Redirect("~/shared/StudentProfile.aspx?id=" + Request.QueryString["id"]); BindGrid(); } } } }
protected void UpdateProfile_Click(object sender, EventArgs e) { MembershipUser student = Membership.GetUser(User.Identity.Name); Guid studentId = (Guid)student.ProviderUserKey; string connectionString = ConfigurationManager.ConnectionStrings["EIMSConnectionString"].ConnectionString; string updateSql = "UPDATE StudentProfiles SET FirstName=@FirstName,LastName=@LastName,Contact=@Contact,Address=@Address,Gender=@Gender,Avatar=@Avatar WHERE StudentId=@StudentId"; string fileName; string ext = System.IO.Path.GetExtension(this.FUDisplayPic.PostedFile.FileName); fileName = Server.MapPath("~/img/StudentAvatars/Display_picture_" + User.Identity.Name + ext); using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(updateSql, myConnection); myCommand.Parameters.AddWithValue("@FirstName", TxtFirstName.Text); myCommand.Parameters.AddWithValue("@LastName", TxtLastName.Text); myCommand.Parameters.AddWithValue("@Contact", TxtContact.Text); myCommand.Parameters.AddWithValue("@Address", TxtAddress.Text); myCommand.Parameters.AddWithValue("@Gender", DDGender.SelectedValue); myCommand.Parameters.AddWithValue("@StudentId", studentId); if (FUDisplayPic.HasFile) { myCommand.Parameters.AddWithValue("@Avatar", "~/img/StudentAvatars/Display_picture_" + User.Identity.Name + ext); FUDisplayPic.SaveAs(fileName); } else { myCommand.Parameters.AddWithValue("@Avatar", DisplayPicture.ImageUrl); } myCommand.ExecuteNonQuery(); } student.Email = TxtEmail.Text; Membership.UpdateUser(student); EimsHelper.SendMail("*****@*****.**", "EIMS Notification.", "Hi Mr./Ms." + "Sarmad" + " " + "Sabih" + ".\nYour child has updated his profile settings.\nYou can log in and see his/her profile to verify the changes.\nIn case of any misinformation you can feel free to contact the administrator." + "\nWe hope to provide you a great experience."); Session["Notice"] = "Your Profile has been updated! And your Parent/Guardian has been notified about the changes via an Email."; Response.Redirect("~/students/settings.aspx"); }
protected void AddNewStudent_ActiveStepChanged(object sender, EventArgs e) { //Get the UserID for the just added user MembershipUser newUser = Membership.GetUser(AddNewStudent.UserName); newUser.ChangePassword(AddNewStudent.Password, "admin123"); Guid newUserId = (Guid)newUser.ProviderUserKey; // Have we JUST reached the Complete step? if (AddNewStudent.ActiveStep.Title == "Complete") { //CreateUserWizardStep CustStep = AddNewStudent.FindControl("CreateUserWizardStep1") as CreateUserWizardStep; //TemplateControl CustStep = CreateUserWizardStep1.ContentTemplate as TemplateControl; TextBox FirstName = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("FirstName") as TextBox; TextBox Email = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Email") as TextBox; TextBox UserName = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("UserName") as TextBox; //TextBox Password = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Password") as TextBox; // Programmatically reference the TextBox controls //TextBox FirstName = CreateUserWizardStep1.FindControl("FirstName") as TextBox; TextBox LastName = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("LastName") as TextBox; TextBox Contact = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Contact") as TextBox; DropDownList Department = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Department") as DropDownList; DropDownList Batch = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Batch") as DropDownList; DropDownList Gender = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Gender") as DropDownList; TextBox RollNum = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("RollNum") as TextBox; TextBox Address = AddNewStudent.CreateUserStep.ContentTemplateContainer.FindControl("Address") as TextBox; //Insert a new record into student profiles string connectionString = ConfigurationManager.ConnectionStrings["EIMSConnectionString"].ConnectionString; //string insertSql = "INSERT INTO StudentProfiles(FirstName, LastName, Contact, Department, Batch, RollNo) VALUES(@FirstName, @LastName, @Contact, @Department, @Batch, @RollNo)"; string insertSql = "INSERT INTO StudentProfiles(StudentId, FirstName, LastName, Contact, DepartmentId, BatchId, RollNo, Gender, Address) VALUES(@UserId, @FirstName, @LastName, @Contact, @Department, @Batch, @RollNo, @Gender, @Address)"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@FirstName", FirstName.Text.Trim()); myCommand.Parameters.AddWithValue("@LastName", LastName.Text.Trim()); myCommand.Parameters.AddWithValue("@Contact", Contact.Text.Trim()); myCommand.Parameters.AddWithValue("@Department", Department.SelectedItem.Value); myCommand.Parameters.AddWithValue("@Batch", Batch.SelectedItem.Value); myCommand.Parameters.AddWithValue("@Gender", Gender.SelectedItem.Value.ToString()); string rollNumber = ""; DataView dvSql = (DataView)DepartmentsDataSource.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql) { if (drvSql["DepartmentName"].ToString() == Department.SelectedItem.Text) { rollNumber = drvSql["DepartmentInitials"].ToString(); } } rollNumber = rollNumber + "-" + Batch.SelectedItem.Text + "-" + RollNum.Text; myCommand.Parameters.AddWithValue("@RollNo", rollNumber); myCommand.Parameters.AddWithValue("@Address", Address.Text.Trim()); myCommand.Parameters.AddWithValue("@UserId", newUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } Roles.AddUserToRole(AddNewStudent.UserName, "student"); //Email EimsHelper.SendMail(Email.Text, "EIMS Registration.", "Hi Mr." + FirstName.Text + " " + LastName.Text + ".\nYou are added as a student on Educational Institute Management System.\nYou can log in with these credentials:\nUsername: "******"\nPassword: "******"admin123" + "\nWe hope to provide you a great experience."); } }