Exemple #1
0
        public ActionResult SaveA360(int IDc, int actp, int wchk, double lat, double lng, int utco)
        {
            //System.Diagnostics.Debug.WriteLine(item2);
            string CurrentLoginID = User.Identity.GetUserId().ToString();

            var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
            int userIDselectInt = userIDselectVar.Single();

            List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                             .Select(s => s.projectID)
                                             .ToList();

            List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                                .Select(s => s.taskOrderID)
                                                .ToList();

            var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
            int userTypeInt    = userTypeSelect.First();

            if (userTypeInt == 2 && CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(63))
            {
                List <uhspageitemsDb> cheka = new List <uhspageitemsDb>();
                string CS = ConfigurationManager.ConnectionStrings["DATAOPBConnection"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    SqlCommand cmd = new SqlCommand("procUHSACCTStmpSave", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@acctid", IDc);
                    cmd.Parameters.AddWithValue("@actp", actp);
                    cmd.Parameters.AddWithValue("@wchk", wchk);
                    cmd.Parameters.AddWithValue("@lat", lat);
                    cmd.Parameters.AddWithValue("@lng", lng);
                    cmd.Parameters.AddWithValue("@utco", utco);

                    SqlParameter outputParameter = new SqlParameter();
                    outputParameter.ParameterName = "@ID";
                    outputParameter.SqlDbType     = System.Data.SqlDbType.Int;
                    outputParameter.Direction     = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(outputParameter);

                    con.Open();
                    cmd.ExecuteNonQuery();

                    string docID = outputParameter.Value.ToString();
                    int    ddID  = Int32.Parse(docID);

                    uhspageitemsDb set1 = new uhspageitemsDb();
                    set1.modInt01 = ddID;
                    cheka.Add(set1);
                }

                var conf = cheka.Select(s => s.modInt01).First();
                return(Json(conf, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }
Exemple #2
0
        public ActionResult athreeform(string ID, int IDK, int IDF)
        {
            //System.Diagnostics.Debug.WriteLine(item2);
            string CurrentLoginID = User.Identity.GetUserId().ToString();

            var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
            int userIDselectInt = userIDselectVar.Single();

            List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                             .Select(s => s.projectID)
                                             .ToList();

            List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                                .Select(s => s.taskOrderID)
                                                .ToList();

            var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
            int userTypeInt    = userTypeSelect.First();
            var dtt            = DateTime.Now.ToString("yyyyMM");
            int dtt1           = int.Parse(dtt);
            var dts            = DateTime.Now.ToString("yyyyMMdd");
            int dt1            = int.Parse(dts);

            ViewBag.usrnm = dbv.agentsViewDbs.Where(s => s.userID == CurrentLoginID).Select(s => s.agentName).First();



            if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(13) && returnTaskOrdersIDlist.Contains(65)))
            {
                List <uhspageitemsDb> pageModel = new List <uhspageitemsDb>();

                string CS = ConfigurationManager.ConnectionStrings["DATAOPAConnection"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    SqlCommand cmd = new SqlCommand("procUHSWOT01refresh", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@IDT", ID);
                    cmd.Parameters.AddWithValue("@IDC", 2);
                    SqlParameter outputParameter = new SqlParameter();
                    outputParameter.ParameterName = "@ID";
                    outputParameter.SqlDbType     = System.Data.SqlDbType.Int;
                    outputParameter.Direction     = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(outputParameter);

                    con.Open();
                    cmd.ExecuteNonQuery();

                    string resp = outputParameter.Value.ToString();
                    int    res  = Int32.Parse(resp);

                    uhspageitemsDb List1 = new uhspageitemsDb();
                    List1.modInt01 = res;
                    pageModel.Add(List1);

                    con.Close();
                }

                int respint = pageModel.Select(s => s.modInt01).First();

                if (respint == 1)
                {
                    var tskoid = opb.UHSWOT01vDbs.Where(s => s.ID == ID).Select(s => s.eXtskoid).First();
                    var distid = opb.UHSWOT01vDbs.Where(s => s.ID == ID).Select(s => s.distid).First();
                    var acctid = opb.UHSWOT01vDbs.Where(s => s.ID == ID).Select(s => s.acctid).First();

                    if (tskoid == 0)
                    {
                        ViewBag.tskoid = IDK;

                        if (IDK == 52)
                        {
                            ViewBag.mode     = opb.UHSinquriesDbs.Where(s => s.tskoid == IDK).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct();
                            ViewBag.task     = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                            ViewBag.tasg     = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).OrderBy(s => s.ID).Select(s => new { L1ID = s.L1ID, L2ID = s.L2ID, L2DS = s.L2DS }).Distinct();
                            ViewBag.inquries = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);
                            List <int> dis1 = opb.UHSUSAC1DISTRICTDbs.Where(s => s.MGRID == userIDselectInt)
                                              .Select(s => s.DISTID)
                                              .ToList();
                            ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis1.Contains(s.ID)).OrderBy(s => s.ID);
                        }
                        else if (IDK == 53 || IDK == 57 || IDK == 58)
                        {
                            ViewBag.mode     = opb.UHSinquriesDbs.Where(s => s.tskoid == IDK).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct();
                            ViewBag.task     = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                            ViewBag.inquries = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);

                            if (IDK == 53)
                            {
                                List <int> dis1 = opb.UHSUSAC1DISTRICTDbs.Where(s => s.MGRID == userIDselectInt)
                                                  .Select(s => s.DISTID)
                                                  .ToList();
                                ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis1.Contains(s.ID)).OrderBy(s => s.ID);
                            }
                            else if (IDK == 57)
                            {
                                List <int> dis1 = opb.UHSUSAC1SURSERVDbs.Where(s => s.MGRID == userIDselectInt)
                                                  .Select(s => s.DISTID)
                                                  .ToList();
                                ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis1.Contains(s.ID)).OrderBy(s => s.ID);
                            }
                            else if (IDK == 58)
                            {
                                List <int> dis1 = opb.UHSUSAC1COEDbs.Where(s => s.MGRID == userIDselectInt)
                                                  .Select(s => s.DISTID)
                                                  .ToList();
                                ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis1.Contains(s.ID)).OrderBy(s => s.ID);
                            }
                        }
                        else if (IDK == 55 || IDK == 56)
                        {
                            ViewBag.mode     = opb.UHSinquriesDbs.Where(s => s.tskoid == IDK).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct();
                            ViewBag.task     = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                            ViewBag.inquries = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == IDK).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);

                            if (IDK == 55)
                            {
                                List <int> acc1 = opb.UHSUSAC1A360Dbs.Where(s => s.MGRID == userIDselectInt)
                                                  .Select(s => s.IDc)
                                                  .ToList();
                                List <int> dis2 = opa.UHSACCTSDbs.Where(s => s.typeid == 1 && acc1.Contains(s.IDc))
                                                  .Select(s => s.DISTID)
                                                  .Distinct()
                                                  .ToList();
                                ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis2.Contains(s.ID)).OrderBy(s => s.ID);
                                ViewBag.accts     = opa.UHSACCTSDbs.Where(s => acc1.Contains(s.IDc)).OrderBy(s => s.IDc).Select(s => new { DISTID = s.DISTID, IDc = s.IDc, CSTNM = s.CSTNM }).Distinct();
                            }
                            else if (IDK == 56)
                            {
                                List <int> acc1 = opb.UHSUSAC1B360Dbs.Where(s => s.MGRID == userIDselectInt)
                                                  .Select(s => s.IDc)
                                                  .ToList();
                                List <int> dis2 = opa.UHSACCTSDbs.Where(s => s.typeid == 2 && acc1.Contains(s.IDc))
                                                  .Select(s => s.DISTID)
                                                  .Distinct()
                                                  .ToList();
                                ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == 0 || dis2.Contains(s.ID)).OrderBy(s => s.ID);
                                ViewBag.accts     = opa.UHSACCTSDbs.Where(s => acc1.Contains(s.IDc)).OrderBy(s => s.IDc).Select(s => new { DISTID = s.DISTID, IDc = s.IDc, CSTNM = s.CSTNM }).Distinct();
                            }
                        }
                    }
                    else if (tskoid == 52)
                    {
                        ViewBag.tskoid    = tskoid;
                        ViewBag.mode      = new SelectList(opb.UHSinquriesDbs.Where(s => s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct(), "tskoid", "taskOrder");
                        ViewBag.task      = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                        ViewBag.tasg      = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { L1ID = s.L1ID, L2ID = s.L2ID, L2DS = s.L2DS }).Distinct();
                        ViewBag.inquries  = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == tskoid).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);
                        ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == distid).OrderBy(s => s.ID);
                    }
                    else if (tskoid == 53 || tskoid == 57 || tskoid == 58)
                    {
                        ViewBag.tskoid    = tskoid;
                        ViewBag.mode      = opb.UHSinquriesDbs.Where(s => s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct();
                        ViewBag.task      = opb.UHSinquriesDbs.Where(s => s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                        ViewBag.inquries  = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == tskoid).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);
                        ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == distid).OrderBy(s => s.ID);
                    }
                    else if (tskoid == 55 || tskoid == 56)
                    {
                        ViewBag.tskoid    = tskoid;
                        ViewBag.mode      = opb.UHSinquriesDbs.Where(s => s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { tskoid = s.tskoid, taskOrder = s.taskOrder }).Distinct();
                        ViewBag.task      = opb.UHSinquriesDbs.Where(s => s.tskoid == tskoid).OrderBy(s => s.ID).Select(s => new { L1ID = s.L1ID, L1DS = s.L1DS }).Distinct();
                        ViewBag.inquries  = opb.UHSinquriesDbs.Where(s => s.ID == 0 || s.tskoid == tskoid).Select(s => new { ID = s.ID, tskoid = s.tskoid, L1ID = s.L1ID, L1DS = s.L1DS, L2ID = s.L2ID, L2DS = s.L2DS, L3DS = s.L3DS, taskOrder = s.taskOrder }).OrderBy(s => s.ID);
                        ViewBag.districts = opb.UHSDISTDP1Dbs.Where(s => s.ID == distid).OrderBy(s => s.ID);
                        ViewBag.accts     = opb.UHSdimCustomerDropDownDbs.Where(s => s.ID == acctid).OrderBy(s => s.ID);
                    }

                    var data1 = opb.UHSWOT01vDbs.Where(s => s.ID == ID).ToList();
                    ViewBag.pageData = data1;

                    ViewBag.mnth   = data1.Select(s => s.yyyymm).First();
                    ViewBag.crdate = data1.Select(s => s.crdate).First();
                    ViewBag.datest = data1.Select(s => s.datest).First();
                    ViewBag.dateex = data1.Select(s => s.dateex).First();

                    ViewBag.comboDistrict = data1.Select(s => s.distnm).First();
                    ViewBag.IDK           = IDK;
                    ViewBag.comboDistrict = data1.Select(s => s.distnm).First();

                    ViewBag.docmid = null;
                    ViewBag.dimgid = 0;

                    ViewBag.userID     = userIDselectInt;
                    ViewBag.userTypeID = userTypeInt;
                    ViewBag.docID      = ID;
                    ViewBag.svctr      = 1;
                    ViewBag.stepTable  = opb.UHSWOP01vDbs.Where(c => c.IDT == ID);
                    ViewBag.cntSteps   = opb.UHSWOT01vDbs.Where(s => s.ID == ID).Select(s => s.tskcnt).First();
                    ViewBag.IDF        = IDF;
                    return(View());
                }
                else
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }
Exemple #3
0
        public ActionResult Index(int projectID, int taskOrderID, int Int1)
        {
            //System.Diagnostics.Debug.WriteLine("test over date");

            string CurrentLoginID = User.Identity.GetUserId().ToString();

            var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
            int userIDselectInt = userIDselectVar.Single();

            List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                             .Select(s => s.projectID)
                                             .ToList();

            List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                                .Select(s => s.taskOrderID)
                                                .ToList();

            var        userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
            int        userTypeInt    = userTypeSelect.First();
            var        dtt            = DateTime.Now.ToString("yyyyMM");
            int        dtt1           = int.Parse(dtt);
            var        dts            = DateTime.Now.ToString("yyyyMMdd");
            int        dt1            = int.Parse(dts);
            int        dis            = db.agentsDbs.Where(s => s.userID == CurrentLoginID).Select(s => s.distid).First();
            int        week           = opa.DATAOPATIME_FRAMEDbs.Where(s => s.dateYMD == dt1).Select(s => s.WNumber).First();
            int        daynbr         = opa.DATAOPATIME_FRAMEDbs.Where(s => s.dateYMD == dt1).Select(s => s.daywnm).First();
            List <int> agentP         = new List <int>(db.agentsProjDistDbs.OrderBy(c => c.ID).Where(c => c.userID == CurrentLoginID && c.projectID != 6 && c.projectID != 7).Select(c => c.projectID).ToList());

            var ch01 = opb.UHSUSAC1A360Dbs.Where(s => s.MGRID == userIDselectInt).Count();
            var ch02 = opb.UHSUSAC1B360Dbs.Where(s => s.MGRID == userIDselectInt).Count();
            var ch03 = opb.UHSUSAC1DISTRICTDbs.Where(s => s.MGRID == userIDselectInt).Count();
            var ch04 = opb.UHSUSAC1SURSERVDbs.Where(s => s.MGRID == userIDselectInt).Count();
            var ch05 = opb.UHSUSAC1COEDbs.Where(s => s.MGRID == userIDselectInt).Count();

            ViewBag.preAgentT = db.agentsTODistDbs.Where(c => c.userID == CurrentLoginID && (((c.taskOrderID == 52 || c.taskOrderID == 53) && ch03 >= 1) ||
                                                                                             (c.taskOrderID == 55 && ch01 >= 1) ||
                                                                                             (c.taskOrderID == 56 && ch02 >= 1) ||
                                                                                             (c.taskOrderID == 57 && ch04 >= 1) ||
                                                                                             (c.taskOrderID == 58 && ch05 >= 1))).Select(c => new { ID = c.taskOrderID }).ToList();
            ViewBag.daynbr = daynbr;

            if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(13) && returnTaskOrdersIDlist.Contains(65)))
            {
                List <uhspageitemsDb> pageModel = new List <uhspageitemsDb>();

                string CS = ConfigurationManager.ConnectionStrings["DATAOPAConnection"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    SqlCommand cmd = new SqlCommand("procUHSWOT01refresh", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;



                    cmd.Parameters.AddWithValue("@IDT", userIDselectInt);
                    cmd.Parameters.AddWithValue("@IDC", 1);
                    SqlParameter outputParameter = new SqlParameter();
                    outputParameter.ParameterName = "@ID";
                    outputParameter.SqlDbType     = System.Data.SqlDbType.Int;
                    outputParameter.Direction     = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(outputParameter);

                    con.Open();
                    cmd.ExecuteNonQuery();

                    string resp = outputParameter.Value.ToString();
                    int    res  = Int32.Parse(resp);

                    uhspageitemsDb List1 = new uhspageitemsDb();
                    List1.modInt01 = res;
                    pageModel.Add(List1);

                    con.Close();
                }

                int respint = pageModel.Select(s => s.modInt01).First();

                if (respint == 1)
                {
                    ViewBag.userID = userIDselectInt;
                    ViewBag.dat    = 0;
                    ViewBag.wek    = 0;
                    ViewBag.per    = 0;
                    ViewBag.dis    = dis;
                    ViewBag.act    = 0;
                    ViewBag.dcg    = 0;
                    ViewBag.dct    = 0;

                    var data1 = opb.UHSWOT01vDbs.Where(s => userTypeInt == 2 || s.crusid == userIDselectInt).ToList();
                    ViewBag.pageData = data1;
                    ViewBag.svctr    = 0;
                    ViewBag.btnSel   = 1;
                    return(View());
                }
                else
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }
Exemple #4
0
        public ActionResult insertDoc(int tskoid, int L3IDc, int dat, int wek, int per, int dis, int act, int dcg, int dct, string IDR)
        {
            string CurrentLoginID = User.Identity.GetUserId().ToString();

            var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
            int userIDselectInt = userIDselectVar.Single();

            List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                             .Select(s => s.projectID)
                                             .ToList();

            List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                                .Select(s => s.taskOrderID)
                                                .ToList();

            var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
            int userTypeInt    = userTypeSelect.First();

            if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(13) && returnTaskOrdersIDlist.Contains(65)))
            {
                var dts    = DateTime.Now.ToString("yyyyMMddHHMMss");
                var newIDb = dts + "DC3010001TO" + tskoid + "DS" + dis + "AC" + act + "US" + userIDselectInt;
                var newID  = newIDb + "," + IDR;



                List <uhspageitemsDb> pageModel = new List <uhspageitemsDb>();

                ViewBag.dat = dat;
                ViewBag.wek = wek;
                ViewBag.per = per;
                ViewBag.dis = dis;
                ViewBag.act = act;
                ViewBag.dcg = dcg;
                ViewBag.dct = dct;

                //System.Diagnostics.Trace.WriteLine(newID);

                string CS = ConfigurationManager.ConnectionStrings["DATAOPAConnection"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    SqlCommand cmd = new SqlCommand("procUHSWOT01insert", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@IDa", newID);
                    cmd.Parameters.AddWithValue("@userid", userIDselectInt);
                    cmd.Parameters.AddWithValue("@L3ID", L3IDc);
                    cmd.Parameters.AddWithValue("@dat", dat);
                    cmd.Parameters.AddWithValue("@wek", wek);
                    cmd.Parameters.AddWithValue("@per", per);
                    cmd.Parameters.AddWithValue("@dis", dis);
                    cmd.Parameters.AddWithValue("@act", act);
                    cmd.Parameters.AddWithValue("@dcg", dcg);
                    cmd.Parameters.AddWithValue("@dct", dct);

                    SqlParameter outputParameter = new SqlParameter();
                    outputParameter.ParameterName = "@ID";
                    outputParameter.SqlDbType     = System.Data.SqlDbType.Int;
                    outputParameter.Direction     = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(outputParameter);

                    con.Open();
                    cmd.ExecuteNonQuery();

                    string resp = outputParameter.Value.ToString();
                    int    res  = Int32.Parse(resp);

                    uhspageitemsDb List1 = new uhspageitemsDb();
                    List1.modInt01 = res;
                    pageModel.Add(List1);

                    con.Close();
                }

                int respint = pageModel.Select(s => s.modInt01).First();



                if (respint == 1)
                {
                    var response = newIDb;
                    return(Json(response, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    var response = 3;
                    return(Json(response, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }