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