public JsonResult updateSubProject(CSubproject2 model)
        {
            string message = "";

            try
            {
                pdsTidRedLiveEntities db = new pdsTidRedLiveEntities();
                subProject2           p  = null;
                if (model.subProjectID == 0)
                {
                    p           = new subProject2();
                    p.projectID = model.projectID;
                }
                else
                {
                    p = db.subProject2.SingleOrDefault(x => x.subProjectID == model.subProjectID);
                }
                p.subProjectName = model.subProjectName;
                if (model.subProjectID == 0)
                {
                    db.subProject2.Add(p);
                }
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                message = ex.Message;
            }
            return(Json(message, JsonRequestBehavior.AllowGet));
        }
        public ActionResult AddEditSubProj(int subProjectID, int ProjectID)
        {
            pdsTidRedLiveEntities db = new pdsTidRedLiveEntities();

            CSubproject2 model = new CSubproject2();

            if (subProjectID > 0)
            {
                subProject2 p = db.subProject2.FirstOrDefault(x => x.subProjectID == subProjectID);
                model.subProjectID   = p.subProjectID;
                model.subProjectName = p.subProjectName;
                model.projectID      = p.projectID;
            }

            return(PartialView("AddEditSubProj", model));
        }