public string CheckUserName(String user, string id)
{
String flag = string.Empty;
EmployeeDataHandler objEmployeeDataHandler = new EmployeeDataHandler();
List <Employee> Employeelist = new List <Employee>();
if (id == null)
{
DataSet ds = objEmployeeDataHandler.GetEmployee();
foreach (DataRow dr in ds.Tables[0].Rows)
{
String UserName = Convert.ToString(dr["UserName"]);
if (user == UserName)
{
flag = "false";
return(flag);
}
}
}
else
{
DataSet ds = objEmployeeDataHandler.GetEmployeeByIDUpdate(id);
foreach (DataRow dr in ds.Tables[0].Rows)
{
String UserName = Convert.ToString(dr["UserName"]);
if (user == UserName)
{
flag = "false";
return(flag);
}
}
}
return(flag = "true");
}
public JsonResult update(String id, Employee objEmployee)
{
string res = string.Empty;
List <Employee> Employeelist = new List <Employee>();
try
{
// TODO: Add update logic here
EmployeeDataHandler objEmployeeDataHandler = new EmployeeDataHandler();
String msg = CheckUserName(objEmployee.UserName, objEmployee.Eid);
if (msg == "true")
{
bool flag = objEmployeeDataHandler.UpdateDetails(objEmployee);
if (flag)
{
DataSet ds = objEmployeeDataHandler.GetEmployee();
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
{
res = "Error";
}
}
else
{
return(Json("true", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
res = "Error";
}
return(Json(Employeelist, JsonRequestBehavior.AllowGet));
}
public JsonResult Get_data()
{
EmployeeDataHandler objEmployeeDataHandler = new EmployeeDataHandler();
List <Employee> Employeelist = new List <Employee>();
DataSet ds = objEmployeeDataHandler.GetEmployee();
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));
}
public async Task <Employee> GetEmployee(int empId)
{
//Kalder metode på employeedatahandlerobjekt der returnere en employee på basis af id givet som argument
return(await employeeBinder.GetEmployee(empId));
}
