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