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); }