/*Funcion: obtener parametros por procesos
Param: processID
Return: Lista ParameterProcessView
*/
public List<ParameterProcessView> getParameterByProcess(String processID)
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.getParameterByProcess(processID);
List<ParameterProcessView> ViewList = new List<ParameterProcessView>();
foreach (DataRow row in DaoResult.Rows)
{
ParameterProcessView x = new ParameterProcessView();
if (DaoResult.Columns.Contains("ParameterId") && row["ParameterId"] != DBNull.Value) { x.ParameterId = Convert.ToInt32(row["ParameterId"]); }
if (DaoResult.Columns.Contains("ParameterYPlotRange") && row["ParameterYPlotRange"] != DBNull.Value) { x.ParameterYPlotRange = Convert.ToInt32(row["ParameterYPlotRange"]); }
if (DaoResult.Columns.Contains("Parameter") && row["Parameter"] != DBNull.Value) { x.Parameter = row["Parameter"].ToString(); }
if (DaoResult.Columns.Contains("Unit") && row["Unit"] != DBNull.Value) { x.Unit = row["Unit"].ToString(); }
if (DaoResult.Columns.Contains("ParameterXPlot") && row["ParameterXPlot"] != DBNull.Value) { x.ParameterXPlot = (bool)row["ParameterXPlot"]; }
if (DaoResult.Columns.Contains("ParameterYPlot") && row["ParameterYPlot"] != DBNull.Value) { x.ParameterYPlot = (bool)row["ParameterYPlot"]; }
if (DaoResult.Columns.Contains("Value") && row["Value"] != DBNull.Value) { x.Value = Convert.ToDouble(row["Value"]); }
ViewList.Add(x);
}
return ViewList;
}
/*Funcion: obtener lista parametros
Param:
Return: status
*/
public List<ParameterView> getParameter()
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.getParameter();
return buildParameter(DaoResult);
}
/*Funcion: actualizar parametros
Param: ParameterUpdateView,AuditDataFromWeb
Return: status
*/
public CUDView updateParameter(ParameterUpdateView parameter, AuditDataFromWeb audit)
{
AuditDao auditDao = new AuditDao();
DataTable auditDaoResult = auditDao.getParameterByParameterID(parameter.ParameterId);
String OldValues = "ParameterId: " + parameter.ParameterId;
foreach (DataRow row in auditDaoResult.Rows)
{
if (auditDaoResult.Columns.Contains("ParameterMinValue") && row["ParameterMinValue"] != DBNull.Value) { OldValues = OldValues + ", ParameterMinValue: " + Convert.ToDouble(row["ParameterMinValue"]); }
if (auditDaoResult.Columns.Contains("ParameterName") && row["ParameterName"] != DBNull.Value) { OldValues = OldValues + ", ParameterName: " + row["ParameterName"].ToString(); }
if (auditDaoResult.Columns.Contains("ParameterXPlot") && row["ParameterXPlot"] != DBNull.Value) { OldValues = OldValues + ", ParameterXPlot: " + (bool)row["ParameterXPlot"]; }
if (auditDaoResult.Columns.Contains("ParameterYPlot") && row["ParameterYPlot"] != DBNull.Value) { OldValues = OldValues + ", ParameterYPlot: " + (bool)row["ParameterYPlot"]; }
if (auditDaoResult.Columns.Contains("ParameterYPlotRange") && row["ParameterYPlotRange"] != DBNull.Value) { OldValues = OldValues + ", ParameterYPlotRange: " + Convert.ToInt32(row["ParameterYPlotRange"]); }
if (auditDaoResult.Columns.Contains("ProcessId") && row["ProcessId"] != DBNull.Value) { OldValues = OldValues + ", ProcessId: " + Convert.ToInt32(row["ProcessId"]); }
if (auditDaoResult.Columns.Contains("UnitId") && row["UnitId"] != DBNull.Value) { OldValues = OldValues + ", UnitId: " + row["UnitId"].ToString(); }
}
ParameterDao Dao = new ParameterDao();
String state = Dao.updateParameter(parameter);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("update", state);
if (logic.update == true)
{
AuditService auditservice = new AuditService();
String Action = "Update parameter";
String NewValues = "ParameterId: " + parameter.ParameterId
+ ", ParameterMinValue: " + parameter.ParameterMinValue
+ ", ParameterName: " + parameter.ParameterName
+ ", ParameterXPlot: " + parameter.ParameterXPlot
+ ", ParameterYPlot: " + parameter.ParameterYPlot
+ ", ParameterYPlotRange: " + parameter.ParameterYPlotRange
+ ", ProcessId: " + parameter.ProcessId
+ ", UnitId: " + parameter.UnitId;
auditservice.formUpdate(Action, NewValues, OldValues, audit);
}
return logic;
}
/*Funcion: Actualizar Units
Param: UnitView,AuditDataFromWeb
Return: Status
*/
public CUDView updateUnits(UnitView unit, AuditDataFromWeb audit)
{
AuditDao auditDao = new AuditDao();
DataTable auditDaoResult = auditDao.getUnitByUnitId(unit.UnitId);
String OldValues = "UnitId: " + unit.UnitId;
foreach (DataRow row in auditDaoResult.Rows)
{
if (auditDaoResult.Columns.Contains("UnitName") && row["UnitName"] != DBNull.Value) { OldValues = OldValues + ", UnitName: " + row["UnitName"].ToString(); }
if (auditDaoResult.Columns.Contains("UnitSymbol") && row["UnitSymbol"] != DBNull.Value) { OldValues = OldValues + ", UnitSymbol: " + row["UnitSymbol"].ToString(); }
}
ParameterDao Dao = new ParameterDao();
String state = Dao.updateUnits(unit);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("update", state);
if (logic.update == true)
{
AuditService auditservice = new AuditService();
String Action = "Update unit";
String NewValues = "UnitId: " + unit.UnitId
+ ", UnitName: " + unit.UnitName
+ ", UnitSymbol: " + unit.UnitSymbol;
auditservice.formUpdate(Action, NewValues, OldValues, audit);
}
return logic;
}
/*Funcion: Insertar Units
Param: UnitsInsertView,AuditDataFromWeb
Return: Lista Units
*/
public CUDView insertUnits(UnitsInsertView unit, AuditDataFromWeb audit)
{
ParameterDao Dao = new ParameterDao();
String state = Dao.insertUnits(unit);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert new unit";
String NewValues = "UnitName: " + unit.UnitName
+ ", UnitSymbol: " + unit.UnitSymbol;
auditservice.formInsert(Action, NewValues, audit);
}
return logic;
}
/*Funcion: Buscar procesos por datos parciales
Param: datos parceales
Return: Lista ParameterView
*/
public List<ParameterView> searchProcess(String partial)
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.searchParameter(partial);
return buildParameter(DaoResult);
}
/*Funcion: insertar parametros
Param: ParameterInsertView,AuditDataFromWeb
Return: status
*/
public CUDView insertParameter(ParameterInsertView parameter, AuditDataFromWeb audit)
{
ParameterDao Dao = new ParameterDao();
String state = Dao.insertParameter(parameter);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert new parameter";
String NewValues = "ParameterName: " + parameter.ParameterName
+ ", ParameterMinValue: " + parameter.ParameterMinValue
+ ", ParameterXPlot: " + parameter.ParameterXPlot
+ ", ParameterYPlot: " + parameter.ParameterYPlot
+ ", ParameterYPlotRange: " + parameter.ParameterYPlotRange
+ ", ProcessId: " + parameter.ProcessId
+ ", UnitId: " + parameter.UnitId;
auditservice.formInsert(Action, NewValues, audit);
}
return logic;
}
/*Funcion: busca si existe el proceso para ese parametro
Param: processID
Return: bool
*/
public bool hadProcessParameter(String processID)
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.hadProcessParameter(processID);
bool state = false;
foreach (DataRow row in DaoResult.Rows)
{
RecipeProcessView x = new RecipeProcessView();
if (DaoResult.Columns.Contains("Result") && row["Result"] != DBNull.Value) { state = (bool) row["Result"]; }
}
return state;
}
//Exec getParameterByProcessAndProduct @ProcessId =1 , @ProductId =1
/*Funcion: Obtener las unidades
Param:
Return: Lista UnitView
*/
public List<UnitView> getUnits()
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.getUnits();
return buildUnits(DaoResult);
}
/*Funcion: Obtener unidad para un parametro
Param: ParameterId
Return: Unit
*/
public UnitView getUnitFromParameter(int ParameterId )
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.getUnitFromParameter(ParameterId);
UnitView View = new UnitView();
foreach (DataRow row in DaoResult.Rows)
{
if (DaoResult.Columns.Contains("UnitId") && row["UnitId"] != DBNull.Value) { View.UnitId = Convert.ToInt32(row["UnitId"]); }
if (DaoResult.Columns.Contains("UnitName") && row["UnitName"] != DBNull.Value) { View.UnitName = row["UnitName"].ToString(); }
if (DaoResult.Columns.Contains("UnitSymbol") && row["UnitSymbol"] != DBNull.Value) { View.UnitSymbol = row["UnitSymbol"].ToString(); }
}
return View;
}
/*Funcion: Obtiene los parametros de un proceso y producto
Param: ProcessProductView
Return: Lista Paramatros
*/
public List<ParameterUnitView> getParameterByProcessAndProduct(ProcessProductView view)
{
ParameterDao Dao = new ParameterDao();
DataTable DaoResult = Dao.getParameterByProcessAndProduct(view);
List<ParameterUnitView> ViewList = new List<ParameterUnitView>();
foreach (DataRow row in DaoResult.Rows)
{
ParameterUnitView x = new ParameterUnitView();
if (DaoResult.Columns.Contains("UnitId") && row["UnitId"] != DBNull.Value) { x.UnitId = Convert.ToInt32(row["UnitId"]); }
if (DaoResult.Columns.Contains("Parameter") && row["Parameter"] != DBNull.Value) { x.Parameter = row["Parameter"].ToString(); }
if (DaoResult.Columns.Contains("Unit") && row["Unit"] != DBNull.Value) { x.Unit = row["Unit"].ToString(); }
ViewList.Add(x);
}
return ViewList;
}