public ActionResult Create([Bind(Include = "Id,StudentID,FeeChallanID,PaymentAmount,PaymentDate")] AspNetStudent_Payment aspNetStudent_Payment)
{
var TransactionObj = db.Database.BeginTransaction();
try
{
if (ModelState.IsValid)
{
db.AspNetStudent_Payment.Add(aspNetStudent_Payment);
db.SaveChanges();
}
TransactionObj.Commit();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var classObjLog = Request.Form["ClassID"];
var logMessage = "Student Payment Added : " + aspNetStudent_Payment.StudentID + ", FeeChallan ID: " + aspNetStudent_Payment.FeeChallanID + ", Payment Amount: " + aspNetStudent_Payment.PaymentAmount + ", Payment Date: " + aspNetStudent_Payment.PaymentDate;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(RedirectToAction("Index"));
}
catch (Exception)
{
TransactionObj.Dispose();
}
ViewBag.FeeChallanID = new SelectList(db.AspNetFeeChallans, "Id", "Id", aspNetStudent_Payment.FeeChallanID);
ViewBag.StudentID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetStudent_Payment.StudentID);
return(View(aspNetStudent_Payment));
}
// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public JsonResult AddLessonPlan(lessonPlan LessonPlan)
{
var TransactionObj = db.Database.BeginTransaction();
try
{
AspNetLessonPlan aspNetLessonPlan = new AspNetLessonPlan();
aspNetLessonPlan.LessonPlanNo = LessonPlan.lessonPlanNo;
aspNetLessonPlan.SubjectID = LessonPlan.subjectID;
aspNetLessonPlan.Date = LessonPlan.Date;
aspNetLessonPlan.Duration = LessonPlan.Duration;
db.AspNetLessonPlans.Add(aspNetLessonPlan);
db.SaveChanges();
int LessonPlanID = db.AspNetLessonPlans.Max(x => x.Id);
foreach (var topic in LessonPlan.Topics)
{
AspNetLessonPlan_Topic lessonPlanTopic = new AspNetLessonPlan_Topic();
lessonPlanTopic.TopicID = topic;
lessonPlanTopic.LessonPlanID = LessonPlanID;
db.AspNetLessonPlan_Topic.Add(lessonPlanTopic);
db.SaveChanges();
}
if (LessonPlan.BreakDown != null)
{
foreach (var breakdown in LessonPlan.BreakDown)
{
AspNetLessonPlanBreakdown aspNetLessonBreakdown = new AspNetLessonPlanBreakdown();
aspNetLessonBreakdown.LessonPlanID = LessonPlanID;
aspNetLessonBreakdown.Minutes = breakdown.Minutes;
aspNetLessonBreakdown.Resources = breakdown.Resources;
aspNetLessonBreakdown.BreakDownHeadingID = breakdown.HeadingID;
aspNetLessonBreakdown.Description = WebUtility.HtmlEncode(breakdown.Description).ToString();
db.AspNetLessonPlanBreakdowns.Add(aspNetLessonBreakdown);
db.SaveChanges();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New LessonPlan Added, SubjectID: " + LessonPlan.subjectID + ", Date: " + LessonPlan.Date;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
db.SaveChanges();
TransactionObj.Commit();
}
catch (Exception)
{
TransactionObj.Dispose();
}
return(Json("data", JsonRequestBehavior.AllowGet));
}
public void EditLessonPlan1234(EditLessonPlanType LessonPlan)
{
var TransactionObj = db.Database.BeginTransaction();
try
{
var lessonID = LessonPlan.LessonPlanID;
AspNetLessonPlan aspNetLessonPlan = db.AspNetLessonPlans.FirstOrDefault(x => x.Id == lessonID);
//aspNetLessonPlan.LessonPlanNo = LessonPlan.lessonPlanNo;
aspNetLessonPlan.SubjectID = LessonPlan.subjectID;
aspNetLessonPlan.Date = LessonPlan.Date;
aspNetLessonPlan.Duration = LessonPlan.Duration;
//db.AspNetLessonPlans.Add(aspNetLessonPlan);
db.SaveChanges();
int LessonPlanID = aspNetLessonPlan.Id;
var Lesson_TopicList = (from lesson_topic in db.AspNetLessonPlan_Topic
where lesson_topic.LessonPlanID == LessonPlanID
select lesson_topic).ToList();
int count = 1;
do
{
var lessonObj = db.AspNetLessonPlan_Topic.FirstOrDefault(x => x.LessonPlanID == LessonPlanID);
if (lessonObj == null)
{
count = 0;
continue;
}
db.AspNetLessonPlan_Topic.Attach(lessonObj);
db.AspNetLessonPlan_Topic.Remove(lessonObj);
db.SaveChanges();
}while (count == 1);
foreach (var topic in LessonPlan.Topics)
{
AspNetLessonPlan_Topic lessonPlanTopic = new AspNetLessonPlan_Topic();
lessonPlanTopic.TopicID = topic;
lessonPlanTopic.LessonPlanID = LessonPlanID;
db.AspNetLessonPlan_Topic.Add(lessonPlanTopic);
db.SaveChanges();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "LessonPlan Edited, LessonPlanID: " + lessonID + ", Date: " + LessonPlan.Date;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
db.SaveChanges();
TransactionObj.Commit();
}
catch (Exception)
{
TransactionObj.Dispose();
}
}
