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(); }