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