public TeacherAllocationViewModel AddAndUpdateTeacherAllocation(TeacherAllocationViewModel vmModel) { try { if (vmModel.ID > 0) { var record = _db.TeacherAllocations.OrderByDescending(x => x.ID).Where(x => x.ID == vmModel.ID).FirstOrDefault(); record.ClassMasterID = vmModel.ClassMasterID; record.TeacherMasterID = vmModel.TeacherMasterID; record.StudentMasterID = vmModel.StudentMasterID; _db.SaveChanges(); } else { TeacherAllocation _TeacherAllocation = new TeacherAllocation(); _TeacherAllocation.ClassMasterID = vmModel.ClassMasterID; _TeacherAllocation.TeacherMasterID = vmModel.TeacherMasterID; _TeacherAllocation.StudentMasterID = vmModel.StudentMasterID; _db.TeacherAllocations.Add(_TeacherAllocation); _db.SaveChanges(); vmModel.ID = _TeacherAllocation.ID; } } catch (Exception ex) { } return(vmModel); }
public IHttpActionResult PutExamType(int id, ExamType examType) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != examType.ExamTypeId) { return(BadRequest()); } db.Entry(examType).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ExamTypeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutTeacher(int id, Teacher teacher) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != teacher.TeacherId) { return(BadRequest()); } db.Entry(teacher).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TeacherExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// PUT odata/EmployeeOdata(5) public IHttpActionResult Put([FromODataUri] int key, Employee employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (key != employee.Id) { return(BadRequest()); } db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeExists(key)) { return(NotFound()); } else { throw; } } return(Updated(employee)); }
public IHttpActionResult PutStudent(int id, Student student) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != student.StudentId) { return(BadRequest()); } db.Entry(student).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!StudentExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,EnrollmentDate")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "CourseID,Title,Credits")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create([Bind(Include = "ID,FirstName,LastName")] Instructor instructor) { if (ModelState.IsValid) { db.Instructors.Add(instructor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(instructor)); }
public ActionResult Create([Bind(Include = "ReportResultId,StudentId,CourseId,ExamTypeId,Marks")] ReportResult reportResult) { if (ModelState.IsValid) { db.ReportResults.Add(reportResult); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reportResult)); }
public ActionResult Create([Bind(Include = "EnrollmentID,Grade,CourseID,StudentID,InstructorID")] Enrollment enrollment) { if (ModelState.IsValid) { db.Enrollments.Add(enrollment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollment.CourseID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "LastName", enrollment.StudentID); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "FirstName", enrollment.InstructorID); return(View(enrollment)); }
public int InsertStudentSectionAllocation(int SessionId, int ClassId, int EnquiryId, int AdmissionId, int SectionId, bool isactive, string status) { int TotalStudent = 0; using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; tblPromoteToClass obj = new tblPromoteToClass(); if (obj != null) { obj.AdmissionId = AdmissionId; obj.SectionId = SectionId; obj.IsActive = isactive; obj.Status = status; dbcontext.tblPromoteToClasses.Add(obj); dbcontext.SaveChanges(); tblEnquiryDetail obj1 = dbcontext.tblEnquiryDetails.Where(x => x.EnquiryId == EnquiryId).FirstOrDefault(); if (obj1 != null) { obj1.SectionId = SectionId; dbcontext.SaveChanges(); } tblAdmission obj2 = dbcontext.tblAdmissions.Where(x => x.AdmissionId == AdmissionId).FirstOrDefault(); if (obj2 != null) { obj2.InSectionStatus = status; dbcontext.SaveChanges(); } } TotalStudent = 1; } catch (Exception ex) { response.success = false; response.message = ex.Message; TotalStudent = 0; } } } return(TotalStudent); }
public int CancelAllocatedStudentSection(int Id) { int Result = 0; using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.PromoteToClassId == Id); if (rs != null) { rs.SectionId = null; rs.RollNo = null; rs.Status = null; } dbcontext.SaveChanges(); Result = 1; } catch (Exception ex) { response.success = false; response.message = ex.Message; Result = 0; } } } return(Result); }
public Response Update_tbAttendance(AttendanceCustomModel objModel) { DateTime DateCheck = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0)); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { tblAttendance cmd = dbcontext.tblAttendances.FirstOrDefault(x => x.IsDeleted == false && x.AdmissionId == objModel.AdmissionId && x.AttendanceDate.Year == DateCheck.Year && x.AttendanceDate.Month == DateCheck.Month && x.AttendanceDate.Day == DateCheck.Day && x.SectionId == objModel.SectionId ); if (cmd != null) { cmd.Attendance = objModel.Attendance; dbcontext.SaveChanges(); response.message = "Record Updated Successfully!!"; } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public ActionResult Create(StudentDTO student) { if (ModelState.IsValid) { Student dbStudent = new Student() { StudentID = student.StudentID, Name = student.Name, Email = student.Email, City = student.City, Class = student.Class, Country = student.Country, EnrollYear = student.EnrollYear }; db.Students.Add(dbStudent); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public StudentMasterViewModel AddAndUpdateStudentMaster(StudentMasterViewModel vmModel) { try { if (vmModel.ID > 0) { var record = _db.StudentMasters.OrderByDescending(x => x.ID).Where(x => x.ID == vmModel.ID).FirstOrDefault(); record.Name = vmModel.Name; record.FatherName = vmModel.FatherName; record.Address = vmModel.Address; record.PhoneNo = vmModel.PhoneNo; record.Email = vmModel.Email; record.DOB = vmModel.DOB; record.Gender = vmModel.Gender; _db.SaveChanges(); } else { StudentMaster _StudentMaster = new StudentMaster(); _StudentMaster.Name = vmModel.Name; _StudentMaster.FatherName = vmModel.FatherName; _StudentMaster.Address = vmModel.Address; _StudentMaster.PhoneNo = vmModel.PhoneNo; _StudentMaster.Email = vmModel.Email; _StudentMaster.DOB = vmModel.DOB; _StudentMaster.Gender = vmModel.Gender; _db.StudentMasters.Add(_StudentMaster); _db.SaveChanges(); vmModel.ID = _StudentMaster.ID; } } catch (Exception ex) { } return(vmModel); }
public ClassMasterViewModel AddAndUpdateClassMaster(ClassMasterViewModel vmModel) { try { if (vmModel.ID > 0) { var record = _db.ClassMasters.OrderByDescending(x => x.ID).Where(x => x.ID == vmModel.ID).FirstOrDefault(); record.ClassName = vmModel.ClassName; _db.SaveChanges(); } else { ClassMaster _classMaster = new ClassMaster(); _classMaster.ClassName = vmModel.ClassName; _db.ClassMasters.Add(_classMaster); _db.SaveChanges(); vmModel.ID = _classMaster.ID; } } catch (Exception ex) { } return(vmModel); }
public Response UpdatePassword(ChangePasswordCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; var rs = dbcontext.tblUserLogins.FirstOrDefault(x => x.IsDeleted == false && x.UserName == objModel.UserName); if (rs != null) { var objUpdate = dbcontext.tblUserLogins.FirstOrDefault(m => m.IsDeleted == false && m.Password == objModel.Password); if (objUpdate != null) { objUpdate.Password = objModel.NewPassword; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { SectionId = objUpdate.Id }; response.success = true; response.message = "1"; } else { response.success = false; response.message = "2"; } } else { response.success = false; response.message = "3"; } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public object SetDefaultSessionRegistrationDetail(SessionMasterCustomModel objModel) { object objClassResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var CheckActive = dbcontext.tblSessions.FirstOrDefault(x => x.IsDefault == true && x.SessionId != objModel.SessionId); if (CheckActive == null) { var rs = dbcontext.tblSessions.FirstOrDefault(x => x.SessionId == objModel.SessionId); if (rs != null) { rs.IsDefault = rs.IsDefault == true ? false : true; rs.ModifiedDate = DateTime.Now; rs.ModifiedBy = objModel.ModifiedBy; dbcontext.SaveChanges(); objClassResult = true; } else { objClassResult = false; } } else { objClassResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objClassResult = null; throw ex; } } return(objClassResult); } }
public Response UpdateStudentRollNoAllocation(PromoteToClassCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.IsDeleted == false && x.IsActive == true && x.PromoteToClassId == objModel.PromoteToClassId); if (rs != null) { rs.RollNo = objModel.RollNo; rs.ModifiedBy = objModel.ModifiedBy; rs.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { PromoteToClassId = objModel.PromoteToClassId }; response.message = "Record Added Successfully!"; } else { response.message = "Record Not Exists!"; } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
/// <summary> /// This method is used to Activate particular farmer detail /// </summary> /// <param name="AssetId">Unique id of Farmer</param> /// <returns>Response</returns> public object SetActiveEventRegistrationDetail(EventMasterCustomModel objEventRegistrationModel) { object objEmployeeResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var rs = dbcontext.tblEvents.FirstOrDefault(x => x.EventId == objEventRegistrationModel.EventId); if (rs != null) { rs.IsActive = rs.IsActive == true ? false : true; //rs.ModifiedDate = DateTime.Now; //rs.ModifiedBy = objEventRegistrationModel.ModifiedBy; dbcontext.SaveChanges(); objEmployeeResult = true; } else { objEmployeeResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objEmployeeResult = null; throw ex; } } return(objEmployeeResult); } }
/// <summary> /// This method is used to delete particular farmer detail /// </summary> /// <param name="AssetId">Unique id of asset</param> /// <returns>Response</returns> public object DeleteSchoolRegistrationDetail(SchoolMasterCustomModel objSchoolRegistrationModel) { object objSchoolResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var rs = dbcontext.tblSchools.FirstOrDefault(x => x.SchoolId == objSchoolRegistrationModel.SchoolId); if (rs != null) { rs.IsDeleted = true; rs.ModifiedDate = DateTime.Now; rs.ModifiedBy = objSchoolRegistrationModel.ModifiedBy; dbcontext.SaveChanges(); objSchoolResult = true; } else { objSchoolResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objSchoolResult = null; throw ex; } } return(objSchoolResult); } }
public object SetActiveEnquiryDetail(EnquiryDetailCustomModel objEnquiryDetailModel) { object objClassResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var rs = dbcontext.tblEnquiryDetails.FirstOrDefault(x => x.EnquiryId == objEnquiryDetailModel.EnquiryId); if (rs != null) { rs.IsActive = rs.IsActive == true ? false : true; rs.ModifiedDate = DateTime.Now; rs.ModifiedBy = objEnquiryDetailModel.ModifiedBy; dbcontext.SaveChanges(); objClassResult = true; } else { objClassResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objClassResult = null; throw ex; } } return(objClassResult); } }
public Response SaveSchoolMasterDetails(SchoolMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.SchoolId == 0) { var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name); if (rs == null) { tblSchool objAddNew = new tblSchool { Name = objModel.Name, MobileNo = objModel.MobileNo, ShortDescription = objModel.ShortDescription, EmailId = objModel.EmailId, Address = objModel.Address, Address2 = objModel.Address2, City = objModel.City, Country = objModel.Country, Image = objModel.Image, Logo = objModel.Logo, State = objModel.State, TagLine = objModel.TagLine, DDate = DateTime.Now, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblSchools.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { SchoolId = objAddNew.SchoolId, Name = objAddNew.Name }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name && x.SchoolId != objModel.SchoolId); if (rs == null) { var objUpdate = dbcontext.tblSchools.FirstOrDefault(m => m.SchoolId == objModel.SchoolId); if (objUpdate != null) { objUpdate.Name = objModel.Name; objUpdate.ShortDescription = objModel.ShortDescription; objUpdate.MobileNo = objModel.MobileNo; objUpdate.EmailId = objModel.EmailId; objUpdate.Address = objModel.Address; objUpdate.Address2 = objModel.Address2; objUpdate.City = objModel.City; objUpdate.Country = objModel.Country; objUpdate.Image = objModel.Image; objUpdate.Logo = objModel.Logo; objUpdate.State = objModel.State; objUpdate.TagLine = objModel.TagLine; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { SchoolId = objUpdate.SchoolId, Name = objUpdate.Name }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveEnquiryDetails(EnquiryDetailCustomModel objModel) { int NewEnquiryId = 0; int NewAdmissionId = 0; using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.EnquiryId == 0) { var rs = dbcontext.tblEnquiryDetails.FirstOrDefault(x => x.IsDeleted == false && x.EmailId == objModel.EmailId && x.MobileNo == objModel.MobileNo); if (rs == null) { tblEnquiryDetail objAddNew = new tblEnquiryDetail { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), ClassId = objModel.ClassId, SessionId = objModel.SessionId, FName = objModel.FName, LName = objModel.LName, MobileNo = objModel.MobileNo, EmailId = objModel.EmailId, FatherName = objModel.FatherName, MotherName = objModel.MotherName, Village = objModel.Village, City = objModel.City, State = objModel.State, PinCode = objModel.PinCode, Address = objModel.Address, Country = "India", Gender = objModel.Gender, BloodGroup = objModel.BloodGroup, AadharNumber = objModel.AadharNumber, Landline = objModel.Landline, Qualification = objModel.Qualification, DateOfBirth = objModel.DateOfBirth, EnquiryDate = objModel.EnquiryDate, CounsellorName = objModel.CounsellorName, Comments = objModel.Comments, Status = objModel.Status, HowToKnowUs = objModel.HowToKnowUs, ReferredBy = objModel.ReferredBy, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now, }; dbcontext.tblEnquiryDetails.Add(objAddNew); dbcontext.SaveChanges(); if (objModel.Status == "Registered") { tblAdmission objAddAdmission = new tblAdmission { EnquiryId = objAddNew.EnquiryId, AdmissionDate = objModel.AdmissionModel.AdmissionDate, TotalFees = objModel.AdmissionModel.TotalFees, RegistrationFees = objModel.AdmissionModel.RegistrationFees, FeeToBePaid = (Convert.ToDecimal(objModel.AdmissionModel.TotalFees) - Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount)), DiscountType = objModel.AdmissionModel.DiscountType, DiscountAmount = objModel.AdmissionModel.DiscountAmount, BalanceAmountDue = (Convert.ToInt32(objModel.AdmissionModel.TotalFees) - (Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount) + Convert.ToDecimal(objModel.AdmissionModel.RegistrationFees))), FeeIncharge = objModel.AdmissionModel.FeeIncharge, PaymentMode = objModel.AdmissionModel.PaymentMode, NoOfInstallments = objModel.AdmissionModel.NoOfInstallments, NextPaymentDate = objModel.AdmissionModel.NextPaymentDate, EnquiryStatus = objModel.Status, InSectionStatus = objModel.Status, IsActive = true, IsDeleted = false, CreatedBy = objModel.AdmissionModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.AdmissionModel.ModifiedBy, ModifiedDate = DateTime.Now, }; dbcontext.tblAdmissions.Add(objAddAdmission); dbcontext.SaveChanges(); tblFeeCollection objAddAdmissionFee = new tblFeeCollection { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), AdmissionId = objAddAdmission.AdmissionId, AmountPaid = objModel.AdmissionModel.RegistrationFees, FeeDate = DateTime.Now, FeeInCharge = objModel.AdmissionModel.FeeIncharge, FeeMode = objModel.AdmissionModel.PaymentMode, FeeType = "Registration Fees", CreatedDate = DateTime.Now, CreatedBy = objModel.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, IsActive = true, IsDeleted = false, }; dbcontext.tblFeeCollections.Add(objAddAdmissionFee); dbcontext.SaveChanges(); } response.responseData = new { EnquiryId = objAddNew.EnquiryId, FName = objAddNew.FName }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblEnquiryDetails.FirstOrDefault(x => x.IsDeleted == false && x.EmailId == objModel.EmailId && x.EnquiryId != objModel.EnquiryId); if (rs == null) { var objUpdate = dbcontext.tblEnquiryDetails.FirstOrDefault(m => m.EnquiryId == objModel.EnquiryId); if (objUpdate != null) { objUpdate.ClassId = objModel.ClassId; objUpdate.SessionId = objModel.SessionId; objUpdate.FName = objModel.FName; objUpdate.LName = objModel.LName; objUpdate.MobileNo = objModel.MobileNo; objUpdate.EmailId = objModel.EmailId; objUpdate.FatherName = objModel.FatherName; objUpdate.MotherName = objModel.MotherName; objUpdate.Village = objModel.Village; objUpdate.City = objModel.City; objUpdate.PinCode = objModel.PinCode; objUpdate.Address = objModel.Address; objUpdate.State = objModel.State; objUpdate.Gender = objModel.Gender; objUpdate.BloodGroup = objModel.BloodGroup; objUpdate.AadharNumber = objModel.AadharNumber; objUpdate.Landline = objModel.Landline; objUpdate.Qualification = objModel.Qualification; objUpdate.DateOfBirth = objModel.DateOfBirth; objUpdate.EnquiryDate = objModel.EnquiryDate; objUpdate.CounsellorName = objModel.CounsellorName; objUpdate.Comments = objModel.Comments; objUpdate.Status = objModel.Status; objUpdate.HowToKnowUs = objModel.HowToKnowUs; objUpdate.ReferredBy = objModel.ReferredBy; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); // return objExpense.ExpenseApprovalId NewEnquiryId = objModel.EnquiryId; response.responseData = new { EnquiryId = objModel.EnquiryId, FName = objModel.FName }; response.message = "Record Updated Successfully!"; } if (objModel.Status == "Registered") { decimal?FeePaidAmount = dbcontext.tblFeeCollections.Where(x => x.AdmissionId == objModel.EnquiryId).Sum(x => x.AmountPaid); var objUpdateAdm = dbcontext.tblAdmissions.FirstOrDefault(m => m.EnquiryId == objModel.EnquiryId); if (objUpdateAdm != null) { objUpdateAdm.AdmissionDate = objModel.AdmissionModel.AdmissionDate; objUpdateAdm.TotalFees = objModel.AdmissionModel.TotalFees; objUpdateAdm.RegistrationFees = objModel.AdmissionModel.RegistrationFees; objUpdateAdm.FeeToBePaid = (Convert.ToDecimal(objModel.AdmissionModel.TotalFees) - Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount)); objUpdateAdm.DiscountType = objModel.AdmissionModel.DiscountType; objUpdateAdm.DiscountAmount = objModel.AdmissionModel.DiscountAmount; //objUpdateAdm.BalanceAmountDue = (Convert.ToInt32(objModel.AdmissionModel.TotalFees) - (Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount) + Convert.ToDecimal(objModel.AdmissionModel.RegistrationFees))); objUpdateAdm.BalanceAmountDue = (Convert.ToInt32(objModel.AdmissionModel.TotalFees) - (Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount) + Convert.ToDecimal(dbcontext.tblFeeCollections.Where(x => x.AdmissionId == objUpdateAdm.AdmissionId).Sum(x => x.AmountPaid)))); objUpdateAdm.FeeIncharge = objModel.AdmissionModel.FeeIncharge; objUpdateAdm.PaymentMode = objModel.AdmissionModel.PaymentMode; objUpdateAdm.NoOfInstallments = objModel.AdmissionModel.NoOfInstallments; objUpdateAdm.NextPaymentDate = objModel.AdmissionModel.NextPaymentDate; objUpdateAdm.EnquiryStatus = objModel.Status; objUpdateAdm.InSectionStatus = objModel.Status; objUpdateAdm.ModifiedBy = objModel.AdmissionModel.ModifiedBy; objUpdateAdm.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); NewAdmissionId = objUpdateAdm.AdmissionId; //response.responseData = new { EnquiryId = objUpdate.EnquiryId, FName = objUpdate.FName }; //response.message = "Record Updated Successfully!"; } else { tblAdmission objAddAdmission = new tblAdmission { EnquiryId = NewEnquiryId, AdmissionDate = objModel.AdmissionModel.AdmissionDate, TotalFees = objModel.AdmissionModel.TotalFees, RegistrationFees = objModel.AdmissionModel.RegistrationFees, FeeToBePaid = (Convert.ToDecimal(objModel.AdmissionModel.TotalFees) - Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount)), DiscountType = objModel.AdmissionModel.DiscountType, DiscountAmount = objModel.AdmissionModel.DiscountAmount, BalanceAmountDue = (Convert.ToInt32(objModel.AdmissionModel.TotalFees) - (Convert.ToDecimal(objModel.AdmissionModel.DiscountAmount) + Convert.ToDecimal(objModel.AdmissionModel.RegistrationFees))), FeeIncharge = objModel.AdmissionModel.FeeIncharge, PaymentMode = objModel.AdmissionModel.PaymentMode, NoOfInstallments = objModel.AdmissionModel.NoOfInstallments, NextPaymentDate = objModel.AdmissionModel.NextPaymentDate, EnquiryStatus = objModel.Status, InSectionStatus = objModel.Status, IsActive = true, IsDeleted = false, CreatedBy = objModel.AdmissionModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.AdmissionModel.ModifiedBy, ModifiedDate = DateTime.Now, }; dbcontext.tblAdmissions.Add(objAddAdmission); dbcontext.SaveChanges(); NewAdmissionId = objAddAdmission.AdmissionId; } var objUpdateAdmFee = dbcontext.tblFeeCollections.FirstOrDefault(m => m.AdmissionId == NewAdmissionId); if (objUpdateAdmFee != null) { objUpdateAdmFee.AdmissionId = NewAdmissionId; objUpdateAdmFee.AmountPaid = objModel.AdmissionModel.RegistrationFees; //objUpdateAdmFee.paymentmode objUpdateAdmFee.FeeDate = DateTime.Now; objUpdateAdmFee.FeeInCharge = objModel.AdmissionModel.FeeIncharge; objUpdateAdmFee.FeeMode = objModel.AdmissionModel.PaymentMode; objUpdateAdmFee.FeeType = "Registration Fees"; objUpdateAdmFee.CreatedDate = DateTime.Now; objUpdateAdmFee.CreatedBy = objModel.CreatedBy; objUpdateAdmFee.ModifiedDate = DateTime.Now; objUpdateAdmFee.ModifiedBy = objModel.ModifiedBy; objUpdateAdmFee.IsActive = true; objUpdateAdmFee.IsDeleted = false; dbcontext.SaveChanges(); } else { tblFeeCollection objAddAdmissionFee = new tblFeeCollection { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), AdmissionId = NewAdmissionId, AmountPaid = objModel.AdmissionModel.RegistrationFees, FeeDate = DateTime.Now, FeeInCharge = objModel.AdmissionModel.FeeIncharge, FeeMode = objModel.AdmissionModel.PaymentMode, FeeType = "Registration Fees", CreatedDate = DateTime.Now, CreatedBy = objModel.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, IsActive = true, IsDeleted = false, }; dbcontext.tblFeeCollections.Add(objAddAdmissionFee); dbcontext.SaveChanges(); } } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveSectionMasterDetails(SectionMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.SectionId == 0) { var rs = dbcontext.tblSections.FirstOrDefault(x => x.IsDeleted == false && x.Title == objModel.Title && x.ClassId == objModel.ClassId); if (rs == null) { tblSection objAddNew = new tblSection { ClassId = objModel.ClassId, SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), Title = objModel.Title, ShortDescription = objModel.ShortDescription, DDate = objModel.DDate, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblSections.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { SectionId = objAddNew.SectionId, Title = objAddNew.Title }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblSections.FirstOrDefault(x => x.IsDeleted == false && x.ClassId == objModel.ClassId && x.Title == objModel.Title && x.SectionId != objModel.SectionId); if (rs == null) { var objUpdate = dbcontext.tblSections.FirstOrDefault(m => m.SectionId == objModel.SectionId); if (objUpdate != null) { objUpdate.ClassId = objModel.ClassId; objUpdate.Title = objModel.Title; objUpdate.ShortDescription = objModel.ShortDescription; objUpdate.DDate = objModel.DDate; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { SectionId = objUpdate.SectionId, Title = objUpdate.Title }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SavePromoteToClassDetails(PromoteToClassCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.PromoteToClassId == 0) { var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.ClassId == objModel.ClassId && x.SectionId == objModel.SectionId && x.AdmissionId == objModel.AdmissionId); if (rs == null) { var AdmId = dbcontext.tblPromoteToClasses.Where(x => x.IsDeleted == false && x.IsActive == true && x.AdmissionId == objModel.AdmissionId); if (AdmId != null) { foreach (var item in AdmId) { item.IsActive = false; } dbcontext.SaveChanges(); } tblPromoteToClass objAddNew = new tblPromoteToClass { SessionId = objModel.SessionId, ClassId = objModel.ClassId, SectionId = objModel.SectionId, LastClassId = objModel.LastClassId, AdmissionId = objModel.AdmissionId, Status = "Attending", RecordStatus = "Promote To New Class", IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblPromoteToClasses.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { PromoteToClassId = objAddNew.PromoteToClassId, Status = objAddNew.Status }; response.message = "Record Added Successfully!"; } //else //{ // rs.SectionId = objModel.SectionId; // rs.Status = objModel.Status; // rs.IsActive = true; // rs.ModifiedBy = objModel.ModifiedBy; // rs.ModifiedDate = DateTime.Now; // dbcontext.SaveChanges(); // response.responseData = new { PromoteToClassId = rs.PromoteToClassId, Status = rs.Status }; // response.message = "Record Updated Successfully!"; //} } //else //{ // var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.ClassId == objModel.ClassId && x.AdmissionId == objModel.AdmissionId && x.PromoteToClassId != objModel.PromoteToClassId); // if (rs == null) // { // var objUpdate = dbcontext.tblPromoteToClasses.FirstOrDefault(m => m.PromoteToClassId == objModel.PromoteToClassId); // if (objUpdate != null) // { // objUpdate.SessionId = objModel.SessionId; // objUpdate.EnquiryId = objModel.EnquiryId; // objUpdate.AdmissionId = objModel.AdmissionId; // objUpdate.ClassId = objModel.ClassId; // objUpdate.SectionId = objModel.SectionId; // objUpdate.ModifiedBy = objModel.ModifiedBy; // objUpdate.ModifiedDate = DateTime.Now; // dbcontext.SaveChanges(); // response.responseData = new { PromoteToClassId = objUpdate.PromoteToClassId, Status = objUpdate.Status }; // response.message = "Record Updated Successfully!"; // } // } // else // { // response.success = false; // response.message = "Record Already Exists!"; // } //} return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveBusChargesMasterDetails(BusChargesMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.BusChargesMasterId == 0) { var rs = dbcontext.tblBusChargesMasters.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.StartPoint == objModel.StartPoint && x.EndPoint == objModel.EndPoint); if (rs == null) { tblBusChargesMaster objAddNew = new tblBusChargesMaster { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), SessionId = objModel.SessionId, StartPoint = objModel.StartPoint, EndPoint = objModel.EndPoint, Amount = objModel.Amount, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblBusChargesMasters.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { BusChargesMasterId = objAddNew.BusChargesMasterId, StartPoint = objAddNew.StartPoint }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblBusChargesMasters.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.StartPoint == objModel.StartPoint && x.EndPoint == objModel.EndPoint && x.BusChargesMasterId != objModel.BusChargesMasterId); if (rs == null) { var objUpdate = dbcontext.tblBusChargesMasters.FirstOrDefault(m => m.BusChargesMasterId == objModel.BusChargesMasterId); if (objUpdate != null) { objUpdate.SessionId = objModel.SessionId; objUpdate.StartPoint = objModel.StartPoint; objUpdate.EndPoint = objModel.EndPoint; objUpdate.Amount = objModel.Amount; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { BusChargesMasterId = objUpdate.BusChargesMasterId, StartPoint = objUpdate.StartPoint }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveSectionAllocationDetails(SectionAllocationCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.PromoteToClassId == 0) { var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.ClassId == objModel.ClassId && x.AdmissionId == objModel.AdmissionId); if (rs == null) { tblPromoteToClass objAddNew = new tblPromoteToClass { SessionId = objModel.SessionId, //EnquiryId = objModel.EnquiryId, AdmissionId = objModel.AdmissionId, ClassId = objModel.ClassId, SectionId = objModel.SectionId, Status = "Attending", IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblPromoteToClasses.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { PromoteToClassId = objAddNew.PromoteToClassId, Status = objAddNew.Status }; response.message = "Record Added Successfully!"; } else { rs.SectionId = objModel.SectionId; rs.Status = objModel.Status; rs.IsActive = true; rs.ModifiedBy = objModel.ModifiedBy; rs.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { PromoteToClassId = rs.PromoteToClassId, Status = rs.Status }; response.message = "Record Updated Successfully!"; } } else { var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.ClassId == objModel.ClassId && x.AdmissionId == objModel.AdmissionId && x.PromoteToClassId != objModel.PromoteToClassId); if (rs == null) { var objUpdate = dbcontext.tblPromoteToClasses.FirstOrDefault(m => m.PromoteToClassId == objModel.PromoteToClassId); if (objUpdate != null) { objUpdate.SessionId = objModel.SessionId; objUpdate.EnquiryId = objModel.EnquiryId; objUpdate.AdmissionId = objModel.AdmissionId; objUpdate.ClassId = objModel.ClassId; objUpdate.SectionId = objModel.SectionId; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { PromoteToClassId = objUpdate.PromoteToClassId, Status = objUpdate.Status }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveAttendanceDetails(AttendanceCustomModel objModel) { DateTime DateCheck = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0)); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; var rs = dbcontext.tblAttendances.FirstOrDefault(x => x.IsDeleted == false && x.AdmissionId == objModel.AdmissionId && x.AttendanceDate.Year == DateCheck.Year && x.AttendanceDate.Month == DateCheck.Month && x.AttendanceDate.Day == DateCheck.Day && x.Attendance == objModel.Attendance && x.SectionId == objModel.SectionId ); if (rs == null) { tblAttendance objAddNew = new tblAttendance { EnquiryId = objModel.EnquiryId, AdmissionId = objModel.AdmissionId, SectionId = objModel.SectionId ?? 0, AttendanceDate = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0)), Attendance = objModel.Attendance, Reason = objModel.Reason, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblAttendances.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { AttendanceId = objAddNew.AdmissionId, AdmissionDate = objAddNew.AttendanceDate }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } //var rs = dbcontext.tblAttendances.FirstOrDefault(x => x.IsDeleted == false && x.AttendanceDate == objModel.AttendanceDate && x.AttendanceId != objModel.AttendanceId); //if (rs == null) //{ // var objUpdate = dbcontext.tblAttendances.FirstOrDefault(m => m.AttendanceId == objModel.AttendanceId); // if (objUpdate != null) // { // objUpdate.EnquiryId = objModel.EnquiryId; // objUpdate.AdmissionId = objModel.AdmissionId; // objUpdate.SectionId = objModel.SectionId ?? 0; // objUpdate.AttendanceDate = objModel.AttendanceDate; // objUpdate.Attendance = objModel.Attendance; // objUpdate.Reason = objModel.Reason; // objUpdate.ModifiedBy = objModel.ModifiedBy; // objUpdate.ModifiedDate = DateTime.Now; // dbcontext.SaveChanges(); // response.responseData = new { AttendanceId = objUpdate.AdmissionId, AdmissionDate = objUpdate.AttendanceDate }; // response.message = "Record Updated Successfully!"; // } //} //else //{ // response.success = false; // response.message = "Record Already Exists!"; //} return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveEmployeeMasterDetails(EmployeeMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.EmployeeId == 0) { var rs = dbcontext.tblEmployees.FirstOrDefault(x => x.IsDeleted == false && (x.EmailId == objModel.EmailId || x.MobileNo == objModel.MobileNo)); if (rs == null) { tblEmployee objAddNew = new tblEmployee { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), FName = objModel.FName, LName = objModel.LName, MobileNo = objModel.MobileNo, EmailId = objModel.EmailId, City = objModel.City, State = objModel.State, Country = objModel.Country, Address = objModel.Address, Address2 = objModel.Address2, Qualification = objModel.Qualification, Experience = objModel.Experience, Designation = objModel.Designation, DateOfJoining = objModel.DateOfJoining, DateOfBirth = objModel.DateOfBirth, DDate = objModel.DDate, BloodGroup = objModel.BloodGroup, Image = objModel.Image, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblEmployees.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { EmployeeId = objAddNew.EmployeeId, FName = objAddNew.FName }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblEmployees.FirstOrDefault(x => x.IsDeleted == false && (x.EmailId == objModel.EmailId || x.MobileNo == objModel.MobileNo) && x.EmployeeId != objModel.EmployeeId); if (rs == null) { var objUpdate = dbcontext.tblEmployees.FirstOrDefault(m => m.EmployeeId == objModel.EmployeeId); if (objUpdate != null) { objUpdate.FName = objModel.FName; objUpdate.LName = objModel.LName; objUpdate.MobileNo = objModel.MobileNo; objUpdate.EmailId = objModel.EmailId; objUpdate.City = objModel.City; objUpdate.State = objModel.State; objUpdate.Country = objModel.Country; objUpdate.Address = objModel.Address; objUpdate.Address2 = objModel.Address2; objUpdate.Qualification = objModel.Qualification; objUpdate.Experience = objModel.Experience; objUpdate.Designation = objModel.Designation; objUpdate.DateOfJoining = objModel.DateOfJoining; objUpdate.DateOfBirth = objModel.DateOfBirth; objUpdate.DDate = DateTime.Now; objUpdate.BloodGroup = objModel.BloodGroup; objUpdate.Image = objModel.Image; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { EmployeeId = objUpdate.EmployeeId, FName = objUpdate.FName }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }