public void UpdateBrokerInfo(BrokerInfoBO brokerInfoBO, string oldName)
{
SqlConnection conn = new SqlConnection(DbConnectionBasic.ConnectionString);
string queryString = "";
queryString = "Update SBP_Broker_Info SET [Name]=@name,[BO_ID]=@boID,[Trade_ID]=@tradeID,[Exchange_Name]=@exchangeName,[CDBL_Participant_ID]=@CDBLParticipantID,[Open_Date]=@openDate Where [Name]=@oldName";
SqlCommand command = new SqlCommand(queryString, conn);
command.Parameters.Add(new SqlParameter("@name", (object)brokerInfoBO.Name));
command.Parameters.Add(new SqlParameter("@boID", (object)brokerInfoBO.BOId));
command.Parameters.Add(new SqlParameter("@tradeID", (object)brokerInfoBO.TradeId));
command.Parameters.Add(new SqlParameter("@exchangeName", (object)brokerInfoBO.ExchangeName));
command.Parameters.Add(new SqlParameter("@CDBLParticipantID", (object)brokerInfoBO.CdblParticipantId));
command.Parameters.Add(new SqlParameter("@openDate", (object)brokerInfoBO.OpenDate));
command.Parameters.Add(new SqlParameter("@oldName", (object)oldName));
try
{
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
throw;
}
}
public void UpdateDefaultSignature(BrokerInfoBO brokerInfoBo)
{
SqlConnection conn = new SqlConnection(DbConnectionBasic.ConnectionString);
string queryString = "";
queryString = "Update SBP_Broker_Info SET [Default_Signature]=@DefaultSignImage";
SqlCommand command = new SqlCommand(queryString, conn);
command.Parameters.Add(new SqlParameter("@DefaultSignImage", (object)brokerInfoBo.DefaultSignImage));
try
{
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
throw;
}
}