public ActionResult getsubsem(stdlistpractical aa)
{
string name = Convert.ToString(Session["subname2"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlistpractical>("exec fetchsubjectsembyname @name", new SqlParameter("@name", name)).ToList();
TempData["sem"] = advisor[0].sem;
}
return(RedirectToAction("Index", "practicalattendancelist"));
}
public ActionResult gettotal(stdlistpractical 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", "practicalattendancelist"));
}
public ActionResult getmoddate2(stdlistpractical aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var name = new SqlParameter("@name", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.modifiedon
};
}
Session["moddate"] = aa.modifiedon;
return(RedirectToAction("Edit", "practicalattendancelist"));
}
public ActionResult Edit()
{
if (Session["id"] == null)
{
return(RedirectToAction("login", "login"));
}
else
{
var id = Session["id"];
var name = Session["name"];
var sem = Session["sem"];
stdlistpractical update = new stdlistpractical();
update.attendddd = getliststd();
update.practicalsubject = getpracticalsub();
return(View(update));
}
}
public ActionResult submitsubname(stdlistpractical aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var name = new SqlParameter("@name", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.batch
};
var yesno = new SqlParameter("@yesno", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.valueyesno
};
}
TempData["batch"] = aa.batch;
Session["currentbatch"] = TempData["batch"];
Session["valueyesno"] = aa.valueyesno;
return(RedirectToAction("getsubsem", "practicalattendancelist"));
}
public ActionResult Index(stdlistpractical stdlst)
{
var insertattendance = new List <stdlistpractical>();
string name = Convert.ToString(Session["subname2"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlistpractical>("exec fetchsubjectsembyname @name", new SqlParameter("@name", name)).ToList();
TempData["sem2"] = advisor[0].sem;
}
string testt = name + " pr";
int semt = Convert.ToInt32(TempData["sem2"]);
string batcht = Convert.ToString(Session["currentbatch"]);
StringBuilder sb = new StringBuilder();
int firstbatcht = Convert.ToInt32(Session["valueyesno"]);
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, 50)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
var firstbatch = new SqlParameter("@firstbatch", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = firstbatcht
};
var batch = new SqlParameter("@batch", SqlDbType.VarChar, 5)
{
Direction = System.Data.ParameterDirection.Input,
Value = batcht
};
insertattendance = adv.Database.SqlQuery <stdlistpractical>("exec insertpracticalattendancesubject @sem, @IsCheck , @subjectname ,@batch ,@firstbatch", sem, IsCheck, subjectname, batch, firstbatch).ToList();
}
foreach (var item in stdlst.attend)
{
string subjectnamet = Convert.ToString(Session["subname2"]);
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 subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = subjectnamet
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
var batch = new SqlParameter("@batch", SqlDbType.VarChar, 5)
{
Direction = System.Data.ParameterDirection.Input,
Value = batcht
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
insertattendance = adv.Database.SqlQuery <stdlistpractical>("exec insertpracticalattendance @stdrollno, @sem, @subjectname, @IsCheck,@batch ,@test", stdrollno, sem, subjectname, IsCheck, batch, 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 IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
var batch = new SqlParameter("@batch", SqlDbType.VarChar, 5)
{
Direction = System.Data.ParameterDirection.Input,
Value = batcht
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
insertattendance = adv.Database.SqlQuery <stdlistpractical>("exec insertpracticalattendance @stdrollno, @sem, @subjectname, @IsCheck,@batch,@test", stdrollno, sem, subjectname, IsCheck, batch, test).ToList();
}
}
}
return(RedirectToAction("Details", "practicalattendancelist"));
}
public ActionResult Edit(stdlistpractical stdlst)
{
var insertattendance = new List <stdlistpractical>();
string modifiedont = Convert.ToString(Session["moddate"]);
string name = Convert.ToString(Session["subname2"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlistpractical>("exec fetchsubjectsembyname @name", new SqlParameter("@name", name)).ToList();
TempData["sem2"] = advisor[0].sem;
}
string testt = name + " pr";
int semt = Convert.ToInt32(TempData["sem2"]);
StringBuilder sb = new StringBuilder();
foreach (var item in stdlst.attendddd)
{
string subjectnamet = Convert.ToString(Session["subname2"]);
int stdrollnot = item.stdrollno;
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 modifiedon = new SqlParameter("@modifiedon", SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Input,
Value = modifiedont
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
var subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = subjectnamet
};
insertattendance = adv.Database.SqlQuery <stdlistpractical>("exec updatepracticalattendance @stdrollno, @IsCheck ,@modifiedon , @subjectname, @test, @sem", stdrollno, IsCheck, modifiedon, subjectname, test, sem).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 modifiedon = new SqlParameter("@modifiedon", SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Input,
Value = modifiedont
};
var IsCheck = new SqlParameter("@IsCheck", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = IsCheckt
};
var test = new SqlParameter("@test", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = testt
};
var subjectname = new SqlParameter("@subjectname", SqlDbType.VarChar, 100)
{
Direction = System.Data.ParameterDirection.Input,
Value = subjectnamet
};
insertattendance = adv.Database.SqlQuery <stdlistpractical>("exec updatepracticalattendance @stdrollno, @IsCheck ,@modifiedon , @subjectname, @test, @sem", stdrollno, IsCheck, modifiedon, subjectname, test, sem).ToList();
}
}
}
return(RedirectToAction("Details", "practicalattendancelist"));
}
