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