public ActionResult EmployeeRegistration()
        {
            try
            {
                Employee emp_reg = new Employee();
                DataTable dt = emp_reg.Emp_Dept_data();
                Service1 gis_service = new Service1();
                DataSet ds = new DataSet();
                ds = gis_service._1Get_Company();
                List<SelectListItem> Company = new List<SelectListItem>();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    Company.Add(new SelectListItem()
                    {
                        Value = ds.Tables[0].Rows[i]["Company"].ToString(),
                        Text = ds.Tables[0].Rows[i]["Company"].ToString()
                    });
                }
                ViewData["Company"] = new SelectList(Company, "Value", "Text", "Select Company");

                List<SelectListItem> dept = new List<SelectListItem>();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    dept.Add(new SelectListItem()
                    {
                        Text = dt.Rows[i]["DEPT_NAME"].ToString(),
                        Value = dt.Rows[i]["DEPT_ID"].ToString()
                    });
                }
                ViewData["Dept_name"] = new SelectList(dept, "Value", "Text", "Select Department");
            }
            catch
            { }
            return View();
        }
        public ActionResult User_complain_reg(user_complain_reg reg)
        {
            try
            {

                if (ModelState.IsValid)
                {
                    string CA_NO = reg.CA_NO.ToString();
                    DataTable dt = reg.User_prev_comp_status(CA_NO);
                    if (dt.Rows.Count != 0)
                    {
                        ModelState.AddModelError("", "Your Complain is already registered.Your Complain number is '" + dt.Rows[0]["COMP_NO"].ToString() + "' ");
                    }
                    else
                    {
                        get_LT_network_detail LT_Network = new get_LT_network_detail();
                        string[] detail = new string[10];
                        DataTable dt1 = LT_Network.get_network_detail(CA_NO);
                        String Sub_station_code = dt1.Rows[0]["Substion_id"].ToString();
                        Service1 gis_service = new Service1();
                        DataSet ds = new DataSet();
                        ds = gis_service._Substation_Div_details(Sub_station_code);
                        detail[0] = dt1.Rows[0]["POLE_NO"].ToString();
                        detail[1] = dt1.Rows[0]["DT_CODE"].ToString();
                        detail[2] = ds.Tables[0].Rows[0]["Company"].ToString();
                        detail[3] = ds.Tables[0].Rows[0]["Circle"].ToString();
                        detail[4] = ds.Tables[0].Rows[0]["DIVISION_1"].ToString();
                        detail[5] = ds.Tables[0].Rows[0]["SUBDIVISIO"].ToString();
                        detail[6] = Sub_station_code;
                        complaints_center comp_cent = new complaints_center();
                        DataTable Center = comp_cent.get_complaints_center(detail[5]);
                        detail[7] = Center.Rows[0]["COMP_CEN_ID"].ToString();
                        reg.User_Web_comp_reg(reg, detail);
                        DataTable dt2 = reg.Get_complaint_NO(CA_NO);
                        ModelState.AddModelError("", "Your Complain is registered.Your Complain number is '" + dt2.Rows[0]["COMP_NO"].ToString() + "' ");

                    }
                }
            }
            catch
            {
                ModelState.AddModelError("", "There is some problem in complain registration,plz try later");
            }
            fault_type();
            User_comp_clear(reg);
            return View();
        }