public ActionResult DataSource(string clss, string actGrps, string actDate, [FromBody] DataManagerRequest dm)
{
double fActDate = GloFunc.ToOADate(DateTime.Parse(actDate));
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(GloVar.iBaseURI);
MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
client.DefaultRequestHeaders.Accept.Add(contentType);
HttpResponseMessage response = client.GetAsync("/api/EnmTransActivities?clss=" + clss + "&actGrps=" + actGrps + "&actDate=" + fActDate + "&dSess=" + dSess + "&mdBID=" + mdBId).Result;
var stringData = response.Content.ReadAsStringAsync().Result;
EnmTransActivity transActs = JsonConvert.DeserializeObject <EnmTransActivity>(stringData);
DataOperations operation = new DataOperations();
IEnumerable data = transActs.ActivityList;
var count = data.AsQueryable().Count();
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
}
public async Task <IActionResult> Index_Get(EnmTransActivity enmTransActivity)
{
GetSchClss(_context);
ViewBag.Schclsses = new SelectList(SchClsLst, "Value", "Text", null);
GetActivityGroup(_context);
ViewBag.ActGrps = new SelectList(SchActivityGroup, "Value", "Text", null);
GetActivity(_context, "Thinking Skills", true);
enmTransActivity.StdClss = "IX-A";
enmTransActivity.TransActDate = DateTime.Now;
enmTransActivity.TransActGroup = "Thinking Skills";
GetActivity(_context, enmTransActivity.TransActGroup, true);
ViewBag.dropdownActivity = drpActLst;
return(View(enmTransActivity));
}
public async Task <ActionResult> Index_Post([Bind("StdClss,TransActDate,TransActGroup")] EnmTransActivity enmTransActivity)
{
try
{
//if (ModelState.IsValid)
//{
GetSchClss(_context);
ViewBag.Schclsses = new SelectList(SchClsLst, "Value", "Text", null);
GetActivityGroup(_context);
ViewBag.ActGrps = new SelectList(SchActivityGroup, "Value", "Text", null);
GetActivity(_context, enmTransActivity.TransActGroup, true);
ViewBag.dropdownActivity = drpActLst;
//}
return(View(enmTransActivity));
}
catch
{
return(View(enmTransActivity));
}
}
public EnmTransActivity GetTransActivity(string clss, string actgrps, double actDate, string dSess, int mDbId)
{
EnmTransActivity stdActs = new EnmTransActivity();
stdActs.StdClss = clss;
stdActs.TransActGroup = actgrps;
stdActs.TransActDate = DateTime.FromOADate(actDate);
stdActs.DBid = mDbId;
List <TransActivity> stdActList = new List <TransActivity>();
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
MySql = "SELECT ActGroupID FROM ActivityGroup ";
MySql = MySql + " WHERE ActGroupName ='" + actgrps + "'";
MySql = MySql + " AND Dormant =0 ";
MySql = MySql + " AND DBID = " + mDbId;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = MySql;
int tActGroupID = (int)command.ExecuteScalar();
MySql = "SELECT RegNumber,PresentRollNo, FirstName, MiddleName, LastName, StdStatus, Unireg, Photo ";
MySql = MySql + " FROM Students WITH (NOLOCK) ";
MySql = MySql + " WHERE PresentClass='" + repSplChr(clss) + "'";
MySql = MySql + " AND StdSession='" + repSplChr(dSess) + "'";
MySql = MySql + " AND Dormant =0 ";
MySql = MySql + " AND StdStatus <=1";
MySql = MySql + " AND DBID = " + mDbId;
MySql = MySql + " ORDER BY PresentRollNo, FirstName";
command.CommandType = System.Data.CommandType.Text;
command.CommandText = MySql;
DbDataReader kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
TransActivity acts = new TransActivity();
if (!kMyReader.IsDBNull(0))
{
acts.RegNumber = kMyReader.GetInt32(0);
strReg = strReg + ", " + acts.RegNumber;
}
if (!kMyReader.IsDBNull(1))
{
acts.RollNumber = kMyReader.GetInt32(1);
}
if (!kMyReader.IsDBNull(2))
{
acts.StdName = kMyReader.GetString(2); // " " + kMyReader.GetString(3) + " " + kMyReader.GetString(4);
}
acts.Activity = "None";
if (!kMyReader.IsDBNull(6))
{
acts.UniReg = kMyReader.GetInt32(6);
}
acts.ActGroupID = tActGroupID;
if (!kMyReader.IsDBNull(7))
{
acts.ImgDataURL = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String((byte[])(kMyReader.GetValue(7))));
}
stdActList.Add(acts);
}
}
kMyReader.Close();
MySql = "SELECT TransActName, RegNumber, ActivityID, TransActID, TransActRemarks ";
MySql = MySql + " FROM TransActivity WITH (NOLOCK) ";
MySql = MySql + " WHERE RegNumber IN (" + strReg.Trim(',') + ")";
MySql = MySql + " AND ActivityID IN (SELECT ActivityID FROM Activity WHERE(ActGroupID = " + tActGroupID + "))";
MySql = MySql + " AND Dormant =0 ";
MySql = MySql + " AND TransActDate = " + actDate;
MySql = MySql + " AND DBID = " + mDbId;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = MySql;
kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
for (int i = 0; i < stdActList.Count - 1; i++)
{
if (!kMyReader.IsDBNull(0))
{
if (stdActList[i].RegNumber == kMyReader.GetInt32(1))
{
if (stdActList[i].Activity == "None")
{
stdActList[i].Activity = kMyReader.GetString(0);
stdActList[i].TransActId = kMyReader.GetInt32(3);
stdActList[i].TransActRemarks = kMyReader.GetString(4);
break;
}
else
{
sActs = stdActList[i];
sActs.Activity = kMyReader.GetString(0);
stdActList[i].TransActId = kMyReader.GetInt32(3);
stdActList[i].TransActRemarks = kMyReader.GetString(4);
stdActList.Insert(i, sActs);
break;
}
}
}
}
}
}
kMyReader.Close();
}
stdActs.ActivityList = stdActList;
stdActs.StdClss = clss;
stdActs.TransActDate = DateTime.FromOADate(actDate);
stdActs.TransActGroup = actgrps;
return(stdActs);
}
