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)); }