public List<OperationView> getOperation()
{
OperationDao Dao = new OperationDao();
DataTable DaoResult = Dao.getOperation();
return buildOperation(DaoResult);
}
/*Funcion: Insertar operacion de un equipo
Param: OperationEquipmentInsertView, AuditDataFromWeb
Return: status
*/
public int getOperationID(OperationInsertView operation)
{
OperationDao Dao = new OperationDao();
DataTable DaoResult = Dao.getOperationID(operation.ProcessId,operation.ProductLineId);
int position = 0;
foreach (DataRow row in DaoResult.Rows)
{
if (DaoResult.Columns.Contains("position") && row["position"] != DBNull.Value) { position = Convert.ToInt32(row["position"]); }
}
return position;
}
/*Funcion: Validar operacion
Param: OperationValidateView
Return: true / false
*/
public OperationValidateView ValidateOperationProcessProduct(OperationInsertView view, List<String> EquipmentIDList)
{
OperationDao Dao = new OperationDao();
view.OperationProcessId = getOperationProcessIdByLastProduct(view);
OperationValidateView result = new OperationValidateView();
result.state = true;
for (int i = 0; i < EquipmentIDList.Count(); i++)
{
DataTable DaoResult = Dao.ValidateOperationProcessProduct(view, EquipmentIDList[i]);
int cont = 0;
foreach (DataRow row in DaoResult.Rows)
{
if (DaoResult.Columns.Contains("cont") && row["cont"] != DBNull.Value) { cont = Convert.ToInt32(row["cont"]); }
}
System.Diagnostics.Debug.WriteLine("Cont: "+cont);
if (cont >= 1)
{
result.EquipmentId = EquipmentIDList[i];
result.state = false;
break;
}
}
return result;
}
/*Funcion: Obtener los tipos de operaciones de una operacion
Param: idOperation
Return: Lista OperationEquipment
*/
public List<OperationEquipmentView> getEquipmentByOperation(int idOperation)
{
OperationDao Dao = new OperationDao();
DataTable recipeDaoResult = Dao.getEquipmentbyOperationManager(idOperation);
return buildEquipmentOperation(recipeDaoResult);
}
/*Funcion: Valida el nombre de la operacion
Param: OperationInsertView
Return: status
*/
public bool validateName(OperationInsertView operation)
{
OperationDao Dao = new OperationDao();
DataTable DaoResult = Dao.validateName(operation);
int cant = 0;
foreach (DataRow row in DaoResult.Rows)
{
if (DaoResult.Columns.Contains("cant") && row["cant"] != DBNull.Value) { cant = Convert.ToInt32(row["cant"]); }
}
if (cant == 0)
{
return true;
}
else
{
return false;
}
}
/*Funcion: Busca una operaciom con los datos de busqueda
Param: datos de busqueda
Return: status
*/
public List<OperationView> searchOperation(string partial)
{
OperationDao Dao = new OperationDao();
DataTable DaoResult = Dao.searchOperation(partial);
return buildOperation(DaoResult);
}
/*Funcion: Insertar operacion de un equipo
Param: OperationEquipmentInsertView, AuditDataFromWeb
Return: status
*/
public CUDView insertOperationEquipment(OperationEquipmentInsertView operation, AuditDataFromWeb audit)
{
OperationDao Dao = new OperationDao();
String state = Dao.insertOperationEquipment(operation);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert new equipment for operation";
String NewValues = "OperationId: " + operation.OperationId
+ ", EquipmentId: " + operation.EquipmentId;
auditservice.formInsert(Action, NewValues, audit);
}
return logic;
}
/*Funcion: Insertar una operaciom
Param: OperationInsertView, AuditDataFromWeb
Return: status
*/
public CUDView insertOperation(OperationInsertView operation, AuditDataFromWeb audit)
{
OperationDao Dao = new OperationDao();
operation.ID = getOperationID(operation);
operation.OperationProcessId = getOperationProcessIdByLastProduct(operation);
List<String> state = Dao.insertOperation(operation);
CUDView logic = CUDVerifyLogic.verifierInsertPKReturnMSQL("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert new operation";
String NewValues = "OperationId: " + logic.insertPK
+ ", ID: " + operation.ID
+ ", OperationName: " + operation.OperationName
+ ", OperationProcessId: " + operation.OperationProcessId
+ ", OperationTypeId: " + operation.OperationTypeId
+ ", ProcessId: " + operation.ProcessId
+ ", ProductLineId: " + operation.ProductLineId;
auditservice.formInsert(Action, NewValues, audit);
}
return logic;
}
/*Funcion: Obtener los tipos de operaciones de un proceso
Param: idProcess
Return: Lista OperationType
*/
public List<OperationTypeView> getOperationTypeByProcess(int idProcess)
{
OperationDao Dao = new OperationDao();
DataTable DaoResult = Dao.getOperationTypeByProcess(idProcess);
List<OperationTypeView> ViewList = new List<OperationTypeView>();
foreach (DataRow row in DaoResult.Rows)
{
OperationTypeView x = new OperationTypeView();
if (DaoResult.Columns.Contains("OperationTypeId") && row["OperationTypeId"] != DBNull.Value) { x.OperationTypeId = Convert.ToInt32(row["OperationTypeId"]); }
if (DaoResult.Columns.Contains("OperationTypeName") && row["OperationTypeName"] != DBNull.Value) { x.OperationTypeName = row["OperationTypeName"].ToString(); }
ViewList.Add(x);
}
return ViewList;
}
