public async Task <ActionResult <AdmissionForm> > PostAdmissionForm(AdmissionForm admissionForm)
{
_context.AdmissionForm.Add(admissionForm);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAdmissionForm", new { id = admissionForm.AdmissionId }, admissionForm));
}
public bool Put(int AdmissionId, AdmissionForm student)
{
ClassController _class = new ClassController();
if (!ModelState.IsValid)
{
return(false);
}
if (AdmissionId != student.AdmissionId)
{
return(false);
}
try
{
Convert.ToInt32(student.Class);
}
catch (Exception ex)
{
student.Class = _class.GetClassID(student.Class).ToString();
}
SchoolDB.Entry(student).State = EntityState.Modified;
try
{
SchoolDB.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(false);
}
return(true);
}
public async Task <IActionResult> PutAdmissionForm(int id, AdmissionForm admissionForm)
{
if (id != admissionForm.AdmissionId)
{
return(BadRequest());
}
_context.Entry(admissionForm).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdmissionFormExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//get student by id
public AdmissionForm Get(string AdmissionNo)
{
AdmissionForm student = SchoolDB.AdmissionForms.Where(x => x.AdmissionNo.Equals(AdmissionNo)).OrderBy(x => x.AdmissionId).FirstOrDefault();
if (student == null)
{
return(null);
}
return(student);
}
//insert student
public int InserStudent(AdmissionForm student)
{
int result = 0;
if (student != null)
{
SchoolDB.AdmissionForms.Add(student);
result = SchoolDB.SaveChanges();
}
return(result);
}
public JsonResult UpdateStudent(int AdmissionId, AdmissionForm student)
{
try
{
StudentController obj = new StudentController();
var response = obj.Put(AdmissionId, student);
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Log.Error(ex.Message.ToString());
return(null);
}
}
public IHttpActionResult Form([FromBody] AdmissionForm admissionForm)
{
var res = new ApiResponse();
try
{
Random r = new Random();
int num = r.Next();
var student = new StudentAdmissionForm()
{
Address = admissionForm.address,
CandidateName = admissionForm.candidatename,
City = admissionForm.city,
Email = admissionForm.email,
FatherName = admissionForm.fathername,
Mobile = admissionForm.mobile,
MotherName = admissionForm.mothername,
State = admissionForm.state,
CourseType = admissionForm.coursetype,
RegistrationNumber = num
};
var response = _admissionForm.Add(student);
var lstmap = admissionForm.items.ConvertAll(x => new StudentQualificationMapping
{
Boards = x.boards,
Class = x.sclass,
StudentAdmissionID = response.Id,
Subjects = x.subjects,
YearOfPassing = x.yearofpassing,
}).ToList();
var returrep = _studentMapping.BulkAdd(lstmap);
res = new ApiResponse()
{
status = HttpStatusCode.OK.ToString(),
code = (int)HttpStatusCode.OK,
result = lstmap
};
}
catch (Exception ex)
{
throw;
}
return(Ok(res));
}
private User CreateUserObject(AdmissionForm student)
{
var name = student.StFirstName.Split(' ');
User user = new User()
{
Email = string.IsNullOrEmpty(student.EmailId) ? $"{student.AdmissionNo}@gmail.com" : student.EmailId,
Username = student.AdmissionNo,
FirstName = name[0],
LastName = name.Length > 1 ? name[1] : "NA",
RoleName = "Student",
Password = $"{student.AdmissionNo}@abC",
ConfirmPassword = $"{student.AdmissionNo}@abC",
SchoolCode = ApplicationConfigurations.SchoolCode
};
return(user);
}
public ActionResult Create(Installment i)
{
try
{
if (i.Form_No != 0 && i.Amount_Paid > 0)
{
int balanceDue = db.Installments.Where(x => x.Form_No == i.Form_No).OrderByDescending(x => x.Datetime).First().Balance_Due;
if (i.Amount_Paid > balanceDue)
{
return(Json("{ \"success\":false,\"errorMsg\":\"Please enter a valid amount \"}", JsonRequestBehavior.AllowGet));
}
if (balanceDue > 0)
{
i.Balance_Due = balanceDue - i.Amount_Paid;
i.Datetime = DateTime.UtcNow;
if (i.Balance_Due == 0)
{ //i.Duedate = "";
//check if form is complete
long formno = i.Form_No;
int stuId = db.StudentDetails.Where(w => w.Form_No == formno).Select(s => s.id).ToArray()[0];
if (db.Installments.Where(w => w.Form_No == formno).OrderByDescending(o => o.Datetime).Select(s => s.Balance_Due).Take(1).ToArray()[0] == 0 ||
db.BatchMember.Any(a => a.studentId == stuId))
{
AdmissionForm ad = db.AdmisionForms.Find(formno);
ad.Form_Complete = true;
}
}
else
{
i.Duedate = i.Datetime.AddDays(7);
}
db.Installments.Add(i);
db.SaveChanges();
return(Json("{ \"success\":true,\"id\":\"" + i.Id + "\"}", JsonRequestBehavior.AllowGet));
}
return(Json("{ \"success\":false,\"errorMsg\":\"Balance due is zero\"}", JsonRequestBehavior.AllowGet));
}
return(Json("{ \"success\":false,\"errorMsg\":\"Amount Paid should be > 0 \"}", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("{ \"success\":false,\"errorMsg\":\"Exception Occured: " + ex.Message + " \"}", JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddStudent(AdmissionForm student)
{
try
{
if (string.IsNullOrEmpty(student.AdmissionNo))
{
return(Json("AdmissionNo cant be blank."));
}
StudentController obj = new StudentController();
var response = obj.Post(student);
return(Json(((SchoolApi.AdmissionForm)(((System.Net.Http.ObjectContent)(response.Content)).Value)).AdmissionId, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Log.Error(ex.Message.ToString());
return(null);
}
}
//delete customer by id
public AdmissionForm Delete(int AdmissionId)
{
AdmissionForm student = SchoolDB.AdmissionForms.Find(AdmissionId);
if (student == null)
{
return(student);
}
SchoolDB.AdmissionForms.Remove(student);
try
{
SchoolDB.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(student);
}
return(student);
}
public ActionResult Create(AdmissionFormViewModel admissionFormViewModel)
{
if (ModelState.IsValid)
{
AdmissionForm AdmissionForm = new AdmissionForm();
AdmissionForm.Dated = DateTime.UtcNow;
AdmissionForm.centerId = admissionFormViewModel.StudentDetail.Center;
db.AdmisionForms.Add(AdmissionForm);
db.SaveChanges();
long form_no = AdmissionForm.Form_No;
//update formno for all tables
admissionFormViewModel.Installment.Form_No = form_no;
admissionFormViewModel.AboutNICT.Form_No = form_no;
admissionFormViewModel.EduQualification.Form_No = form_no;
admissionFormViewModel.StudentDetail.Form_No = form_no;
//check for empty model properties
if (!admissionFormViewModel.JobExperience.HasAllEmptyProperties())
{
admissionFormViewModel.JobExperience.Form_No = form_no;
db.JobExperiences.Add(admissionFormViewModel.JobExperience);
}
if (!admissionFormViewModel.KnowledgeOfComp.HasAllEmptyProperties())
{
admissionFormViewModel.KnowledgeOfComp.Form_No = form_no;
db.KnowledgeOfComps.Add(admissionFormViewModel.KnowledgeOfComp);
}
//check for uploaded files
if (admissionFormViewModel.Files != null)
{
foreach (var File in admissionFormViewModel.Files)
{
File.Form_No = form_no;
File.Datetime = AdmissionForm.Dated;
db.Files.Add(File);
}
}
admissionFormViewModel.Installment.Duedate = DateTime.UtcNow.AddDays(10);
admissionFormViewModel.Installment.Datetime = AdmissionForm.Dated;
admissionFormViewModel.Installment.Balance_Due = 3000 - admissionFormViewModel.Installment.Amount_Paid;
//update student reg no
int regNo = db.StudentDetails.Where(y => y.Center.Equals(admissionFormViewModel.StudentDetail.Center)).OrderByDescending(x => x.Reg_No).Select(s => s.Reg_No).FirstOrDefault();
if (regNo == 0 || regNo == null)
{
regNo++;
}
//set the reg number
admissionFormViewModel.StudentDetail.Reg_No = regNo;
//add all the models to db
db.AboutNICTs.Add(admissionFormViewModel.AboutNICT);
db.EduQualifications.Add(admissionFormViewModel.EduQualification);
db.StudentDetails.Add(admissionFormViewModel.StudentDetail);
db.Installments.Add(admissionFormViewModel.Installment);
db.SaveChanges();
return(RedirectToAction("Details", form_no));
}
List <SelectListItem> items = new List <SelectListItem>();
foreach (var center in db.Centers.ToList())
{
items.Add(new SelectListItem {
Value = center.CenterId.ToString(), Text = center.CenterName
});
}
ViewBag.Centers = items;
return(View(admissionFormViewModel));
}
