public ActionResult Create(FormCollection frm)
        {
            try
            {
                usp_ServiceGetbyID_Result service = new usp_ServiceGetbyID_Result();
                int result = 0;
                if (ModelState.IsValid)
                {
                    TryUpdateModel(service);
                    result = (int)onlinetutor.usp_ServiceInsert(service.Description, 1, service.CategoryID).FirstOrDefault();
                }
                if (result == 1)
                {
                    return(RedirectToAction("Index"));
                }

                else
                {
                    ViewBag.CategoryID = new SelectList(onlinetutor.usp_CategoryGetList(), "CategoryID", "CategoryName");
                    ModelState.AddModelError("", "Service already exists");
                    return(View("create"));
                }
            }
            catch (Exception ex)
            {
                return(RedirectToAction("Index"));
            }
        }
 public ActionResult Edit(int serviceid)
 {
     try
     {
         ViewBag.Categoryid = new SelectList(onlinetutor.usp_CategoryGetList(), "CategoryID", "CategoryName");
         usp_ServiceGetbyID_Result servicedetail = onlinetutor.usp_ServiceGetbyID(serviceid).FirstOrDefault();
         return(View(servicedetail));
     }
     catch (Exception ex)
     {
         return(View());
     }
 }
 public ActionResult Edit()
 {
     try
     {
         usp_ServiceGetbyID_Result service = new usp_ServiceGetbyID_Result();
         TryUpdateModel(service);
         int result = (int)onlinetutor.usp_ServiceUpdate(service.ServiceID, service.Description, 1, service.Status, service.CategoryID).FirstOrDefault();
         return(RedirectToAction("Index"));
     }
     catch (Exception ex)
     {
         return(View("Index"));
     }
 }