public async Task <ActionResult> Choose(SelectMarks selectMarks)
{
try
{
if (ModelState.IsValid)
{
HttpResponseMessage responseMessage = await client.GetAsync(url + "/api/Func/GetSchClss/?dSess=" + dSess + "&mdBId=" + mdBId);
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
SchClssLst = JsonConvert.DeserializeObject <List <SelectListItem> >(responseData);
//ViewBag.SchSessLst = await GetSchSession(_context);
}
// GetSchClss(_context);
ViewBag.SchClssLst = new SelectList(SchClssLst, "Value", "Text", null);
ViewBag.SchExmLst = await GetSchExm(_context, selectMarks.MClss);
ViewBag.SchSubLst = await GetSchSub(_context, selectMarks.MClss, selectMarks.ExamName);
}
return(View(selectMarks));
}
catch
{
return(View());
}
}
public async Task <IActionResult> PutSelectMarks([FromRoute] int id, [FromBody] SelectMarks selectMarks)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != selectMarks.SelectMarksId)
{
return(BadRequest());
}
_context.Entry(selectMarks).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SelectMarksExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostSelectMarks([FromBody] SelectMarks selectMarks)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.SelectMarks.Add(selectMarks);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSelectMarks", new { id = selectMarks.SelectMarksId }, selectMarks));
}
public async Task <int> GetSubID([FromBody] SelectMarks selectMarks)
{
if (!ModelState.IsValid)
{
return(-1);
}
string MySql2 = "";
object tmpObj;
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql2 = " SELECT SubID FROM Subjects WITH (NOLOCK)";
MySql2 = MySql2 + " WHERE SubName = '" + repSplChr(selectMarks.SubName) + "'";
MySql2 = MySql2 + " AND Clss = '" + repSplChr(selectMarks.MClss) + "'";
MySql2 = MySql2 + " AND AcaSession = '" + repSplChr(selectMarks.Sessn) + "'";
MySql2 = MySql2 + " AND Dormant = 0";
MySql2 = MySql2 + " AND dBID = " + selectMarks.DBid;
command.CommandType = CommandType.Text;
tmpObj = command.ExecuteScalarAsync();
if (!((Object)tmpObj == null))
{
if (GloFunc.IsNumeric(tmpObj.ToString()))
{
return(int.Parse(tmpObj.ToString()));
}
else
{
return(-1);
}
}
else
{
return(-1);
}
//conn.Close();
}
//var subjects = await _context.Subjects.SingleOrDefaultAsync(m => m.SubAutoId == id);
//if (subjects == null)
//{
// return NotFound();
//}
//return Ok(subjects);
}
//[SubmitButtonSelector(Name = "Delete")]
public ActionResult ChSubjects(SelectMarks selectMarks)
{
try
{
// TODO: Add update logic here
//@Html.ActionLink("Marks", "Choose", "SelectMarks")
return(RedirectToAction("..//Marks/MarksEntry", selectMarks));
}
catch
{
return(View());
}
}
// GET: Marks/MarksEntry
public ActionResult MarksEntry(SelectMarks selectMarks)
{
//var mSubID = await AcaFunctions.GetSubID(_context, selectMarks.SubName, selectMarks.MClss);
//var subType = await GetGradeType(_context, selectMarks.SubName, selectMarks.MClss);
//var mrkLst = await AcaFunctions.GetMarksLst(_context, selectMarks.MClss);
//ViewBag.DataSource = mrkLst;
ViewBag.Clss = selectMarks.MClss;
ViewBag.SubName = selectMarks.SubName;
ViewBag.ExamName = selectMarks.ExamName;
//ViewBag.SubID = mSubID;
//ViewBag.subType = subType;
//var grid = new WebGrid(mrkLst);
return(View());
}
public async Task <string> GetGradeType([FromBody] SelectMarks selectMarks)
{
string MySql;
string cbGradesType = "";
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql = "SELECT GradeType,GradeOrMarks";
MySql = MySql + " FROM Subjects WITH (NOLOCK) ";
MySql = MySql + " WHERE Dormant=0";
MySql = MySql + " AND Clss='" + repSplChr(selectMarks.MClss) + "'";
MySql = MySql + " AND SubName='" + repSplChr(selectMarks.SubName) + "'";
MySql = MySql + " AND AcaSession='" + repSplChr(selectMarks.Sessn) + "'";
MySql = MySql + " AND Dormant =0";
MySql = MySql + " AND DBID = " + selectMarks.DBid;
command.CommandText = MySql;
DbDataReader kMyReader = await command.ExecuteReaderAsync();
if (kMyReader.HasRows)
{
kMyReader.Read();
if (!kMyReader.IsDBNull(0))
{
if (kMyReader.GetInt32(1) == 1)
{
cbGradesType = kMyReader.GetString(0);
}
}
}
conn.Close();
return(cbGradesType);
}
}
public async Task <List <Marks> > GetMarksLst([FromBody] SelectMarks selectMarks)
{
List <Marks> markList = new List <Marks>();
string MySql;
string fName = "";
string mName = "";
string lName = "";
var conn = _context.Database.GetDbConnection();
if (conn.State != ConnectionState.Open)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql = "SELECT RegNumber,PresentRollNo, FirstName, MiddleName, LastName,StdStatus,Unireg ";
MySql = MySql + " FROM Students WITH (NOLOCK) ";
MySql = MySql + " WHERE PresentClass='" + repSplChr(selectMarks.MClss) + "'";
MySql = MySql + " AND StdSession='" + repSplChr(selectMarks.Sessn) + "'";
MySql = MySql + " AND Dormant =0 ";
MySql = MySql + " AND StdStatus <=1 ";
MySql = MySql + " AND DBID = " + selectMarks.DBid;
MySql = MySql + " ORDER BY PresentRollNo";
command.CommandText = MySql;
DbDataReader kMyReader = await command.ExecuteReaderAsync();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
Marks marks = new Marks();
if (!kMyReader.IsDBNull(0))
{
marks.RegNum = kMyReader.GetInt32(0);
}
if (!kMyReader.IsDBNull(1))
{
marks.presentRollNum = kMyReader.GetInt32(1);
}
if (!kMyReader.IsDBNull(2))
{
fName = kMyReader.GetString(2);
}
if (!kMyReader.IsDBNull(3))
{
mName = kMyReader.GetString(3);
}
if (!kMyReader.IsDBNull(4))
{
lName = kMyReader.GetString(4);
}
marks.StdName = fName + mName + lName;
//if (!kMyReader.IsDBNull(5)) { marks.stdStatus = kMyReader.GetInt32(5); }
if (!kMyReader.IsDBNull(6))
{
marks.UniReg = kMyReader.GetInt32(6);
}
markList.Add(marks);
}
}
conn.Close();
return(markList);
}
}
