public ActionResult AssertAction(InstrumentAssert instrumentassert)
{
ModelState.Remove("InstrumentAssertID");
ModelState.Remove("InstrumentCode");
if (ModelState.IsValid)
{
string msg = "";
if (instrumentassert.InstrumentAssertID > 0)
{
var dataset = entities.InstrumentAsserts.Where(f => f.InstrumentAssertID == instrumentassert.InstrumentAssertID).FirstOrDefault();
if (dataset != null)
{
Instrument instument = entities.Instruments.Where(x => x.InstrumentID == instrumentassert.InstrumentID).FirstOrDefault();
String code = "SMMS_" + instument.Name + "_00" + instrumentassert.InstrumentAssertID;
dataset.InstrumentCode = code;
dataset.InstrumentID = instrumentassert.InstrumentID;
dataset.InstrumentConditionID = instrumentassert.InstrumentConditionID;
msg = "Instrument Updated Successfully";
}
}
else
{
Instrument instument = entities.Instruments.Where(x => x.InstrumentID == instrumentassert.InstrumentID).FirstOrDefault();
try
{
var insAssert = entities.InstrumentAsserts.Max(x => x.InstrumentAssertID) + 1;
String code = "SMMS_" + instument.Name + "_00" + insAssert;
instrumentassert.InstrumentCode = code;
}
catch
{
String code = "SMMS_" + instument.Name + "_00" + 1;
instrumentassert.InstrumentCode = code;
}
entities.InstrumentAsserts.Add(instrumentassert);
msg = "Instrument Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Assert",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpInstrument = CommonController.drpInstrument();
ViewBag.drpInstrumentCondition = CommonController.drpInstrumentCondition();
return(PartialView(instrumentassert));
}
public ActionResult FeeAction(int?id)
{
ViewBag.drpInstrument = CommonController.drpInstrument();
if (id != 0)
{
FeeStructire dataset = entities.FeeStructires.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult PerformanceAction(int?id)
{
ViewBag.drpNote = CommonController.drpNote();
ViewBag.drpProgram = CommonController.drpProgram();
if (id != 0)
{
PerformanceList dataset = entities.PerformanceLists.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult EnrolmentAction(int?id)
{
ViewBag.drpStudent = CommonController.drpStudent();
ViewBag.drpBatch = CommonController.drpBatch();
if (id != 0)
{
Enrolment dataset = entities.Enrolments.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult PaymentAction(int?id)
{
ViewBag.drpPaymentStatus = CommonController.drpPaymentStatus();
ViewBag.drpEnrollment = CommonController.drpEnrollment();
if (id != 0)
{
Payment dataset = entities.Payments.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult BatchAction(int?id)
{
ViewBag.drpTutor = CommonController.drpTutor();
ViewBag.drpLesson = CommonController.drpLesson();
if (id != 0)
{
Lessonbatch dataset = entities.Lessonbatches.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult HireAction(int?id)
{
ViewBag.drpAssert = CommonController.drpAssert();
ViewBag.drpEnrollment = CommonController.drpEnrollment();
if (id != 0)
{
InstrumentHire dataset = entities.InstrumentHires.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult ServiceAction(InstumentService service)
{
ModelState.Remove("InstumentServiceID");
if (ModelState.IsValid)
{
string msg = "";
if (service.InstumentServiceID > 0)
{
var dataset = entities.InstumentServices.Where(f => f.InstumentServiceID == service.InstumentServiceID).FirstOrDefault();
if (dataset != null)
{
dataset.Problem = service.Problem;
dataset.Date = service.Date;
dataset.Comments = service.Comments;
dataset.InstrumentHireId = service.InstrumentHireId;
dataset.TechnicianID = service.TechnicianID;
InstrumentAssert instrumentAssert = entities.InstrumentAsserts.Where(f => f.InstrumentAssertID == service.InstrumentHire.InstrumentAssertID).FirstOrDefault();
instrumentAssert.InstrumentConditionID = 2;
msg = "Instrument service Updated Successfully";
}
}
else
{
entities.InstumentServices.Add(service);
InstrumentAssert instrumentAssert = entities.InstrumentAsserts.Where(f => f.InstrumentAssertID == service.InstrumentHire.InstrumentAssertID).FirstOrDefault();
instrumentAssert.InstrumentConditionID = 2;
msg = "Instrument Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Service",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpInstrumentHire = CommonController.drpInstrumentHire();
ViewBag.drpTechnician = CommonController.drpTechnician();
return(PartialView(service));
}
public ActionResult NoteAction(int?id)
{
ViewBag.drpCourseLevel = CommonController.drpCourseLevel();
ViewBag.drpInstrument = CommonController.drpInstrument();
ViewBag.drpMusic = CommonController.drpMusic();
if (id != 0)
{
MusicSheet dataset = entities.MusicSheets.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult LessonAction(int?id)
{
ViewBag.drpCourseLevel = CommonController.drpCourseLevel();
ViewBag.drpInstrument = CommonController.drpInstrument();
ViewBag.drpLessonType = CommonController.drpLessonType();
if (id != 0)
{
Lesson dataset = entities.Lessons.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult ServiceAction(int?id)
{
ViewBag.drpInstrumentHire = CommonController.drpInstrumentHire();
ViewBag.drpTechnician = CommonController.drpTechnician();
if (id != 0)
{
InstumentService dataset = entities.InstumentServices.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult AssertAction(int?id)
{
ViewBag.drpInstrument = CommonController.drpInstrument();
ViewBag.drpInstrumentCondition = CommonController.drpInstrumentCondition();
if (id != 0)
{
InstrumentAssert dataset = entities.InstrumentAsserts.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
public ActionResult BatchAction(Lessonbatch lesson)
{
ModelState.Remove("LessonBatchID");
if (ModelState.IsValid)
{
string msg = "";
if (lesson.LessonBatchID > 0)
{
var dataset = entities.Lessonbatches.Where(f => f.LessonBatchID == lesson.LessonBatchID).FirstOrDefault();
if (dataset != null)
{
dataset.Name = lesson.Name;
dataset.Duration = lesson.Duration;
dataset.StartTime = lesson.StartTime;
dataset.EndTime = lesson.EndTime;
dataset.Description = lesson.Description;
dataset.LessonID = lesson.LessonID;
dataset.TutorID = lesson.TutorID;
dataset.BatchDate = lesson.BatchDate;
msg = "Lesson Batch Updated Successfully";
}
}
else
{
entities.Lessonbatches.Add(lesson);
msg = "New Lesson Batch Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Batch",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpTutor = CommonController.drpTutor();
ViewBag.drpLesson = CommonController.drpLesson();
return(PartialView(lesson));
}
public ActionResult TutorSkillAction(int?id, int?uid)
{
ViewBag.drpInstrument = CommonController.drpInstrument();
ViewBag.drpCourseLevel = CommonController.drpCourseLevel();
if (id != 0)
{
InstumentLevel dataset = entities.InstumentLevels.Find(id);
return(PartialView(dataset));
}
else
{
InstumentLevel dataset = new InstumentLevel();
dataset.UserID = (int)uid;
return(PartialView(dataset));
}
}
public ActionResult HireAction(InstrumentHire instrumenthire)
{
ModelState.Remove("InstrumentHireId");
if (ModelState.IsValid)
{
string msg = "";
if (instrumenthire.InstrumentHireId > 0)
{
var dataset = entities.InstrumentHires.Where(f => f.InstrumentHireId == instrumenthire.InstrumentHireId).FirstOrDefault();
if (dataset != null)
{
dataset.Description = instrumenthire.Description;
dataset.InstrumentAssertID = instrumenthire.InstrumentAssertID;
dataset.EnrolmentID = instrumenthire.EnrolmentID;
dataset.InstrumentAssert.InstrumentConditionID = 3;
msg = "Hire details Updated Successfully";
}
}
else
{
entities.InstrumentHires.Add(instrumenthire);
InstrumentAssert datasetassert = entities.InstrumentAsserts.Where(f => f.InstrumentAssertID == instrumenthire.InstrumentAssertID).FirstOrDefault();
datasetassert.InstrumentConditionID = 3;
msg = "New Hire details Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Hire",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpAssert = CommonController.drpAssert();
ViewBag.drpEnrollment = CommonController.drpEnrollment();
return(PartialView(instrumenthire));
}
public ActionResult PaymentAction(Payment payment)
{
ModelState.Remove("PaymentID");
if (ModelState.IsValid)
{
string msg = "";
if (payment.PaymentID > 0)
{
var dataset = entities.Payments.Where(f => f.PaymentID == payment.PaymentID).FirstOrDefault();
if (dataset != null)
{
dataset.PayableAmount = payment.PayableAmount;
dataset.PaidAMount = payment.PaidAMount;
dataset.Comments = payment.Comments;
dataset.EnrolmentID = payment.EnrolmentID;
dataset.PaymentStatus = payment.PaymentStatus;
msg = "Payment details Updated Successfully";
}
}
else
{
entities.Payments.Add(payment);
msg = "New Payment Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Payment",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpPaymentStatus = CommonController.drpPaymentStatus();
ViewBag.drpEnrollment = CommonController.drpEnrollment();
return(PartialView(payment));
}
public ActionResult LessonAction(Lesson lesson)
{
ModelState.Remove("LessonID");
if (ModelState.IsValid)
{
string msg = "";
if (lesson.LessonID > 0)
{
var dataset = entities.Lessons.Where(f => f.LessonID == lesson.LessonID).FirstOrDefault();
if (dataset != null)
{
dataset.Name = lesson.Name;
dataset.Description = lesson.Description;
dataset.CourseLevelID = lesson.CourseLevelID;
dataset.LessonTypeID = lesson.LessonTypeID;
dataset.InstrumentID = lesson.InstrumentID;
msg = "Lesson Updated Successfully";
}
}
else
{
entities.Lessons.Add(lesson);
msg = "New Lesson Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Lesson",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpCourseLevel = CommonController.drpCourseLevel();
ViewBag.drpLessonType = CommonController.drpLessonType();
ViewBag.drpInstrument = CommonController.drpInstrument();
return(PartialView(lesson));
}
public ActionResult EnrolmentAction(Enrolment enrolment)
{
ModelState.Remove("EnrolmentID");
if (ModelState.IsValid)
{
string msg = "";
if (enrolment.EnrolmentID > 0)
{
var dataset = entities.Enrolments.Where(f => f.EnrolmentID == enrolment.EnrolmentID).FirstOrDefault();
if (dataset != null)
{
dataset.Date = enrolment.Date;
dataset.StudentID = enrolment.StudentID;
dataset.LessonBatchID = enrolment.LessonBatchID;
msg = "Enrolment details Updated Successfully";
}
}
else
{
entities.Enrolments.Add(enrolment);
msg = "New Enrollment Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Enrolment",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpStudent = CommonController.drpStudent();
ViewBag.drpBatch = CommonController.drpBatch();
return(PartialView(enrolment));
}
public ActionResult TutorSkillAction(InstumentLevel instumentLevel)
{
ModelState.Remove("TutorInstumentID");
if (ModelState.IsValid)
{
string msg = "";
string uid = "";
Tutor datasetTutor = entities.Tutors.Where(f => f.UserID == instumentLevel.UserID).FirstOrDefault();
uid = datasetTutor.TutorID.ToString();
if (instumentLevel.InstumentLevelID > 0)
{
var dataset = entities.InstumentLevels.Where(f => f.InstumentLevelID == instumentLevel.InstumentLevelID).FirstOrDefault();
if (dataset != null)
{
dataset.InstrumentID = instumentLevel.InstrumentID;
dataset.CourseLevelID = instumentLevel.CourseLevelID;
dataset.UserID = instumentLevel.UserID;
msg = "Instrument skill Updated Successfully";
}
}
else
{
entities.InstumentLevels.Add(instumentLevel);
msg = "New Instrument skill Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "TutorSkill?id=" + uid,
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpCourseLevel = CommonController.drpInstrument();
ViewBag.drpCourseLevel = CommonController.drpCourseLevel();
return(PartialView(instumentLevel));
}
public ActionResult FeeAction(FeeStructire feestructire)
{
ModelState.Remove("FeeID");
if (ModelState.IsValid)
{
string msg = "";
if (feestructire.FeeID > 0)
{
var dataset = entities.FeeStructires.Where(f => f.FeeID == feestructire.FeeID).FirstOrDefault();
if (dataset != null)
{
dataset.StudentFee = feestructire.StudentFee;
dataset.OpenFee = feestructire.OpenFee;
dataset.HireFee = feestructire.HireFee;
msg = "Fee Structure Updated Successfully";
}
}
else
{
entities.FeeStructires.Add(feestructire);
msg = "New Fee Structure Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Fee",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpInstrument = CommonController.drpInstrument();
return(PartialView(feestructire));
}
public ActionResult StudentAction(UserStudent userstudent)
{
ModelState.Remove("UserID");
ModelState.Remove("StudentID");
if (ModelState.IsValid)
{
string msg = "";
if (userstudent.StudentID > 0)
{
var datasetStudent = entities.Students.Where(f => f.StudentID == userstudent.StudentID).FirstOrDefault();
var datasetUser = entities.Users.Where(f => f.UserID == datasetStudent.UserID).FirstOrDefault();
if (datasetStudent != null && datasetUser != null)
{
datasetStudent.ParentName = userstudent.ParentName;
datasetStudent.ParentAddrsss = userstudent.ParentAddrsss;
datasetStudent.ParentEmail = userstudent.ParentEmail;
datasetStudent.ParentPhone = userstudent.ParentPhone;
datasetUser.FirstName = userstudent.FirstName;
datasetUser.LastName = userstudent.LastName;
datasetUser.DOB = userstudent.DOB;
datasetUser.Email = userstudent.Email;
datasetUser.Phone = userstudent.Phone;
datasetUser.Address = userstudent.Address;
datasetUser.Password = userstudent.Password;
datasetUser.UserRoleID = userstudent.UserRoleID;
entities.SaveChanges();
msg = "Student details Updated Successfully";
}
}
else
{
User datasetUser = new User();
datasetUser.FirstName = userstudent.FirstName;
datasetUser.LastName = userstudent.LastName;
datasetUser.DOB = userstudent.DOB;
datasetUser.Email = userstudent.Email;
datasetUser.Phone = userstudent.Phone;
datasetUser.Address = userstudent.Address;
datasetUser.Password = userstudent.Password;
datasetUser.UserRoleID = userstudent.UserRoleID;
entities.Users.Add(datasetUser);
Student datasetStudent = new Student();
int id = userstudent.UserID;
datasetStudent.UserID = id;
datasetStudent.ParentName = userstudent.ParentName;
datasetStudent.ParentAddrsss = userstudent.ParentAddrsss;
datasetStudent.ParentEmail = userstudent.ParentEmail;
datasetStudent.ParentPhone = userstudent.ParentPhone;
entities.Students.Add(datasetStudent);
entities.SaveChanges();
msg = "New Student Added successfully";
}
return(new JsonResult
{
Data = new
{
success = true,
action = "Student",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpStudentRole = CommonController.drpStudentRole();
return(PartialView(userstudent));
}
public ActionResult TutorAction(UserTutor usertutor)
{
ModelState.Remove("UserID");
ModelState.Remove("TutorID");
if (ModelState.IsValid)
{
string msg = "";
if (usertutor.TutorID > 0)
{
var datasetTutor = entities.Tutors.Where(f => f.TutorID == usertutor.TutorID).FirstOrDefault();
var datasetUser = entities.Users.Where(f => f.UserID == datasetTutor.UserID).FirstOrDefault();
if (datasetTutor != null && datasetUser != null)
{
datasetTutor.TutorLevelID = usertutor.TutorLevelID;
datasetUser.FirstName = usertutor.FirstName;
datasetUser.LastName = usertutor.LastName;
datasetUser.DOB = usertutor.DOB;
datasetUser.Email = usertutor.Email;
datasetUser.Phone = usertutor.Phone;
datasetUser.Address = usertutor.Address;
datasetUser.Password = usertutor.Password;
datasetUser.UserRoleID = 3;
entities.SaveChanges();
msg = "Turor details Updated Successfully";
}
}
else
{
User datasetUser = new User();
datasetUser.FirstName = usertutor.FirstName;
datasetUser.LastName = usertutor.LastName;
datasetUser.DOB = usertutor.DOB;
datasetUser.Email = usertutor.Email;
datasetUser.Phone = usertutor.Phone;
datasetUser.Address = usertutor.Address;
datasetUser.Password = usertutor.Password;
datasetUser.UserRoleID = 3;
entities.Users.Add(datasetUser);
Tutor datasetTutor = new Tutor();
int id = usertutor.UserID;
datasetTutor.UserID = id;
datasetTutor.TutorLevelID = usertutor.TutorLevelID;
entities.Tutors.Add(datasetTutor);
entities.SaveChanges();
msg = "New Tutor Added successfully";
}
return(new JsonResult
{
Data = new
{
success = true,
action = "Tutors",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpTutorLevel = CommonController.drpTutorLevel();
return(PartialView(usertutor));
}
