public async Task <IActionResult> PutTransActivity([FromRoute] int id, [FromBody] TransActivity transActivity)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            try
            {
                transActivity.ActivityId = GetActivityID(_context, transActivity.Activity, transActivity.ActGroupID, transActivity.DBid);
                var conn = _context.Database.GetDbConnection();
                if (conn.State == ConnectionState.Closed)
                {
                    await conn.OpenAsync();
                }
                using (var command = conn.CreateCommand())
                {
                    if (transActivity.Activity == "None")
                    {
                        if (transActivity.TransActId != 0)
                        {
                            MySql = " UPDATE TransActivity SET ";
                            MySql = MySql + " Dormant = 1 ";
                            MySql = MySql + " WHERE TransActID = " + transActivity.TransActId;
                            MySql = MySql + " AND RegNumber = " + transActivity.RegNumber;
                            command.CommandType = CommandType.Text;
                            command.CommandText = MySql;
                            command.ExecuteNonQuery();
                        }
                    }
                    else
                    {
                        MySql = " INSERT INTO TransActivity (TransActID, TransActName, ActivityID, RegNumber, TransActValue, "
                                + "TransActDate, TransActObserver, TeachID, TransActRemarks, UniReg, Score, ";
                        MySql = MySql + " Dormant, LoginName, ModTime, cTerminal, dBID) Values (0, '";
                        MySql = MySql + transActivity.Activity + "'," + transActivity.ActivityId + "," + transActivity.RegNumber + ","
                                + transActivity.TransActValue + "," + GloFunc.ToOADate(transActivity.TransActDate) + ",'"
                                + transActivity.TransActObserver + "',0,'" + transActivity.TransActRemarks + "'," + transActivity.UniReg + ",0,";
                        MySql = MySql + "0,'" + transActivity.LoginName + "'," + GenFunc.GloFunc.ToOADate(DateTime.Now);
                        MySql = MySql + ",'" + transActivity.CTerminal + "'," + transActivity.DBid + ")";

                        command.CommandType = CommandType.Text;
                        command.CommandText = MySql;
                        command.ExecuteNonQuery();
                    }
                }
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!TransActivityExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }
            return(NoContent());
        }
        public async Task <IActionResult> PostTransActivity([FromBody] TransActivity transActivity)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            _context.TransActivity.Add(transActivity);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetTransActivity", new { id = transActivity.AutoId }, transActivity));
        }
        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);
        }