public ResponseResult AddUser(UserInfoVM userInfoVM) { ResponseResult responseResult = new ResponseResult(); try { User user = new User() { UId = userInfoVM.UId, FirstName = userInfoVM.FirstName, LastName = userInfoVM.LastName, Birthday = userInfoVM.Birthday, Gender = userInfoVM.Gender, Email = userInfoVM.Email, Password = userInfoVM.Password, UserTypeId = userInfoVM.UserTypeId, Status = userInfoVM.Status }; _dbContext.Users.Add(user); //AssignGuardianWithStudent(userInfoVM.StudentId, userInfoVM.UId); _dbContext.SaveChanges(); responseResult.Content = null; responseResult.MessageCode = MessageCode.Y.ToString(); responseResult.SystemMessage = "Data Saved Succesfully."; } catch (Exception ex) { responseResult.Content = null; responseResult.MessageCode = MessageCode.N.ToString(); responseResult.SystemMessage = ex.Message; } return(responseResult); }
private void btnSave_Click(object sender, EventArgs e) { tblTeacher tb = new tblTeacher(); tb.TeacherName = txtTeacherName.Text; tb.Email = txtEmail.Text; tb.Remarks = txtRemarks.Text; db.tblTeachers.Add(tb); db.SaveChanges(); MessageBox.Show("Teacher Details Saved"); LoadGrid(); ClearData(); }
private void btnSave_Click(object sender, EventArgs e) { tblSession tb = new tblSession(); tb.SessionName = txtSessionName.Text; tb.StartDate = dateTimePicker1.Value; db.tblSessions.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Session Added"); LoadGrid(); ClearData(); } }
private void btnSave_Click(object sender, EventArgs e) { tblSubject tb = new tblSubject(); tb.SubjectName = txtSubjectName.Text; tb.Description = txtDescription.Text; db.tblSubjects.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Subject Added"); LoadGrid(); ClearData(); } }
private void btnSave_Click(object sender, EventArgs e) { tblTeacherSubjectMapping tb = new tblTeacherSubjectMapping(); tb.TeacherId = Convert.ToInt32(cboTeacher.SelectedValue); tb.SubjectId = Convert.ToInt32(cboSubject.SelectedValue); db.tblTeacherSubjectMappings.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Mapping Added"); LoadGrid(); ClearData(); } }
private void btnSave_Click(object sender, EventArgs e) { tblAssignment tb = new tblAssignment(); tb.SubjectId = Convert.ToInt32(cboSubjectId.SelectedValue); tb.ReleaseDate = dateTimePicker1.Value; tb.SubmissionDate = dateTimePicker2.Value; tb.Remarks = txtRemarks.Text; db.tblAssignments.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Assignment Added"); LoadGrid(); ClearData(); } }
private void btnChangePassword_Click(object sender, EventArgs e) { tblLogin tb = db.tblLogins.Where(u => u.Username == txtUsername.Text && u.Password == txtOldPassword.Text).FirstOrDefault(); if (tb != null) { if (txtNewPassword.Text == txtConfirmPassword.Text) { tb.Password = txtNewPassword.Text; if (db.SaveChanges() > 0) { MessageBox.Show("User Password Changed"); ClearData(); } else { MessageBox.Show("Please Confirm New Password"); } } } else { MessageBox.Show("You have entered wrong password"); } }
private void btnSave_Click(object sender, EventArgs e) { tblStaff tb = new tblStaff(); tb.StaffName = txtStaffName.Text; tb.UserName = txtUsername.Text; tb.Password = txtPassword.Text; tb.Email = txtEmail.Text; tb.ContactNo = txtContactNumber.Text; db.tblStaffs.Add(tb); if (db.SaveChanges() > 0) { LoadGrid(); MessageBox.Show("Staff Details Added"); ClearData(); } ; }
private void btnSave_Click(object sender, EventArgs e) { tblStudent tb = new tblStudent(); tb.StudentName = txtStudentName.Text; tb.Address = txtStudentAddress.Text; tb.Email = txtEmail.Text; tb.Contact = txtContact.Text; tb.SessionId = Convert.ToInt32(cboSessionId.SelectedValue); tb.FacultyId = Convert.ToInt32(cboFacultyId.SelectedValue); db.tblStudents.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Student Added"); LoadGrid(); ClearData(); } }
private void btnSave_Click(object sender, EventArgs e) { tblFaculty tb = new tblFaculty(); tb.FacultyDescription = txtFacultyDescription.Text; db.tblFaculties.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Faculty Added"); LoadGrid(); ClearData(); } }
public ResponseResult AddStudent(StudentVM studentVM) { ResponseResult responseResult = new ResponseResult(); try { long sId = GenerateStudentId(); StudentBasic studentBasic = new StudentBasic() { StudentId = sId, Name = studentVM.Name, Birthday = studentVM.Birthday, FatherName = studentVM.FatherName, MotherName = studentVM.MotherName, PresentAddress = studentVM.PresentAddress, PermanentAddress = studentVM.PermanentAddress, Contact1 = studentVM.Contact1, Contact2 = studentVM.Contact2 }; StudentInfo studentInfo = new StudentInfo() { StudentId = sId, Roll = studentVM.Roll, ClassId = studentVM.ClassId, SectionId = studentVM.SectionId, Shift = studentVM.Shift, Year = studentVM.Year, Residential = studentVM.Residential }; _dbContext.StudentBasics.Add(studentBasic); _dbContext.StudentInfoes.Add(studentInfo); _dbContext.SaveChanges(); responseResult.Content = null; responseResult.MessageCode = MessageCode.Y.ToString(); responseResult.SystemMessage = "Data Saved Succesfully."; } catch (Exception ex) { responseResult.Content = null; responseResult.MessageCode = MessageCode.N.ToString(); responseResult.SystemMessage = ex.Message; } return(responseResult); }
private void btnSave_Click(object sender, EventArgs e) { tblAssignmentSubmission tb = new tblAssignmentSubmission(); tblStudent tbl = db.tblStudents.Where(a => a.StudentId == studentid).FirstOrDefault(); tb.StudentId = tbl.StudentId; tb.AssignmentId = Convert.ToInt32(cboAssignmentId.SelectedValue); tb.StatusId = Convert.ToInt32(cboStatusId.SelectedValue); tb.SubmittedDate = dateTimePicker1.Value; tblAssignment tba = db.tblAssignments.Where(a => a.AssignmentId == tb.AssignmentId).FirstOrDefault(); DateTime subdate = Convert.ToDateTime(tb.SubmittedDate); DateTime submissiondate = Convert.ToDateTime(tba.SubmissionDate); //DateTime submissiondate = Convert.ToDateTime(tba.ReleaseDate); TimeSpan dt = subdate.Subtract(submissiondate); if (dt.TotalDays >= 1) { txtIsOnTime.Text = "No"; int d = Convert.ToInt16(dt.TotalDays); MessageBox.Show("Assignment Submission Late by " + d + " days"); } else { txtIsOnTime.Text = "Yes"; } tb.IsOnTime = Convert.ToString(txtIsOnTime.Text); db.tblAssignmentSubmissions.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Assignment Submitted"); LoadGrid(); // ClearData(); } }