public List <TransactionEntity> GetEmployeeList()
{
var empList = new List <TransactionEntity>();
SqlDataReader reader = null;
try
{
StoreProcedureCommand procedure = CreateProcedureCommand("dbo.GetEmployee");
reader = ExecuteCommandAndReturnDataReader(procedure);
while (reader.Read())
{
empList.Add(new TransactionEntity {
EmpID = new Guid(reader["EmpID"].ToString()), Name = reader["Name"].ToString(), Address = reader["Address"].ToString(), EMail = reader["EMail"].ToString(), Phone = reader["Phone"].ToString()
});
}
reader.Close();
}
catch (Exception ex)
{
reader.Close();
throw ex;
}
return(empList);
}
public Result UpdateEmployee(TransactionEntity employeeData)
{
var result = new Result()
{
IsValid = false
};
StoreProcedureCommand procedure = CreateProcedureCommand("dbo.UpdateEmployee");
procedure.AppendGuid("EmpID", employeeData.EmpID);
procedure.AppendNVarChar("Address", employeeData.Address);
procedure.AppendNVarChar("EMail", employeeData.EMail);
procedure.AppendNVarChar("Phone", employeeData.Phone);
int resultValue = ExecuteCommand(procedure);
if (resultValue == 0)
{
result.IsValid = true;
result.Message = new List <string> {
"Employee updated successfully"
};
}
return(result);
}
public Result DeleteEmployee(Guid empID)
{
var result = new Result()
{
IsValid = false
};
StoreProcedureCommand procedure = CreateProcedureCommand("dbo.DeleteEmployee");
procedure.AppendGuid("EmpID", empID);
int resultValue = ExecuteCommand(procedure);
if (resultValue == 0)
{
result.IsValid = true;
result.Message = new List <string> {
"Employee deleted successfully"
};
}
return(result);
}
