public JsonResult Add_record(Employee objEmployee) { string res = string.Empty; List <Employee> Employeelist = new List <Employee>(); try { EmployeeDataHandler objEmployeeDataHandler = new EmployeeDataHandler(); String msg = CheckUserName(objEmployee.UserName, objEmployee.Eid); if (msg == "true") { String id = objEmployeeDataHandler.AddEmployee(objEmployee); DataSet ds = objEmployeeDataHandler.Get_ByID(id); foreach (DataRow dr in ds.Tables[0].Rows) { Employeelist.Add( new Employee { Eid = Convert.ToString(dr["Eid"]), Ename = Convert.ToString(dr["Ename"]), Email = Convert.ToString(dr["Email"]), Salary = Convert.ToString(dr["Salary"]), mobile = Convert.ToString(dr["mobile"]), UserName = Convert.ToString(dr["UserName"]), Password = Convert.ToString(dr["Password"]) }); } return(Json(Employeelist, JsonRequestBehavior.AllowGet)); } else { return(Json("true", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { res = "Error"; } return(Json(Employeelist, JsonRequestBehavior.AllowGet)); }
public JsonResult Get_databyid(String id) { EmployeeDataHandler objEmployeeDataHandler = new EmployeeDataHandler(); List <Employee> Employeelist = new List <Employee>(); DataSet ds = objEmployeeDataHandler.Get_ByID(id); foreach (DataRow dr in ds.Tables[0].Rows) { Employeelist.Add( new Employee { Eid = Convert.ToString(dr["Eid"]), Ename = Convert.ToString(dr["Ename"]), Email = Convert.ToString(dr["Email"]), Salary = Convert.ToString(dr["Salary"]), mobile = Convert.ToString(dr["mobile"]), UserName = Convert.ToString(dr["UserName"]), Password = Convert.ToString(dr["Password"]) }); } return(Json(Employeelist, JsonRequestBehavior.AllowGet)); }