public ActionResult updateCourse(int id)
{
var enddate_with_id = db.get_course_end_date(id);
DateTime date = DateTime.Now;
var current_date = date.Date;
if (enddate_with_id.created_date < current_date)
{
return(RedirectToAction("Index", "Course_list"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(15);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
TempData["mydata"] = id;
Batch_header bhdata = db.get_batch_Master_data(id);
ViewBag.bhdata = bhdata;
List <Batch_details> bddata = db.Get_Batch_detail_data(id);
ViewBag.bddata = bddata;
List <Teacher> tdp = db.Teacher_DropDown();
ViewBag.Teachdropdown = tdp;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
return(View(menudisplay));
}
}
public ActionResult Index(Batch_header bh)
{
bool status = false;
List <Teacher> tdp = db.Teacher_DropDown();
ViewBag.Teachdropdown = tdp;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
var bh_id = db.AutoGenerate_batch_id();
bh.Bh_id = Convert.ToInt32(bh_id.Bh_id);
db.InsertBatchHeader(bh);
foreach (var bhdtl in bh.Batch_details)
{
bhdtl.Bh_id = Convert.ToInt32(bh_id.Bh_id);
db.InsertBatchDetails(bhdtl);
}
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Index(Helper_mst hm)
{
string status = null;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
List <Batch_header> bh = db.Course_DropDown();
ViewBag.cordropdown = bh;
var hp_id = db.AutoGenerate_Helper_id();
hm.Hpl_id = Convert.ToInt32(hp_id.Hpl_id);
Batch_header get_date = db.get_batch_Master_data(hm.bh_id);
var bhdate = get_date.course_end_date.Date;
DateTime date = DateTime.Now;
var current_date = date.Date;
if (bhdate < current_date)
{
status = "ederror";
}
else
{
db.InsertHelperHeader(hm);
foreach (var hmdtl in hm.Helper_dtl)
{
hmdtl.Hpl_id = Convert.ToInt32(hp_id.Hpl_id);
db.InsertHelperDetails(hmdtl);
}
status = "done";
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Index(Attendance_mst am)
{
string status = null;
List <Batch_header> bh = db.Course_DropDown();
ViewBag.cordropdown = bh;
var at_id = db.AutoGenerate_attendance();
am.att_id = Convert.ToInt32(at_id.att_id);
Batch_header get_date = db.get_batch_Master_data(am.bh_id);
var bhdate = get_date.course_end_date.Date;
DateTime date = DateTime.Now;
var current_date = date.Date;
if (bhdate < current_date)
{
status = "ederror";
}
else
{
var dprcd = db.get_Duplicate_data(am.bh_id, current_date);
if (dprcd.att_id == 0)
{
db.InsertAttHeader(am);
status = "done";
}
else
{
status = "dupcte";
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult updateCourse(Batch_header bh)
{
bool status = false;
var BH_id = TempData["mydata"];
if (BH_id == null)
{
BH_id = bh.Bh_id;
}
bh.Bh_id = Convert.ToInt32(BH_id);
List <Teacher> tdp = db.Teacher_DropDown();
ViewBag.Teachdropdown = tdp;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
db.Update_batch_Master(bh);
if (bh.Batch_details != null)
{
foreach (var bhdtl in bh.Batch_details)
{
bhdtl.Bh_id = Convert.ToInt32(BH_id);
db.InsertBatchDetails(bhdtl);
}
}
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
