//New
public ActionResult testdemo(stdlisttheory aa)
{
int id = Convert.ToInt32(TempData["id"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlisttheory>("exec getsubsemfromid @id", new SqlParameter("@id", id)).ToList();
TempData["sem"] = advisor[0].sem;
}
return(RedirectToAction("Index", "attendancelist"));
}
public ActionResult gettotal(stdlisttheory aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var modifiedon2 = new SqlParameter("@modifiedon2", SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.modifiedon2
};
}
Session["secondmoddate"] = aa.modifiedon2;
return(RedirectToAction("total", "attendancelist"));
}
//Details
public ActionResult getlist(stdlisttheory aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var name = new SqlParameter("@name", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.modifiedon
};
}
TempData["moddate"] = aa.modifiedon;
return(RedirectToAction("Details", "attendancelist"));
}
public ActionResult test(stdlisttheory aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var name = new SqlParameter("@name", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.subid
};
}
TempData["id"] = aa.subid;
Session["kumar"] = TempData["id"];
return(RedirectToAction("testdemo", "attendancelist"));
}
public ActionResult Index()
{
if (Session["id"] == null)
{
return(RedirectToAction("login", "login"));
}
else
{
var id = Session["id"];
var name = Session["name"];
var sem = Session["sem"];
stdlisttheory update = new stdlisttheory();
update.attend = gettheorystd();
update.theorysubject = gettheorysub();
return(View(update));
}
}
public ActionResult Index(stdlisttheory stdlst)
{
var insertattendance = new List <stdlisttheory>();
int id = Convert.ToInt32(TempData["id"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlisttheory>("exec getsubsemfromid @id", new SqlParameter("@id", id)).ToList();
TempData["semtest"] = advisor[0].sem;
}
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlisttheory>("exec getsubnameforlist @id", new SqlParameter("@id", id)).ToList();
Session["subname2"] = advisor[0].name;
}
string subjectnamet = Convert.ToString(Session["subname2"]);
int semt = Convert.ToInt32(TempData["semtest"]);
StringBuilder sb = new StringBuilder();
string testt = subjectnamet + " th";
using (var adv = new AttendanceContext())
{
var sem = new SqlParameter("@sem", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = semt
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = 1
};
var subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 500)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
insertattendance = adv.Database.SqlQuery <stdlisttheory>("exec inserttheoryattendancesubject @sem, @IsCheck , @subjectname ", sem, IsCheck, subjectname).ToList();
}
foreach (var item in stdlst.attend)
{
int stdrollnot = item.rollno;
if (item.IsCheck)
{
int IsCheckt = 1;
using (var adv = new AttendanceContext())
{
var sem = new SqlParameter("@sem", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = semt
};
var stdrollno = new SqlParameter("@stdrollno", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = stdrollnot
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
var subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = subjectnamet
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
insertattendance = adv.Database.SqlQuery <stdlisttheory>("exec inserttheoryattendance @stdrollno, @sem, @IsCheck ,@subjectname, @test ", stdrollno, sem, IsCheck, subjectname, test).ToList();
}
}
else
{
int IsCheckt = 0;
using (var adv = new AttendanceContext())
{
var sem = new SqlParameter("@sem", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = semt
};
var stdrollno = new SqlParameter("@stdrollno", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = stdrollnot
};
var subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = subjectnamet
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
insertattendance = adv.Database.SqlQuery <stdlisttheory>("exec inserttheoryattendance @stdrollno, @sem, @IsCheck, @subjectname, @test", stdrollno, sem, IsCheck, subjectname, test).ToList();
}
}
}
return(RedirectToAction("Details", "attendancelist"));
}
