public ActionResult Index()
        {
            var RDObj = new ResidentialDrillModel();
            var CL    = new commonLogic();

            CL.dataTable     = RDObj.select();
            CL.tableId       = "residentialsDrill";
            ViewBag.htmldata = CL.buildGridView();
            return(View());
        }
        public ActionResult DrillLog(ResidentialDrillModel RD)
        {
            Boolean status = RD.insert();

            if (status)
            {
                return(RedirectToAction("Index", "ResidentialDrill", new { msg = 6 }));
            }
            else
            {
                return(RedirectToAction("Index", "ResidentialDrill", new { msg = 7 }));
            }
        }
        public String getViewData(FormCollection form)
        {
            string uniqueID = form["uniqueID"];
            string html     = "";
            var    CL       = new commonLogic();

            try
            {
                var       RM = new ResidentialDrillModel();
                DataTable residentialData = RM.GetResidentialData(uniqueID);
                //DataTable residentialClientData = RM.GetResidentialClientData(residentialData.Rows[0]["id"].ToString());
                html += CL.buildResidentialHTML(residentialData);
            }
            catch (Exception e)
            {
                CL.getLog("error while getting data for popip in resdential_drill_log " + e);
                return(html);
            }
            return(html);
        }