public List <SysApi> GetAllSysApi()
{
SqlCommand cmd = new SqlCommand("dbo.SysApi_GetAllApi");
var dt = _sqlDatabase.ExecuteSelect(cmd);
List <SysApi> apiList = new List <SysApi>();
foreach (DataRow row in dt.Rows)
{
SysApi api = new SysApi();
api.Id = (int)row["SysApiId"];
api.Name = row["Name"].ToString();
api.Code = row["Code"].ToString();
apiList.Add(api);
}
return(apiList);
}
public List <Robot> GetAllRobot()
{
SqlCommand cmd = new SqlCommand("dbo.Robot_GetAll");
var dt = _sqlDb.ExecuteSelect(cmd);
List <Robot> res = new List <Robot>();
foreach (DataRow row in dt.Rows)
{
Robot r = new Robot()
{
Id = DataTableUtils.GetValue <int>(row, "RobotId"),
Code = DataTableUtils.GetValue <string>(row, "Code"),
Name = DataTableUtils.GetValue <string>(row, "Name")
};
res.Add(r);
}
return(res);
}
public RobotGridObstacleBehaviourLinkViewModel GetObstacleBehaviourList(string robotCode, string obstacleCode)
{
SqlCommand cmd = new SqlCommand("dbo.LinkRobotGridObstacleBehaviour_Get");
cmd.Parameters.AddWithValue("@RobotCode", robotCode);
cmd.Parameters.AddWithValue("@GridObstacleCode", obstacleCode);
var dt = _sqlDb.ExecuteSelect(cmd);
DataRow row = dt.Rows[0];
RobotGridObstacleBehaviourLinkViewModel obj = new RobotGridObstacleBehaviourLinkViewModel();
obj.RobotCode = DataTableUtils.GetValue <string>(row, "RobotCode");
obj.ObstacleCode = DataTableUtils.GetValue <string>(row, "ObstacleCode");
obj.ObstacleName = DataTableUtils.GetValue <string>(row, "ObstacleName");
obj.ObstacleBehaviourDescription = DataTableUtils.GetValue <string>(row, "ObstacleBehaviourDescription");
obj.ObstacleBehaviourCode = DataTableUtils.GetValue <string>(row, "ObstacleBehaviourCode");
return(obj);
}
public List <EmployeeViewModel> GetEmployeeByPan(List <string> panList)
{
SqlCommand cmd = new SqlCommand("dbo.CoreEmployee_GetByPan");
cmd.Parameters.AddWithValue("@Pan", string.Join(",", panList));
var dt = _sqlDatabase.ExecuteSelect(cmd);
List <EmployeeViewModel> empList = new List <EmployeeViewModel>();
foreach (DataRow row in dt.Rows)
{
EmployeeViewModel empModel = new EmployeeViewModel();
empModel.Id = DataTableUtils.GetValue <long?>(row, "CoreEmployeeId");
empModel.Pan = DataTableUtils.GetValue <string>(row, "Pan");
empModel.FirstName = DataTableUtils.GetValue <string>(row, "FirstName");
empModel.LastName = DataTableUtils.GetValue <string>(row, "LastName");
empModel.BirthDate = DataTableUtils.GetValue <DateTime?>(row, "BirthDate");
empModel.Description = DataTableUtils.GetValue <string>(row, "Description");
empList.Add(empModel);
}
return(empList);
}