/// <summary> /// RemoveOtherDataInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public dynamic RemoveOtherDataInfo(OtherDataItem info) { using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { sqlCon.Open(); string sql; SqlCommand reply; sql = "delete from other_clone where id = @id"; reply = new SqlCommand(sql, sqlCon); reply.CommandTimeout = 60; reply.Parameters.AddWithValue("@id", info.id); try { reply.ExecuteNonQuery(); } catch (Exception ex) { } sqlCon.Close(); sqlCon.Dispose(); string userName; if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268) { userName = "******";// HttpContext.Current.User.Identity.Name; } else { userName = HttpContext.Current.User.Identity.Name; } var guidelines = new GuidelinesLayer(); try { return(guidelines.GetGuidelines(0, null, info.xccId, userName)); } catch (InvalidOperationException) { return("Selected scorecard does not contain record with this ID"); } catch (Exception) { return(new GuidelineScorecardInfo()); } } }
public dynamic RemoveOtherDataInfo([FromBody] OtherDataItem info) { GuidelinesLayer guidelinesLayer = new GuidelinesLayer(); return(guidelinesLayer.RemoveOtherDataInfo(info)); }