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