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 MusicAction(Music music)
{
ModelState.Remove("MusicID");
if (ModelState.IsValid)
{
string msg = "";
if (music.MusicID > 0)
{
var dataset = entities.Musics.Where(f => f.MusicID == music.MusicID).FirstOrDefault();
if (dataset != null)
{
dataset.Name = music.Name;
dataset.Description = music.Description;
msg = "Music Updated Successfully";
}
}
else
{
entities.Musics.Add(music);
msg = "New Music Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Music",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(PartialView(music));
}
public ActionResult CourseAction(CourseLevel courselevel)
{
ModelState.Remove("CourseLevelID");
if (ModelState.IsValid)
{
string msg = "";
if (courselevel.CourseLevelID > 0)
{
var dataset = entities.CourseLevels.Where(f => f.CourseLevelID == courselevel.CourseLevelID).FirstOrDefault();
if (dataset != null)
{
dataset.LevelName = courselevel.LevelName;
msg = "Course Level Updated Successfully";
}
}
else
{
entities.CourseLevels.Add(courselevel);
msg = "New Course Level Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "CourseLevel",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(PartialView(courselevel));
}
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));
}