public UpdateSymbolMasterQM UpdateSymbolMaster(UpdateSymbolMasterCM updateSymbolMasterCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new SymbolMasterUpdateCommand {
Connection = connection
};
command.Execute(updateSymbolMasterCM);
}
return(new UpdateSymbolMasterQM());
}
public UpdateSymbolMasterResponseDto UpdateSymbolMaster(UpdateSymbolMasterRequestDto updateSymbolMasterRequestDto)
{
var cModel = new UpdateSymbolMasterCM
{
SymbolCode = updateSymbolMasterRequestDto.SymbolCode,
Symbol = updateSymbolMasterRequestDto.Symbol,
Name = updateSymbolMasterRequestDto.Name,
ContentType = updateSymbolMasterRequestDto.ContentType,
Data = updateSymbolMasterRequestDto.Data,
UpdatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove,
UpdatedDateTime = System.DateTime.UtcNow,
isExistingImage = updateSymbolMasterRequestDto.isExistingImage
};
var response = symbolMasterRepository.UpdateSymbolMaster(cModel);
return(new UpdateSymbolMasterResponseDto());
}
public void Execute(UpdateSymbolMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspUpdateSymbolMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@Symbol", SsDbType.VarChar, ParameterDirection.Input, model.Symbol));
sqlCommand.Parameters.Add(AddParameter("@Name", SsDbType.VarChar, ParameterDirection.Input, model.Name));
sqlCommand.Parameters.Add(AddParameter("@ContentType", SsDbType.VarChar, ParameterDirection.Input, model.ContentType));
sqlCommand.Parameters.Add(AddParameter("@Data", SsDbType.VarBinary, ParameterDirection.Input, model.Data));
sqlCommand.Parameters.Add(AddParameter("@UpdatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid()));
sqlCommand.Parameters.Add(AddParameter("@UpdatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow));
sqlCommand.Parameters.Add(AddParameter("@isExistingImage", SsDbType.Bit, ParameterDirection.Input, model.isExistingImage));
sqlCommand.Parameters.Add(AddParameter("@SymbolCode", SsDbType.Decimal, ParameterDirection.Input, model.SymbolCode));
sqlCommand.ExecuteNonQuery();
}
}
