public int Manage(string Filter, AV_SiteScriptScannerConfigurations sc)
{
SqlCommand loCommand = DataContext.OpenConnection();
try
{
loCommand = DataContext.SetStoredProcedure(loCommand, "AV_ManageSiteScriptSCConfig");
SqlParameter returnParameter = loCommand.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
loCommand = DataContext.StartTransaction(loCommand);
int id = DataContext.ExecuteScalar(DataContext.AddParameters(loCommand, "@Filter", Filter, "@SiteScriptId", sc.SiteScriptId, "@MeasurementId", sc.MeasurementId, "@KpiId", sc.KpiId, "@KpiValue", sc.KpiValue));
DataContext.EndTransaction(loCommand);
int result = Convert.ToInt32(loCommand.Parameters["@RETURN_VALUE"].Value);
return(result);
}
catch (Exception)
{
DataContext.CancelTransaction(loCommand);
throw;
}
finally
{
DataContext.CloseConnection(loCommand);
}
}
public ActionResult SaveScannerConfiguration(int[] kpiId, string[] kpiValue, int KeyId = 0, int MeasurementId = 0)
{
AV_SiteScriptScannerConfigurations scConfig = new AV_SiteScriptScannerConfigurations();
try
{
if (kpiId != null)
{
for (int i = 0; i < kpiId.Length; i++)
{
scConfig = new AV_SiteScriptScannerConfigurations
{
SiteScriptId = KeyId,
MeasurementId = MeasurementId,
KpiId = kpiId[i],
KpiValue = kpiValue[i]
};
SiteScriptScannerConfigBL.Manage("Insert", scConfig);
}
return(Json(new { Status = true }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
}
return(Json(new { Status = false }, JsonRequestBehavior.AllowGet));
}
public int Manage(string filter, AV_SiteScriptScannerConfigurations sc)
{
return(scDL.Manage(filter, sc));
}
