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