public int InsertMappedRelation(BALLinks obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("[dbo].[sp_Links]", cn); da.InsertCommand.Parameters.AddWithValue("@Action", obj._Action); da.InsertCommand.Parameters.AddWithValue("@marketId", obj._MarketId); da.InsertCommand.Parameters.AddWithValue("@RateCategory", obj._CateId); da.InsertCommand.Parameters.AddWithValue("@Discount", obj._discount); da.InsertCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.InsertCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public DataTable BindControlsAgent(BALLinks obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_Links]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@AgentID", obj._Agent); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public int RemoveAgentMarketMapper(BALLinks obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.DeleteCommand = new SqlCommand("[dbo].[sp_Links]", cn); da.DeleteCommand.Parameters.AddWithValue("@Action", obj._Action); da.DeleteCommand.Parameters.AddWithValue("@AgentID", obj._Agent); da.DeleteCommand.Parameters.AddWithValue("@marketid", obj._MarketId); da.DeleteCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.DeleteCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public List <AgentMarket> BindControlsAgentmarket(BALLinks obj) { List <AgentMarket> agentMarkets = new List <AgentMarket>(); try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_Links]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@marketid", obj._MarketId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { List <Action> actions = new List <Action>(); foreach (DataRow row in dtReturnData.Rows) { AgentMarket am = new AgentMarket { AgentId = Convert.ToInt32(row[0].ToString()), //AgentName = DataSecurityManager.Decrypt(row[1].ToString()), cnt = Convert.ToBoolean(row[2].ToString()) }; actions.Add(new Action(() => am.AgentName = DataSecurityManager.Decrypt(Convert.ToString(row[1])))); agentMarkets.Add(am); } ParallelOptions po = new ParallelOptions(); po.MaxDegreeOfParallelism = 100; Parallel.Invoke(po, actions.ToArray()); } return(agentMarkets); } catch (Exception) { return(null); } }