/// <summary>
        /// to delete test x test group by id
        /// </summary>
        public bool DeleteTestByTestGroupByIDs(int TestID, int TestGroupID)
        {
            using (Entities db = new Entities())
            {
                bool isDeleted = false;

                REF_TEST_X_TEST_GROUP_TB result = db.REF_TEST_X_TEST_GROUP_TB
                                                  .FirstOrDefault(u => u.N_TEST_SYSID == TestID && u.N_TEST_GROUP_SYSID == TestGroupID);

                db.REF_TEST_X_TEST_GROUP_TB.Remove(result);
                db.SaveChanges();
                isDeleted = true;

                return(isDeleted);
            }
        }
        public ActionResult Create(TestGroupCreateTestViewModel Model, bool IsTest = false)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    string modifiedBy = IsTest ? "Unit Test Case" : _modifiedBy;
                    REF_TEST_X_TEST_GROUP_TB record = new REF_TEST_X_TEST_GROUP_TB()
                    {
                        B_INACTIVE         = false,
                        DT_ENTERED         = DateTime.UtcNow,
                        DT_MODIFIED        = DateTime.UtcNow,
                        N_TEST_GROUP_SYSID = Model.ID,
                        N_TEST_SYSID       = Model.SelectedTest,
                        SZ_ENTERED_BY      = modifiedBy,
                        SZ_MODIFIED_BY     = _modifiedBy
                    };

                    _uow.Repository <REF_TEST_X_TEST_GROUP_TB>().Add(record);
                    _uow.SaveChanges();

                    return(RedirectToAction("Details", new { ID = Model.ID, TestGroupID = Model.SelectedTest }));
                }

                Model.Tests = (List <SelectListItem>)_testRepo.GetTestGroupsSelectListByTestID(Model.ID);

                return(View(Model));
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    ViewBag.Message = "Function: TestGroupController.Create_POST\n\nError: " + ex.Message;
                }
                else
                {
                    ViewBag.Message = "Function: TestGroupController.Create_POST\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
                };
                Session["ErrorMessage"] = ViewBag.Message;
                return(RedirectToAction("InternalServerError", "Error"));
            };
        }